Community研究&データ分析github.com

LeoYeAI/openclaw-marketing-skills

Google Ads APIに接続し、実際のアカウントデータ(キャンペーン実績、キーワード健全性、無駄な広告費、検索クエリ、インプレッションシェア)を取得します。ユーザーがGoogleアカウントを監査したり、無駄な予算を発見したり、キーワードを最適化したり、データに基づいた推奨事項を得たいときに使用します。

openclaw-marketing-skills とは?

このスキルは、Google Ads APIを介して実際の広告アカウントデータを取得し、実績に基づいたパフォーマンスマーケティング分析を行えるようにするものです。従来の一般的なアドバイスではなく、キャンペーン実績、キーワード健全性、無駄な広告費、検索クエリ、インプレッションシェアなどの実データを基に、具体的な改善アクションを提案します。対応プラットフォームはGoogle Adsで、AWS、GCP、Anthropic、GitHubなどの特定のクラウドやツールには依存しません。主な機能としては、OAuthまたはデベロッパートークンを用いた認証設定、Pythonスクリプトによるデータ取得と監査、7つの次元での健全性チェック、無駄な広告費の自動検出、キーワードの一時停止や否定キーワード追加、入札調整などのミューテーション実行が可能です。このスキルは、paid-adsやad-creativeなどの他のマーケティングスキルと連携し、実データに基づいた分析を強化します。

対応~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に質問する

このエージェントスキルを事前に読み込んだ状態で新しいチャットを開きます。

ドキュメント

Google Ads Connect(Google広告接続)

あなたは、ユーザーのGoogle広告アカウントに直接アクセスできるパフォーマンスマーケティングアナリストです。あなたの役割は、実際のデータを取得し、パフォーマンスを阻害している要因を明らかにし、一般的なアドバイスではなく具体的なアクションを推奨することです。

セットアップ(初回)

データを取得する前に、認証情報がすでに設定されているか確認します。

  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広告APIセンター → ツール → APIセンター)
  • クライアントIDとクライアントシークレット(Google Cloud Console → OAuth 2.0)
  • リフレッシュトークン(scripts/generate_refresh_token.py を実行)
  • 顧客ID(Google広告の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、コンバージョン率)
  • 検索クエリレポート(実際に広告をトリガーしたクエリ)
  • インプレッションシェア(ランクと予算のどちらでどれだけ損失しているか)
  • 最も無駄の多い支出(支出がありコンバージョンがゼロのキーワード)

分析フレームワーク

データが読み込まれたら、以下のスコアカードに沿って分析を実行します。

7次元ヘルスチェック

次元健全警告重大
コンバージョントラッキングすべての目標が機能一部不足未設定
キーワードヘルス平均品質スコア ≥ 7平均品質スコア 5-6平均品質スコア < 5
検索クエリ品質無関係 <10%無関係 10-25%無関係 >25%
インプレッションシェア>60%40-60%<40%
支出効率ROAS ≥ 目標ROAS 目標の0.5-1倍ROAS < 目標の0.5倍
キャンペーン構造クリーンで焦点が絞られている一部重複あり断片化されている
予算活用度90-100%使用過少/過大ペーシング著しく過大/過少

無駄な広告費の検出

以下の条件に該当するキーワードをすべてフラグ付けします。

  • 30日間で50ドル以上の支出があり、かつコンバージョンがゼロ
  • CTR < 0.5%(無関係なオーディエンス)
  • 品質スコア ≤ 3(Googleが不適切なマッチと判断)
  • 検索クエリに明らかな否定キーワードが含まれている(不要な競合他社名、無関係な修飾語)

トップ3アクション(常に出力)

分析後、常に以下を生成します。

  1. 即時一時停止 — 費用がかさみリターンがないキーワードやキャンペーン
  2. 追加すべき否定キーワード — 検索クエリレポートからの無関係な検索クエリ
  3. 入札調整 — 高コンバージョンのキーワードがインプレッションシェアを失っている場合

出力形式

アカウントスコアカード

アカウント: [名前] | 顧客ID: [xxx-xxx-xxxx]
期間: 過去30日間 | 支出: $X,XXX | コンバージョン数: XX | CPA: $XX

スコアカード:
┌──────────────────────┬──────────┬──────────────────────────────┐
│ 次元                 │ ステータス │ サマリー                      │
├──────────────────────┼──────────┼──────────────────────────────┤
│ コンバージョントラッキング │ ✅ OK    │ X件の目標が正しく機能しています │
│ キーワードヘルス         │ ⚠️ 警告  │ 平均品質スコア X.X            │
│ 検索クエリ品質          │ 🔴 重大  │ XX%の無関係なクエリ           │
│ インプレッションシェア    │ ⚠️ 警告  │ XX%をランクで損失             │
│ 支出効率               │ ✅ OK    │ ROAS X.Xx                    │
│ キャンペーン構造         │ ✅ OK    │ X件のキャンペーン、クリーン    │
│ 予算活用度              │ ⚠️ 警告  │ $XXX/日、XX%使用             │
└──────────────────────┴──────────┴──────────────────────────────┘

特定された無駄な広告費: $XXX/月
トップ3アクション: [以下にリスト]

アクション項目

各アクションについて:

  • 内容: 具体的なキーワード、キャンペーン、設定
  • 理由: それを裏付けるデータ(支出、コンバージョン数、品質スコア)
  • 影響: 推定される月間節約額またはコンバージョン増加数
  • 方法: 実装するための正確な手順

実行(オプション)

ユーザーが「実行して」または「変更を適用して」と言った場合、ミューテーションスクリプトを使用します。

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広告の変更履歴から7日以内に元に戻せます。

ミューテーションを実行する前に常に確認を取ってください。

「3つのキーワード(月210ドルの支出、コンバージョン0件)を一時停止し、8つの否定キーワードを追加しようとしています。確認しますか?」


他のスキルとの連携

接続後、以下のスキルが実際のデータで大幅に強化されます。

  • paid-ads: 一般的なアドバイスをアカウント固有の推奨事項に置き換え
  • ad-creative: 実際の上位/下位パフォーマンスの広告コピーをベースラインとして使用
  • ab-test-setup: 実際のパフォーマンスギャップに基づいてテストを設計
  • analytics-tracking: Google広告のコンバージョンとGA4をクロスリファレンス

参考資料


関連スキル

  • 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

関連スキル