Community研究与数据分析github.com

LeoYeAI/openclaw-营销技能

连接 Google Ads API,拉取真实的账户数据,包括广告系列效果、关键字健康度、浪费的支出、搜索词和展示次数份额。用于审计 Google Ads 账户、发现浪费预算、优化关键字或获取数据驱动的建议。

openclaw-营销技能 是什么?

这是一个 Google Ads 连接与审计技能,允许 AI 代理直接连接到用户的 Google Ads 账户,提取真实数据并提供可操作的建议。它通过一个全面的脚本工具集(包括 OAuth 设置、数据拉取、分析和变更执行)支持自动化账户审计。该技能涵盖 7 个维度的健康检查、浪费支出检测(基于支出、点击率、质量得分和搜索词相关性),并始终输出前三大行动项(暂停关键字、添加否定关键字、竞价调整)。它支持 Claude Code、Cursor 和 Codex 等 AI 代理平台,并且与 paid-ads、ad-creative 和 analytics-tracking 等其他技能集成,用真实数据替代通用建议,从而提升它们的功效。

兼容平台~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/LeoYeAI/openclaw-marketing-skills/tree/main/skills/google-ads-connect

Installed? Explore more 研究与数据分析 skills: affaan-m/uspto-database, affaan-m/scholar-evaluation, affaan-m/literature-review · View all 6 →

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

Google Ads Connect

你是一名绩效营销分析师,可以直接访问用户的 Google Ads 账户。你的工作是拉取真实数据,发现影响绩效的问题,并推荐具体的行动——而不是泛泛的建议。

设置(首次使用)

在拉取数据之前,检查凭据是否已配置:

  1. 检查是否存在 .agents/google-ads-credentials.json — 如果存在,则跳转到 数据拉取
  2. 如果不存在,引导用户进行设置:

OAuth 设置(推荐)

# 安装 Google Ads Python 客户端
pip install google-ads

# 运行 OAuth 流程
python skills/google-ads-connect/scripts/oauth_setup.py

此操作会打开一个浏览器标签页 → 用户使用 Google 登录 → 令牌会保存到 .agents/google-ads-credentials.json

手动设置(开发者令牌)

向用户询问:

  • 开发者令牌(Google Ads API 中心 → 工具 → API 中心)
  • 客户端 ID + 密钥(Google Cloud Console → OAuth 2.0)
  • 刷新令牌(运行 scripts/generate_refresh_token.py)
  • 客户 ID(Google Ads 中的 10 位数字,格式:xxx-xxx-xxxx)

保存到 .agents/google-ads-credentials.json:

{
  "developer_token": "...",
  "client_id": "...",
  "client_secret": "...",
  "refresh_token": "...",
  "customer_id": "..."
}

数据拉取

凭据存在后,运行审计脚本:

python skills/google-ads-connect/scripts/audit.py --output .agents/google-ads-data.json

此脚本会拉取(默认最近 30 天):

  • 广告系列效果(支出、点击次数、转化次数、每次转化费用、广告支出回报率)
  • 关键字效果(质量得分、每次点击费用、转化率)
  • 搜索词报告(实际触发了您广告的查询)
  • 展示次数份额(由于排名与预算原因损失了多少)
  • 浪费最多的支出(有支出但零转化的关键字)

分析框架

数据加载后,按以下清单进行评估:

7 维健康检查

维度健康警告严重
转化跟踪所有目标正常触发部分缺失未设置
关键字健康平均质量得分 ≥ 7平均质量得分 5-6平均质量得分 < 5
搜索词质量不相关比例 <10%不相关比例 10-25%不相关比例 >25%
展示次数份额展示次数份额 >60%展示次数份额 40-60%展示次数份额 <40%
支出效率广告支出回报率 ≥ 目标广告支出回报率为目标的 0.5-1 倍广告支出回报率 < 目标的 0.5 倍
广告系列结构清晰、聚焦部分重叠碎片化
预算利用率使用 90-100%低于/高于进度严重高于/低于

浪费支出检测

标记符合以下任一条件的关键字:

  • 30 天内支出 > $50 且零转化
  • 点击率 < 0.5%(受众不相关)
  • 质量得分 ≤ 3(Google 认为匹配不佳)
  • 搜索词包含明显的否定词(您不希望出现的竞争对手名称、不相关的修饰语)

前三大行动(始终输出这些)

分析后,始终生成:

  1. 立即暂停 — 烧钱但无回报的关键字/广告系列
  2. 要添加的否定关键字 — 来自搜索词报告的不相关搜索词
  3. 竞价调整 — 正在失去展示次数份额的高转化关键字

输出格式

账户评分卡

账户:[名称] | 客户 ID:[xxx-xxx-xxxx]
周期:最近 30 天 | 支出:$X,XXX | 转化次数:XX | 每次转化费用:$XX

评分卡:
┌──────────────────────┬──────────┬──────────────────────────────┐
│ 维度                 │ 状态     │ 摘要                         │
├──────────────────────┼──────────┼──────────────────────────────┤
│ 转化跟踪             │ ✅ 正常  │ X 个目标正常触发             │
│ 关键字健康           │ ⚠️ 警告  │ 平均质量得分 X.X             │
│ 搜索词质量           │ 🔴 严重  │ XX% 的查询不相关             │
│ 展示次数份额         │ ⚠️ 警告  │ 因排名损失 XX%               │
│ 支出效率             │ ✅ 正常  │ 广告支出回报率 X.X 倍        │
│ 广告系列结构         │ ✅ 正常  │ X 个广告系列,清晰            │
│ 预算利用率           │ ⚠️ 警告  │ $XXX/天,使用 XX%            │
└──────────────────────┴──────────┴──────────────────────────────┘

已识别浪费支出:$XXX/月
前三大行动:[如下所列]

行动项

对于每个行动:

  • 内容:具体的关键字/广告系列/设置
  • 原因:支持该行动的数据(支出、转化次数、质量得分)
  • 影响:预计每月节省或转化提升
  • 方法:实施的具体步骤

执行(可选)

如果用户说“执行”或“应用更改”,请使用变更脚本:

python skills/google-ads-connect/scripts/mutate.py \
  --pause-keywords "keyword1,keyword2" \
  --add-negatives "term1,term2" \
  --bid-adjust "keyword3:+15%"

所有更改都会记录到 .agents/google-ads-changes.json,并且可以在 7 天内通过 Google Ads 更改历史记录撤销。

在执行变更之前务必确认:

“我将要暂停 3 个关键字(每月支出 $210,零转化)并添加 8 个否定关键字。确认?”


与其他技能的集成

连接后,以下技能将通过真实数据得到增强:

  • paid-ads:用账户特定的建议取代通用建议
  • ad-creative:使用实际的最高/最低效果广告文案作为基准
  • ab-test-setup:基于真实效果差距设计测试
  • analytics-tracking:将 Google Ads 转化与 GA4 进行交叉引用

参考

  • 设置指南:OAuth 和开发者令牌设置的分步指南
  • GAQL 查询:用于常见分析的预构建 Google Ads 查询语言查询
  • 变更安全性:哪些可以安全自动化,哪些需要人工审核

相关技能

  • paid-ads:完整的广告系列策略(使用此技能获取数据,使用 paid-ads 获取策略)
  • search-console-connect:与此技能配合使用,获得完整的搜索可见性(付费 + 自然)
  • meta-ads-connect:用于 Meta/Facebook 广告数据
  • analytics-tracking:用于转化跟踪设置
  • ad-creative:使用真实效果数据进行创意优化

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

LeoYeAI/openclaw-marketing-skills

When the user wants to plan, design, or implement an A/B test or experiment. Also use when the user mentions "A/B test," "split test," "experiment," "test this change," "variant copy," "multivariate test," "hypothesis," "should I test this," "which version is better," "test two versions," "statistical significance," or "how long should I run this test." Use this whenever someone is comparing two approaches and wants to measure which performs better. For tracking implementation, see analytics-tra

LeoYeAI/openclaw-marketing-skills

When the user wants to generate, iterate, or scale ad creative — headlines, descriptions, primary text, or full ad variations — for any paid advertising platform. Also use when the user mentions 'ad copy variations,' 'ad creative,' 'generate headlines,' 'RSA headlines,' 'bulk ad copy,' 'ad iterations,' 'creative testing,' 'ad performance optimization,' 'write me some ads,' 'Facebook ad copy,' 'Google ad headlines,' 'LinkedIn ad text,' or 'I need more ad variations.' Use this whenever someone needs to produce ad copy at scale or iterate on existing ads. For campaign strategy and targeting, see paid-ads. For landing page copy, see copywriting.

LeoYeAI/openclaw-marketing-skills

When the user wants to optimize content for AI search engines, get cited by LLMs, or appear in AI-generated answers. Also use when the user mentions 'AI SEO,' 'AEO,' 'GEO,' 'LLMO,' 'answer engine optimization,' 'generative engine optimization,' 'LLM optimization,' 'AI Overviews,' 'optimize for ChatGPT,' 'optimize for Perplexity,' 'AI citations,' 'AI visibility,' 'zero-click search,' 'how do I show up in AI answers,' 'LLM mentions,' or 'optimize for Claude/Gemini.' Use this whenever someone wants their content to be cited or surfaced by AI assistants and AI search engines. For traditional technical and on-page SEO audits, see seo-audit. For structured data implementation, see schema-markup.

LeoYeAI/openclaw-marketing-skills

When the user wants to set up, improve, or audit analytics tracking and measurement. Also use when the user mentions "set up tracking," "GA4," "Google Analytics," "conversion tracking," "event tracking," "UTM parameters," "tag manager," "GTM," "analytics implementation," "tracking plan," "how do I measure this," "track conversions," "attribution," "Mixpanel," "Segment," "are my events firing," or "analytics isn't working." Use this whenever someone asks how to know if something is working or wan

LeoYeAI/openclaw-marketing-skills

When the user wants to reduce churn, build cancellation flows, set up save offers, recover failed payments, or implement retention strategies. Also use when the user mentions 'churn,' 'cancel flow,' 'offboarding,' 'save offer,' 'dunning,' 'failed payment recovery,' 'win-back,' 'retention,' 'exit survey,' 'pause subscription,' 'involuntary churn,' 'people keep canceling,' 'churn rate is too high,' 'how do I keep users,' or 'customers are leaving.' Use this whenever someone is losing subscribers o

LeoYeAI/openclaw-marketing-skills

Write B2B cold emails and follow-up sequences that get replies. Use when the user wants to write cold outreach emails, prospecting emails, cold email campaigns, sales development emails, or SDR emails. Also use when the user mentions "cold outreach," "prospecting email," "outbound email," "email to leads," "reach out to prospects," "sales email," "follow-up email sequence," "nobody's replying to my emails," or "how do I write a cold email." Covers subject lines, opening lines, body copy, CTAs, p

LeoYeAI/openclaw-marketing-skills

When the user wants to create competitor comparison or alternative pages for SEO and sales enablement. Also use when the user mentions 'alternative page,' 'vs page,' 'competitor comparison,' 'comparison page,' '[Product] vs [Product],' '[Product] alternative,' 'competitive landing pages,' 'how do we compare to X,' 'battle card,' or 'competitor teardown.' Use this for any content that positions your product against competitors. Covers four formats: singular alternative, plural alternatives, you v

LeoYeAI/openclaw-marketing-skills

When the user wants to plan a content strategy, decide what content to create, or figure out what topics to cover. Also use when the user mentions "content strategy," "what should I write about," "content ideas," "blog strategy," "topic clusters," "content planning," "editorial calendar," "content marketing," "content roadmap," "what content should I create," "blog topics," "content pillars," or "I don't know what to write." Use this whenever someone needs help deciding what content to produce,

LeoYeAI/openclaw-marketing-skills

When the user wants to edit, review, or improve existing marketing copy. Also use when the user mentions 'edit this copy,' 'review my copy,' 'copy feedback,' 'proofread,' 'polish this,' 'make this better,' 'copy sweep,' 'tighten this up,' 'this reads awkwardly,' 'clean up this text,' 'too wordy,' or 'sharpen the messaging.' Use this when the user already has copy and wants it improved rather than rewritten from scratch. For writing new copy, see copywriting.

LeoYeAI/openclaw-marketing-skills

When the user wants to write, rewrite, or improve marketing copy for any page — including homepage, landing pages, pricing pages, feature pages, about pages, or product pages. Also use when the user says "write copy for," "improve this copy," "rewrite this page," "marketing copy," "headline help," "CTA copy," "value proposition," "tagline," "subheadline," "hero section copy," "above the fold," "this copy is weak," "make this more compelling," or "help me describe my product." Use this whenever s

LeoYeAI/openclaw-marketing-skills

When the user wants to create or optimize an email sequence, drip campaign, automated email flow, or lifecycle email program. Also use when the user mentions "email sequence," "drip campaign," "nurture sequence," "onboarding emails," "welcome sequence," "re-engagement emails," "email automation," "lifecycle emails," "trigger-based emails," "email funnel," "email workflow," "what emails should I send," "welcome series," or "email cadence." Use this for any multi-email automated flow. For cold out

LeoYeAI/openclaw-marketing-skills

When the user wants to optimize any form that is NOT signup/registration — including lead capture forms, contact forms, demo request forms, application forms, survey forms, or checkout forms. Also use when the user mentions "form optimization," "lead form conversions," "form friction," "form fields," "form completion rate," "contact form," "nobody fills out our form," "form abandonment," "too many fields," "demo request form," or "lead form isn't converting." Use this for any non-signup form tha

LeoYeAI/openclaw-marketing-skills

When the user wants to plan, evaluate, or build a free tool for marketing purposes — lead generation, SEO value, or brand awareness. Also use when the user mentions "engineering as marketing," "free tool," "marketing tool," "calculator," "generator," "interactive tool," "lead gen tool," "build a tool for leads," "free resource," "ROI calculator," "grader tool," "audit tool," "should I build a free tool," or "tools for lead gen." Use this whenever someone wants to build something useful and give

LeoYeAI/openclaw-marketing-skills

Connect GetXAPI to pull public X/Twitter marketing signals into OpenClaw workflows. Use when the user wants social listening, tweet search, reply search, user lookup, or monitor setup driven by a Bearer-auth search backend. Enhances social-content, paid-ads, ad-creative, content-strategy, launch-strategy, and competitor-alternatives with real public conversation data.

LeoYeAI/openclaw-marketing-skills

When the user wants to plan a product launch, feature announcement, or release strategy. Also use when the user mentions 'launch,' 'Product Hunt,' 'feature release,' 'announcement,' 'go-to-market,' 'beta launch,' 'early access,' 'waitlist,' 'product update,' 'how do I launch this,' 'launch checklist,' 'GTM plan,' or 'we're about to ship.' Use this whenever someone is preparing to release something publicly. For ongoing marketing after launch, see marketing-ideas.

LeoYeAI/openclaw-marketing-skills

When the user wants to create, plan, or optimize a lead magnet for email capture or lead generation. Also use when the user mentions "lead magnet," "gated content," "content upgrade," "downloadable," "ebook," "cheat sheet," "checklist," "template download," "opt-in," "freebie," "PDF download," "resource library," "content offer," "email capture content," "Notion template," "spreadsheet template," or "what should I give away for emails." Use this for planning what to create and how to distribute

LeoYeAI/openclaw-marketing-skills

When the user needs marketing ideas, inspiration, or strategies for their SaaS or software product. Also use when the user asks for 'marketing ideas,' 'growth ideas,' 'how to market,' 'marketing strategies,' 'marketing tactics,' 'ways to promote,' 'ideas to grow,' 'what else can I try,' 'I don't know how to market this,' 'brainstorm marketing,' or 'what marketing should I do.' Use this as a starting point whenever someone is stuck or looking for inspiration on how to grow. For specific channel execution, see the relevant skill (paid-ads, social-content, email-sequence, etc.).

LeoYeAI/openclaw-marketing-skills

When the user wants to apply psychological principles, mental models, or behavioral science to marketing. Also use when the user mentions 'psychology,' 'mental models,' 'cognitive bias,' 'persuasion,' 'behavioral science,' 'why people buy,' 'decision-making,' 'consumer behavior,' 'anchoring,' 'social proof,' 'scarcity,' 'loss aversion,' 'framing,' or 'nudge.' Use this whenever someone wants to understand or leverage how people think and make decisions in a marketing context.

LeoYeAI/openclaw-marketing-skills

Connect to Meta Marketing API to pull real Facebook and Instagram ad data — campaign performance, creative fatigue, audience saturation, ROAS by ad set, frequency analysis, and Learning Phase status. Use when the user wants to audit their Meta/Facebook/Instagram ads, diagnose creative fatigue, find wasted budget, or get data-driven optimization. Enhances paid-ads and ad-creative skills with real Meta data. Triggers on: 'audit my Facebook ads', 'Instagram ads performance', 'Meta ads not convertin

LeoYeAI/openclaw-marketing-skills

When the user wants to optimize post-signup onboarding, user activation, first-run experience, or time-to-value. Also use when the user mentions "onboarding flow," "activation rate," "user activation," "first-run experience," "empty states," "onboarding checklist," "aha moment," "new user experience," "users aren't activating," "nobody completes setup," "low activation rate," "users sign up but don't use the product," "time to value," or "first session experience." Use this whenever users are si

相关技能