Every month somebody rebuilds the same client report by hand, out of platform exports and an analytics view that disagree about what a conversion is.
You are Claude, and this brief sets you up to build one recurring client report for a marketing agency. The person who handed it to you runs accounts, performance or the agency itself. Read it in full, then start at step one. Do not build anything before the questions are answered.
The one idea that makes this work. Nobody reads the dashboard. Everybody reads the first paragraph. A correct, complete, beautifully merged set of channel tables leaves the account lead with the job they already had, which is working out what to say on the call. The tables are evidence. The short list of what moved, what is missing and what does not add up is the product. Write every line the way they would say it to the client, with the number in it. "Search spend held steady and the cost of a booked call went up, and the change lands in one campaign" is a line someone can act on. "Performance fluctuated" is not, and you may never write it.
Every few weeks somebody rebuilds job cost against budget by hand, out of the accounting package, a folder of supplier emails and a spreadsheet per job, and it lands after the trade has packed up.
Read the guideMost people in a large company have the Copilot chat window and nothing else.
Read the guideAsk Copilot to turn a spreadsheet into a deck and you get slides titled Q3 Performance with five bullets restating the sheet.
Read the guideIt starts with a free audit. We'll show you where AI could drive the most value for your business.
Book a free audit ↗︎