itallstartedwithaideaitallstartedwithaidea/google-ads-skills/skills/google-ads-math/SKILL.md

google-ads-math

Skill38 starsChanged 8 months agoApache-2.0View on GitHub

Google Ads math and forecasting calculations. Activate when the user asks about budget projections, ROAS calculations, CPA targets, conversion forecasts, impression share opportunity, or any PPC-related math. No API credentials needed — works with numbers the user provides.

We split this skill into the rules it gives an agent

3 rules. About 0 are common, 3 are distinctive, and 0 are very specific to this project.

≈0
Common · estimate
Many files like this have a rule of this kind.
≈3
Distinctive · estimate
This author's own choices. Worth a look.
0
Very specific
Tied to their project's names, files or tools. Probably skip.

Common
Distinctive
Very specific

Distinctive:
Always present calculations in a table:
line 127
Distinctive:
Always show your work — list inputs, formula, and result
line 144
Distinctive:
Use 30.4 days per month (365/12) for monthly projections
line 148

≈ “Common” is an estimate: at least 1 in 5 of the 308,232 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.

Files

SKILL.md

Google Ads Math

You are a PPC math engine. When the user provides numbers, run the calculations below and present results in clear tables. No API access needed — this is pure math.

Core Formulas

Cost Per Acquisition (CPA)

CPA = Total Spend / Total Conversions

Return on Ad Spend (ROAS)

ROAS = Revenue / Spend
ROAS as percentage = (Revenue / Spend) × 100

A ROAS of 3.0x means $3 revenue for every $1 spent.

Click-Through Rate (CTR)

CTR = Clicks / Impressions

Cost Per Click (CPC)

CPC = Spend / Clicks

Conversion Rate (CVR)

CVR = Conversions / Clicks

Projection Calculations

Budget Projection

Given: daily spend, CPC, conversion rate

Daily Clicks = Daily Budget / CPC
Daily Conversions = Daily Clicks × CVR
Monthly Spend = Daily Budget × 30.4
Monthly Conversions = Daily Conversions × 30.4
Monthly CPA = Monthly Spend / Monthly Conversions

ROAS Target

Given: spend, revenue, target ROAS

Current ROAS = Revenue / Spend
At Target = Current ROAS >= Target ROAS
Gap = Target ROAS - Current ROAS
Revenue Needed = Spend × Target ROAS

CPA Target

Given: spend, conversions, target CPA

Current CPA = Spend / Conversions
At Target = Current CPA <= Target CPA
To Hit Target = need (Spend / Target CPA) conversions
Additional Conversions Needed = (Spend / Target CPA) - Current Conversions

Conversion Forecast

Given: daily conversions, daily spend, forecast days

Projected Conversions = Daily Conversions × Forecast Days
Projected Spend = Daily Spend × Forecast Days
Projected CPA = Projected Spend / Projected Conversions

Impression Share Opportunity

Given: current impression share (%), total impressions

Missed Impressions = Total Impressions × ((1 - IS) / IS)
Potential Total = Total Impressions + Missed Impressions
Estimated Missed Clicks = Missed Impressions × CTR
Estimated Missed Conversions = Missed Clicks × CVR
Estimated Missed Revenue = Missed Conversions × Avg Conv Value

Break-Even ROAS

Given: profit margin

Break-Even ROAS = 1 / Profit Margin
Example: 30% margin → Break-Even ROAS = 1 / 0.30 = 3.33x

Bid Estimation

Given: target position, current CPC, quality score

Approximate rule: each QS point ≈ 10-15% CPC reduction
QS 10 vs QS 5: roughly 50% cheaper CPC at same position

Output Format

Always present calculations in a table:

| Metric | Value |
|---|---|
| Daily Budget | $75.00 |
| Avg CPC | $1.80 |
| Est. Daily Clicks | 42 |
| Conversion Rate | 3.5% |
| Est. Daily Conversions | 1.5 |
| **Monthly Spend** | **$2,280.00** |
| **Monthly Conversions** | **45** |
| **Monthly CPA** | **$50.67** |

Guidelines

Always show your work — list inputs, formula, and result
Round to 2 decimal places for dollars, 1 decimal for percentages
Flag unrealistic inputs (e.g., CTR > 20%, CPA < $1 on non-brand)
Offer sensitivity analysis: "If CPC increases 20%, your CPA would be..."
Use 30.4 days per month (365/12) for monthly projections

Download now (ZIP)

In this repository4 other files it gives its agents.
- google-ads-analysisSkill
- google-ads-auditSkill
- google-ads-mcpSkill
- google-ads-writeSkill

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

Reviews can't be read right now.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

Check your setup, free