From spreadsheets to daily cost per booking.
Trovant Media built client reports by hand every week and struggled to reconcile leads from the ad platforms with bookings in Liine CRM. In three weeks we connected TikTok, Google Ads and Facebook to those bookings, with cost per booking by service type, updated daily.
Trovant MediaPerformance marketing agency · Health and beauty clients
Cost per booking by serviceFernway Med Spa · Oct 15–21The ads counted leads. Liine counted bookings.
Trovant’s team built weekly spreadsheets by hand and struggled to reconcile ad leads with Liine CRM bookings. There was no automated cost per booking and no view by service type.
In the reports
Out of the reports
Ad leads matched to Liine bookings, in Trovant’s own reporting.
Maven connectors sync TikTok, Google Ads and Facebook into BigQuery daily, where ad-platform leads are matched to Liine CRM records.
Trovant Media’s environment
Ad platforms
Liine CRM
- CRM leads and bookings
- Matched to ad-platform leads
Maven
- ConnectConnectors on a daily sync
- ModelWarehouse and business metrics

- MatchLeads to bookings, discrepancy checks
Client reportingFernway Med Spa ▾Powered by Maven
4 dashboard views in Maven, updated daily
How Trovant’s reporting changed, week by week.
Three weeks of delivery, from connecting the ad platforms to shipping four dashboard views, then daily updates with no weekly spreadsheets.
- Week 1Data and modeling
- Week 2CRM matching
- Week 3Four dashboard views
- ThenDaily, on its own
- Week 1
Connect and model the data
Maven connectors for TikTok, Google Ads and Facebook feed a BigQuery warehouse, with dbt models for the business metrics on a daily sync.
BeforePlatform exports pasted into a spreadsheet every week
AfterDaily syncs into one warehouse
- Week 2
Match leads to bookings
Liine CRM is connected and ad-platform leads are mapped to CRM records, with cost per lead, cost per booking and discrepancy checks automated.
BeforeAd leads and Liine bookings reconciled by hand
AfterLeads matched to bookings automatically
- Week 3
Ship four dashboard views
Platform overview with cost per lead and per booking, week-over-week trends, Facebook and TikTok lead forms by service type, and day-over-day tables.
BeforeNo cost per booking by platform or service type
AfterCost per booking by platform and service type
- After launch
Reporting runs itself
Metrics update daily, and the hours that went into spreadsheets go into optimizing campaigns.
BeforeHours every week building reports
After4–6 hours a week back for optimization
TikTok leads cost half what Google’s do. Per booking, both cost $77.
A platform overview with cost per lead beside cost per booking for each platform, and cost per booking by service type.

By platform
Cost per booking by service
Cost per booking, week over week
Still building client reports by hand every week? We’ll show you what daily cost per booking by service type looks like for your clients.
Book a walkthroughThis dashboard transformed how we operate. We went from spending hours every week creating reports to having real-time insights at our fingertips. Being able to see cost per booking by service type across all our platforms has dramatically accelerated how quickly we optimize campaigns.
Take your agency from weekly spreadsheets to daily cost per booking.
Start with a free scan of a client’s tracking, or have us build daily cost-per-booking reporting for your agency.