Weekly Pulse

Monday Report - GA4 + Google Ads + Performance Master Sync

Run every Monday morning
1
GA4
GA4 Traffic L30
Last 30 days by source
GA4 Data API
-->
Report (L30) tab
Sessions by traffic source (Organic, Paid, Direct, etc.)
Writes to L52W!Report (L30) sheet
2
YoY
GA4 YoY Comparison
This week vs Same week LY
GA4 Data API
-->
YoY cells
Compare current week to same week last year
Calculates % change in sessions/conversions
4
PM
Performance Master Sync
Weekly column update
L52W Calculated
-->
Perf Master (Week Col)
Copy calculated metrics to Performance Master
Updates the current week's column

Data Written

GA4 Traffic Sources
~10 rows
GA4 YoY Cells
~20 cells
Google Ads Metrics
~30 cells
Perf Master Column
1 week column

Data Flow Details

GA4 Traffic Sources

  • Organic Search
  • Paid Search (Google Ads)
  • Direct
  • Email
  • Social (Organic + Paid)
  • Referral
  • Display

Google Ads Metrics

  • CPM - Cost per 1000 impressions
  • CPC - Cost per click
  • CTR - Click-through rate
  • Conv Rate - Conversion rate
  • Breakdown by device type

Sheet Targets

  • L52W!Report (L30) - GA4 traffic
  • L52W!Report (YoY) - Year comparison
  • L52W!Google Ads - Ads metrics
  • Perf Master - Weekly rollup

API Credentials

  • GA4: Property ID 249403019
  • Google Ads: Customer ID in env
  • OAuth 2.0 with refresh tokens
  • Same credentials as daily flows