Meta Ads Dashboard

Cost per booked call, week by week

Hubjoy VV

Weekly Trend

Week	HJ Spend	VV Spend	HJ Book	VV Book	HJ CPBC	VV CPBC

Ad Set Performance

VV Ad Sets

Ad Set	4-Wk Spend	4-Wk Leads	CPL (4-Wk)	This Wk	Last Wk	Status

Hubjoy Ad Sets

Ad Set	4-Wk Spend	4-Wk Leads	CPL (4-Wk)	This Wk	Last Wk	Status

Pipeline + Outcomes

VV Bookings This Week

Deal	Current Stage	Created

VV Active Pipeline (Past Discovery)

Deal	Stage	Days Open

VV Pending Deals

Deal	Created	Days Pending

VV Cumulative Summary

Metric	Value

Hubjoy Bookings This Week

Deal	Current Stage	Created

Hubjoy Active Pipeline (Past Discovery)

Deal	Stage	Days Open

Hubjoy Pending Deals

Deal	Created	Days Pending

Hubjoy Cumulative Summary

Metric	Value

Reminder: Ad-spend only comparison. HJ also carries SDR/Dave time, nurture emails, and phone costs that VV does not.

Where to Invest Next

Recent performance (what we're projecting from)

Side	Spend (4w)	Avg/wk	Booked	CPBC

What extra spend would likely produce

Assumes current CPBC holds. More spend usually means slightly higher costs. Rough estimates.

Scenario (over 4 weeks)	Extra spend	Est. bookings	Est. completed

Pipeline to Revenue

How ad spend turns into customers and revenue. Using $25,000 average LTV per customer as placeholder.

The funnel so far

Stage	Hubjoy	VV	Total

How long it takes to close a customer

Active pipeline deals

Company	Side	Current Stage	Days open

Important context. HJ's real customer acquisition cost is higher - this report only counts ad spend. HJ also carries SDR time, nurture emails, and phone costs. The $25,000 LTV is a placeholder.

Deal-by-Deal Audit

VV Booked Calls

Wk	Created	Company	Outcome	Stage	Days

Hubjoy Paid Booked Calls

Wk	Created	Company	Outcome	Stage	Days

Excluded Deals

Created	Company	Source	Reason

Reconciliation

Bucket	Count

Methodology

What counts as a booked call

Any deal in the default sales pipeline with a createdate inside the reporting window.

Call outcome rules

Current Stage	Call Outcome
Expressed Interest	Pending (booked, not yet held)
Recycled	No-show
Discovery / Deep Dive / Audit / Closing / Proposal Signed / Closed Won	Completed
Closed Lost (with discovery completed)	Completed (call happened, deal didn't close)

How we assign VV vs Hubjoy

VV: contact custom_contact_source IN (VV-Zapier, VV-Discovery) OR hs_analytics_first_url contains try.hubjoy.co
Hubjoy paid: contact hs_analytics_source = PAID_SOCIAL AND not VV
Excluded: everything else (organic, referral, direct traffic, etc.)

Why we use createdate, not meeting date

Createdate never changes. Meeting date gets overwritten when calls are rescheduled.
Meeting date is sometimes blank on valid bookings.
Createdate is the moment the booking happened - closest event to the ad.
Lines up ad spend weeks with booking event weeks.

Data sources

Meta ad spend: Pipeboard MCP at campaign level for the reporting window.
HubSpot deals: API deal search, default pipeline, createdate in window.
Contact attribution: HubSpot contact properties (custom_contact_source, hs_analytics_source, hs_analytics_first_url).

Known caveats

Ad-spend only. HJ's real cost includes SDR time, nurture emails, and phone costs.
Small sample sizes. Show rate conclusions are directional, not definitive.
HJ pending deal staleness. Many pending HJ deals are 30+ days old. If resolved as no-shows, HJ's show rate would drop further.
VV pixel leads vs HubSpot bookings gap. VV reports more leads in Meta than appear in HubSpot.
$25,000 LTV is a placeholder. Replace with real deal revenue data when available.

Week boundaries

Monday-Sunday (ISO). Deals created on Monday belong to that week's Monday-Sunday window.

Paid Ads Dashboard