Skip to content

Social Analytics Reporter

Example prompt: "Every Friday, pull our follower counts, post engagement rates, and top-performing posts from Twitter, LinkedIn, and Instagram. Summarise the trends in a report and email it to the marketing team."

How to automate social media performance reporting with GloriaMundo

The Problem

Pulling performance metrics from multiple social platforms means logging into each one, navigating to the analytics section, exporting the numbers, and then manually combining them into a single view. For a team managing three or four accounts, this takes an hour or more every week — and the result is often a hastily assembled spreadsheet that nobody reads carefully. Without a consistent report, it is hard to spot trends (which platform is growing, which content type works, whether engagement is declining) until they are obvious enough to be problems.

How GloriaMundo Solves It

We build a workflow that runs on a weekly schedule. Integration steps connect to each of your social accounts and pull key metrics — follower count, posts published, total engagement (likes, comments, shares), and the top-performing posts for the period. A code step normalises the data into a consistent format across platforms. An LLM step analyses the numbers and writes a brief narrative summary: what went up, what went down, which posts resonated, and any patterns worth noting. The report is emailed to your team via Gmail or posted to a Slack channel. Glass Box preview shows you the full report — metrics and narrative — before it is sent, so you can verify the numbers and adjust the commentary.

Example Workflow Steps

  1. Trigger (scheduled): Runs every Friday afternoon to cover the week's activity.
  2. Step 1 (integration): Fetch follower counts, engagement metrics, and recent posts from Twitter, LinkedIn, and Instagram.
  3. Step 2 (code): Normalise metrics into a consistent format — platform, followers, posts published, total engagement, engagement rate.
  4. Step 3 (code): Identify the top 3 performing posts across all platforms by engagement.
  5. Step 4 (LLM): Analyse the metrics and write a narrative summary highlighting trends, standout content, and areas that need attention.
  6. Step 5 (integration): Email the report to the marketing team via Gmail.

Integrations Used

  • Twitter — source of follower and engagement metrics
  • LinkedIn — source of page analytics and post performance
  • Instagram — source of profile metrics and post engagement data
  • Gmail — delivers the weekly report to the marketing team

Who This Is For

Marketing managers, heads of content, and agency account managers who need a consolidated view of social performance across platforms without manually pulling numbers from each dashboard every week.

Time & Cost Saved

Manually pulling metrics from three platforms, formatting a report, and writing a summary takes roughly 1-1.5 hours per week. This workflow automates the data collection, normalisation, and narrative writing, reducing the effort to a quick review of the finished report. Over a month, that is 4-6 hours saved on reporting. The workflow uses integration, code, and LLM steps, costing a few credits per weekly run.