Blog · How-to guides · Sales teams
Analyze influencer audience fit using supplied aggregate summaries and campaign results. Compare a clearly defined target segment, consistent engagement ratios, and observed qualified leads without inferring missing audience evidence.
Analyze influencer audience fit by comparing supplied aggregate evidence with the customers your company wants to reach. Calculate a clearly defined segment share, keep engagement on a consistent basis, and use observed campaign outcomes to test whether audience fit translates into qualified interest.
Write the audience requirement as a business question. A US commercial lighting supplier might want US purchasing contacts at electrical contractors. Country is one part of that requirement; buying responsibility and company type are separate parts.
The Small Business Administration's market-research guidance recommends gathering relevant demographic information and considering where customers live and where the business can reach. For this workflow, the practical consequence is to define the segment before looking at creator rankings.
Use your target market analysis to establish the customer requirement. Then list which parts are evidenced by each supplied summary. A country breakdown may support geographic fit while leaving employer type and purchasing authority unmeasured. Keep those gaps explicit rather than converting a partial match into an overall fit score.
For each creator, record the source, extraction date, audience population, campaign window, included content, and metric definitions. Request the same reporting basis from each participant. A current follower snapshot cannot silently replace the follower base used in a historical campaign calculation.
Prepare one row per creator and campaign window. Keep audience evidence separate from your company's outcome evidence: creator-supplied counts belong to the former; tracked sessions and qualified lead records belong to the latter. A media-kit percentage without a stated denominator is incomplete.
The fictional lighting supplier below has two completed pilot campaigns with matching reporting windows and the same offer. Its supplied geography summaries use each creator's stated follower base and contain no unclassified country values. The interaction counts include the same selected action types for the same content scope.
Put these headers in A1:F1 and the two observations in rows 2 and 3:
| Creator | Stated followers | Reported US followers | Selected interactions | Tracked sessions | Qualified leads |
|---|---|---|---|---|---|
| Creator A | 40,000 | 24,000 | 1,600 | 800 | 24 |
| Creator B | 25,000 | 20,000 | 1,500 | 1,000 | 40 |
These are supplied aggregate inputs, not discovered audience information. If an actual summary has unknown geography, add that count and retain it in the denominator when reporting share of all followers. If only the known-geography base is available, label the share accordingly.
Add G1:I1 as US follower share, Interaction-to-follower ratio, and Qualified leads per tracked session. Enter these formulas in row 2 and fill down:
G2 = IF(B2>0,C2/B2,NA())
H2 = IF(B2>0,D2/B2,NA())
I2 = IF(E2>0,F2/E2,NA())
The labels before each equals sign identify the destination cells. Format the results as percentages with two decimal places. Keep full precision in the cells.
Geographic fit share = Reported US followers / Stated followers
Interaction-to-follower ratio = Selected campaign interactions / Stated followers
Observed lead-to-session ratio = Qualified campaign leads / Tracked campaign sessions
| Creator | US follower share | Interaction-to-follower ratio | Qualified leads per tracked session |
|---|---|---|---|
| Creator A | 60.00% | 4.00% | 3.00% |
| Creator B | 80.00% | 6.00% | 4.00% |
For Creator A, the calculations are 24,000 / 40,000, 1,600 / 40,000, and 24 / 800. Creator B uses 20,000 / 25,000, 1,500 / 25,000, and 40 / 1,000. Each percentage can be rebuilt from the input row.
Creator B has the higher geographic share and more observed qualified leads, despite a smaller stated follower base. Creator A has more reported US followers in absolute terms. Those are different findings; neither establishes the number of purchasing contacts in either audience.
Check that the geographic count is no larger than its stated base and that every campaign uses the same selected interactions. Reconcile qualified leads to your campaign report using a consistent qualification rule and duplicate treatment. Keep the same tracking window for sessions and leads, including any stated allowance for later conversions.
The worked example assigns every qualified lead to one primary campaign. Therefore, =SUM(F2:F3) gives 24 + 40 = 64 leads and must equal the campaign report total. Microsoft documents SUM as adding a range; numeric source cells and complete row coverage still need checking. This assignment rule concerns recorded leads, not overlap between creator audiences.
Do not add creator follower bases and call the result a unique combined audience. Use audience overlap analysis when supplied evidence can establish shared audiences. Likewise, use website audience analysis to investigate the tracked site activity without assuming every session represents a different person.
Covirage is not affiliated with Microsoft.
Upload your audience summaries and campaign-result file or Google Sheet to Covirage; it maps the columns, and its tools compute and check the supplied counts and ratios. 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 workflow.
Request an aggregate audience summary with reporting dates, population definitions, coverage, and relevant target-segment counts. Add campaign interactions and your own tracked sessions or qualified leads if available. Preserve the source of each field so unsupported claims remain visible.
A larger audience can contain a smaller proportion of the group you want to reach. Compare both the relevant segment count and its share of the stated population, then examine observed business outcomes using consistent campaign definitions.
No. An aggregate interaction count describes reported activity under the supplied definition. It cannot establish the identity or authenticity of the accounts behind it. Treat source quality as a separate evidence question and avoid labeling accounts from aggregate ratios.
Only when their populations and definitions support the calculation. A location share and an occupation share do not reveal the share meeting both conditions. Ask for a joint breakdown or leave that part of audience fit unmeasured.