Blog · Board and management reporting
Paid social KPIs connect campaign spending, clicks, orders, new customers, and attributed revenue. Use a worked campaign example to calculate the measures and check the attribution rules before changing budgets.
A paid social KPI connects campaign spending to a specific result under a stated attribution rule. Report clicks, orders, new customers, and attributed revenue together, then calculate the cost of each result. A click measure helps explain delivery; it cannot, on its own, tell a finance team whether the spending earned an acceptable return.
For an online seller, the conversion might be a paid order. For a business sales team, it might be a qualified lead accepted by sales. Keep the event consistent across campaigns and label it plainly; mixing form submissions with purchases produces a meaningless cost-per-conversion comparison.
Write the rule beside the report: the eligible touch, credit allocation, conversion window, reporting time zone, and date used to group results. Keep click-attributed and view-attributed outcomes separate unless a combined measure is explicitly required. The report should let a reviewer explain why a given order belongs to a given campaign.
Clicks need a definition too. The IAB Click Measurement Guidelines distinguish clickthroughs from interactions within an ad and address valid-click counting and filtration. Use outbound clicks consistently in the example below, rather than combining every social interaction into one denominator.
A KPI also needs an owner. Marketing owns campaign definitions and media spending; sales or ecommerce operations owns the outcome event; finance owns the revenue and cost treatment. Agree on those definitions before setting targets.
Start with a campaign export containing campaign ID, channel, reporting date, spend, impressions, and outbound clicks. Add an order summary with order ID, order date, assigned campaign, net revenue, and a new-customer flag. Determine new-customer status from the company's customer history, rather than assuming every conversion is a new buyer.
Keep one assigned campaign per order in this example. Reconcile orders and revenue to the sales export before summarizing them by campaign. If reporting partial credit instead, use a separate weighted-credit measure and verify that each order's credits sum to the intended total.
For a lead-generation business, the equivalent check links accepted leads to their source records and qualification status. The broader customer KPIs review covers subsequent customer behavior; this page focuses on acquisition spending and the outcomes assigned to it.
A US office-supplies seller reviews September spending. Its chosen rule credits a paid order to the most recent eligible paid-social click within seven days before the order, with no view-based credit. The file includes orders through October 7 so the September click cohort has time to mature. This is an example policy, not a claim about any platform's default settings.
Revenue is merchandise sales after discounts and refunds, excluding sales tax and shipping charges. Media spend excludes creative production and agency fees. The assigned order rows are mutually exclusive across the two campaigns.
| Campaign | Spend (USD) | Impressions | Outbound clicks | Assigned orders | New customers | Attributed net revenue (USD) |
|---|---|---|---|---|---|---|
| Social A prospecting | 12,000 | 400,000 | 8,000 | 200 | 150 | 36,000 |
| Social B retargeting | 8,000 | 200,000 | 2,000 | 100 | 80 | 24,000 |
| Total | 20,000 | 600,000 | 10,000 | 300 | 230 | 60,000 |
These are illustrative company records. Impressions are exposures counted by the source report, not a deduplicated count of people. Assigned orders also differ from new customers because a returning customer can place an order.
Outbound click-through rate = Outbound clicks / Impressions
Click-to-order conversion rate = Assigned orders / Outbound clicks
Cost per order = Media spend / Assigned orders
Media spend per new customer = Media spend / New customers
Attributed ROAS = Attributed net revenue / Media spend
| Measure | Social A calculation | Social A | Social B calculation | Social B | Total from summed inputs |
|---|---|---|---|---|---|
| Outbound click-through rate | 8,000 / 400,000 | 2.0% | 2,000 / 200,000 | 1.0% | 10,000 / 600,000 = 1.7% |
| Cost per outbound click (USD) | 12,000 / 8,000 | 1.50 | 8,000 / 2,000 | 4.00 | 20,000 / 10,000 = 2.00 |
| Click-to-order conversion rate | 200 / 8,000 | 2.5% | 100 / 2,000 | 5.0% | 300 / 10,000 = 3.0% |
| Cost per order (USD) | 12,000 / 200 | 60.00 | 8,000 / 100 | 80.00 | 20,000 / 300 = 66.67 |
| Media spend per new customer (USD) | 12,000 / 150 | 80.00 | 8,000 / 80 | 100.00 | 20,000 / 230 = 86.96 |
| Attributed ROAS | 36,000 / 12,000 | 3.00x | 24,000 / 8,000 | 3.00x | 60,000 / 20,000 = 3.00x |
Percentages round to one decimal place; dollar ratios and ROAS round to two. Retain unrounded inputs when calculating totals. The total cost per order comes from total spending divided by total orders, rather than an average of campaign ratios.
Social A has cheaper clicks, cheaper orders, and lower media spending per new customer. Social B converts a larger share of its outbound clicks into orders. Both return the same attributed revenue per media dollar, so higher conversion alone does not establish which campaign deserves more budget.
Audience and purpose matter. Retargeting may reach people already close to purchasing, while prospecting seeks a different audience. Compare each campaign with its agreed objective and prior comparable cohorts. Check whether new-customer value, product mix, or available audience changes the business case before shifting spending.
Attributed ROAS is a revenue measure, not profit or incremental sales caused by advertising. Research comparing advertising measurement with randomized experiments found observational approaches often differed from experimental results. Treat attribution as an allocation rule; use an appropriately designed experiment when the decision requires a causal estimate.
The example's media spend per new customer is also narrower than full customer acquisition cost. A broader acquisition measure needs the other included costs and a consistent customer population. The distinction between a KPI, metric, and measure helps keep these labels precise.
The campaign export must sum to $20,000 of included media spending. The assigned order file must contain 300 distinct orders, 230 first-time customers under the stated rule, and $60,000 of included revenue. A customer with several orders still contributes only once to the new-customer count.
Reconcile excluded orders separately: organic, other channels, orders outside the window, and unmatched records. Do not force every sale into a social campaign merely to make channel revenue equal company revenue. A dashboard review is easier to trust when its totals can be traced to those records.
Bring campaign spending and an approved, aggregated conversion-and-revenue export with consistent attribution definitions. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See self-service analytics for the supporting approach to working through business questions from your files.
Start with spend, outbound clicks, the conversion event that matters to the business, new customers, and attributed net revenue. Derive cost and return measures from those inputs. Include impressions and click-through rate to diagnose delivery, while keeping the business outcome central to budget decisions.
No. Return on ad spend divides attributed revenue by advertising spend. It leaves out product costs, fulfillment, overhead, and other expenses unless you explicitly build a separate contribution calculation. Revenue can exceed media spending while the campaign still falls short of its contribution requirement.
Reports may use different conversion events, attribution windows, time zones, or rules for crediting a view versus a click. Several channels may also claim the same order. Compare the definitions and reconcile order IDs before interpreting a difference as missing sales or tracking failure.
A high rate means the counted clicks are large relative to impressions. It does not establish lead quality, purchasing intent, or profitable acquisition. Read it alongside conversion rate and cost per business outcome, using a consistent definition of outbound clicks rather than all interactions.