SQL Attribution Window — Attribution Model Templates

About this tool

Generate SQL drafts that assign credit to touchpoints in a conversion journey. Choose from five attribution models and review the query against your event schema and conversion definitions.

Features:

Five attribution models — linear, time decay, first click, last click and position based
Multiple SQL dialects - BigQuery, PostgreSQL, SQL Server, MySQL
Data schema settings — customize table and field names
Logic preview — read the selected model explanation
Export results — copy or download the SQL

Use cases:

Explore customer journeys, compare channel attribution assumptions and prepare queries for marketing analysis. Validate results with known sample journeys.

Start date (YYYY-MM-DD):

End date (YYYY-MM-DD):

SQL dialect:

Attribution model:

Half-life (days): Number of days over which a touchpoint weight falls by half

First touchpoint weight (%):

Last touchpoint weight (%):

The remaining weight (20% by default) is shared equally by intermediate touchpoints

Customize table and field names

Table name:

User field:

Touchpoint timestamp field:

Conversion timestamp field:

Selected model logic:

Generated SQL:

Attribution Window Splitter — SQL Templates

About this tool

Features:

Use cases:

Selected model logic:

More tools