PPC Waste Detector - Google & Meta Budget Leak Auditor

Find wasted ad spend: query bleed, cannibalization, junk placements and click fraud.

No hosted demo for this project — it runs locally. See install instructions below.

View Source on GitHub →

Discuss This Project on WhatsApp

Google Ads & PPC

Overview

PPC Waste Detector analyzes Google Ads and Meta search query data to identify wasted spend: negative-intent query bleed, cross-campaign keyword cannibalization, casual gaming display placements and click-fraud patterns. It exports negative keyword lists in Ads Editor CSV format.

Screenshot of the ppc-waste-detector project
Report preview from the repository docs showing a PPC waste audit summary.

Problem It Solves

A meaningful share of PPC budgets leaks into irrelevant queries and placements. Without systematic detection, managers keep paying for clicks that cannot convert.

Target Users

  • PPC managers and media buyers
  • Agencies running Google and Meta accounts
  • E-commerce and lead-gen teams

Key Features

  • Six waste detectors covering query intent, cannibalization and placements
  • Click-fraud pattern heuristics
  • Automated negative keyword list generation
  • Ads Editor CSV export
  • CLI interface with CI (ruff, mypy, pytest)

Technologies

  • Python
  • Typer
  • Pydantic
  • pytest
  • CSV tooling

Contribution & Skills

Sole author. Built the detection rules, query analysis pipeline, negative keyword generation and export formats.

Install & Usage

Install

git clone https://github.com/hamid-digitalmarketer/ppc-waste-detector.git
cd ppc-waste-detector
pip install -e ".[dev]"

Run an audit

ppc-waste audit
ppc-waste export-negatives --format ads-editor

Full documentation lives in the repository README →

FAQ

What counts as ad waste?

Negative-intent query bleed, cross-campaign keyword cannibalization, junk display placements (for example casual gaming apps) and click-fraud patterns.

Can I export the negative keywords?

Yes. The tool exports negative keyword lists in Ads Editor CSV format ready for account import.

Related Projects

PD
Google Ads & PPC

ppc-performance-dashboard

A Streamlit dashboard for clean PPC KPI analysis and period comparison.

Screenshot of the meta-lead-quality-analyzer projectMeta Ads

meta-lead-quality-analyzer

Score Meta lead quality and feed offline conversions back to the algorithm.

Screenshot of the conversion-tracking-doctor projectAnalytics & Tracking

conversion-tracking-doctor

Diagnose broken conversion tracking and data quality across GA4, Ads and Meta CAPI.

Need Help With ppc-waste-detector or Similar Tooling?

I build custom MarTech tools, audits and automation for teams. Start the conversation on WhatsApp.

Contact Me on WhatsApp
💬WhatsApp