Monthly social media report for every Metricool brand

On the first Monday of every month at 8am, build and send a client-ready social media performance report for each brand in my Metricool account. Use a cron trigger. If the schedule cannot express "first Monday of the month" directly, run every Monday at 8am and stop immediately unless the day of the month is 7 or lower.

Start with Metricool's Get Admin Simple Profiles to list every brand on my account. Metricool is brand scoped, so hold on to the numeric blogId for each brand and pass it with every stats call that follows. Work through the brands one at a time.

For each brand, set the reporting period to the previous full calendar month, from the 1st to the last day. Pull Get Stats Instagram Posts, Get Stats Instagram Reels, Get Stats Instagram Stories and Get Stats Facebook Posts for that period, and pull follower demographics with Get Stats City Provider and Get Stats Gender Provider. Then pull the same four post level stats for the month before that, so any growth claim is measured against a real baseline instead of guessed.

Write a narrative per brand in plain English. This is the point of the workflow: the value is the written analysis, not a table of numbers. Cover what grew and by how much against the previous month, the three best performing posts across all formats with a short explanation of why each one worked looking at format, subject, hook and publish time, which format underperformed and the likely reason, a one or two line audience note drawn from the city and gender data, and two concrete recommendations for next month that follow from this brand's own numbers rather than generic social media advice.

Stay honest with the data. Only cite numbers that actually came back. If a brand has no Instagram or no Facebook connected, skip that section and say so in one line rather than inventing figures. If a brand returned no activity at all for the month, do not email the client and flag the brand in the internal summary instead.

Let me set two inputs before the run. First, a brand to recipient mapping: for each brand name, the client contact email the report goes to, plus an optional cc address for the account manager. Second, a tone setting with two options, formal client facing or internal shorthand, which changes how the narrative is written without changing what it covers.

Send each brand's report with Gmail Send a Message to that brand's mapped contact, using a subject like "Northlight Coffee, social performance for March 2026". Put the narrative in the body with a compact block of headline figures underneath it. If a brand has no mapped recipient, send nothing for that brand and record it as needing a contact.

When every brand is done, post one short internal summary to our agency channel with Slack Send a Message. Give one line per brand with the headline of the month and whether the report went out, then a short list of any brands that were skipped, had no recipient mapped, or need someone to look at them before the client asks.