Schema: Data Warehouse - MTA

Order

Name

Description

Type

1

report

The name of the report

str

2

advertiser

Rockerbox Account ID

str

3

identifier

conversion segment id

int

4

date

Date when the action occurred

date

5

timestamp_conv

Timestamp of when the conversion occurred (ISO 8601 format in UTC)

timestamp

6

conversion_hash_id

Identifier per unique conversion (this is a hash of the conversion_key value)

str

7

conversion_key

An identifier used to denote a unique conversion event (this is typically your provided Order ID)

str

8

action

Name of the conversion event

str

9

new_to_file

At the time of conversion, if Rockerbox has seen that user make a Purchase before, then new_to_file = 0. Otherwise, they are considered a new customer and new_to_file = 1.

int

10

onsite_count

The total number of times a user was seen on your website

int

11

total_events

Total number of marketing touchpoints leading up to the conversion

int

12

event_id

Identifier per unique marketing touch point

str

13

timestamp_events

Timestamp of when the marketing touchpoint occurred (ISO 8601 format in UTC)

timestamp

14

sequence_number

The order of when this marketing touchpoint occurred (1 = first, 2 = second, etc.)

int

15

hash_ip_events

Hashed IP address of user for a particular marketing touchpoint

str

16

type

The report type (e.g., platform_data)

str

17

uid

Rockerbox User ID cookie

str

18

user_agent_events

User agent string associated with the user for the marketing event

str

19

base_id

Primary User ID

str

20

currency_code

The advertiser reporting currency for both revenue and spend

str

21

fx_rate_to_usd

The exchange rate from the local currency to USD for the date. If currency_code is USD, this value will be 1.

float

22

platform

The name of the platform (e.g., Facebook)

str

23

spend_key

The ID used to pull spend from an advertisting platform. This is typically the Ad ID, but may differ based on your account setup.

str

24

matches

List of categorization rules that a touchpoint has matched with. The last rule in the list is applied.

dict

25

tier_1

Marketing channel categorization level 1 (most broad), as defined in your mapping rules. For example, a link where referrer url = Google and utm_campaign = cpc may be mapped as tier_1 = Paid Search and tier_2 = Google

str

26

tier_2

Marketing channel categorization level 2

str

27

tier_3

Marketing channel categorization level 3

str

28

tier_4

Marketing channel categorization level 4

str

29

tier_5

Marketing channel categorization level 5 (most specific)

str

30

original_url

URL of the page where the marketing touchpoint occurred

str

31

request_referrer

Page Referrer (the previous site where the user came from)

str

32

utm_parameters

All URL parameters that begin with utm_ and their values

dict

33

url_parameters

All URL parameters, except for those that begin with utm_, and their values

dict

34

tier_one

One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files.

str

35

tier_two

One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files.

str

36

tier_three

One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files.

str

37

tier_four

One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files.

str

38

tier_five

One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files.

str

39

normalized

Weight given to this marketing touchpoint, as determined by the multi-touch attribution model

float

40

revenue_normalized

Using the normalized weight, the portion of conversion revenue that is attributed to this marketing touchpoint

float

41

first_touch

Will be 1 if this marketing touchpoint is the first interaction. Otherwise will be 0.

int

42

revenue_first_touch

If the marketing touchpoint is the first interaction, it will get full revenue credit. Otherwise will be 0.

float

43

last_touch

Will be 1 if this marketing touchpoint is the last interaction. Otherwise will be 0

int

44

revenue_last_touch

If the marketing touchpoint is the last interaction, it will get full revenue credit. Otherwise will be 0.

float

45

even

Fractional credit a marketing touchpoint receives if each touchpoint gets equal weight

float

46

revenue_even

Using the even weight, the portion of conversion revenue that is attributed to this marketing touchpoint

float

47

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

int

48

updated_at

Time the cache record was updated most recently

timestamp


Did this page help you?