Weekly social media performance brief in Notion and Slack

Every Monday at 8am, write my social team's weekly performance brief from Hootsuite Analytics, publish it to Notion, and post the headline numbers into Slack.

Start with the Hootsuite Retrieve Social Profiles operation to get every social account connected to the workspace. Then pull the last seven days of data for those accounts: use List Posts and Metrics for the posts published in that window, and use List Profiles and Metrics for the daily follower and engagement trend. Also pull the seven days before that window so you can calculate week over week movement.

Two Hootsuite constraints to respect when querying analytics. Analytics requests accept at most 10 social profile IDs per request, so batch the accounts into groups of 10 rather than requesting all of them at once, and combine the results before analyzing. Analytics data older than two years is not available, so keep every request inside that window.

Analyze what actually moved rather than dumping numbers. Identify the three best and three worst performing posts by engagement. For the three winners, work out what they had in common across format (image, video, carousel, text, link), topic, and time of day, and say so explicitly. For each account, compare this week to the previous week and state whether followers and engagement went up or down and by how much. If nothing was published in the window, still report the follower and engagement trend and say plainly that there was no new content to analyze.

End the brief with a plain recommendation of what to do more of next week, stated as a concrete action rather than an observation. The brief should end with an action, not a chart.

Publish the finished brief using the Notion Create a Page operation, as a new page in our social reporting database, titled with the week's date range. Structure it as: headline numbers, top three posts, bottom three posts, what the winners had in common, per-account week over week movement, and the recommendation.

Then use the Slack Bot Send a Message operation to post into our marketing channel: the headline numbers (total posts, total engagement, follower change, and the week over week direction) plus a link to the Notion page. Keep the Slack message short enough to read without expanding it, and let the Notion page carry the detail.