Facebook audience analysis: compare reach and engagement

Facebook audience analysis compares how many accounts your content reached with the interactions that content generated over matching periods. Keep reach and actions separate, define your ratio explicitly, and check the underlying counts before explaining a percentage change.

Start with matching aggregate exports

Bring the export your team already has, together with its reporting dates, account identifier, extraction date, and metric descriptions. Keep the original file untouched and prepare a working sheet with one row per account and reporting window. Choose equal windows and the same time zone.

Meta explains that content with the most engagement is not necessarily content with the greatest reach. That distinction is the starting point: a larger audience and a more responsive audience answer different questions.

For this comparison, use reach for the whole window and separate columns for reactions, comments, and shares. Record whether each field includes paid distribution. If an export labels a field differently, preserve its definition; do not rename views or impressions as reach simply to complete the sheet.

The rows below are a fictional US industrial distributor's aggregate content results. Both windows cover fourteen days. They show response to content, without advertising spend, conversion attribution, or customer identities. Use advertising analytics when the question concerns campaign spending and attributed business results.

Build the spreadsheet calculation

Put these headers in A1:G1: Period, Reach, Reactions, Comments, Shares, Selected interactions, and Interaction ratio. The input rows occupy rows 2 and 3. Reach is the supplied whole-period audience figure; the selected interactions column is your calculated subtotal.

Calculate selected interactions in F2:

=SUM(C2:E2)

Calculate the ratio in G2:

=IF(B2>0,F2/B2,NA())

Fill both formulas down to row 3 and format G as a percentage with two decimal places. These formulas use ordinary cell references; Microsoft documents SUM as adding values or ranges. Check that the component cells contain numbers before summing them.

Selected interaction ratio = (Reactions + Comments + Shares) / Whole-period reach

This is an explicitly chosen business ratio, rather than a claim about the platform's own engagement-rate formula. It counts actions per reached account. The same account can react and comment, so it is not the percentage of distinct accounts that engaged.

Compare the movement and prove the result

Put the comparison labels in I1:J1 as Measure and Change. Enter the following formulas in J2:J4 alongside the corresponding labels.

The audience grew faster than the selected actions. Reach rose from 40,000 to 50,000, while interactions rose from 1,500 to 1,600. The resulting ratio fell from 3.75% to 3.20%. Percentages are rounded to two decimal places; the calculations retain full precision.

Rebuild the first subtotal as 1,200 + 180 + 120 = 1,500 and the second as 1,250 + 200 + 150 = 1,600. Then check that each component agrees with its corresponding source field and that each reach figure matches the original whole-window report. These checks catch transcription mistakes that a correctly written ratio cannot catch.

Do not total the two reach rows and label the result unique reach for September. People can appear in both windows. A combined-period audience needs its own deduplicated aggregate from the source. Audience overlap analysis addresses that separate comparison when suitable evidence is available.

Turn the comparison into a review question

The table supports a precise conclusion: distribution expanded, selected actions increased, and actions per reached account declined. It does not establish that the new audience was less valuable or that any content caused a sales change.

Have the content owner review changes in publishing volume, topic, format, and paid distribution between the windows. Add those as explanatory notes or separate comparisons using the same definitions. Keep the main table intact so the team can distinguish observed movement from proposed explanations.

If the business objective is more qualified website activity, compare a separately supplied site report using website audience analysis. The social audience and the website audience have different units and should keep their own denominators.

Where Facebook audience analysis goes wrong

• Adding unique audiences across posts or dates. Overlap makes those sums unsuitable as a whole-period unique audience.
• Changing the numerator. Adding clicks in the second window while counting only reactions, comments, and shares in the first creates an artificial change.
• Changing the audience scope. Paid and organic distribution need consistent inclusion rules before comparing periods.
• Reading missing values as zero. An unavailable comment or reach field means the ratio is incomplete. Keep it flagged until the source is checked.
• Calling actions people. An action subtotal cannot identify distinct engaged accounts or the individuals behind an aggregate.

Covirage is not affiliated with Meta, Facebook, or Microsoft.

Compare your own export in Covirage

Upload your aggregate audience file or Google Sheet to Covirage; it maps the columns, and its tools compute and check the period 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 export; creating the account takes about a minute.

See self-service analytics for the supporting workflow.