Automated Call Reports for Multi-Location Businesses

Posted by: Gina Bennett Date Posted: March 26, 2025
Back to Case Studies

Issue

Carpet & Tile Mart has a multi-location business model, with each location having a branch manager.

We wanted to way to send each branch manager an automated report that includes calls only to their location, which can’t be achieved with the current report options in CallTrackerFX.

Solution

I created a Looker report for each location that’s filtered to only pull in their location’s calls.  We originally pulled in all calls for each location but found that it was too many for the branch manager to realistically act on.

To make the data more actionable, we upped the frequency to send 3x per week and filter calls to only include those with an Automated Touchpoint Status of Lead Follow Up, Upsell Request or New Lead.  This makes the report include the calls that are most likely to need a follow-up.

I used the Schedule Delivery option in Looker to automate the sending of the report to the branch managers.  To keep these from flooding my inbox, I added a filter to my email to automatically archive them.

 

Note: This is a solution that does require some maintenance here and there (ex: branch manager changes, labeling changes, etc) and does open up the doors for branch managers you may otherwise not work with (ex: I had one email me to ask why they had so few calls in their report), so definitely keep that in mind if you decide to go this route!

Achievement

An automated system that gives location managers a list of call leads to follow up on