Skip to main content
Schema - Performance Report
János Moldvay avatar
Written by János Moldvay
Updated over a week ago

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

Enjoy working with us? Please consider leaving a review.

Did this answer your question?