Datapipe
Start free

Social marketing · USE CASE

Review last month’s content calendar against post results.

Match the content calendar your team keeps in Google Sheets to Instagram and Facebook Pages post results. See which content pillars to keep, which to question and which posts never made it into the plan.

Data sources
Assistant
Destination
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE

Which content pillars earned their place in next month’s calendar?

Content pillarInstagram saves per postFacebook shares per post
Product tips19025
Promotions133

October calendar · Posts created Oct 1–31 UTC · Counters read Nov 12

Product tips average 190 saves per Instagram post and 25 shares per Facebook post. Promotions average 13 and 3 while filling nine of the 24 planned slots. Take both to the planning meeting, with one calendar row that has no post link.

WHERE THE RESULT GOES

Google Sheets

Export each data source report to Google Sheets, then add your analysis or checklist to the review Sheet.

Example use case

Ask. Follow up.
Take the next step.

✦ AI assistantSample use case
InstagramFacebook PagesGoogle Sheets
YOU

  1. 01
    7 matched posts · 4 Instagram, 3 FacebookKeep and extend

    Next

  2. 02
    9 of 24 planned slots · 5 Instagram, 4 FacebookReview with the client

    Next

October calendar · Posts created Oct 1–31 UTC · Counters read Nov 12

01 · CONNECT YOUR DATA

Your tools. One place to ask.

3 of 3 Free data sources
No credit card · Daily refresh

DatapipeYour project
Your AI assistantor a report in Sheets / Data Studio
  1. Create your free workspace

    Sign up with your company email. Your first project opens on Data sources.

  2. Add the data sources

    Choose the accounts for this use case. Authorize access and select the property or site.

  3. Bring your question

    Connect your project to a supported AI assistant, or build your source reports.

Create a free account →
Setup steps & what you need

Email/password signups confirm their email first. Use Google signup with a company account if you prefer.

  • Instagram: Authorize Instagram and select the intended professional account. Personal accounts are not supported; required reporting permissions and account access apply. Setup guide ↗
  • Facebook Pages: Authorize Facebook Pages and select the intended managed Page. Required reporting permissions and account access apply. Setup guide ↗
  • Google Sheets: Authorize Google Sheets with an account that can open the file, then paste the spreadsheet link and select the intended tab and columns. Setup guide ↗

Free includes 3 data sources across the workspace. One account/property added to one project counts as one. Extra properties or the same account in another project use another slot.

02 · ASK A USEFUL QUESTION

Start with a prompt.
Follow the evidence.

Copy these in order into your connected assistant.
Each builds on the answer before it.

01

Read the calendar and its post links

Read the full prompt
Use only this Datapipe project’s authorized data. Discover the connected accounts, datasets and compatible fields first. Confirm dates, timezones, currencies and data coverage. Keep missing or unmatched rows visible; never substitute sample data. Compare the sources explicitly and explain every match. Do not change source records or send messages.

Read the content calendar tab in the connected Google Sheet and show me its actual headers before using them. I expect planned date, network, content pillar, status and post link; ask me if a header is unclear. If planned dates arrive as serial numbers, convert them and tell me. Keep the rows for the month I name. Return the number of planned rows per network and pillar, the rows marked cancelled, and the published rows with no post link. Do not guess a missing link or pillar.
02

Match the links to Instagram and Facebook posts

Read the full prompt
From the connected Instagram account, read Feed posts and Reels with Media ID, Published at, Media link, Product type, Likes, Comments, Lifetime reach, Lifetime saves and Lifetime shares. From the connected Facebook Page, read Published Page posts with Post ID, Created at, Post link, Reactions, Comments and Shares. Use a window that covers the month and keep posts created in that month in UTC. Match each calendar link to Media link or Post link after trimming spaces, removing anything after a question mark and the trailing slash. List calendar rows with no matching post and posts with no calendar row. Tell me the read time; these counters are lifetime values at that moment, and an empty value is missing, not zero.
03

Prepare the pillar review for planning

Read the full prompt
Prepare one table per network. Instagram: for each content pillar, matched posts, total saves, saves per post and the lowest and highest reach. Facebook: for each pillar, matched posts, total shares, shares per post and total reactions. Do not add Instagram and Facebook figures together, and do not sum reach. Add each pillar’s share of planned slots. List unplanned posts and unmatched calendar rows separately, and say when an unplanned post might be a row with a missing link instead of deciding for me. Mark pillars with fewer than three posts as too few to compare. Draft the tables in this conversation. Do not edit the Sheet or publish anything.
Need to connect your assistant?Claude guide ↗ChatGPT guide ↗

03 · USE WHAT YOU FIND

Take the pillar review to the planning meeting.

  1. 01

    Read the calendar your team keeps in Google Sheets.

  2. 02

    Match each calendar link to the post the network returns.

  3. 03

    Take the pillar review to the planning meeting.

Check the result at your next review.

Run the same review for November at the same distance from month end, so each post has had a similar time to collect saves and shares. Compare per-post figures by pillar and network with October, note which slots the team changed, and check whether calendar rows without a link went down.

Implementation tips for this use case

For each pillar and network, count the matched posts and calculate saves per post on Instagram and shares per post on Facebook. Keep the two networks in separate columns, and show reach as a range, since reach counts unique accounts and cannot be added across posts. With a few posts per pillar, use the table as a direction for the team to test. Agree next month’s slots together, then copy the agreed table to the planning Sheet.

WHEN YOU NEED MORE CONTEXT

Go a little deeper.

The method and reporting checks
behind this example.

How to review a content calendar against Instagram and Facebook post results

  1. Read the calendar your team keeps in Google Sheets.

    Add the spreadsheet, the Instagram professional account and the Facebook Page to one project. Read the calendar tab and confirm its actual headers: planned date, network, content pillar, status and post link. A date cell can arrive as a spreadsheet serial number, so convert it before filtering by month. Keep rows marked as published, set cancelled rows aside and list published rows with no link. The content pillar exists only in your plan; neither network returns one.

  2. Match each calendar link to the post the network returns.

    Read Instagram Feed posts and Reels and Facebook Published Page posts for a window that covers the month. Posts are selected by creation time in UTC, up to 120 days back. Compare the calendar link with the Instagram Media link or the Facebook Post link after removing spaces, share parameters and the trailing slash. Keep posts with no calendar row as unplanned. Counters are current lifetime values and can include paid distribution. Stories are returned only while Instagram still shows them, so last month’s Stories are not part of this review.

  3. Take the pillar review to the planning meeting.

    For each pillar and network, count the matched posts and calculate saves per post on Instagram and shares per post on Facebook. Keep the two networks in separate columns, and show reach as a range, since reach counts unique accounts and cannot be added across posts. With a few posts per pillar, use the table as a direction for the team to test. Agree next month’s slots together, then copy the agreed table to the planning Sheet.

See the complete example report
EXAMPLE REPORT

Which content pillars earned their place in next month’s calendar?

October calendar · Posts created Oct 1–31 UTC · Counters read Nov 12

Which content pillars earned their place in next month’s calendar?
Content pillarInstagram saves per postFacebook shares per post
Product tips19025
Promotions133
WHAT TO LOOK ATProduct tips average 190 saves per Instagram post and 25 shares per Facebook post. Promotions average 13 and 3 while filling nine of the 24 planned slots. Take both to the planning meeting, with one calendar row that has no post link.

Take the pillar review to the planning meeting.

Four Instagram posts in this pillar collected 760 saves, 190 per post, with reach between 3,900 and 5,100 each. Three Facebook posts collected 75 shares, 25 per post. Both are the highest per-post figures of the four pillars. Promotions filled nine of the 24 planned slots. Five Instagram posts collected 65 saves, 13 per post, with reach between 1,800 and 2,500 each. Four Facebook posts collected 12 shares, 3 per post.

Try the example with sample CSVs

Fictional rows matching the example above. Attach these files to your assistant for a sample analysis.

Data method, reporting checks & sources

Add the spreadsheet, the Instagram professional account and the Facebook Page to one project. Read the calendar tab and confirm its actual headers: planned date, network, content pillar, status and post link. A date cell can arrive as a spreadsheet serial number, so convert it before filtering by month. Keep rows marked as published, set cancelled rows aside and list published rows with no link. The content pillar exists only in your plan; neither network returns one. Read Instagram Feed posts and Reels and Facebook Published Page posts for a window that covers the month. Posts are selected by creation time in UTC, up to 120 days back. Compare the calendar link with the Instagram Media link or the Facebook Post link after removing spaces, share parameters and the trailing slash. Keep posts with no calendar row as unplanned. Counters are current lifetime values and can include paid distribution. Stories are returned only while Instagram still shows them, so last month’s Stories are not part of this review. For each pillar and network, count the matched posts and calculate saves per post on Instagram and shares per post on Facebook. Keep the two networks in separate columns, and show reach as a range, since reach counts unique accounts and cannot be added across posts. With a few posts per pillar, use the table as a direction for the team to test. Agree next month’s slots together, then copy the agreed table to the planning Sheet.

Each post matches one calendar row by its normalized link; nothing is matched by caption or date alone. Instagram and Facebook measures stay in separate columns, and reach is never summed across posts. Counters are lifetime values at the read time and can include paid distribution. Unplanned posts and calendar rows without a link are listed, not dropped.

  • Each post matches one calendar row by its normalized link; nothing is matched by caption or date alone.
  • Instagram and Facebook measures stay in separate columns, and reach is never summed across posts.
  • Counters are lifetime values at the read time and can include paid distribution.
  • Unplanned posts and calendar rows without a link are listed, not dropped.
  • Access to the intended Instagram account or property.
  • Access to the intended Facebook Pages account or property.
  • Access to the intended Google Sheets account or property.
  • Each post matches one calendar row by its normalized link; nothing is matched by caption or date alone.

For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions.

Instagram media insights: reach, saves and shares ↗Facebook Page posts and permanent post links ↗Google Sheets API cell values ↗Report starting points ↗

A FEW USEFUL ANSWERS

Before you start.

Why do I need the calendar as well as Instagram and Facebook?

The networks return each post’s link, date and counters. The calendar holds what your team planned: the content pillar, the format and the posts that were cancelled. Without it you can rank posts, but you cannot tell which kind of content to plan more of.

How are posts matched to calendar rows?

By the post link your team pastes into the calendar after publishing. It is compared with the link each network returns, after removing spaces, share parameters and the trailing slash. Rows without a link stay unmatched until someone fills them in.

Can I add Instagram and Facebook numbers into one score?

Keep them apart. Saves exist on Instagram and not on Facebook, reactions and likes are counted differently, and the audiences differ. Compare pillars within each network.

Do the counters show only what happened during the month?

No. The dates choose which posts are returned. Likes, saves, shares, reach and reactions are totals up to the moment of the read, so older posts have had longer to collect them.

Are Instagram Stories included?

Instagram returns Stories only while they are still live, usually for 24 hours. A monthly review reads Feed posts and Reels; Stories from earlier in the month cannot be recovered.

Does the assistant change the calendar or publish posts?

No. It prepares the review in your conversation. Your team decides next month’s slots and updates the calendar.

YOUR NEXT STEP

Try it with your own data.

Start free with up to 3 data sources. No credit card.

Start free →