Community研究與資料分析github.com

LeoYeAI/openclaw-marketing-skills

連接 Google Ads API 以提取真實的帳戶資料,包含廣告活動成效、關鍵字健康度、浪費的支出、搜尋字詞與曝光比重。適用於審核 Google Ads 帳戶、找出浪費的預算、優化關鍵字或取得數據驅動的建議。

openclaw-marketing-skills 是什麼?

這是一個專為 AI 代理(如 Claude Code、Cursor、Codex)設計的技能,可讓代理直接連接到使用者的 Google Ads 帳戶,提取並分析真實的廣告數據。其主要功能是執行全面的 Google Ads 審核,包含七大維度健康檢查(轉換追蹤、關鍵字健康度、搜尋字詞品質、曝光比重、支出效率、廣告活動結構、預算運用),並自動偵測浪費的支出(例如:在 30 天內花費超過 50 美元但零轉換的關鍵字)。技能支援多種平台,其核心工作流程包含:透過 OAuth 或開發人員權杖進行設定、執行審核腳本提取最近 30 天的資料、根據詳細的計分卡分析資料、提供具體行動建議(如暫停關鍵字、加入否定關鍵字、調整出價),並在獲得使用者確認後執行變更。所有變更皆可記錄並支援復原。此技能也能增強其他行銷相關技能(如付費廣告、廣告創意),用真實數據取代泛泛的建議。

相容平台~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 控制台 → 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 天):

  • 廣告活動成效(花費、點擊、轉換、每次轉換成本 CPA、廣告投資報酬率 ROAS)
  • 關鍵字成效(品質分數、每次點擊成本 CPC、轉換率)
  • 搜尋字詞報告(實際觸發您廣告的查詢)
  • 曝光比重(因排名或預算而損失的比例)
  • 最大浪費支出(有花費但零轉換的關鍵字)

分析框架

資料載入後,依此計分卡進行審核:

七大維度健康檢查

維度健康警告危險
轉換追蹤所有目標正常運作部分遺失未設定
關鍵字健康度平均 QS ≥ 7平均 QS 5-6平均 QS < 5
搜尋字詞品質<10% 不相關10-25% 不相關>25% 不相關
曝光比重>60% IS40-60% IS<40% IS
支出效率ROAS ≥ 目標ROAS 0.5-1 倍目標ROAS < 0.5 倍目標
廣告活動結構清晰、聚焦有些重疊零散
預算運用使用率 90-100%進度過快/過慢嚴重超支/不足

浪費支出偵測

標記任何符合以下條件的關鍵字:

  • 30 天內花費 > 50 美元 且 零轉換
  • 點擊率 CTR < 0.5%(不相關的受眾)
  • 品質分數 ≤ 3(Google 認為配對不佳)
  • 搜尋字詞包含明顯的否定關鍵字(您不希望出現的競爭對手名稱、不相關的修飾詞)

前三項行動(務必輸出)

分析後,務必列出:

  1. 立即暫停 — 花費預算卻無回報的關鍵字/廣告活動
  2. 需新增的否定關鍵字 — 來自搜尋字詞報告的不相關搜尋詞
  3. 出價調整 — 有高轉換率但正在失去曝光比重的關鍵字

輸出格式

帳戶計分卡

帳戶:[名稱] | 客戶 ID:[xxx-xxx-xxxx]
期間:最近 30 天 | 花費:$X,XXX | 轉換:XX | 每次轉換成本 CPA:$XX

計分卡:
┌──────────────────────┬──────────┬──────────────────────────────┐
│ 維度 │ 狀態 │ 摘要 │
├──────────────────────┼──────────┼──────────────────────────────┤
│ 轉換追蹤 │ ✅ 正常 │ X 個目標正確運作中 │
│ 關鍵字健康度 │ ⚠️ 警告 │ 平均 QS X.X │
│ 搜尋字詞品質 │ 🔴 危險 │ XX% 為不相關查詢 │
│ 曝光比重 │ ⚠️ 警告 │ 因排名損失 XX% │
│ 支出效率 │ ✅ 正常 │ ROAS X.Xx │
│ 廣告活動結構 │ ✅ 正常 │ 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,且可透過 Google Ads 變更記錄在 7 天內復原。

執行異動前務必取得使用者確認:

「我即將暫停 3 個關鍵字(每月花費 $210,0 次轉換)並新增 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

相關技能