How to use AI to write your weekly marketing report
A report nobody reads is wasted time. One page with what changed and what to do next gets read.
Gather the numbers
- In Google Analytics 4, open the Traffic acquisition report for the last 7 days and download it with the share button.
- Copy last week's rows from your lead log.
- Add anything else you track, like calls or Business Profile views, as plain numbers.
The prompt
Paste the numbers and ask for a one-page report with this week compared to last week, the two biggest changes and one thing to check next week. Add this rule: "Only use the numbers I gave you. If something is missing, say it's missing."
Check it before you send it
Compare three numbers in the report against the export. AI can misread a column or add two rows together. Once it's right, the same prompt works every week, and an automation can run it on Monday mornings.
Want this set up for you?
Trojan Digital Marketing, my agency, builds these setups for businesses that would like to hand it off. See what's included.