SAP

Marketing & Advertising

Social Advertising Performance Calculator

Measure paid-social frequency, click, landing, lead and customer rates, acquisition costs, ROAS, gross profit, and contribution after advertising.

Impressions per reached account-
Link clicks divided by impressions-
Visitors divided by link clicks-
Leads divided by visitors-
Customers divided by leads-
Spend divided by leads-
Spend divided by customers-
Attributed revenue divided by spend-
Attributed gross profit-
Gross profit minus advertising spend-

Decision view

Paid-social funnel and contribution bridge

Paid-social funnel and contribution bridgeAudience volume narrows through each conversion stage before revenue is reconciled to gross profit and contribution.
Exact scenario comparisonAttributed customers changes while all other entered assumptions remain constant.
Attributed customersImpressions per reached accountLink clicks divided by impressionsVisitors divided by link clicksLeads divided by visitorsCustomers divided by leadsSpend divided by leadsSpend divided by customersAttributed revenue divided by spendAttributed gross profitGross profit minus advertising spend

How to use Social Advertising Performance Calculator

  1. Export impressions, unique reach, and link clicks for one campaign scope, date range, platform timezone, and attribution setting.
  2. Reconcile link clicks with measured landing visitors, then reconcile visitors with qualified leads using frozen event definitions.
  3. Enter attributed customers, spend, and revenue from the same cohort and attribution window without mixing platform and CRM populations.
  4. Enter realized gross margin after refunds or fulfillment costs when available, rather than treating revenue as contribution.
  5. Read adjacent-stage losses, CPL, CAC, ROAS, and contribution together, then test incrementality separately before changing budget.

Calculator guide

Understanding Social Advertising Performance Calculator

Paid social performance is a multi-stage conversion path. Reach, impressions, clicks, landing arrivals, leads, customers, revenue, gross profit, and ad spend should remain connected but not collapsed into one rate.

Adjacent stages Each rate uses the prior stage.
Losses stay visible Clicks and visitors are not merged.
Cost per outcome CPL and CAC share spend.
Margin before spend Revenue becomes gross profit first.

Detailed calculation process

Trace the paid-social funnel into contribution

The default campaign has 420,000 impressions, 185,000 reached accounts, 6,200 link clicks, 5,600 visitors, 780 leads, 145 customers, $32,000 spend, and $118,000 revenue.

General formula: f = I/RCTR = C/ILAR = W/CLR = L/WCR = U/LCPL = A/LCAC = A/UROAS = Q/AG = QgP = G-A Each conversion rate divides one stage by the immediately preceding stage. Revenue is reduced by gross-margin share before advertising spend is subtracted.

What each symbol means

I, R Impressions and unique reach (counts).
C, W Link clicks and landing visitors (counts).
L, U Qualified leads and attributed customers.
A, Q Advertising spend and attributed revenue (currency).
f, CTR Frequency and click-through rate.
LAR, LR, CR Landing-arrival, lead, and customer conversion rates.
g, G, P Gross-margin share, gross profit, and contribution after ads.

Worked substitution with the default inputs

1. Measure exposure and clicks f = 420,000/185,000 = 2.27027CTR = 6,200/420,000 = 1.47619% Frequency uses reach; CTR uses impressions.
2. Measure landing arrival LAR = 5,600/6,200 = 90.3226% The loss from clicks to recorded visitors is kept visible.
3. Measure lead and customer conversion LR = 780/5,600 = 13.9286%CR = 145/780 = 18.5897% Lead and customer quality are separate funnel stages.
4. Calculate acquisition costs CPL = 32,000/780 = $41.0256CAC = 32,000/145 = $220.6897 Both use the same spend but different outcome counts.
5. Bridge revenue to contribution ROAS = 118,000/32,000 = 3.6875xG = 118,000×62% = $73,160P = 73,160-32,000 = $41,160 Gross margin converts revenue to gross profit before ad spend is deducted.

The default funnel converts 185,000 reached accounts into 145 customers at $220.69 CAC and produces $41,160 contribution after ads.

Measurement contract

Freeze platform, analytics, and CRM definitions

A funnel is valid only when every stage describes the same campaign population and reporting period.

Exposure scope Record platform, account, campaign, placements, dates, timezone, and whether reach is estimated.
Event scope Define link click, landing arrival, qualified lead, and customer before combining platform, analytics, and CRM exports.
Attribution scope Keep click-through, view-through, conversion window, deduplication, and reporting-date settings with the exported result.

Platform references: Meta Help, reach and impressions definitions (https://www.facebook.com/help/274400362581037) and Meta Conversions API measurement guidance (https://www.facebook.com/business/help/AboutConversionsAPI).

Funnel diagnosis

Treat every adjacent-stage loss as a different question

The proportional funnel helps locate where volume disappears, but the remedy depends on the transition rather than the largest percentage alone.

Impression to click Creative, audience, placement, and delivery influence CTR, while frequency provides repeated-exposure context.
Click to arrival Load speed, consent handling, redirects, duplicate clicks, and tracking continuity can separate clicks from recorded visitors.
Lead to customer Qualification rules, follow-up speed, sales capacity, offer fit, and conversion delay affect the final customer stage.

Decision boundary

Separate attributed efficiency from incremental value

ROAS and contribution describe the entered attributed cohort; they do not reveal what would have happened without the campaign.

Attribution The selected platform or analytics rule assigns credit across observed touchpoints.
Incrementality A holdout, lift test, or credible causal design is needed to estimate outcomes caused by advertising rather than merely associated with it.
Budget decision Scale only after checking marginal performance, capacity, cash timing, creative fatigue, and the uncertainty of attributed revenue and margin.

Worked situations

Practical examples

  • The default 420,000 impressions across 185,000 reached accounts produce frequency 2.2703 and link CTR 1.4762%; neither metric is a customer conversion rate.
  • Of 6,200 link clicks, 5,600 become recorded landing visitors, so landing arrival is 90.3226%. The gap should be investigated before later-stage lead quality is blamed.
  • Attributed revenue of $118,000 at 62% gross margin produces $73,160 gross profit. Subtracting $32,000 ad spend leaves $41,160 contribution, excluding other operating costs.

Better inputs

Useful tips

  • Freeze attribution window, timezone, campaign filters, and event definitions before exporting every funnel stage.
  • Inspect the largest adjacent-stage loss before optimizing; a click-to-arrival problem calls for a different response than a lead-to-customer problem.
  • Deduplicate browser, server, CRM, and offline events before comparing customer counts with spend.
  • Use realized gross margin after refunds, cancellations, chargebacks, and direct fulfillment cost when available.

Before relying on the result

Limitations and common mistakes

  • Platform attribution assigns credit under a selected rule and is not proof that advertising caused the outcome.
  • Reach may be estimated and reporting definitions can change across platforms, placements, privacy settings, and export dates.
  • Creative fatigue, organic lift, view-through credit, cross-device journeys, returns, taxes, fixed operating costs, and customer lifetime value are excluded.
  • All stages use aggregate counts, so segment mix, repeated people, cohort delay, and conversion-time distribution are hidden.

Reference

Key terms

Reach
Estimated number of distinct accounts or people exposed under the reporting platform's definition.
Impressions
Number of times an ad was displayed, including repeated exposure to the same reached account.
Frequency
Impressions divided by unique reach.
Click-through rate
Link clicks divided by impressions for the selected campaign scope.
Landing arrival
Recorded landing visitors divided by link clicks.
Cost per lead
Advertising spend divided by qualified leads under the frozen lead definition.
Customer acquisition cost
Advertising spend divided by attributed customers in the same cohort and window.
ROAS
Attributed revenue divided by advertising spend; it does not include gross margin by itself.
Contribution after ads
Attributed gross profit minus advertising spend, before other excluded operating costs.

Important note

Use one frozen measurement contract for the whole funnel and retain the export settings with the result. Do not treat platform-attributed customers, ROAS, or contribution as causal lift without an appropriate incrementality test.

Frequently asked questions

Why can landing visitors be lower than link clicks?

Page-load failure, redirects, consent settings, duplicate clicks, blockers, cross-device behavior, and different reporting definitions can all create a gap.

Is frequency a conversion rate?

No. It is impressions per reached account and describes repeated exposure, not progression to a downstream outcome.

Why subtract spend from gross profit instead of revenue?

Revenue still carries product or service delivery cost. Applying gross margin first keeps ad spend from being compared with an economically overstated value.

Does positive attributed contribution prove the campaign caused profit?

No. It shows positive contribution under the entered attribution and margin assumptions; incrementality and other operating costs require separate evidence.