Schema: Data Warehouse - Platform Performance - Facebook

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 name of the ad campaign. Your campaign contains ad sets and ads

str

15

campaign_id

The unique ID of the ad campaign. Your campaign contains ad sets and ads

str

16

adset_name

The name of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting

str

17

adset_id

The unique ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting

str

18

ad_name

The name of the ad

str

19

ad_id

The unique ID of the 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 the ad

int

24

impressions

The number of times your ads were on screen

int

25

inline_link_clicks

The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window

int

26

outbound_clicks

The number of clicks on links that take people off Facebook-owned properties

int

27

view_1d

The total number of view through conversions within a 1 day lookback.

dict

28

click_1d

The total number of click through conversions within a 1 day lookback window.

dict

29

click_7d

The total number of click through conversions within a 7 day lookback window.

dict

30

view_1d_value

The total value of view through conversions (in the local currency tracked in the FB pixel) within a 1 day lookback.

dict

31

click_1d_value

The total value of click through conversions (in the local currency tracked in the FB pixel) within a 1 day lookback window.

dict

32

click_7d_value

The total value of click through conversions (in the local currency tracked in the FB pixel) within a 7 day lookback window.

dict

33

view_1d_value_usd

The total value of view through conversions converted to USD within a 1 day lookback.

dict

34

click_1d_value_usd

The total value of click through conversions converted to USD within a 1 day lookback window.

dict

35

click_7d_value_usd

The total value of click through conversions converted to USD within a 7 day lookback window.

dict

36

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

str

37

updated_at

timestamp


Did this page help you?