Schema: Data Warehouse - Platform Performance - Bing

Order

Name

Description

Type

1

advertiser

Rockerbox Account ID

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

campaign_name

The campaign name

str

15

campaign_id

The Microsoft Advertising assigned unique identifier of a campaign

str

16

ad_group_name

The ad group name

str

17

ad_group_id

The Microsoft Advertising assigned unique identifier of an ad group

str

18

ad_title

The ad title

str

19

ad_id

The Microsoft Advertising assigned unique identifier of an ad

str

20

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

21

currency_code

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

str

22

spend_usd

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

float

23

clicks

The number of clicks on an ad

int

24

impressions

The number of times an ad has been displayed on search results pages

int

25

conversions

The number of conversions. ConversionsQualified is the count of conversions across all conversion goals with the ExcludeFromBiddingProperty set to false. AllConversionsQualified is the count of conversions across all conversion goals regardless of the ExcludeFromBidding setting. ViewThroughConversionsQualified is the count of view-through conversions across all conversion goals.

dict

26

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

str

27

updated_at

timestamp


Did this page help you?