Blog · Board and management reporting · Sales teams
Compare aggregate Instagram follower, reach, and engagement exports across matching periods. Use exact spreadsheet formulas to reconcile follower movement and interpret changes in audience response.
Instagram audience analysis compares follower growth with the audience reached and the interactions generated by content. Begin with aggregate exports for matching periods, reconcile the follower count, and calculate a response ratio whose numerator and denominator are written down.
A follower count is a balance at a point in time. Follows and unfollows are movements during a period. Reach and interactions describe activity over a period. Mixing those units makes a report look complete while hiding what changed.
Meta's Instagram best-practices announcement treats engagement and reach as separate areas, with follower growth discussed alongside reach. Use that distinction in your own review: first establish whether the base grew, then ask whether the audience exposed to content responded differently.
Work from the file you already have. Preserve its account identifier, dates, time zone, extraction date, content scope, and original metric labels. The calculation below calls the supplied unique audience figure "Reached accounts"; confirm your export's definition before mapping a differently named field into it. Total views and unique reached accounts are different units.
For the corresponding channel comparison, Facebook audience analysis uses aggregate reach and actions. Keep those results alongside this table, with their definitions visible, rather than assuming the audience measures can be added together.
The fictional example is a US commercial kitchen supplier's account. Each window covers fourteen days. All metrics use the same account and content scope; "Interactions" is the supplied count of likes, comments, saves, and shares under an unchanged definition.
Copy the following headers into A1:G1, with the data in rows 2 and 3. Opening and closing follower counts must use the boundaries of each activity window.
| Period | Opening followers | Follows | Unfollows | Closing followers | Reached accounts | Interactions |
|---|---|---|---|---|---|---|
| September 1-14, 2026 | 10,000 | 450 | 150 | 10,300 | 24,000 | 960 |
| September 15-28, 2026 | 10,300 | 500 | 200 | 10,600 | 30,000 | 900 |
Add H1:K1 as Net followers, Follower growth, Interaction ratio, and Follower residual. Enter these formulas in row 2 and fill down:
H2 = C2-D2
I2 = IF(B2>0,H2/B2,NA())
J2 = IF(F2>0,G2/F2,NA())
K2 = E2-(B2+C2-D2)
The labels before each equals sign show where to enter the formula. Format I and J as percentages with two decimal places, and leave H and K as counts.
Net follower growth = Follows - Unfollows
Follower growth rate = Net follower growth / Opening followers
Interaction ratio = Supplied interactions / Whole-period reached accounts
This interaction ratio counts actions relative to reached accounts. It does not measure the share of unique reached accounts who engaged, because one account can take several actions.
The calculated columns produce the following results. Percentages are rounded to two decimal places; use unrounded cells for subsequent calculations.
| Period | Net followers | Follower growth | Interaction ratio | Follower residual |
|---|---|---|---|---|
| September 1-14 | 300 | 3.00% | 4.00% | 0 |
| September 15-28 | 300 | 2.91% | 3.00% | 0 |
The first follower balance is 10,000 + 450 - 150 = 10,300. The second is 10,300 + 500 - 200 = 10,600. Both residuals equal zero, and the first closing balance matches the next opening balance. If either test fails, review date boundaries, source adjustments, and extraction timing before explaining growth.
Gross follows increased, but net additions stayed at 300 because unfollows also increased. The second growth rate is lower because the same net addition is divided by a larger opening balance. Calling follows alone "audience growth" would hide the departures.
Reach increased by 25.00%, calculated as =F3/F2-1. Interactions declined by 6.25%, calculated as =G3/G2-1. The interaction ratio fell by 1.00 percentage point, calculated as =(J3-J2)*100. The account expanded its distribution while generating fewer total actions.
For an additional input check, =SUM(C2:C3) gives 450 + 500 = 950 follows; compare that with any matching source subtotal. Microsoft's SUM documentation explains adding a range; check numeric cell types because text values in a referenced range are ignored. Do not apply the same addition to whole-period reach and call it a unique combined audience.
The content owner should review changes in publishing volume, format, topic, and distribution scope. Record these as possible explanations, then inspect comparable content groups. The aggregate table cannot establish which change caused the lower response.
If audience composition is supplied, compare the same group definitions and disclose the population behind each percentage. A follower geography share and a reached-audience geography share have different denominators. Keep unknown or unavailable groups visible.
Use audience overlap analysis for shared audiences across groups, and website audience analysis when the business question moves to activity on your site. Neither audience should be inferred from follower growth alone.
Covirage is not affiliated with Meta, Instagram, Facebook, or Microsoft.
Upload your aggregate follower and activity file or Google Sheet to Covirage; it maps the columns, and its tools compute and check the growth balances and ratios. The external AI model explains the result 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.
Choose the denominator that answers your question and state it. Interactions divided by reach describe actions relative to the audience exposed. Interactions divided by followers use the follower base instead. Keep the choice consistent when comparing periods.
Subtract unfollows from follows for the same reporting window. Check that opening followers plus this net change equals closing followers. Divide net change by opening followers for the growth rate, keeping adjustments separate if the source includes them.
An aggregate export describes counts and any supplied group breakdowns. It does not provide the identities behind those totals. Keep conclusions at the aggregate level and avoid treating a demographic share as evidence about a particular follower or customer.
Follower additions, departures, distribution, and content response measure different behavior. Compare net growth with reach and the chosen interaction count, then review changes in format and audience scope. The numbers establish the movement; they do not establish its cause.