Blog · Board and management reporting
Influencer analytics compares creator costs, recorded reach, engagement and attributed sales. Build a consistent campaign spreadsheet, calculate the rates and reconcile orders before making a renewal decision.
Influencer analytics compares creator campaign costs, engagement and attributed sales on a consistent basis. Start with the campaign results and order exports you already have, then separate audience activity from commercial outcomes. A creator with the strongest engagement rate does not automatically generate the most revenue per campaign dollar.
Choose a reporting period, an order cutoff and one campaign identifier for each creator engagement. State whether reach covers all posts in the engagement or only the posts included in the spending total. Use the same definition of engagements across creators, such as the recorded sum of likes, comments, shares and saves.
Keep campaign spending in a separate register with creator fees, gifted-product cost, agency charges and allocated campaign labor. Document the allocation basis. Combining fees from a whole engagement with results from its opening post makes the creator look more expensive than the comparable campaign.
Prepare an order-level file with a unique order ID, assigned creator campaign, billed sales and refunds. Establish how an order receives campaign credit before comparing results. If a discount code and a tracked link identify the same order, apply your agreed precedence rule and count the order once. Keep unassigned orders visible outside the creator comparison.
Google Analytics documents campaign parameters, including source, campaign and content. Preserve these identifiers when they are available in your exports; content values can distinguish creative variants. This analysis uses supplied identifiers and recorded results rather than identifying potential creators or investigating audience authenticity.
For the separate question of audience suitability, use influencer audience analysis. Audience fit belongs beside the performance result, rather than being inferred from the size of a creator's following.
A US home-goods company compares completed creator engagements for September 2026. Each assigned order appears once, and the refund cutoff is the same for every creator. The spending register includes the agreed campaign costs. The following activity columns occupy A through F in the summary sheet.
| Creator campaign | Campaign cost (USD) | Reported reach | Engagements | Tracked visits | Attributed orders |
|---|---|---|---|---|---|
| North | 6,000 | 100,000 | 5,000 | 1,600 | 80 |
| Lake | 4,000 | 60,000 | 4,200 | 1,200 | 60 |
| Cedar | 2,000 | 40,000 | 1,600 | 400 | 20 |
| Total | 12,000 | 200,000 | 10,800 | 3,200 | 160 |
The reach total is the sum of creator-reported reach, with possible overlap. It is not deduplicated campaign reach. Engagements are actions, so they need not represent distinct people either.
Place billed sales in G, refunds in H and net revenue in I:
| Creator campaign | Billed sales (USD) | Refunds (USD) | Net revenue (USD) |
|---|---|---|---|
| North | 17,000 | 1,000 | 16,000 |
| Lake | 9,500 | 500 | 9,000 |
| Cedar | 3,500 | 500 | 3,000 |
| Total | 30,000 | 2,000 | 28,000 |
Use sales after discounts, excluding collected sales tax, with a consistent shipping treatment. Here refunds are positive deductions from those sales. Do not subtract them again if the order export already supplies revenue net of refunds.
Suppose Orders contains one row per order, campaign in B, billed sales in C and refunds in D. Billed sales for the campaign in summary cell A2 are:
=SUMIFS(Orders!$C$2:$C$5000,Orders!$B$2:$B$5000,$A2)
Use the same formula against Orders column D for refunds. Microsoft's SUMIFS documentation explains how matching criteria select the values to sum. Increase the range when the export extends beyond it, and confirm campaign labels agree across files.
Covirage is not affiliated with Google or Microsoft.
Enter these Excel or Google Sheets formulas in I2, J2, K2, L2 and M2, respectively, then fill down:
=G2-H2
=IF(C2=0,"",D2/C2)
=IF(E2=0,"",F2/E2)
=IF(F2=0,"",B2/F2)
=IF(B2=0,"",I2/B2)
These are, respectively, net revenue, engagements per reported reach, orders per tracked visit, cost per attributed order and net revenue per campaign dollar. Format J and K as percentages. Show dollars and revenue multiples to two decimal places; retain unrounded values in the workbook.
| Creator campaign | Engagement / reach | Orders / visits | Cost per order (USD) | Net revenue / cost |
|---|---|---|---|---|
| North | 5.00% | 5.00% | 75.00 | 2.67x |
| Lake | 7.00% | 5.00% | 66.67 | 2.25x |
| Cedar | 4.00% | 5.00% | 100.00 | 1.50x |
| Total | 5.40% | 5.00% | 75.00 | 2.33x |
Lake leads on engagement and cost per attributed order. North leads on net revenue per campaign dollar. Those results answer different renewal questions; delivery costs would still be needed to compare profit. Use influencer marketing ROI for that narrower investment calculation.
The sales check is $30,000 less $2,000 equals $28,000. Campaign net revenues also sum to $28,000, and the assigned order file must contain the same 160 unique orders represented in the activity table. Reconcile the $12,000 campaign cost to the approved spending register separately.
Compute total ratios from totals. For example, =SUM(I2:I4)/SUM(B2:B4) gives 2.33x, while =SUM(B2:B4)/SUM(F2:F4) gives $75.00 per order. Averaging the displayed creator ratios gives each engagement equal weight regardless of spending or order volume.
Google defines attribution as assigning credit along the customer path. Credit is not proof of incremental demand. Use influencer marketing attribution to resolve overlapping sales credit before interpreting these comparisons.
For post and creative comparisons, see the campaign and content measures in social media marketing analytics. Keep that diagnosis separate from the creator-level renewal decision here.
Bring a campaign spending file, recorded activity summaries and a prepared order export to Covirage; it maps the columns, and its tools compute and check the campaign comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See sales insights for the supporting business context.
Choose metrics that match the campaign objective. Reach and engagement describe recorded audience activity; attributed orders and net revenue describe commercial outcomes under a stated assignment rule. Include total campaign cost so the review can distinguish an engaging creator from an economical source of recorded orders.
You can show the sum of creator-reported reach, but label it as such. The same person may appear in several creators' audiences. Without a defensible overlap adjustment, that sum does not represent the number of unique people reached by the combined campaign.
Attributed revenue records sales credit under a chosen rule. Return on investment also requires the relevant delivery costs and full campaign investment. Neither measure alone proves causality: some customers might have purchased without the campaign, so incremental impact requires separate supporting evidence.