Reference

BigQuery Custom Attribution Model

Build a custom multi-touch attribution model using GA4 raw data in BigQuery.

On this page

Category: Integration. Difficulty: Advanced. Estimated time: 1 hour. Estimated time saved: 20h/month. These estimates depend on your account and task.

Platforms

Google Analytics

Integrations

BigQuery

Connect these services separately in the AI client or automation tool you use. A cookbook example does not add a native Ad Superpowers integration.

Best for

Growth Engineer

Prerequisites

GA4 BigQuery export enabled
SQL knowledge

Connect the required accounts and your AI assistant, then confirm the workspace and client context. Open a recipe for its prerequisites, prompts and expected output. Treat durations and time savings as editorial estimates, not guarantees. Check proposed writes before approving them. Recipes involving another service need a separate connection to that service.

Tools used

Tool	Purpose
`ga4_run_report`	Validate against GA4

The tools available to your assistant depend on account connections, workspace permissions and client support. Browse the tool catalog.

Prompts

Use these prompts in your connected AI assistant. Replace account names, dates and targets as needed. Read the result before following a recommendation or approving a write.

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

Automation

This recipe is intended for an interactive run. Review the result with your assistant before proceeding.

All recipes · Featured · Quick wins · Deep dives · Automated workflows · Integrations · Platforms · Roles