Gain Leads is a digital marketing agency based in Florida, United States. They have more than 40 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.”
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 Scripts
Twilio’s API
Interested in something similar?
Fill the form below and get your 100% FREE no-obligation 30-minute strategy session call.