Skip to main content

Schema - Performance Report

Updated yesterday

Note: Adtriba Core is a legacy feature that we continue to support but no longer sell. The latest version of this feature is available as Funnel Measurement.
If you are already using Funnel Measurement, find more information here. To upgrade, contact us.

COLUMN

SCHEMA

EXAMPLE

project_id

integer

243

project_name

varchar(50)

[CLIENTNAME]_DE

report_id

integer

201

report_name

varchar(50)

Transaction

date

date

2020-07-01

channel

varchar(1000)

Paid Search

source

varchar(1000)

Google Ads

campaign

varchar(1000)

summer_2020

conversion_datadriven_regular

double precision

121

conversion_firstcontact_regular

double precision

121

conversion_lastcontact_regular

double precision

121

conversion_ushaped_regular

double precision

121

conversion_linear_regular

double precision

121

conversion_timedecay_regular

double precision

121

revenue_datadriven_regular

double precision

8888.88

revenue_firstcontact_regular

double precision

8888.88

revenue_lastcontact_regular

double precision

8888.88

revenue_ushaped_regular

double precision

8888.88

revenue_linear_regular

double precision

8888.88

revenue_timedecay_regular

double precision

8888.88

conversion_datadriven_clv

double precision

123.45

revenue_datadriven_clv

double precision

9999.99

spend

double precision

123123.45

Note: The column date will be used as partition key during incremental exports

Did this answer your question?