How do I put together a monthly Instagram and Facebook performance report
Pull Instagram and Facebook for the same calendar month, keep fixed columns, compare with last month and last year, and add recommendations.
Smalt AI team ·
Export Facebook and Instagram separately for the full calendar month, using the same window and the same columns every month. Put reach, views, interactions, follower change and your top posts in one sheet, compare it with last month and the same month last year, and finish with a few recommendations tied to those numbers. Keep paid results in their own section.
Decide what the report is for
Start with who reads it and what they decide. Hootsuite’s report template guide (a vendor blog, published 6 July 2026) begins the same way: define the audience and objectives, then pick metrics that match those goals. For a monthly report to a manager, a one-paragraph summary, one table and a short list of next steps usually covers it.
The guide names engagement rate, reach, follower growth and top content as the core monthly numbers. Your own goals may swap some of these out. A page that exists to drive sign-ups cares more about link clicks than follower count.
Pull the data for the same window each month
Use the full calendar month, 1st to last day, for both platforms. A rolling 30 days drifts against the calendar and makes month-over-month comparisons harder to trust.
In the Instagram professional dashboard, open Insights. Meta’s help page for Instagram insights lists sections for views, interactions, new followers and content you shared, and you can set a custom date range. This overview is where the account-level totals come from.
Two limits matter for monthly reporting:
- Without a Meta One plan, insights cover up to 90 days.
- Looking back further, and exporting, require a paid Meta One tier (the page names Advanced, Expert and Max). The export is a CSV of content-level insights, from the share icon.
Plan names and requirements change, so check them in your own account.
Export both platforms from Meta Business Suite
Meta Business Suite can export both platforms. A University of Arkansas Division of Agriculture guide (created 14 August 2024) describes the path:
- Open Content, then Export data.
- Choose Facebook or Instagram, then select the Page or account.
- Set the date range, a metric preset, data view “Lifetime” and content level “Post”.
- Generate the export, wait for it to reach 100%, and download the CSV.
The guide says generation can take 10 minutes or longer and that a single export is limited to a 92-day range. Menu labels may have changed since it was written, so compare each step with what you see in the live interface.
Export Facebook and Instagram as two files and keep them as two tabs. Their metrics are defined differently, and merging them early hides that.
Save and archive each month’s export from now on. Past months cannot always be pulled again, and your future year-ago column depends on those files.
Choose a fixed set of columns
Use the same columns every month so a change in the number means a change in performance, not in the report. A workable set for each platform, with where each comes from:
- Reach, views, total interactions, net follower change and link clicks or profile taps: the account-level totals in the Insights overview. The post-level export is unlikely to supply these directly, and we have not confirmed that it does.
- Top five posts by reach, with the post link: the Business Suite or Instagram post-level export.
Use views, not impressions, for Instagram. Meta’s Instagram account insights reference says the impressions metric was deprecated as of 21 April 2025 and replaced by views. A comparison that spans that date mixes two definitions. If your year-ago figure was pulled before the change, note that next to the number.
The same reference marks reach and accounts_engaged as estimated, and says follower demographics need at least 100 followers or engagements. Data can lag by up to 48 hours, and when data is unavailable the API returns an empty set rather than 0. In your sheet, mark missing cells “not available”, never 0. Wait two days after month-end before you pull the final numbers.
We have not verified the exact Facebook metric names shown in Business Suite, so match the Facebook columns to whatever your export labels them.
Compare, then explain
Put three figures side by side for each column: this month, last month and the same month last year. Hootsuite’s guide says to allow for seasonality when comparing with the previous period, and the year-ago column is how you do it. It only works if you saved earlier exports or screenshots; if you didn’t, start the archive now and leave the cell as “not available”. Values below are made up.
| Platform and metric | This month | Last month | Last year |
|---|---|---|---|
| Instagram reach | 12,400 | 11,800 | 9,100 |
| Instagram views | 31,000 | 29,500 | not available |
| Facebook reach | 4,300 | 4,600 | 3,900 |
| Facebook net follower change | +18 | +25 | not available |
Keep paid results in a separate section. Boosted posts and ads inflate reach and views, and a monthly organic comparison stops meaning anything when the ad budget changes between months.
For the analysis, name what drove the largest movements. Look at the top and weakest posts for format, topic, posting day and caption length, then write what you saw in plain sentences. A sentence such as “the three demo videos out-reached every static post” (a made-up example) is a finding. “Engagement was up” is not.
Close with two or three recommendations, each tied to a number in the table, such as “post the demo format twice a week next month, since it led reach on both platforms”. Label them as recommendations. The data shows what happened, not that repeating it will work.
This post gives no target engagement rate. Benchmarks vary widely, so your own previous months are the better yardstick.
Doing it with an AI coworker
Instagram and Facebook are connected apps in Smalt, so you can hand the pull and the first draft to your AI coworker. Ask it something like “How did last month’s Instagram and Facebook posts do?”, and say which columns you want, which comparison periods, and that paid results go in a separate section. You can ask for the result as a Google Sheets or Excel workbook, a PowerPoint deck, or a dashboard at a shareable link. Check which metrics the connected pages actually return before you lock the template, since Facebook and Instagram report different things.
What to check before you rely on it
- Compare a few totals against the native Insights screen. If they disagree, find out why before the report goes out.
- Check the dates on every export. The Business Suite 92-day limit and the 90-day window without Meta One both cut off older data silently if you aren’t looking.
- Confirm the menu paths and plan requirements in your live account, since Meta changes them.
- Treat reach and accounts engaged as estimates, and say so in a footnote.
- Read the recommendations yourself. A person who knows the campaign calendar will spot a spike caused by a giveaway or an outage that the numbers alone don’t explain.
Smalt is an AI coworker that takes jobs like this end to end and hands back the finished file.