Get a weekly content performance report without pulling the data yourself
Every Monday, Zero pulls the past 7 days of post metrics from X, scores each post by engagement, and writes a short narrative report: top performer, biggest underperformer, week-over-week change, and one concrete recommendation. The narrative posts to Slack; the full data archives to Notion.
Zero connects:
Why weekly content reviews don't happen consistently
You know you should be reviewing content performance weekly. You have not done it in three weeks because pulling numbers from X, formatting them, and writing a narrative takes 90 minutes you do not have on a Monday morning. Zero does the whole thing on a schedule. It pulls the numbers, runs the scoring formula, writes the narrative, posts it to Slack, and archives the raw data to Notion — all before your first meeting.
How to set up a recurring content performance report with Zero
@Zero every Monday at 9am PST, pull the past 7 days of post performance from @vm0_ai on X. Score each post: (likes×1) + (retweets×3) + (replies×2). Write a short report: top performer and why, biggest underperformer and likely cause, week-over-week total engagement change, and one concrete recommendation for the week. Post the narrative to #marketing-and-community. Archive the full report with raw metrics to Notion under 'Content Performance Reports > Week of [Mon Date]'.
How Zero pulls metrics, scores posts, and writes the narrative
Zero pulls post metrics from X
Zero fetches impressions, likes, retweets, and replies for all posts published in the past 7 days from the specified X account. It captures raw numbers for every post in the window.
Posts scored and ranked
Zero computes an engagement score for each post using (likes × 1) + (retweets × 3) + (replies × 2). It identifies the top performer, the lowest-scoring post with 3 or more days of data, and calculates the week-over-week delta in total engagement.
Narrative posted and data archived
Zero writes a short narrative covering the top performer, underperformer, week-over-week change, and one concrete recommendation. It posts the narrative to your Slack channel and saves a full metrics table to the Notion page you specified.
Pull on demand, compare content formats, or create an executive summary
Required integrations: X (Twitter), Slack, and Notion — plus Plausible for traffic correlation
X (Twitter)
Zero pulls impressions, likes, retweets, and replies for all posts in the specified window.
Slack
Zero posts the narrative report to your Slack channel on schedule.
Notion
Zero archives the full report with a raw metrics table to the specified Notion page.
Plausible
Zero correlates post engagement with actual site visits, surfacing which posts drove real traffic and not just social activity. Optional but recommended.
Best practices for automated content performance reporting
Run on Monday, not Sunday — X metrics for posts published in the last 48 hours are not stable yet and will shift by morning.
Add Plausible to see which posts drove real site visits — a post with a high engagement score but zero traffic clicks is a vanity win, not a growth win.
Use the format experiment debrief at the end of each 2-week sprint to decide which content formats to scale, iterate, or retire.