← Back to Skills Marketplace
danyangliu-sandwichlab

Ads Report Generator

by danyangliu · GitHub ↗ · v1.0.0
cross-platform ✓ Security Clean
325
Downloads
0
Stars
1
Active Installs
1
Versions
Install in OpenClaw
/install daily-weekly-report-generator
Description
Produce daily and weekly performance reports for Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, and DSP/programmatic campaigns.
README (SKILL.md)

Ads 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

  1. Metric Definition Clarification
  2. Query Plan
  3. Result Summary
  4. Interpretation and Caveats
  5. Decision Recommendation

Workflow

  1. Disambiguate metric definitions and time window.
  2. Build query slices by platform, funnel, and audience.
  3. Compute trend deltas and variance drivers.
  4. Summarize findings with confidence level.
  5. 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

{
  "platform": "Meta",
  "spend": 12000,
  "revenue": 42000,
  "roas": 3.5
}

Examples

Example 1: Daily report automation

Input:

  • Need 9AM daily summary for key campaigns
  • KPI: spend, cpa, roas

Output focus:

  • report schema
  • anomaly highlights
  • top next actions

Example 2: Attribution window comparison

Input:

  • 1d click vs 7d click disagreement
  • Decision needed for budget shift

Output focus:

  • side-by-side metric table
  • interpretation caveats
  • decision recommendation

Example 3: Traffic structure diagnosis

Input:

  • Revenue flat but traffic rising
  • Suspected quality decline

Output focus:

  • source mix decomposition
  • quality signal changes
  • corrective action plan

Quality Checklist

  • Required sections are complete and non-empty
  • Trigger keywords include at least 3 registry terms
  • Input and output contracts are operationally testable
  • Workflow and decision rules are capability-specific
  • Platform references are explicit and concrete
  • At least 3 practical examples are included
Usage Guidance
This skill is a text-based recipe for building ad reports and does not itself connect to ad platforms or install software. Before using: (1) confirm where you'll supply data (dashboards/CSV/API) — the skill expects a data_source_scope but will not fetch it for you; (2) never paste platform credentials into free-text prompts — if you plan to wire connectors, use secure credential storage/mechanisms provided by your platform; (3) review any 'handoff payload' the agent generates before sending it to external systems; (4) because the skill can be invoked by the agent, limit autonomous runs if you don't want unsupervised report generation. If you need an automated connector that fetches live data, expect a separate integration that will require credentials and review that integration separately.
Capability Analysis
Type: OpenClaw Skill Name: daily-weekly-report-generator Version: 1.0.0 The skill bundle is benign. The `SKILL.md` clearly defines a business-oriented purpose (ad report generation and recommendations) and includes robust guardrails such as 'Never fabricate metrics or policy outcomes' and 'Include at least one rollback or stop-loss condition when spend risk exists'. It also instructs the agent to 'escalate with a structured handoff payload' if high-risk issues appear. There is no evidence of prompt injection attempts, data exfiltration, malicious execution, or other harmful behaviors across any of the provided files.
Capability Assessment
Purpose & Capability
Name/description (daily/weekly ads reporting across multiple platforms) match the SKILL.md content: it defines input/output contracts, query plans, trend computations, and recommendations. It does not request unrelated resources or declare unneeded capabilities.
Instruction Scope
SKILL.md contains only guidance for disambiguation, building query slices, summarization, interpretation, and escalation. It does not instruct the agent to read arbitrary files, access environment variables, or send data to external endpoints. 'Escalate with a structured handoff payload' is generic guidance but does not specify external destinations or credentials.
Install Mechanism
No install spec and no code files; the skill is instruction-only so nothing is written to disk or fetched during install. This is proportionate for a planning/reporting skill.
Credentials
The skill declares no required environment variables, no primary credential, and no config paths. That matches the documented behavior (it produces query plans and recommendations rather than directly connecting to ad APIs).
Persistence & Privilege
always is false and model invocation is allowed (platform default). The skill does not request permanent presence or attempt to modify other skills or system-wide settings.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install daily-weekly-report-generator
  3. After installation, invoke the skill by name or use /daily-weekly-report-generator
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
daily-weekly-report-generator v1.0.0 - Initial release of automated report generator for Meta, Google, TikTok, YouTube, Amazon, and DSP ads. - Specialized for actionable reporting: assembles daily/weekly ad reports, summarizes findings, and recommends next steps. - Includes support for key KPIs (revenue, ROAS, CPA, budget) across channel-specific workflows. - Offers clear workflow, decision criteria, and failure handling guidance. - Provides multiple practical usage examples and a robust input/output contract for consistent operation.
Metadata
Slug daily-weekly-report-generator
Version 1.0.0
License
All-time Installs 1
Active Installs 1
Total Versions 1
Frequently Asked Questions

What is Ads Report Generator?

Produce daily and weekly performance reports for Meta (Facebook/Instagram), Google Ads, TikTok Ads, YouTube Ads, Amazon Ads, and DSP/programmatic campaigns. It is an AI Agent Skill for Claude Code / OpenClaw, with 325 downloads so far.

How do I install Ads Report Generator?

Run "/install daily-weekly-report-generator" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Ads Report Generator free?

Yes, Ads Report Generator is completely free (open-source). You can download, install and use it at no cost.

Which platforms does Ads Report Generator support?

Ads Report Generator is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Ads Report Generator?

It is built and maintained by danyangliu (@danyangliu-sandwichlab); the current version is v1.0.0.

💬 Comments