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

Conversions attributed via first touch attribution methodology

int

14

ntf_first_touch

Conversions for new customers attributed via first touch attribution methodology

int

15

revenue_first_touch

Conversion revenue attributed via first touch attribution methodology

float

16

ntf_revenue_first_touch

Conversion revenue for new customers attributed via first touch attribution methodology

float

17

last_touch

Conversions attributed via last touch attribution methodology

int

18

ntf_last_touch

Conversions for new customers attributed via last touch attribution methodology

int

19

revenue_last_touch

Conversion revenue attributed via last touch attribution methodology

float

20

ntf_revenue_last_touch

Conversion revenue for new customers attributed via last touch attribution methodology

float

21

even

Conversions attributed via even weight attribution methodology

float

22

ntf_even

Conversions for new customers attributed via even weight attribution methodology

float

23

revenue_even

Conversion revenue attributed via even weight attribution methodology

float

24

ntf_revenue_even

Conversion revenue for new customers attributed via even weight attribution methodology

float

25

normalized

Conversions attributed via multi-touch attribution model

float

26

ntf_normalized

Conversions for new customers attributed via multi-touch attribution model

float

27

revenue_normalized

Conversion revenue attributed via multi-touch attribution model

float

28

ntf_revenue_normalized

Conversion revenue for new customers attributed via multi-touch attribution model

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 record was updated most recently

Note: Rockerbox aggregates data on a identifier + date granularity; therefore, when a specific type of data (ex conversion for a single channel) is edited, all records data from the full date are replaced and the updated_at timestamp will be updated for all rows for that identifier + date.

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?