Separate missing or zero clicks from valid cost-per-click calculations. Preparation only, not an account action.
Download the free skill
One complete Markdown file. No subscription or fabricated setup files.
Download SKILL.mdWhat to provide
Cost/click export, dates, currency, full campaign grain and denominator policy.
How it works
- Match cost and clicks at the same scope and date.
- Calculate CPC only with verified positive clicks and comparable currency.
- Flag missing, zero or negative denominators separately from genuinely zero cost.
- Return a report exception note; do not fill gaps or rank campaigns on invalid ratios.
The output
key | cost | clicks | currency/scope | CPC or held | denominator reason
Worked fictional example
Fictional cost 30 and clicks 10 gives CPC 3. Cost 30 and clicks 0 is held, not CPC 0; cost 0 and clicks 10 gives 0.
Checks and limits
Keep source versions and original values. Unknowns stay unknown. Use qualified review for regulated, legal or hiring decisions. No live account compatibility test, send, share, schedule, ledger change or payment is authorized.
More marketing workflows · How-to guides
Method: reviewed source. Demand lead: Oct7 GSC chart throughOct4: marketing copilot37,PlanableClaude33/ChatGPT23,brief12,report11; other profession topics are related workflow-method demand leads, not exact queries. Exact monthly volume unmeasured. Checked October 7, 2026.