Skip to content
+

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

MetricHow it is computed
Cost per lead (CPL)Marketing spend ÷ leadsLeads are counted in HubSpot, by the source or campaign attached to each lead.
MQL rateQualified leads ÷ leads
Lead-to-customer rateLeads 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.

MetricDefinitionUnit
Marketing spendTotal cost of marketing campaigns by spend date.Currency
LeadsNumber 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 / LeadsCurrency
MQL rateMarketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / LeadsRatio (%)
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency

Questions you can answer

QuestionFacebook Ads onlyHubSpot + Facebook Ads combined
Are the leads any good?UnknownMQL rate, lead-to-customer rate
How much do I spend per customer?UnknownCAC by campaign
Which campaigns should I stop?By cost per resultBy CAC and lead-to-customer rate

Steps

  1. 1

    Connect HubSpot

    Create a private app in HubSpot with read access to contacts and deals, and paste its access token into DataxLand.

  2. 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. 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. 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 and Facebook Marketing in minutes

Free plan with no time limit · No card required · Sample workspace ready in minutes