Ad spend and pipeline in one report.

Campaign ROI

For each campaign you get spend, contacts, deals, cost per contact and per opportunity, deal value, open pipeline, won revenue and ROAS. UTM values that couldn't be matched to a campaign are listed separately, and the agent can assign them to a campaign on the next call.

Channels

For each traffic source in HubSpot (paid search, paid social, organic search, direct and the rest) you get contacts, deals and revenue. For paid search and paid social, the hub adds ad spend, cost per lead and cost per opportunity.

Matching and attribution

The Data Hub matches campaigns by the name in utm_campaign, as HubSpot stores it in its traffic sources, or by campaign ID.

• First touch (Original Source) or last touch (Latest Source)
• Deals take the source of their oldest associated contact
• Based on contacts and deals created in the selected period
• Amounts in HubSpot's company currency. If currencies differ, the hub skips ROAS and says so.

What you need

HubSpot plus at least Google Ads, LinkedIn Ads or Meta Ads. Each source is queried through its own connection, so access levels and allowed accounts apply just as they would for a direct call. The reports are read-only, need no approval and come with the Reporting and Campaign management templates. The Ad ROI review playbook walks the agent through the analysis.

Checked figures, nothing stored

Report results carry the same data context, including definitions of each metric, and the agent can check its figures against a fresh calculation with the fact check. Nothing is stored along the way: the log records the call, not the numbers.