Tracking original traffic source for long sales cycle

How we managed to get attribution right for this company with a long and complicated sale cycle.

“Systematik prevailed where 2 other agencies failed miserably.
They did the work in a fraction of the time and at a fraction of the cost of the other agencies.
Thanks to them, I can now confidently make critical business decisions based on accurate data. This is absolutely invaluable to our business!”
Adrian shiel Co-founder of High-Performing Coach Ltd.

The problems

  • With a very long and complicated funnel, tracking sales original traffic sources was almost impossible using traditional, cookie-based methods.
  • They had no reporting tools and were doing almost everything manually using spreadsheets.
  • They had absolutely no idea which marketing campaigns were generating sales.
  • Using cookies to track long sales cycles is getting more difficult with browsers now having third-party cookie protection.

The solution

We noticed that their CRM (activecampaign) was their main source of truth. Almost every step of the funnel was tracked inside activecampaign. Mostly by using zapier.

We decided that it would only make sense to also add the original traffic source directly in their contact information once they complete the first step of their funnel.

In order to do that, we had to add hidden fields to their booking form (scheduleonce). By doing that, we were able to capture any query parameters we wanted and send them over to activeCampaign.

We captured the source, medium, campaign, content, term, gclid, and fbclid. With that information, we were not only able to know what was the original source for any buyers, but also send the gclid and fbclid information back to the right marketing platform to help the algorithm optimize their campaigns.

The last piece of the puzzle was to send activecampaign data to BigQuery. Once the data was there, we used that data source to build a simple dashboard that would help them visualize their data in a unified way.

The results

They were finally able to understand how each marketing platform performed and confidently change their strategy based on that data. They also saved about 5 hours a month on reporting alone which was a big win as well.

The technical stuff

Attribution report

  • Filters (date range, sales rep, product purchased, source, medium, campaign, content, term)
  • Source
  • Medium
  • Campaign
  • Content
  • Term

Technology used to build the dashboards

  • Google data studio (data visualization)
  • Google BigQuery
  • Google sheets
  • Google app scripts
  • ActiveCampaign’s API

High-performing coach main technology stack

  • ActiveCampaign
  • ScheduleOnce
  • Facebook ads
  • Google ads
  • Linkedin ads
  • Google sheets
  • Zoom
  • Leadpages
  • Typeform

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.