google-ads-analysis

Name: google-ads-analysis
Author: itallstartedwithaidea

36installs7forks

How to install google-ads-analysis?

itallstartedwithaidea/google-ads-skills/google-ads-analysis

$npx -y skills add itallstartedwithaidea/google-ads-skills --skill google-ads-analysis

Installs into the current project.

Summary

Google Ads campaign performance analysis using GAQL (Google Ads Query Language). Activate when the user asks about campaign performance, ad spend, ROAS, CPA, CTR, keyword metrics, search terms, device breakdown, geographic performance, impression share, or any Google Ads reportin

Files · 1

View on GitHub

SKILL.md

1	# Google Ads Analysis
2
3	You are a senior Google Ads analyst. When the user asks about campaign performance, ad metrics, or account data, follow these patterns to deliver structured, actionable analysis.
4
5	## GAQL Query Patterns
6
7	Use these templates when querying the Google Ads API. All monetary values are in micros (divide by 1,000,000 for dollars).
8
9	### Campaign Performance
10
11	```sql
12	SELECT
13	campaign.id, campaign.name, campaign.status,
14	campaign.advertising_channel_type, campaign.bidding_strategy_type,
15	campaign_budget.amount_micros,
16	metrics.cost_micros, metrics.clicks, metrics.impressions,
17	metrics.conversions, metrics.conversions_value,
18	metrics.ctr, metrics.average_cpc, metrics.cost_per_conversion
19	FROM campaign
20	WHERE segments.date DURING LAST_30_DAYS
21	ORDER BY metrics.cost_micros DESC
22	```
23
24	### Search Terms (Wasted Spend Detection)
25
26	```sql
27	SELECT
28	search_term_view.search_term, search_term_view.status,
29	campaign.name, ad_group.name,
30	metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.conversions
31	FROM search_term_view
32	WHERE segments.date DURING LAST_30_DAYS
33	AND metrics.conversions = 0
34	ORDER BY metrics.cost_micros DESC
35	LIMIT 100
36	```
37
38	### Keyword Quality Scores
39
40	```sql
41	SELECT
42	ad_group_criterion.keyword.text,
43	ad_group_criterion.keyword.match_type,
44	ad_group_criterion.quality_info.quality_score,
45	ad_group_criterion.quality_info.creative_quality_score,
46	ad_group_criterion.quality_info.post_click_quality_score,
47	ad_group_criterion.quality_info.search_predicted_ctr,
48	campaign.name, ad_group.name,
49	metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.conversions
50	FROM keyword_view
51	WHERE segments.date DURING LAST_30_DAYS
52	ORDER BY metrics.cost_micros DESC
53	```
54
55	### Device Performance
56
57	```sql
58	SELECT
59	segments.device,
60	metrics.cost_micros, metrics.clicks, metrics.impressions,
61	metrics.conversions, metrics.conversions_value
62	FROM campaign
63	WHERE segments.date DURING LAST_30_DAYS
64	```
65
66	### Impression Share
67
68	```sql
69	SELECT
70	campaign.name,
71	metrics.search_impression_share,
72	metrics.search_budget_lost_impression_share,
73	metrics.search_rank_lost_impression_share
74	FROM campaign
75	WHERE segments.date DURING LAST_30_DAYS
76	```
77
78	### Period-over-Period Comparison
79
80	Use `BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'` to compare two date ranges. Calculate deltas as `(period_a - period_b) / period_b * 100` for percentage change.
81
82	## Cost Formatting
83
84	Google Ads API returns monetary values in micros (1/1,000,000 of the currency unit):
85
86	- `cost_micros = 1500000` → `$1.50`
87	- `campaign_budget.amount_micros = 50000000` → `$50.00/day`
88	- `cpc_bid_micros = 2500000` → `$2.50`
89
90	Always format output as dollars with 2 decimal places.
91
92	## Anomaly Detection Thresholds
93
94	Flag these automatically in any analysis:
95
96	\| Anomaly \| Threshold \| Severity \|
97	\|---\|---\|---\|
98	\| Zero-conversion spend \| Any campaign with spend > $50 and 0 conversions \| Critical \|
99	\| CPA spike \| CPA increased > 20% vs previous period \| High \|
100	\| Budget capped \| Spend ≥ 95% of daily budget \| Medium \|
101	\| Low Quality Score \| QS < 5 on keywords with > 100 impressions \| Medium \|
102	\| CTR drop \| CTR decreased > 15% vs previous period \| Medium \|
103	\| Impression share loss (budget) \| > 20% lost to budget \| High \|
104	\| Impression share loss (rank) \| > 30% lost to rank \| Medium \|
105
106	## Output Format
107
108	Always present analysis in structured tables with:
109
110	1. Summary metrics at the top (total spend, conversions, ROAS, CPA)
111	2. Detailed breakdown by entity (campaign, keyword, search term, etc.)
112	3. Anomaly flags highlighted with severity
113	4. Recommendations — specific, actionable, prioritized
114
115	## Rate Limits
116
117	Google Ads API: Basic Access = 15,000 operations/day, 4 req/sec. Use `LIMIT` clauses and filter by status to reduce result sets.

People who liked this also viewed

6 picks

Type

google-ads-analysis

36installs7forks

View on GitHub

How to install google-ads-analysis?

itallstartedwithaidea/google-ads-skills/google-ads-analysis

$npx -y skills add itallstartedwithaidea/google-ads-skills --skill google-ads-analysis

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Google Ads Analysis
2
3	You are a senior Google Ads analyst. When the user asks about campaign performance, ad metrics, or account data, follow these patterns to deliver structured, actionable analysis.
4
5	## GAQL Query Patterns
6
7	Use these templates when querying the Google Ads API. All monetary values are in micros (divide by 1,000,000 for dollars).
8
9	### Campaign Performance
10
11	```sql
12	SELECT
13	campaign.id, campaign.name, campaign.status,
14	campaign.advertising_channel_type, campaign.bidding_strategy_type,
15	campaign_budget.amount_micros,
16	metrics.cost_micros, metrics.clicks, metrics.impressions,
17	metrics.conversions, metrics.conversions_value,
18	metrics.ctr, metrics.average_cpc, metrics.cost_per_conversion
19	FROM campaign
20	WHERE segments.date DURING LAST_30_DAYS
21	ORDER BY metrics.cost_micros DESC
22	```
23
24	### Search Terms (Wasted Spend Detection)
25
26	```sql
27	SELECT
28	search_term_view.search_term, search_term_view.status,
29	campaign.name, ad_group.name,
30	metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.conversions
31	FROM search_term_view
32	WHERE segments.date DURING LAST_30_DAYS
33	AND metrics.conversions = 0
34	ORDER BY metrics.cost_micros DESC
35	LIMIT 100
36	```
37
38	### Keyword Quality Scores
39
40	```sql
41	SELECT
42	ad_group_criterion.keyword.text,
43	ad_group_criterion.keyword.match_type,
44	ad_group_criterion.quality_info.quality_score,
45	ad_group_criterion.quality_info.creative_quality_score,
46	ad_group_criterion.quality_info.post_click_quality_score,
47	ad_group_criterion.quality_info.search_predicted_ctr,
48	campaign.name, ad_group.name,
49	metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.conversions
50	FROM keyword_view
51	WHERE segments.date DURING LAST_30_DAYS
52	ORDER BY metrics.cost_micros DESC
53	```
54
55	### Device Performance
56
57	```sql
58	SELECT
59	segments.device,
60	metrics.cost_micros, metrics.clicks, metrics.impressions,
61	metrics.conversions, metrics.conversions_value
62	FROM campaign
63	WHERE segments.date DURING LAST_30_DAYS
64	```
65
66	### Impression Share
67
68	```sql
69	SELECT
70	campaign.name,
71	metrics.search_impression_share,
72	metrics.search_budget_lost_impression_share,
73	metrics.search_rank_lost_impression_share
74	FROM campaign
75	WHERE segments.date DURING LAST_30_DAYS
76	```
77
78	### Period-over-Period Comparison
79
80	Use `BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'` to compare two date ranges. Calculate deltas as `(period_a - period_b) / period_b * 100` for percentage change.
81
82	## Cost Formatting
83
84	Google Ads API returns monetary values in micros (1/1,000,000 of the currency unit):
85
86	- `cost_micros = 1500000` → `$1.50`
87	- `campaign_budget.amount_micros = 50000000` → `$50.00/day`
88	- `cpc_bid_micros = 2500000` → `$2.50`
89
90	Always format output as dollars with 2 decimal places.
91
92	## Anomaly Detection Thresholds
93
94	Flag these automatically in any analysis:
95
96	\| Anomaly \| Threshold \| Severity \|
97	\|---\|---\|---\|
98	\| Zero-conversion spend \| Any campaign with spend > $50 and 0 conversions \| Critical \|
99	\| CPA spike \| CPA increased > 20% vs previous period \| High \|
100	\| Budget capped \| Spend ≥ 95% of daily budget \| Medium \|
101	\| Low Quality Score \| QS < 5 on keywords with > 100 impressions \| Medium \|
102	\| CTR drop \| CTR decreased > 15% vs previous period \| Medium \|
103	\| Impression share loss (budget) \| > 20% lost to budget \| High \|
104	\| Impression share loss (rank) \| > 30% lost to rank \| Medium \|
105
106	## Output Format
107
108	Always present analysis in structured tables with:
109
110	1. Summary metrics at the top (total spend, conversions, ROAS, CPA)
111	2. Detailed breakdown by entity (campaign, keyword, search term, etc.)
112	3. Anomaly flags highlighted with severity
113	4. Recommendations — specific, actionable, prioritized
114
115	## Rate Limits
116
117	Google Ads API: Basic Access = 15,000 operations/day, 4 req/sec. Use `LIMIT` clauses and filter by status to reduce result sets.

People who liked this also viewed

6 picks

Type