01
Paid → revenue funnel
iData rule: spend, impressions, clicks and LP clicks come from paid-platform exports. The lead/sign-up KPI comes from HubSpot Ads CRM Leads, because Google Contacts - Lead and signup_completed changed over time and should not be summed as separate lead sources.
02
Channel truth table
iGoogle Ads delivery is a period aggregate. Primary lead/signup uses HubSpot Ads CRM Leads. Activated users uses Contacts - Activated User. MQL uses the HubSpot Marketing Qualified Leads count from the new HubSpot report. Customer is removed from this view. True PQL / ICP-fit is not in this export.
01
Google Search funnel
02
Google Ads source tables
CRM leads by ad group
HubSpot Ads report Leads column. This is the primary Google lead/sign-up KPI.
Lead reconciliation
Primary KPI: HubSpot Ads CRM Leads = 1,546. Google conversion actions are diagnostics and must not be added together.
iPlain concept: this tab defines the reporting destination. It does not pretend the product/revenue numbers are inside the paid CSVs.
01
Final revenue funnel layer
02
Metric contract