Lead-gen tracking rebuild
A lead-generation account was sending Google the wrong quality signal. The work rebuilt click ID capture, landing-page tracking and offline conversion feedback so Smart Bidding could optimise toward qualified enquiries.
Results without client-name theatre.
Most commercial work should stay anonymous. The useful pattern is the problem, the signal fix and the business outcome.
Ecommerce LTV warehouse
An ecommerce setup connected order lines, transaction IDs, product-level first purchase data and ad platform data into BigQuery so LTV and new customer quality could be queried outside platform attribution.
Reporting layer cleanup
Client reporting moved from platform screenshots toward governed definitions in BigQuery, with Claude used to query views and generate commentary from consistent data.
Search Console and crawl cleanup
Old CMS leftovers, thin pages and sitemap noise were reduced so Google had a cleaner crawl surface and the live site matched the actual business.