Skip to content

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–21
Spend$14,722
Leads612
Bookings184
Cost per booking$80
ServiceBotox$7816 booked$7031 booked$8718 bookedLip filler$1129 booked$9614 booked$10412 bookedLaser hair removal$1417 booked$8419 booked$11810 bookedHydraFacial$4122 booked$6311 booked$5215 booked

The 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

Weekly spreadsheetLeads

Out of the reports

BookingsCost per bookingBy service type

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

  1. ConnectConnectors on a daily sync
  2. Model
    Warehouse and business metrics
  3. MatchLeads to bookings, discrepancy checks
Cost per leadCost per bookingService typeWeek over weekDay over day
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.

  1. Week 1Data and modeling
  2. Week 2CRM matching
  3. Week 3Four dashboard views
  4. ThenDaily, on its own
  1. 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.

    Before

    Platform exports pasted into a spreadsheet every week

    After

    Daily syncs into one warehouse

  2. 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.

    Before

    Ad leads and Liine bookings reconciled by hand

    After

    Leads matched to bookings automatically

  3. 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.

    Before

    No cost per booking by platform or service type

    After

    Cost per booking by platform and service type

  4. After launch

    Reporting runs itself

    Metrics update daily, and the hours that went into spreadsheets go into optimizing campaigns.

    Before

    Hours every week building reports

    After

    4–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.

Client reportingUpdated today, 6:00 AM
Fernway Med Spa ▾Oct 15 – 21vs prior 7 days
Ad spend$14,722+6% vs prior 7 days
Bookings184+12% vs prior 7 days
Cost per lead$24−3% vs prior 7 days
Cost per booking$80−5% vs prior 7 days

By platform

Cost per leadCost per booking
TikTok$18236 leads$7754 bookings
Google Ads$35168 leads$7775 bookings
Facebook$23208 leads$8755 bookings
All platforms$24612 leads$80184 bookings

Cost per booking by service

Botox$7765 booked
Lip filler$10335 booked
Laser hair removal$10536 booked
HydraFacial$4948 booked

Cost per booking, week over week

$96Sep 2
$93Sep 9
$95Sep 16
$89Sep 23
$88Sep 30
$86Oct 7
$84Oct 14
$80Oct 21
Illustrative dataPowered by Maven

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 walkthrough

This 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.