Simple yet effective twilio automated reports

How we helped gain leads, a digital marketing agency, offer their clients call reports with this simple API.

“Systematik is the real deal when it comes to data analysis and reporting. He set me up custom dashboards with scheduled weekly reports that are automatically shared with my clients. So now i and my team can spend less time on reports for clients and more time actually improving our campaigns. I highly recommend them.”

David edwards Founder of gain leads

The problems

  • Their clients needed an easy way to see if their marketing effort was paying off.
  • Their clients wanted to know how many calls over 30 seconds they received, with day and time as well.
  • Their clients are not tech-savvy so the solution needed to be super simple.

The solution

  • We identified the KPIs that are important for their clients
  • We automated connected data studio to google ads
  • We built an app script that connected to twilio’s API and extracted daily call data to report in data studio.
  • We created a template that would be easy to duplicate for each client.
  • Bring it all together in data studio with a branded dashboard that they could easily share with their client or even schedule monthly reports to be sent automatically.

The results

A simple, yet effective automated report that their clients can access anytime from their browser. We also added a scheduled pdf report to be sent monthly for clients who won’t take the time to go online and use the report.

The technical stuff

Google ads dashboard features

  • Filters (date range, google ads campaign, client)
  • Number of clicks
  • Click-through rate
  • Impressions
  • Conversions
  • Conversion rate
  • Cost per conversion
  • Total spent
  • Average cost per click
  • Top campaigns table
  • Line chart with conversion and clicks over time

Twilio dashboard features

  • Filters (date range, client)
  • Number of calls received
  • Number of first-time callers
  • The number of calls with a duration equals or greater than 30 seconds
  • Number of calls with a duration of less than 30 seconds
  • Average call duration
    Number of calls over time by type & time of day
  • Number of calls over time by type & day of week

Technology used to build the dashboards​

  • Google data studio (data visualization)
  • Google sheets
  • Google app Ssripts
  • Twilio’s API