google-ads-daily

GitHub

每日Google Ads账户运营审查技能,通过MCP或手动导出获取数据,分析预算浪费、新增信号及可扩展机会,辅助日常优化决策。

skills/google-ads-daily/SKILL.md TheMattBerman/google-ads-copilot

Trigger Scenarios

需要每日检查Google Ads账户表现 询问广告账户的浪费、信号或缩放建议

Install

npx skills add TheMattBerman/google-ads-copilot --skill google-ads-daily -g -y
More Options

Use without installing

npx skills use TheMattBerman/google-ads-copilot@google-ads-daily

指定 Agent (Claude Code)

npx skills add TheMattBerman/google-ads-copilot --skill google-ads-daily -a claude-code -g -y

安装 repo 全部 skill

npx skills add TheMattBerman/google-ads-copilot --all -g -y

预览 repo 内 skill

npx skills add TheMattBerman/google-ads-copilot --list

SKILL.md

Frontmatter
{
    "name": "google-ads-daily",
    "description": "Daily operator review for Google Ads. Surfaces what changed, where waste is showing up, where signal is emerging, what is ready to scale, and what should be left alone. Pulls live data via MCP or works with manual exports."
}

Google Ads Daily Operator

Read first:

  • google-ads/references/operator-thesis.md
  • google-ads/references/query-patterns.md
  • google-ads/references/tracking-playbook.md
  • google-ads/references/structure-playbook.md
  • google-ads/references/deliverable-templates.md

Read workspace if available:

  • workspace/ads/account.md
  • workspace/ads/goals.md
  • workspace/ads/winners.md
  • workspace/ads/findings.md
  • workspace/ads/change-log.md
  • workspace/ads/learnings.md
  • workspace/ads/drafts/_index.md — check for pending drafts to surface

The 5 Daily Questions

  1. Can we trust the account today?
  2. Where is waste showing up?
  3. Where is signal emerging?
  4. What is ready to scale or isolate?
  5. What should we not touch yet?

Data Acquisition

Connected Mode (MCP available)

Pull these queries via the search tool on google-ads-mcp:

Campaign performance — last 7 days:

SELECT
  campaign.name,
  campaign.status,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.conversions_value,
  metrics.cost_per_conversion,
  segments.date
FROM campaign
WHERE segments.date DURING LAST_7_DAYS
  AND campaign.status = 'ENABLED'
ORDER BY metrics.cost_micros DESC

Recent account changes:

SELECT
  change_event.change_date_time,
  change_event.change_resource_type,
  change_event.change_resource_name,
  change_event.client_type,
  change_event.user_email,
  change_event.old_resource,
  change_event.new_resource
FROM change_event
WHERE change_event.change_date_time DURING LAST_7_DAYS
ORDER BY change_event.change_date_time DESC
LIMIT 50

Budget-limited detection (search campaigns):

SELECT
  campaign.name,
  metrics.search_impression_share,
  metrics.search_budget_lost_impression_share,
  metrics.search_rank_lost_impression_share,
  metrics.cost_micros,
  metrics.conversions
FROM campaign
WHERE campaign.status = 'ENABLED'
  AND campaign.advertising_channel_type = 'SEARCH'
  AND segments.date DURING LAST_7_DAYS

For prior-period comparison, run the campaign performance query with BETWEEN dates for the preceding 7 days.

See data/gaql-recipes.md for additional queries.

Date Range Fallback

If LAST_7_DAYS returns 0 rows, fall back to LAST_14_DAYS, then LAST_30_DAYS. For daily reviews, don't go further back — instead note "Account dormant: no activity in the last 30 days" and recommend running a full audit with historical data. Always state the date range used.

Export Mode (no MCP)

Ask the user for:

  • Campaign overview: last 7 days (Campaign, Status, Impressions, Clicks, Cost, Conversions, CPA)
  • Any recent change history
  • Optionally: impression share data

See data/export-formats.md for recommended export format.


Process

  1. Announce mode (connected/export) at the start.
  2. Pull or review current data snapshot.
  3. Compare against goals and recent changes.
  4. Highlight deltas, not everything. Focus on what changed since last check.
  5. Use the operator summary template from deliverable-templates.md.
  6. Check workspace/ads/drafts/_index.md — surface any pending drafts that need review.
  7. Append meaningful notes to workspace/ads/findings.md if something new matters.

Draft Output

The daily review does not usually produce new drafts — its job is to surface what matters and flag urgency. However:

  • If it identifies an urgent waste problem (e.g., $200+ burned on junk queries overnight), create a quick negative draft using drafts/templates/negative-draft.md
  • If it identifies a budget emergency (e.g., strong campaign exhausting budget by noon), create a budget draft using drafts/templates/budget-draft.md
  • Always surface existing pending drafts from the index — "You have 3 pending drafts awaiting review"

Threshold for daily-triggered drafts: only when the finding is time-sensitive enough that waiting for the next scheduled analysis would waste significant spend.

Output Shape

  1. Account Status block — account name, CID, status, date range used, tracking confidence, mode
  2. What changed (deltas, not full state)
  3. Trust check (is tracking still clean?)
  4. Waste flag (any new leaks?)
  5. Signal flag (anything emerging?)
  6. Pending drafts to review
  7. Memory updates (if any)

Rules

  • Focus on change, not static facts.
  • Mention confidence if data quality is questionable.
  • Do not recommend churn for the sake of activity.
  • Good operators know when not to touch things.
  • Always check the draft queue — the daily is the operator's inbox.

Version History

  • 2c253ee Current 2026-07-25 07:33

Same Skill Collection

google-ads/SKILL.md
skills/google-ads-apply/SKILL.md
skills/google-ads-audit/SKILL.md
skills/google-ads-budget/SKILL.md
skills/google-ads-connect/SKILL.md
skills/google-ads-draft-summary/SKILL.md
skills/google-ads-intent-map/SKILL.md
skills/google-ads-landing-review/SKILL.md
skills/google-ads-negatives/SKILL.md
skills/google-ads-plan/SKILL.md
skills/google-ads-pmax/SKILL.md
skills/google-ads-rsas/SKILL.md
skills/google-ads-search-terms/SKILL.md
skills/google-ads-structure/SKILL.md
skills/google-ads-tracking/SKILL.md

Metadata

Files
0
Version
2c253ee
Hash
65053e52
Indexed
2026-07-25 07:33

ホーム - Wiki
Copyright © 2011-2026 iteam. Current version is 2.155.2. UTC+08:00, 2026-08-22 01:52
浙ICP备14020137号-1 $お客様$