Google Ads GAQL scripts, contribution margin models, POAS calculators and budget pacing governance.
Automated Google Ads script that cross-references campaign, ad group and shared negative lists against active positive keywords to flag silent blocking.
Hourly Google Ads script that compares spend, CPC, CPA and conversion volume against a 7-day baseline to catch broken tracking and runaway spend within 60 minutes.
Scheduled GAQL script checking HTTP response codes, redirect chains and soft-404 signatures across all active ad final URLs.
Automated pacing projection system and Google Ads MCC script accounting for flight schedules, weekend conversion shifts and approval safety gates.
Interactive financial unit-economics modeller calculating net contribution margin, Profit on Ad Spend (POAS), break-even ROAS and scaling scenarios.
Interactive diagnostic to model creative frequency curves, calculate First-Time Impression Ratio (FTIR) decay, and forecast CPA escalation.
Self-contained Python pipeline for media mix modelling. Includes geometric Adstock decay, Hill function diminishing returns, and Ridge regression spend attribution.