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 |
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 |
content | varchar(5000) | accessories |
term | varchar(5000) | product |
location | varchar(5000) | |
referrer | varchar(5000) | |
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 |
customer_type | varchar(50) | returning |
gclid | varchar(5000) | abcxyz |
Note: The column conversion_date will be used as partition key during incremental exports