daily-weekly-report-generator
Produce daily and weekly performance reports for Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, and DSP/programmatic campaigns.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/danyangliu-sandwichlab/daily-weekly-report-generatorAds Report Generator
Purpose
Core mission:
- report assembly, narrative summarization, action recommendation
This skill is specialized for advertising workflows and should output actionable plans rather than generic advice.
When To Trigger
Use this skill when the user asks for:
- ad execution guidance tied to business outcomes
- growth decisions involving revenue, roas, cpa, or budget efficiency
- platform-level actions for: Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, DSP/programmatic
- this specific capability: report assembly, narrative summarization, action recommendation
High-signal keywords:
- ads, advertising, campaign, growth, revenue, profit
- roas, cpa, roi, budget, bidding, traffic, conversion, funnel
- meta, googleads, tiktokads, youtubeads, amazonads, shopifyads, dsp
Input Contract
Required:
- question_or_report_goal
- metric_scope: KPI, dimensions, and date range
- data_source_scope
Optional:
- attribution_window
- benchmark_reference
- dashboard_filters
- confidence_threshold
Output Contract
- Metric Definition Clarification
- Query Plan
- Result Summary
- Interpretation and Caveats
- Decision Recommendation
Workflow
- Disambiguate metric definitions and time window.
- Build query slices by platform, funnel, and audience.
- Compute trend deltas and variance drivers.
- Summarize findings with confidence level.
- Propose concrete next actions.
Decision Rules
- If metric definitions conflict, lock one canonical definition before analysis.
- If sample size is small, mark result as directional not conclusive.
- If attribution changes materially alter result, show both views.
Platform Notes
Primary scope:
- Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, DSP/programmatic
Platform behavior guidance:
- Keep recommendations channel-aware; do not collapse all channels into one generic plan.
- For Meta and TikTok Ads, prioritize creative testing cadence.
- For Google Ads and Amazon Ads, prioritize demand-capture and query/listing intent.
- For DSP/programmatic, prioritize audience control and frequency governance.
Constraints And Guardrails
- Never fabricate metrics or policy outcomes.
- Separate observed facts from assumptions.
- Use measurable language for each proposed action.
- Include at least one rollback or stop-loss condition when spend risk exists.
Failure Handling And Escalation
- If critical inputs are missing, ask for only the minimum required fields.
- If platform constraints conflict, show trade-offs and a safe default.
- If confidence is low, mark it explicitly and provide a validation checklist.
- If high-risk issues appear (policy, billing, tracking breakage), escalate with a structured handoff payload.
Code Examples
Query Spec Example
metric: roas
dimensions: [platform, campaign]
date_range: last_30d
Result Schema
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-danyangliu-sandwichlab-daily-weekly-report-generator": {
"enabled": true,
"auto_update": true
}
}
}Related Skills
cmo-ads-helper
Support CMO-level planning across Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, Shopify Ads, and DSP/programmatic with revenue, profit, cashflow, ROAS, and LTV strategy modeling.
landing-page-optimizer
Optimize conversion pages for paid traffic from Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, and Shopify Ads journeys.
crm-lead-manager
Manage ad-generated leads and pipeline routing from Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, and landing-page funnels.
traffic-structure-analyzer
Analyze traffic composition and quality trends from Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, and DSP/programmatic channels.
roas-forecast-attribution-modeler
Build ROAS forecasting and attribution-model assumptions for Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, Shopify Ads, and DSP/programmatic planning.