Schema: Data Warehouse - Buckets Breakdown

Order

Name

Description

Type

1

type

The report type (e.g., platform_data)

str

2

report

The name of the report

str

3

advertiser

Rockerbox Account ID

str

4

identifier

conversion segment id

int

5

date

Date when the action occurred

date

6

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

7

tier_2

Marketing channel categorization level 2

str

8

tier_3

Marketing channel categorization level 3

str

9

tier_4

Marketing channel categorization level 4

str

10

tier_5

Marketing channel categorization level 5 (most specific)

str

11

platform

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

str

12

platform_join_key

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

str

13

first_touch

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

int

14

ntf_first_touch

First touch conversions, filtered by new to file users

int

15

revenue_first_touch

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

float

16

ntf_revenue_first_touch

First touch revenue, filtered by new to file users

float

17

last_touch

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

int

18

ntf_last_touch

Last touch conversions, filtered by new to file users

int

19

revenue_last_touch

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

float

20

ntf_revenue_last_touch

Last touch revenue, filtered by new to file users

float

21

even

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

float

22

ntf_even

Even weight conversions, filtered by new to file users

float

23

revenue_even

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

float

24

ntf_revenue_even

Even weight revenue, filtered by new to file users

float

25

normalized

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

float

26

ntf_normalized

Modeled weight conversions, filtered by new to file users

float

27

revenue_normalized

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

float

28

ntf_revenue_normalized

Modeled weight revenue, filtered by new to file users

float

29

spend

Total spend in the advertisers reporting currency

float

30

currency_code

The advertiser reporting currency for both revenue and spend

str

31

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

32

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

int

33

updated_at

Time the cache record was updated most recently

timestamp

Primary Key: the concatenation of date, platform_join_key, and tiers 1-5 can be used as a primary key


How did we do?