Skip to content

Weekly Content Performance Rollup

Example prompt: "Every Monday at 9am, look at the articles we published in the last 7 days from our blog Google Sheet. For each one, fetch the page view count from our Analytics sheet, count the social shares from the Twitter and LinkedIn share-tracking columns, and write a short note on which pieces over- or under-performed against the rolling 8-week median. Save the rollup to a 'Weekly Performance' tab and post the headline numbers and the three biggest movers to #editorial in Slack."

The Problem

Editorial teams want to know what worked each week, but pulling the numbers together is its own small chore. Page views live in one tool, social shares in another, newsletter clicks somewhere else, and the editor ends up either skipping the review or building a half-finished spreadsheet that nobody reads. The result is a team that publishes briskly and learns slowly, because the feedback loop is too friction-heavy to sustain weekly.

How GloriaMundo Solves It

We build a Monday-morning workflow that compiles last week's performance into a single editorial digest. An integration step reads the list of articles published in the last 7 days from your blog inventory sheet. A second integration step pulls the matching page view rows from your Analytics sheet and the share counts from your social tracking columns. A code step joins everything by URL, computes per-article totals, and compares each piece to the rolling 8-week median for the section. An LLM step writes a short narrative summary, calling out the biggest over- and under-performers with a sentence on plausible reasons. An integration step writes the full table to a 'Weekly Performance' tab and posts the headline numbers and top three movers to the editorial Slack channel. Glass Box preview shows the full digest before anything is written.

Example Workflow Steps

  1. Trigger (scheduled): Runs every Monday at 9:00am.
  2. Step 1 (integration): Read articles published in the last 7 days from the blog inventory sheet.
  3. Step 2 (integration): Read matching page view rows from the Analytics sheet and share counts from the social tracking columns.
  4. Step 3 (code): Join the data by URL, compute per-article totals, and compare each piece to the 8-week rolling median.
  5. Step 4 (LLM): Write a short summary calling out the biggest over- and under-performers and plausible reasons.
  6. Step 5 (integration): Write the full table to a 'Weekly Performance' tab in the same Google Sheet.
  7. Step 6 (integration): Post the headline numbers and top three movers to the #editorial Slack channel.

Integrations Used

  • Google Sheets — article inventory and analytics data in, weekly performance tab out
  • Slack — headline numbers and top movers posted to the editorial channel

Who This Is For

Editorial leads, content managers, and small in-house publishing teams who already export numbers to a spreadsheet and want the weekly review compiled and circulated without anyone having to sit down and do it.

Time & Cost Saved

Pulling and formatting a weekly performance review by hand typically takes 60-90 minutes between fetching numbers, building the table, and writing the commentary. This workflow reduces it to a 5-minute read of the Slack post and a quick scan of the sheet for editors who want the detail. Over a year, that is roughly 50-60 hours of editorial time returned.