COLUMN

SCHEMA

EXAMPLE

project_id

integer

243

project_name

varchar(50)

[CLIENTNAME]_DE

report_id

integer

201

report_name

varchar(50)

Transaction

report_type

varchar(15)

clv

journey_id

varchar(40)

abc123

user_id

varchar(500)

aaaa1111

log_id

varchar(200)

aadjaj-01931jakjd-das

touchpoint_date

date

2020-07-01

touchpoint_timestamp

timestamp

2020-07-01 1:23:45

touchpoint_position

bigint

1

channel

varchar(1000)

Paid Search

source

varchar(1000)

Google Ads

campaign

varchar(1000)

summer_2020

medium

varchar(1000)

cpc

location

varchar(5000)

https://example.com/foobar

referrer

varchar(5000)

https://someotherpage.com/test

conversion_id

varchar(200)

XYZ123

conversion_date

date

2020-07-01

conversion_timestamp

timestamp

2020-07-01 1:23:45

conversion_datadriven

double precision

0.5280936787

conversion_ushaped

double precision

0.5

conversion_firstcontact

double precision

0

conversion_lastcontact

double precision

1

conversion_linear

double precision

0

conversion_timedecay

double precision

0

revenue_datadriven

double precision

528.0936787

revenue_ushaped

double precision

500

revenue_firstcontact

double precision

0

revenue_lastcontact

double precision

1000

revenue_linear

double precision

0

revenue_timedecay

double precision

0

currency

varchar(10)

EUR

geo_country

varchar(100)

Germany

geo_country_iso

varchar(10)

DE

geo_subdivision

varchar(100)

Hamburg

geo_city

varchar(100)

Hamburg

geo_postal_code

varchar(100)

22459

geo_latitude

double precision

53.6242

geo_longitude

double precision

9.9235

device_type

varchar(500)

Desktop

device_hardware_vendor

varchar(500)

Apple

device_hardware_family

varchar(500)

Macintosh

device_hardware_model

varchar(500)

Macintosh

device_platform_vendor

varchar(500)

Apple

device_platform_family

varchar(500)

macOS

device_platform_model

varchar(500)

10.12

device_browser_vendor

varchar(500)

Apple

device_browser_family

varchar(500)

Safari

device_browser_model

varchar(500)

10.1

custom_* (used for non-default columns per customer/report)

Enjoy working with us? Please consider leaving a review.

Did this answer your question?