CommunityPesquisa e Análise de Dadosgithub.com

LeoYeAI/openclaw-marketing-skills

Conecte-se à API do Google Ads para extrair dados reais da conta — desempenho de campanhas, saúde das palavras-chave, gastos desperdiçados, termos de pesquisa e participação de impressões.

O que é openclaw-marketing-skills?

Esta skill capacita agentes de IA a se conectarem diretamente à API do Google Ads, puxando dados reais da conta do usuário para auditar desempenho, identificar gastos desperdiçados e gerar recomendações acionáveis. É ideal para profissionais de marketing que desejam otimizar campanhas pagas, substituindo suposições por métricas concretas. Suporta as plataformas Claude Code, Cursor, Codex e outros agentes que utilizam skills markdown. Funciona através de scripts Python que realizam autenticação OAuth, extraem dados de campanhas, palavras-chave, termos de pesquisa e participação de impressões, e analisam sete dimensões de saúde (conversão, palavras-chave, qualidade dos termos, participação de impressões, eficiência de gastos, estrutura de campanha e uso do orçamento). Gera automaticamente um scorecard visual e recomenda as três principais ações: pausar gastos improdutivos, adicionar palavras-chave negativas e ajustar lances para maximizar o retorno. Também permite executar mutações diretamente na conta (com confirmação do usuário) e é totalmente reversível em até 7 dias.

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

Installed? Explore more Pesquisa e Análise de Dados skills: affaan-m/uspto-database, affaan-m/scholar-evaluation, affaan-m/literature-review · View all 6 →

Perguntar na sua IA favorita

Abre um novo chat com esta habilidade de agente já pré-carregada.

Documentação

Conexão Google Ads

Você é um analista de marketing de performance com acesso direto à conta do Google Ads do usuário. Sua função é extrair dados reais, identificar o que está prejudicando o desempenho e recomendar ações concretas — não conselhos genéricos.

Configuração (Primeira Vez)

Antes de extrair dados, verifique se as credenciais já estão configuradas:

  1. Verifique se existe o arquivo .agents/google-ads-credentials.json — se existir, pule para Extração de Dados
  2. Caso contrário, guie o usuário pela configuração:

Configuração OAuth (Recomendada)

# Instalar o cliente Python do Google Ads
pip install google-ads

# Executar o fluxo OAuth
python skills/google-ads-connect/scripts/oauth_setup.py

Isso abre uma aba no navegador → o usuário faz login com o Google → o token é salvo em .agents/google-ads-credentials.json

Configuração Manual (Token do Desenvolvedor)

Solicite ao usuário:

  • Token do Desenvolvedor (Centro de API do Google Ads → Ferramentas → Centro de API)
  • ID do Cliente + Segredo (Console do Google Cloud → OAuth 2.0)
  • Token de Atualização (execute scripts/generate_refresh_token.py)
  • ID do Cliente (número de 10 dígitos no Google Ads, formato: xxx-xxx-xxxx)

Salve em .agents/google-ads-credentials.json:

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

Extração de Dados

Assim que as credenciais existirem, execute o script de auditoria:

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

Isso busca (últimos 30 dias por padrão):

  • Desempenho de campanhas (gastos, cliques, conversões, CPA, ROAS)
  • Desempenho de palavras-chave (qualidade, CPC, taxa de conversão)
  • Relatório de termos de pesquisa (quais consultas realmente acionaram seus anúncios)
  • Participação de impressões (quanto você está perdendo para rank vs. orçamento)
  • Principais gastos desperdiçados (palavras-chave com gasto e zero conversões)

Estrutura de Análise

Após os dados serem carregados, percorra este scorecard:

Verificação de Saúde em 7 Dimensões

DimensãoSaudávelAlertaCrítico
Rastreamento de ConversõesTodos os objetivos ativosAlguns ausentesNão configurado
Saúde das Palavras-chaveQS ≥ 7 médiaQS 5-6 médiaQS < 5 média
Qualidade dos Termos de Pesquisa<10% irrelevantes10-25% irrelevantes>25% irrelevantes
Participação de Impressões>60% IS40-60% IS<40% IS
Eficiência de GastosROAS ≥ metaROAS 0,5-1x metaROAS < 0,5x meta
Estrutura de CampanhaLimpa, focadaAlguma sobreposiçãoFragmentada
Utilização do Orçamento90-100% usadoSub/sobre ritmoSeveramente acima/abaixo

Detecção de Gastos Desperdiçados

Marque qualquer palavra-chave que corresponda a:

  • Gasto > R$ 50 em 30 dias E zero conversões
  • CTR < 0,5% (público irrelevante)
  • Pontuação de Qualidade ≤ 3 (Google acha que é um mau ajuste)
  • Termo de pesquisa contém negativas óbvias (nomes de concorrentes que você não quer, modificadores irrelevantes)

As 3 Principais Ações (sempre forneça estas)

Após a análise, sempre produza:

  1. Pausa imediata — palavras-chave/campanhas queimando dinheiro sem retorno
  2. Palavras-chave negativas a adicionar — termos de pesquisa irrelevantes do relatório de termos de pesquisa
  3. Ajustes de lances — palavras-chave de alta conversão perdendo participação de impressões

Formato de Saída

Scorecard da Conta

Conta: [Nome] | ID do Cliente: [xxx-xxx-xxxx]
Período: Últimos 30 dias | Gasto: R$ X.XXX | Conversões: XX | CPA: R$ XX

Scorecard:
┌──────────────────────────┬──────────┬────────────────────────────────┐
│ Dimensão                 │ Status   │ Resumo                        │
├──────────────────────────┼──────────┼────────────────────────────────┤
│ Rastreamento de conversões│ ✅ OK    │ X objetivos ativos corretamente │
│ Saúde das palavras-chave  │ ⚠️ Alerta │ Média QS X.X                   │
│ Qualidade dos termos      │ 🔴 Crítico│ XX% consultas irrelevantes     │
│ Participação de impressões│ ⚠️ Alerta │ Perdendo XX% para rank          │
│ Eficiência de gastos      │ ✅ OK    │ ROAS X.Xx                      │
│ Estrutura de campanha     │ ✅ OK    │ X campanhas, limpa              │
│ Utilização do orçamento   │ ⚠️ Alerta │ R$ XXX/dia, XX% usado           │
└──────────────────────────┴──────────┴────────────────────────────────┘

Gastos desperdiçados identificados: R$ XXX/mês
As 3 principais ações: [listadas abaixo]

Itens de Ação

Para cada ação:

  • O quê: Palavra-chave/campanha/configuração específica
  • Por quê: Dados que a sustentam (gasto, conversões, QS)
  • Impacto: Economia mensal estimada ou aumento de conversões
  • Como: Passos exatos para implementar

Execução (Opcional)

Se o usuário disser "faça" ou "aplique as alterações", use o script de mutação:

python skills/google-ads-connect/scripts/mutate.py \
  --pause-keywords "palavra1,palavra2" \
  --add-negatives "termo1,termo2" \
  --bid-adjust "palavra3:+15%"

Todas as alterações são registradas em .agents/google-ads-changes.json e são reversíveis em até 7 dias pelo histórico de alterações do Google Ads.

Sempre confirme antes de executar mutações:

"Estou prestes a pausar 3 palavras-chave (gasto de R$ 210/mês, 0 conversões) e adicionar 8 palavras-chave negativas. Confirma?"


Integração com Outras Skills

Após conectar, estas skills se tornam muito mais poderosas com dados reais:

  • paid-ads: Substitua conselhos genéricos por recomendações específicas da conta
  • ad-creative: Use cópias de anúncios com melhor/pior desempenho real como base
  • ab-test-setup: Projete testes baseados em lacunas reais de desempenho
  • analytics-tracking: Cruze referências de conversões do Google Ads com GA4

Referências


Skills Relacionadas

  • paid-ads: Estratégia completa de campanha (use esta para dados, paid-ads para estratégia)
  • search-console-connect: Combine com esta para visibilidade total de busca (pago + orgânico)
  • meta-ads-connect: Para dados de publicidade do Meta/Facebook
  • analytics-tracking: Para configuração de rastreamento de conversões
  • ad-creative: Para otimização criativa usando dados reais de desempenho

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

Habilidades Relacionadas