Why reach by format is the first Instagram number to analyse
If you look after an Instagram account for a shop, a studio, a club or your own project, sooner or later someone asks a simple question: what should we post more of? Opinions are easy to find. Reels are said to be everything, carousels are said to be underrated, photos are said to be dead. The only answer that counts for your account is in your own numbers, and the first number to look at is reach, split by format.
Reach comes first because everything else depends on it. Nobody can like, save, share, follow or tap a link without having seen the post. An account whose posts are seen by more of the right people has room to grow; an account with flat reach can polish captions for months without moving. This free lesson shows how to turn the reach column of a monthly export into two things a team can act on: a reach rate for every post and a fair comparison of reels, carousels and photos.
The example is Marrowbell Plant Studio, a fictional plant shop with a small studio for repotting workshops and 18,400 Instagram followers at the start of September 2026. The company, its posts and every number are invented for learning, and nothing here is an official platform figure or benchmark. The twelve posts in the article are the same twelve as in the interactive sheet above, so you can follow every step in the lab.
Reach, impressions and followers: three numbers that get mixed up
Before any formula, the terms need to be clear, because reports that mix them up cannot be compared. Followers are the accounts that subscribed to the profile. Reach is the number of different accounts that saw a post at least once. Impressions, which newer reports often simply call views, count every time the post was shown, so one person who looks at a carousel three times adds three impressions and one account to the reach.
- Reach is never larger than impressions. If an export shows the opposite, something went wrong on the way into the spreadsheet. Lesson 16 of the course turns this into an automatic check.
- Reach is not limited by followers. A post is shown to a part of the followers and, if it does well, to people who do not follow the account: on the reels tab, on the explore page, through shares and through hashtags.
- Not every follower sees every post. A normal feed post reaches only a part of the audience, often a minority. That is not a penalty; people follow many accounts and open the app for a few minutes at a time.
The reach rate: one division that makes posts comparable
A reach of 10,000 is excellent for an account with 2,000 followers and disappointing for one with 200,000. To judge a post you therefore put its reach in relation to the audience: reach rate = reach ÷ followers. For Marrowbell Plant Studio with 18,400 followers, a post with a reach of 9,800 has a reach rate of 9,800 ÷ 18,400 = 53 %. In plain words: it was seen by about as many accounts as 53 % of the follower count.
Note the careful wording. A reach rate of 53 % does not mean that 53 % of the followers saw the post, because some of the viewers are non-followers. It is a size comparison, not a share. That is also why the reach rate can be far above 100 %: the rescue reel P07 reached 63,800 accounts, 347 % of the follower count. Later in the course, lesson 11 splits reach into followers and non-followers so that you can see exactly who was reached.
A fully worked example: Marrowbell Plant Studio in September 2026
Here are the twelve posts of the month with their topic, format and reach, and the reach rate calculated from the 18,400 followers at the start of the month.
| Post | Topic | Format | Reach | Reach rate |
|---|---|---|---|---|
| P01 | Repotting a monstera | Reel | 42,600 | 232 % |
| P02 | Five low-light plants | Carousel | 9,800 | 53 % |
| P03 | New terracotta pots | Photo | 5,200 | 28 % |
| P04 | Watering myths | Reel | 21,500 | 117 % |
| P05 | Pothos propagation guide | Carousel | 12,400 | 67 % |
| P06 | Shop window in autumn | Photo | 4,600 | 25 % |
| P07 | Rescuing a fiddle-leaf fig | Reel | 63,800 | 347 % |
| P08 | Soil mix recipe | Carousel | 8,900 | 48 % |
| P09 | Studio tour | Reel | 17,300 | 94 % |
| P10 | Customer shelf of the week | Photo | 6,100 | 33 % |
| P11 | Pet-safe plants | Carousel | 11,700 | 64 % |
| P12 | Unboxing a rare hoya | Reel | 28,400 | 154 % |
Even without a formula, two things stand out. The five reels hold the five highest reach values, from 17,300 to 63,800. And the three photos sit at the bottom, between 4,600 and 6,100, which is a reach rate of 25 % to 33 %. The chart below sorts the posts by reach and draws the follower count as a dashed line, which makes the pattern visible at a glance.
Step 1: the reach rate and the absolute reference
In the sheet the reach is in column D, rows 4 to 15, and the follower count is in cell D2. The reach rate of the first post is =D4/$D$2. The dollar signs are the point of this step. When you copy a formula down, the spreadsheet moves every reference along: D4 becomes D5, D6 and so on, which is what you want for the reach. Without dollar signs D2 would also move and become D3, D4, D5, so the second post would be divided by a header and the third by the reach of the first post.
Writing $D$2 makes the reference absolute: it stays on D2 wherever the formula is copied. In Excel and in the lab you can press F4 while the cursor is on the reference to add the dollar signs. Then format the column as a percentage. If a result shows as 3.47 instead of 347 %, the formula is right and only the cell format is missing.
Step 2: counting posts per format with COUNTIF
A comparison of formats starts with the question of how many posts there are of each. COUNTIF(range, criterion) counts the cells in a range that match a criterion. With the formats listed in G4:G6, the formula for the reels is =COUNTIF($C$4:$C$15,G4). The range is absolute so that it does not slide when you copy the formula down to carousels and photos; the criterion G4 is relative so that it does move. The result: 5 reels, 4 carousels and 3 photos, together 12 posts. If the three counts do not add up to the number of rows, a format is misspelled somewhere, which is a useful check in itself.
Step 3: total reach per format with SUMIF
SUMIF(range, criterion, sum_range) works like COUNTIF with one more argument: the cells to add up. =SUMIF($C$4:$C$15,G4,$D$4:$D$15) looks down the format column, and for every row that says Reel it adds the reach from column D. The reels collected 173,600 reach in total, the carousels 42,800 and the photos 15,900. The three totals add up to 232,300, the reach of all twelve posts.
One caution about this total. Adding up reach across posts counts a person once for every post they saw. 232,300 is therefore not the number of different people Marrowbell Plant Studio reached in September; that figure is only available at account level in the insights. Summed post reach is still useful for comparing formats and months, as long as it is called what it is.
Step 4: average reach per post with AVERAGEIF
Totals favour whatever was posted most often. The fair comparison is the average reach per post, and AVERAGEIF(range, criterion, average_range) has the same three arguments as SUMIF: =AVERAGEIF($C$4:$C$15,G4,$D$4:$D$15). It is exactly SUMIF ÷ COUNTIF, so you can check it by hand: 173,600 ÷ 5 = 34,720 for reels, 42,800 ÷ 4 = 10,700 for carousels and 15,900 ÷ 3 = 5,300 for photos.
| Format | Posts | Total reach | Average reach | Average reach rate |
|---|---|---|---|---|
| Reel | 5 | 173,600 | 34,720 | 189 % |
| Carousel | 4 | 42,800 | 10,700 | 58 % |
| Photo | 3 | 15,900 | 5,300 | 29 % |
| All posts | 12 | 232,300 | 19,358 | 105 % |
How to read the result
On average a reel reached 34,720 accounts, about 3.2 times as many as a carousel and 6.6 times as many as a photo. Expressed as a reach rate, the average reel reached 189 % of the follower count, the average carousel 58 % and the average photo 29 %. For this account and this month, reels are clearly the format that carries the content beyond the existing audience.
Three qualifications belong next to that sentence. First, the sample is small: 5 reels, 4 carousels and 3 photos. One post decides a lot. Without the rescue reel P07 the reel average would be (173,600 − 63,800) ÷ 4 = 27,450, still far ahead, but about a fifth lower. Second, reach is not the goal in itself. A carousel that is saved and reread, or a photo that brings a customer into the shop, can be worth more than a reel seen briefly by strangers. Third, formats are tied to topics: the reels here are entertaining and instructive, the photos are mostly product news. A part of the difference belongs to the topic, not to the format.
That is why the honest conclusion is a hypothesis and a next step, not a rule: reels reach the most people for us; let us keep at least four a month, test whether a product topic works as a reel too, and look at saves and follows before cutting anything. The following lessons of the course give you exactly those extra views.
Typical errors in this table and how to catch them
- Forgetting the dollar signs. The first row looks right, the rows below show nonsense or a #VALUE! error. Check the last row: it must still divide by $D$2.
- Dividing the wrong way round. Followers ÷ reach gives numbers like 0.29 or 3.5 that look plausible at first. A quick test: a post with more reach must get the higher rate.
- Comparing totals instead of averages. The carousels have 2.7 times the total reach of the photos, but there was also one more of them. Per post the factor is 2.0.
- Averaging everything together.
AVERAGEover the whole column gives one number for all formats. It is the right tool for the account as a whole, not for the comparison. - Inconsistent format names. 'Reel', 'reel ' with a trailing space and 'Reels' are three different criteria for COUNTIF. If the counts do not add up to the number of posts, look for spelling variants.
- Reading the reach rate as a share of followers. It compares reach with the size of the audience; non-followers are part of the reach.
- Treating one month as the truth. With three to five posts per format, a single unusual post moves the average a lot. Repeat the table every month and watch whether the order of the formats stays the same.
Step by step in the spreadsheet
- Put the follower count in a labelled cell above the table (D2) and the post list below it: post, topic, format, reach.
- In E4 type
=D4/$D$2, format it as a percentage and copy it down to E15. - List the formats once in G4:G6. Type them exactly as they appear in the data.
- In H4 type
=COUNTIF($C$4:$C$15,G4)and copy down. Check that the counts add up to 12. - In I4 type
=SUMIF($C$4:$C$15,G4,$D$4:$D$15)and copy down. - In J4 type
=AVERAGEIF($C$4:$C$15,G4,$D$4:$D$15)and copy down. Check one value by hand: total ÷ posts. - Select the format names and the averages and insert a column chart with a clear title, for example Average reach per post by format.
Quick reference: the functions in this lesson
| Function | What it does | Example from the sheet |
|---|---|---|
$D$2 | Absolute reference: stays fixed when the formula is copied | =D4/$D$2 |
COUNTIF | Counts the cells that match a criterion | =COUNTIF($C$4:$C$15,G4) |
SUMIF | Adds the cells of a second range where the first range matches | =SUMIF($C$4:$C$15,G4,$D$4:$D$15) |
AVERAGEIF | Averages the cells of a second range where the first range matches | =AVERAGEIF($C$4:$C$15,G4,$D$4:$D$15) |
SUM, AVERAGE | Total and mean of a whole range, used for checks | =SUM(D4:D15) |
Where the numbers come from and how to keep them clean
Instagram shows reach for each post in its insights, and business accounts can export several weeks or months at once through the professional tools or a scheduling tool. Whatever the source, a few habits keep the table usable. Export on a fixed day, for example on the third of the following month, so that every post has had at least a few days to collect its reach. Keep one row per post and one column per metric. Record the format in a column of its own with a fixed set of names. And note the follower count on the first day of the month, because a rate needs a base that does not move while you measure.
Metric names and definitions change from time to time, and what a tool calls 'views', 'accounts reached' or 'impressions' is not always the same thing. The arithmetic of this lesson does not depend on the label: you need one number that counts different accounts per post, and one number for the size of the audience. Platform figures quoted anywhere in this course are illustrative.
The other nineteen labs at a glance
Reach by format is the entry point. The following nineteen labs add the other measurements a growing account needs, each with its own data set and with every cell checked as you type.
Lessons 2 to 4 deal with reactions and audience. You calculate engagement rates by reach and by followers and see why the two differ, separate saves and shares from likes and label keeper posts with IF, and split follower growth into new follows and unfollows to get a weekly growth and churn rate.
Lessons 5 to 8 look at how content is found and what happens next: posting times with WEEKDAY and average reach per time slot, a fair comparison of hashtag sets, the story funnel with retention, drop-off and completion rate, and the path from reach to profile visit to follow.
Lessons 9 to 14 go deeper. You measure reel retention with hook rate and average share watched, build a pillar-by-format grid with SUMIFS and a heat map, split reach into followers and non-followers, rank posts with a weighted score, forecast followers with a trend line and learn why the median describes a typical reel better than the mean.
Lessons 15 to 20 turn analysis into planning and reporting: a what-if comparison of two posting plans, data quality checks on a raw export, monthly reporting with date ranges, a scenario grid of compounding growth, the link from tagged content to shop orders and finally a monthly scorecard with targets and a chart.
Summary
Reach is the number of different accounts that saw a post, and the reach rate divides it by the follower count so that posts and accounts of different size can be compared. With an absolute reference for the follower cell and the three conditional functions COUNTIF, SUMIF and AVERAGEIF you can turn a month of posts into a small table that shows how many posts each format had, how much reach it collected and what a typical post delivers. At Marrowbell Plant Studio the average reel reached 34,720 accounts, the average carousel 10,700 and the average photo 5,300.
Read the averages together with the number of posts, treat a single month as a first indication and never judge a format by reach alone. Then open the lab above, type the four formulas yourself and build the chart. The data are fictional; the method works on any real export.
Frequently asked questions
What is the difference between reach and impressions on Instagram?
Reach counts each account that saw a post once, however often it looked. Impressions (often called views) count every time the post was shown. Impressions are therefore always at least as large as reach.
How do I calculate the reach rate of an Instagram post?
Divide the reach of the post by the follower count: reach rate = reach / followers. In a spreadsheet with the followers in D2 and the reach in D4 the formula is =D4/$D$2. Example: 9,800 reach / 18,400 followers = 53 %.
Can the reach rate be higher than 100 %?
Yes. Reach includes people who do not follow the account, for example viewers who find a reel on the reels tab or through a share. In the fictional example a reel reaches 63,800 accounts with 18,400 followers, a reach rate of 347 %.
Should I compare formats by total reach or by average reach?
By average reach per post. The total depends on how often a format was posted. The average, calculated with AVERAGEIF or as SUMIF divided by COUNTIF, shows what one more post of that format is likely to deliver. Always show the number of posts next to it.
How many posts do I need before the comparison is reliable?
There is no fixed number, but with only three to five posts per format a single unusual post can change the average a lot. Treat one month as a first indication, repeat the table monthly and trust patterns that stay the same over several months.
Do reels always get more reach than carousels and photos?
No. In the fictional example reels reach the most accounts, and many accounts see a similar pattern, but it depends on the topic, the audience and the platform at that time. That is why you measure your own posts instead of relying on a general rule.
Keep going: Instagram Growth & Reels Analytics: Reach by Format, Engagement Rates, Saves & Shares, Follower Churn, Posting Times & Story Funnels
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Engagement Rate Variants: By Reach, By Followers and the Account-Level Rate
- Saves and Shares: Save Rate, Share Rate and Labelling Keeper Posts
- Follower Growth and Churn: Net Growth, Weekly Growth Rate and Unfollow Rate
- Posting Time Analysis: Weekdays, Time Slots and Average Reach per Slot
- Hashtag Sets: Hashtag Share of Reach and a Fair Comparison of Four Sets
- The Story Funnel: Retention per Frame, Drop-Off, Exit Rate and Completion Rate
- From Reach to Follow: Profile Visit Rate, Follow Conversion and Reach per New Follower
- Reels Retention: Hook Rate, Average % Watched, Watch Hours and a Rating with IFS
- Content Pillars: A Pillar × Format Reach Grid with SUMIFS and a Heat Map
- Discovery: Non-Follower Share of Reach and Follows per 1,000 Non-Follower Reach
- Ranking Posts: A Weighted Score with SUMPRODUCT, RANK.EQ, LARGE and XLOOKUP
- Follower Forecast: Monthly Growth Rate, SLOPE, FORECAST.LINEAR and Months to a Goal
- Typical Reach: Mean versus Median, Flagging Viral Outliers and a Clean Baseline
- Posting Mix What-If: Projected Reach, Production Hours and Reach per Hour for Two Plans
- Data Quality Checks: Duplicates, Impossible Values and Missing Reach in an Export
- Monthly Reporting with Dates: MONTH, EOMONTH, Date Ranges in COUNTIFS and SUMIFS
- Growth Scenario Grid: Compounding New-Follower and Unfollow Rates over Six Months
- From Reach to Revenue: Click Rate, Order Rate, Revenue per 1,000 Reach and Revenue Share
- Final Project: A Monthly Instagram Scorecard by Format with Targets and Status