Combine HubSpot with Facebook Ads to get real CPL and CAC
Facebook lead form and landing page ads pour leads into HubSpot. Ads Manager reports cost per result, but it does not know which leads qualified or which became customers. HubSpot knows that, but it does not know the cost. With both sources combined, DataxLand puts spend by day and campaign next to leads, qualified leads and new customers, and computes cost per lead, MQL rate, lead-to-customer rate and customer acquisition cost. You see which campaigns bring cheap leads but expensive customers.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- A cheap lead is not necessarily a good lead; only the CRM knows which leads became customers.
- Meta's cost per result does not account for duplicate or junk leads that the CRM rejects.
- Real CAC needs ad spend and new customers from the CRM in the same period.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Cost per lead (CPL) | Marketing spend ÷ leadsLeads are counted in HubSpot, by the source or campaign attached to each lead. |
| MQL rate | Qualified leads ÷ leads |
| Lead-to-customer rate | Leads converted to customers ÷ leads |
| Customer acquisition cost (CAC) | Marketing spend ÷ new customers from marketing |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Leads | Number of leads (prospects) created in the period, by creation date. | Count |
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
| MQL rate | Marketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / Leads | Ratio (%) |
| Lead-to-customer rate | Leads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / Leads | Ratio (%) |
| Customer acquisition cost (CAC) | Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketing | Currency |
Questions you can answer
| Question | Facebook Ads only | HubSpot + Facebook Ads combined |
|---|---|---|
| Are the leads any good? | Unknown | MQL rate, lead-to-customer rate |
| How much do I spend per customer? | Unknown | CAC by campaign |
| Which campaigns should I stop? | By cost per result | By CAC and lead-to-customer rate |
Steps
- 1
Connect HubSpot
Create a private app in HubSpot with read access to contacts and deals, and paste its access token into DataxLand.
- 2
Connect Facebook Ads
Paste an access token with ads read permission and your ad account ID; DataxLand reads campaigns, ad sets, ads and daily metrics.
- 3
Review Si's mapping
Si proposes which HubSpot properties hold the lead's source and campaign to join with Facebook campaigns, and which stages count as MQL and customer; you approve.
- 4
Build and read the dashboards
The Marketing funnel and Campaigns and budget dashboards show CPL, MQL and CAC by campaign; set an alert when CAC rises.
Frequently asked questions
What about leads with no campaign information?
Leads missing a source or campaign count toward the total but are not attached to any campaign; Si shows the share of unattributed leads so you can fix your UTM tags or forms.
Is contact information in HubSpot exposed?
No. Emails, phone numbers and names are hashed on load and masked before they reach Si. Dashboards only show aggregated numbers.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect HubSpot →Connect Facebook Marketing →Ask Si about your HubSpot data →Ask Si about your Facebook Marketing data →
Other combinations
- Combine HubSpot with Google Ads to see which keywords bring real customers
- Combine Stripe with HubSpot to see the MRR your sales team brings in
- Combine Excel orders with Facebook Ads for shops that sell through a fan page
- Combine your PostgreSQL order database with Facebook Ads
- Combine Shopee with Facebook Ads to see your blended ROAS
- Combine Shopify with Facebook Ads to see profit after advertising
Combine HubSpot and Facebook Marketing in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes