- Home
- Skills
- Research & Analysis
- weekly marketing report generator
Works with the AI tools you already use
weekly marketing report generator
Transforms raw analytics data into executive-ready weekly reports with variance analysis and actionable insights.
$7
weekly marketing report generator
Example session with this skill installed
Generate a weekly report. Meta Ads: $5k spend, 2.1 ROAS. Google Ads: $3k spend, 4.5 ROAS. Shopify: $22k revenue, 15% WoW growth. Email: 22% open rate, 2.1% CR. Last week ROAS was 3.0 total.
- Read your context and instructions
- Compiled the weekly marketing report
- Generated the data export
The report for the week is complete, focusing on the high-performing Google Ads segment and the revenue surge in Shopify.
Weekly Marketing Performance Report
Executive Summary
This week saw a significant revenue increase of 15% WoW, primarily driven by high-intent search traffic and improved email conversion rates. While Google Ads continues to be our primary efficiency engine with a 4.5 ROAS, Meta Ads performance has softened, dragging the total blended ROAS down from 3.0 to 3.2 (blended). The primary focus for next week is scaling the Google Ads winners to offset Meta's rising acquisition costs.
Channel Performance & Variance
| Channel | Spend | Revenue | ROAS | WoW Change | Status |
|---|---|---|---|---|---|
| Meta Ads | $5,000 | $10,500 | 2.1 | -12% | 🔴 Declining |
| Google Ads | $3,000 | $13,500 | 4.5 | +8% | 🟢 Improving |
| $200 | $4,800 | 24.0 | +15% | 🟢 Improving | |
| Total | $8,200 | $28,800 | 3.5 | +15% | Stable |
Win/Loss Analysis
Win (Google Ads): Top-of-page rate for "premium leather bags" increased by 20%. The high intent translated to a record 4.5 ROAS. Confidence: High.
Loss (Meta Ads): Creative fatigue in the 'Spring Sale' video set. CPMs rose 18% WoW without a corresponding lift in CTR. Confidence: Medium.
Surprise: Email conversion rate (2.1%) is at a 90-day high despite no change in discount strategy. Hypothesis: New welcome flow optimization is working.
Next-Week Recommendations
- Action: Reallocate $1,000 from Meta Ads underperforming sets to Google Ads "Best Sellers" campaign.
- Expected Outcome: +$2,400 incremental revenue.
- Confidence: High.
- Action: Refresh Meta Ads creative. Replace 'Spring Sale' video with user-generated content (UGC) testimonials.
- Expected Outcome: Lower CPMs and return to 2.5 ROAS.
- Confidence: Medium.
- Action: Analyze the specific segments driving the 2.1% Email CR to replicate for the monthly newsletter.
- Expected Outcome: Sustained high conversion rates.
- Confidence: High.
Next steps
- Export the normalized CSV data for your monthly tracking sheet.
- Review the creative assets for the Meta Ads refresh by Tuesday.
- Update the Google Ads budget caps to accommodate the $1,000 shift.
weekly-marketing-report-generator.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
The problem
Marketing reporting takes hours of manual work across fragmented dashboards. Most reports end up as data dumps that lack narrative and actionable insights for decision-makers.
What it does
- Normalizes data from Google Analytics, Meta, TikTok, Shopify, and Stripe into a unified performance view.
- Performs variance analysis across WoW, MoM, and YoY timeframes to flag significant outliers.
- Identifies specific wins and losses per channel with root-cause hypotheses and confidence levels.
- Generates a story-first executive summary and a prioritized list of three high-impact recommendations for the following week.
Why this beats prompting it yourself
General prompts often output generic summaries or overwhelm users with too many low-priority tasks. This skill applies a rigid Story-First Reporting Framework that forces the agent to distinguish signal from noise and limit recommendations to avoid decision fatigue.
Use cases
- Preparing a data narrative and decision log for weekly marketing team meetings.
- Generating agency-quality client reports without manually stitching together screenshots.
- Creating concise board or investor updates that focus on revenue and ROAS trends.
- Reconciling multi-channel spend and attribution from disparate platform exports.
Known limitations
Requires manual data paste from platform dashboards as it lacks direct API connectors. Analysis quality drops if WoW/MoM historical data is not provided for comparison.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 23 days ago
- Passed all security checks, Safe to install