BAX ECOM PPC Agent: Scheduled Dual-Level Google Ads Analysis with AI-Generated Email Reports

Problem:

An ecommerce business running Google Ads needed a deeper level of campaign reporting than basic campaign-level data, they needed both portfolio-level campaign overviews and individual campaign deep-dives automatically processed and delivered without any manual dashboard work.

Solution: Built a scheduled n8n workflow that pulls two levels of Google Ads data, a full campaign list pull (getAllCampaigns) processed through a code block, followed by an individual campaign detail pull (getCampaign) processed through a second code block, both data layers are passed to the BAX ECOM PPC Agent powered by OpenAI, which synthesizes portfolio and campaign-level insights and distributes a complete performance report via Gmail with Calculator tool support for precise metric computation.

Result:

Delivered an automated two-tier PPC analysis system that gives ecommerce teams both a high-level portfolio view and granular campaign performance in a single AI-generated report, delivered to their inbox on schedule with zero manual data pulling or analysis.