Compare supplied social audience segments with engagement, leads and recorded first orders. Work from exported files, keep denominators consistent and reconcile matched revenue before making a business decision.
For audience analysis, social media exports let a business compare supplied audience segments, engagement and recorded sales outcomes. Calculate composition within each platform, then place matched lead and order results beside it. Keep the distinction between audience description and purchase attribution clear throughout the review.
A US business equipment distributor wants to know whether its social campaigns reach the business functions that generate recorded orders. Marketing owns the audience and campaign exports; sales operations owns lead identifiers; finance owns the order totals. Agree on the reporting period and matching rules before comparing results.
Use the segment labels already present in supplied aggregate files. Do not guess personal traits from names, photographs or engagement. If the audience export and the commercial export do not share a documented segment mapping, compare them at platform or campaign level instead.
This review concerns the audience and its recorded outcomes. The broader social media marketing analytics article covers campaign performance, while website audience analysis considers visitors after they arrive on your site.
Keep the original files, and create a comparison sheet with one row per platform and supplied segment for September 2026. Audience accounts are a September 30 snapshot; impressions and engagement events cover September. The commercial cohort consists of leads created in September and their first orders recorded through October 15, 2026.
The example assumes the source files already provide compatible aggregate segment labels and documented campaign mappings. Each lead belongs to one campaign, and each converted lead contributes at most one first order. Record unknown or unmatched values separately; they are not evidence of no activity.
| Platform | Supplied segment | Audience accounts | Impressions | Engagement events | Matched leads | First orders | First-order revenue (USD) |
|---|---|---|---|---|---|---|---|
| Network A | Operations | 6,000 | 30,000 | 1,200 | 60 | 12 | 18,000 |
| Network A | Finance | 4,000 | 20,000 | 600 | 30 | 9 | 18,000 |
| Network B | Operations | 3,000 | 12,000 | 360 | 24 | 6 | 9,000 |
| Network B | Finance | 2,000 | 8,000 | 160 | 16 | 4 | 8,000 |
| Total account memberships and events | 15,000 | 70,000 | 2,320 | 130 | 31 | 53,000 |
Audience counts across networks are account memberships, not deduplicated people. Engagement events can include repeat actions; they are not unique engaged accounts. Both distinctions belong in the report beside the table.
For campaign identification, Google Analytics documents source, medium and campaign URL parameters. Use consistently recorded campaign identifiers where your exports contain them. A campaign parameter does not establish an individual audience member's identity or demographic segment.
Place the input table in A1:H5, excluding its total row. In I2, calculate the segment's share of that platform's audience:
=IF(SUMIFS($C$2:$C$5,$A$2:$A$5,A2)=0,"",C2/SUMIFS($C$2:$C$5,$A$2:$A$5,A2))
Microsoft's SUMIFS documentation explains how the function sums rows meeting specified criteria. Here, the criterion is the platform in A2. Fill down; Operations represents 60.0% of each network's supplied audience, and Finance represents 40.0%.
Use these formulas for engagement per impression in J2, first orders per matched lead in K2, and average first-order value in L2:
=IF(D2=0,"",E2/D2)
=IF(F2=0,"",G2/F2)
=IF(G2=0,"",H2/G2)
Blank results mean the denominator is zero. Investigate missing source values before applying the formulas; do not silently turn a missing export into zero performance. Covirage is not affiliated with Microsoft or Google.
Sum the inputs by platform before dividing. For Network A's engagement rate, use:
=SUMIFS($E$2:$E$5,$A$2:$A$5,"Network A")/SUMIFS($D$2:$D$5,$A$2:$A$5,"Network A")
The following results use unrounded inputs. Percentages are rounded to one decimal place and order values to cents.
| Platform | Impressions | Engagement events | Matched leads | First orders | Revenue (USD) | Events / impressions | Orders / leads | Average first order (USD) |
|---|---|---|---|---|---|---|---|---|
| Network A | 50,000 | 1,800 | 90 | 21 | 36,000 | 3.6% | 23.3% | 1,714.29 |
| Network B | 20,000 | 520 | 40 | 10 | 17,000 | 2.6% | 25.0% | 1,700.00 |
| Total | 70,000 | 2,320 | 130 | 31 | 53,000 | 3.3% | 23.8% | 1,709.68 |
Network A has more recorded engagement per impression, but Network B has a higher first-order rate among matched leads. That suggests separate questions about campaign response and lead quality. It does not justify assuming Network B's entire audience is more valuable.
For a dedicated review of the first handoff, use click-to-lead conversion rate. For accounts appearing in multiple exported audiences, use audience overlap analysis rather than adding audience counts and calling the sum reach.
The platform revenue totals must equal the matched order detail: 36,000 + 17,000 = $53,000. Check that each order identifier appears once, that cancellations and credits follow the same policy, and that the order window matches the stated cohort.
Suppose the same cohort's order register contains the following reconciliation:
| Reconciliation item | First-order revenue (USD) |
|---|---|
| Matched to supplied social campaigns | 53,000 |
| Not matched to those campaigns | 6,000 |
| Order register total | 59,000 |
The identity is 53,000 + 6,000 = 59,000. Matching coverage is 53,000 / 59,000 = 89.8%, rounded to one decimal place. Keep the unmatched $6,000 visible; do not distribute it in proportion to audience size.
Upload your audience summaries and matched campaign, lead and order workbook; Covirage maps the columns, and its tools compute segment shares, rates and reconciliation checks. 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; creating the account takes about a minute.
See sales insights for the supporting business context.
Aggregate audience exports alone cannot identify individual buyers. You need a documented connection between campaign records and your own lead or order records. If that connection exists only at campaign level, report campaign outcomes beside audience composition without claiming that particular audience members purchased.
Choose a denominator that fits the question and label it. Engagement events divided by impressions measures events relative to exposures; events divided by audience accounts answers something different. Keep the same event definition and denominator when comparing segments or periods.
Only if the resulting measure is labeled as account memberships across platforms. One person may appear on several platforms, so the sum does not establish unique reach. Compare composition within each platform unless your supplied files contain a valid deduplication method.
No. Engagement and recorded purchases can move together without showing that the engagement caused the purchase. Compare matched outcomes, purchase timing and campaign scope, then use a separately designed business test before making a causal claim or a major spending change.