The AI Prompt That Builds a Data-Driven Social Media Calendar (Free Template)

FILES TO ATTACH (Meta Business Suite → Insights, Instagram selected)
From Results (last 90 days, each card exported as CSV, daily data):
1. Views — 2. Reach — 3. Content interactions — 4. Link clicks — 5. Visits — 6. Follows
From Audience (note: this tab is Lifetime-only — Meta does not allow date filtering here):
7. Demographics CSV — age & gender, top cities, top countries (lifetime)
8. Screenshot of the Trends sub-tab (follower growth over time)
From Content (last 90 days):
9. Content → Content: post-level export, one row per post with all metrics (most important file)
10. Content → Overview: top content formats export

THE PROMPT
I run the Instagram account for [@YOUR_HANDLE] ([FOLLOWER_COUNT] followers). Attached is real data
from my Meta Business Suite Insights. Note two data limitations: my Audience demographics are
lifetime (Meta does not allow date filtering there), while everything else covers [90-DAY DATE RANGE].
Build me a content calendar for [TARGET MONTH / YEAR] grounded in this data — not generic best practices.

1. About my business
What we do / sell: [YOUR PRODUCT OR SERVICE]
Who my customers actually are: [YOUR REAL TARGET CUSTOMERS]
Brand voice: [e.g. motivational, witty, authoritative, friendly]
Language(s): [e.g. English, Arabic, mixed]
Things we never do/say: [YOUR BRAND NO-GOS]

2. My goal for this month
Primary goal: [e.g. awareness, engagement, leads, sales]
How I measure success: [YOUR KEY METRICS]

3. What is happening this month
Promotions / launches: [ANYTHING LAUNCHING, OR "N/A"]
Events: [ANY EVENTS, OR "N/A"]
Holidays / seasonal moments: [RELEVANT DATES, OR "N/A"]
Dates to avoid: [BLACKOUT DATES, OR "N/A"]

4. My production capacity
Posts per week I can realistically produce: [NUMBER]
Formats: [e.g. stories, reels, single image, carousels]
Who creates content: [YOU / A TEAM / FREELANCER]
Assets on hand: [e.g. testimonials, product photos, B-roll]

5. What I want you to do — in this order

STEP A — Analyze before planning anything:
Audience quality first:
- My demographics are a lifetime accumulation, so treat them as "who I have collected over the
  account life," not necessarily who is joining now. Compare them against who my customers are
  (section 1): how much of my audience is actually addressable, and how should that shape content,
  language, and how I judge my reach numbers?
- Cross-reference with the Follows daily CSV and the Trends screenshot: if recent growth patterns
  suggest my new followers differ from the lifetime mix (e.g. spikes from viral content that likely
  pulled international viewers), flag it — and tell me what content attracts the right followers vs. wrong ones.
- Check whether my best-performing posts match my core demographic, or whether I am creating for an
  audience I do not have.

Performance diagnosis (organic data — note if your ads run separately and are not in these files):
1. Align the six daily Results CSVs by date, find spike and dip days, and use the post-level Content
   export to identify exactly which posts caused each one. CAUTION: Results-tab totals may include
   some paid effects (ad-driven visits and follows), so when a spike has no matching organic post,
   consider ads as the likely cause before crediting content.
2. Diagnose divergences between metrics — e.g. views/reach rising while interactions fall — and what fixes them.
3. Top 5 / bottom 5 posts and the pattern behind each (format, topic, hook, posting time), cross-checked
   against the formats export.
4. Which posts drive link clicks vs. follows vs. conversations — and which matter most for my stated goal.
5. Visits vs. Follows: estimate profile conversion; flag if my bio/grid is the leak.
6. [If you run ads] How should my organic calendar complement the paid side rather than duplicate it —
   e.g. if ads handle awareness, should organic focus on trust and conversion?
7. [If Messaging / Benchmarking attached] Assess response rate / time and competitive position.
8. Flag anything surprising.
Present a short insights summary and wait for my confirmation before building anything.

STEP B — After I confirm, build the [TARGET MONTH] calendar as a table, one row per post: date + time
(your timezone), format, content pillar / topic, hook, caption draft or direction (language per post if
mixed), CTA, hashtag direction, and the specific Step A insight that justifies it.

STEP C — Strategy layer: content pillar split justified by my data; 3 labeled experiments (at least
one targeting my weakest trending metric, one testing local-vs-international content if flagged); and
which metrics to track next month with targets — plus what organic should hand off to ads and vice versa.

6. Rules
- Every recommendation must trace to my data or my goals. If you are guessing, say so.
- Respect the data limitations: lifetime demographics ≠ recent audience; Results totals may carry paid effects.
- Do not exceed my production capacity. Match my brand voice.
- If my data contradicts best practices, trust my data and flag it.
- If anything is missing or unclear, ask before assuming.
- Output the final calendar as a downloadable spreadsheet.