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.