Simple Twilio automated reports

Simple yet effective Twilio reports

Home » Case Studies » Simple Twilio automated reports

Gain Leads is a digital marketing agency based in Florida, United States. They have more than 50 clients in the locksmith industry and recently started to expand their services to other niches.

“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 Looker Studio to Google Ads
We built an app script that connected to Twilio’s API and extracted daily call data to report in Looker Studio.
We created a template that would be easy to duplicate for each client.
Bring it all together in Looker 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 Looker Studio (data visualization)
Google Sheets
Google App Scripts
Twilio’s API