Creating Location-Specific ROI Reports for Clients with Multiple Locations in One MCFX Profile

Posted by: Macenzi Barker Date Posted: February 22, 2024
Back to Case Studies

Issue

This corporate account will soon pass billing for WebFX services to each individual location to pick up the cost themselves. The corporate POCs needed to see location-specific ROI reporting for the individual locations that we’re running ads for, but there was no way to do that with our current setup in MCFX.

Solution

There are two parts to this solution:

  1. ROI – Investment
    • To calculate their ROI, we need to know their investment level – they were specifically interested in their PPC spend
      • Since the corporate account was paying for PPC ads for 3 locations, we needed to be able to determine their investment level by location
      • The AM ensured that each ad in the campaigns was broken out by location
      • Our M&A team was able to break out the conversion action for an e-commerce purchase into 3 new conversions, 1 for each location
  2. ROI – Return
    • To calculate their ROI, we need to know the return for each of the locations, which wasn’t possible with the current MCFX configuration
      • Our MCFX integration developers added link decoration to ensure we weren’t losing attribution as users passed between the main site domain and ordering subdomains
      • The developer updated the integration to include the thank-you-page URL as a form field in the order submission in LeadManagerFX (this allowed us to see which location the user ordered from because the URL included the location’s ordering subdomain name)
    • To determine the return value, the team was able to grab an export of the LeadManagerFX order submission data and filter by medium = PPC and the page URL by location to sum the order total for the relevant location

Putting it all together:

  • With the investment value from Google Ads and the return value from LeadManagerFX, we can calculate ROI figures for locations, even if they share MCFX profiles!

Achievement

We were able to customize this client’s tracking setup to deliver the granular reporting they were looking for to present our findings to the rest of the team! They have nearly 50 locations that are potentially interested in our marketing services, so this win could bring clients for years to come!