Schema: Data Warehouse - Platform Performance - Google
The name of the Rockerbox account.
The dataset type (e.g., platform_data)
The name of the ad platform (e.g., Adwords)
The name of the dataset (e.g., platform_performance_adwords)
The unique identifier of the account in the advertising platform
The date that the action occured
The UTC hour that the action occured
Marketing channel categorization level 1
Marketing channel categorization level 2
Marketing channel categorization level 3
Marketing channel categorization level 4
Marketing channel categorization level 5
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
The ad network that your ads are being displayed on (e.g., SEARCH, SEARCH_PARTNERS, MIXED, YOUTUBE_WATCH)
The primary serving target for ads within the campaign (e.g., SEARCH, DISPLAY, SHOPPING)
The name of the ad campaign. Each campaign contains one or more ad groups.
The unique identifier of the ad campaign.
The type of the ad group (e.g., SEARCH_STANDARD, DISPLAY_STANDARD)
The name of the ad group. Each ad group contains one or more ad group ads.
The unique identifier of the ad group.
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
The local currency of your account in the ad platform (e.g., EUR, USD)
The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in USD.
The number of clicks on the ad.
The number of times your ad is shown on a search result page or other site on the Google Network.
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.
The count of conversions based on the time of conversion.
The count of conversions based on the time of the attributed advertising event (impression or click).
The count of view through conversions based on the time of the attributed impression.
The value of conversions based on the time of conversion.
The value of conversions based on the time of the attributed advertising event (impression or click).
The maximum number of days which may elapse between an impression and a conversion without an interaction.
The maximum number of days that may elapse between an interaction (e.g., a click) and a conversion event.
Identifier used by Rockerbox to sync dataset to your warehouse