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

Share this case study

Our latest case studies

This step-by-step guidel will teach you how to calculate the remaining days in a month, the total days, and the days that have already passed.
How we helped Spaceful Technologies identify where leads were being lost and monitor performance.
Spaceful is a new tech-enabled logistics company from Montreal that takes the hassle out of self-storage. They offer eCommerce Fulfillment, Subscription Box Fulfillment, FBA Prep Services, B2B Fulfillment, and Last-Mile Delivery Solutions (Same Day, Next Day, Scheduled).
How we helped this digital marketing agency automate their monthly reporting for all of their clients.
Recognizing the growing inefficiencies in their existing data pipeline, WholesomeCo sought to transform their approach to data management. Mitchell Moody, their Director of Analytics, reached out to Systematik, for their expertise as dbt partners and staff augmentation to expedite the deployment process.