prathamaar

The work / 05 projects

Projects.

Reporting, measurement, and review tools I've built alongside my advertising work. Each case study explains the problem, my contribution, and what the tool enables.

Scheduled reporting
Centralized Account Monitoring - The master sheet manages active client accounts and tracks the status of each automated reporting run.
Meta AdsCase study

Meta Ads Auto Reporting

Scheduled Meta Ads reporting in Google Sheets, with four reporting levels, run-status monitoring, and retries for failed pulls.

  • Meta Ads API
  • Google Apps Script
  • Google Sheets
  • Automation
View case study
On-demand data
Pulse Web dashboard.
Meta AdsCase study

Pulse — Multi-Account Data Pull

An internal dashboard where staff request Meta Ads data by account, date range, and reporting level without editing the master setup.

  • Meta API
  • Google Apps Script
  • Google Sites
  • Google Sheets
View case study
AI-assisted review
ADD, NEGATIVE, and MONITOR recommendations with reasons and analysis dates.
Google AdsCase study

Search Term Analyzer

An internal Google Sheets workflow that suggests ADD, NEGATIVE, or MONITOR decisions for analyst review. Separate from the public Search Term Classifier.

  • Google Sheets
  • Google Apps Script
  • Claude API
  • Google Ads
View case study
Closed-loop measurement
Google Ads conversion setup for downstream offline outcomes.
Google AdsCase study

Offline Conversion Import

Offline conversion tracking that connects confirmed sales with Google Ads activity, extending measurement beyond WhatsApp clicks.

  • Google Ads
  • Google Sheets
  • Google Apps Script
  • Offline Conversion Tracking
View case study
Reporting & analysis
Report configuration settings for the reporting context and preferences.
Google AdsCase study

A Google Ads reporting workflow that uses Claude to draft performance commentary for an analyst to review before sharing.

  • Google Ads
  • Google Ads Scripts
  • Google Sheets
  • Claude API
View case study