Schema: Data Warehouse - Platform Performance - Google

Order

Name

Description

Type

1

advertiser

The name of the Rockerbox account.

str

2

type

The dataset type (e.g., platform_data)

str

3

platform

The name of the ad platform (e.g., Adwords)

str

4

report

The name of the dataset (e.g., platform_performance_adwords)

str

5

identifier

The unique identifier of the account in the advertising platform

str

6

date

The date that the action occured

date

7

utc_hour

The UTC hour that the action occured

int

8

tier_1

Marketing channel categorization level 1

str

9

tier_2

Marketing channel categorization level 2

str

10

tier_3

Marketing channel categorization level 3

str

11

tier_4

Marketing channel categorization level 4

str

12

tier_5

Marketing channel categorization level 5

str

13

mta_tiers_join_key

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

str

14

ad_network_type

The ad network that your ads are being displayed on (e.g., SEARCH, SEARCH_PARTNERS, MIXED, YOUTUBE_WATCH)

str

15

advertising_channel_type

The primary serving target for ads within the campaign (e.g., SEARCH, DISPLAY, SHOPPING)

str

16

campaign_name

The name of the ad campaign. Each campaign contains one or more ad groups.

str

17

campaign_id

The unique identifier of the ad campaign.

str

18

ad_group_type

The type of the ad group (e.g., SEARCH_STANDARD, DISPLAY_STANDARD)

str

19

ad_group_name

The name of the ad group. Each ad group contains one or more ad group ads.

str

20

ad_group_id

The unique identifier of the ad group.

str

21

spend

The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in the ad platform account’s local currency

float

22

currency_code

The local currency of your account in the ad platform (e.g., EUR, USD)

str

23

spend_usd

The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in USD.

float

24

clicks

The number of clicks on the ad.

int

25

impressions

The number of times your ad is shown on a search result page or other site on the Google Network.

int

26

cost_micros

Ad spend in micro currency units (micros). For example, $1.23 will come back as 1230000 (1.23 x 1,000,000). Micro amounts always refer to the account’s local currency.

int

27

all_conversions_by_conversion_date

The count of conversions based on the time of conversion.

dict

28

all_conversions

The count of conversions based on the time of the attributed advertising event (impression or click).

dict

29

view_through_conversions

The count of view through conversions based on the time of the attributed impression.

dict

30

all_conversions_value_by_conversion_date

The value of conversions based on the time of conversion.

dict

31

all_conversions_value

The value of conversions based on the time of the attributed advertising event (impression or click).

dict

32

view_through_lookback_window_days

The maximum number of days which may elapse between an impression and a conversion without an interaction.

dict

33

click_through_lookback_window_days

The maximum number of days that may elapse between an interaction (e.g., a click) and a conversion event.

dict

34

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

str

35

updated_at

timestamp

Primary Key: the concatenation of identifier, date, utc_hour, campaign_id, ad_group_id, and ad_network_type can be used as a primary key


How did we do?