Back to Cookbook
IntegrationTeamFeatured
BigQuery Custom Attribution Model
Build a custom multi-touch attribution model using GA4 raw data in BigQuery.
1 hour
AdvancedLevel:
20h/monthPlatforms
Integrations
BigQuery
Best For
Prerequisites
- GA4 BigQuery export enabled
- SQL knowledge
Tools Used
ga4_run_reportValidate against GA4Prompts
Copy these prompts and paste them into Claude, ChatGPT, or any connected AI assistant with Ad Superpowers.
Custom Attribution
Help me design a custom multi-touch attribution model using my GA4 BigQuery export. I want to use a position-based model (40/20/40) but weighted by time decay. Show me the SQL query structure.
Expected output: SQL query for custom attribution model with explanation