Turn each client's platform exports into their monthly report
At the start of the month Claude reads one client's platform exports and last month's report, and writes the report the client actually reads: what grew, what worked and what to do next.
Safe versionMarketingWhen you need it
Set it up3 steps
Open the Claude desktop app and sign in with the Claude account you use for work. On a personal Free, Pro or Max plan, chats can be used for training unless you switch off SettingsPrivacyHelp improve Claude.
No account yet? Ask your manager.
Where things are in Claude
- CustomizeConnectors In Claude's left sidebar: connect your email and files.
- /schedule Type it in a new Cowork task to run a prompt on a schedule.
- Scheduled In Claude's left sidebar: what runs, to pause or change it.
- At month end, export last month's results for the client from each platform, totals and the post list only, into a Drive folder named after the client, next to last month's report. Delete any follower list, comments, messages or lead list from the export before you save it.
- Connect Google Drive under CustomizeConnectors.
- Paste this workflow's prompt into Cowork once per client and name the client's folder. Read the draft, then send it to the client as you always do.
Set this up on your computer: the Claude desktop app runs it.
The prompt
- Write last month's report for the client whose Drive folder I name, from the platform exports in it and last month's report.
- Write it as a Google Doc in the client's folder:
- 1. A three-line summary the client can read on its own: the month in one sentence, the best result, the one thing to change.
- 2. For each platform: followers, reach, engagement rate, clicks and posts published, against the month before.
- Taken out by a company rule: 3. The three posts that did best and the one that did worst, with the numbers that show it and the likely reason.3. The three posts that did best and the one that did worst, named by date and format, with the numbers that show it and the likely reason.safe version
- 4. Three recommendations for next month, each tied to a number above.
- Taken out by a company rule: Use only the numbers in the exports. If two exports disagree or a number looks wrong, mark it [CHECK] instead of fixing it. Write in the language of last month's report.Use the totals only. Leave out usernames, commenter names, comments, direct messages and any follower or lead list: if an export still shows them, ignore them and never repeat them. Use only the numbers in the exports. If two exports disagree or a number looks wrong, mark it [CHECK] instead of fixing it. Write in the language of last month's report.safe version
- Company rule: never put customers' personal data into this task. If an email or file contains them, skip that part and tell me.company rule
Kept out of AI
- Customer personal dataKept out
- Safe version. Works from platform totals, exported without follower lists, comments, messages or lead lists. Usernames and commenters stay out of the prompt and the report.
What you get
A client-ready report draft: last month compared, the best and worst posts with their numbers, and three recommendations for next month.
Get this workflow for your team
Two minutes each: everyone gets a plan of ready workflows like this one, inside your company's rules.
Your manager sees progress and hours. Never what Claude reads or writes.
FirstPrompt's workflow library adapts parts of Anthropic's knowledge-work-plugins (Apache-2.0), rewritten by FirstPrompt. Source and licence