EXPERIENCE, COMMERCIAL ANALYTICS
One version of the numbers for ads, sales and payments
A three month project, from July to September 2025, for a digital marketing company that sells through webinars: its advertising, CRM, payment and webinar platforms integrated into a data warehouse with dashboards for management.
The challenge
Commercial information lived in four different platforms: advertising in Meta Ads, contacts and sales management in GoHighLevel, payments in Stripe and webinar attendance in WebinarFuel. Each had its own reports, and following a contact’s full journey, from the ad to the purchase, meant crossing them by hand.
What was done
- ETL processes in Python that extract and normalize the data from the four platforms through their APIs.
- Real time updates of the CRM contacts through webhooks, on top of the scheduled loads.
- A PostgreSQL data warehouse that brings advertising, contacts, payments and attendance into a single model.
- Metabase dashboards with the sales funnel indicators, deployed in containers in the cloud.
Result
Management now looks at the full funnel in one place, from the ad to the payment, with data that updates without manual work. It is the same capability we apply in any company whose commercial numbers live in separate platforms.
Do your commercial numbers live in separate platforms?
A first conversation costs nothing and usually clarifies whether the problem is the one you thought it was.
Schedule a strategic conversation