Advertising
Campaign Manager 360 schema
SightShark syncs Campaign Manager 360 into a data warehouse you own. It creates 43 tables holding 400 fields, refreshed daily. The full trafficking structure: accounts, advertisers, campaigns, ads, creatives, placements and sites, with the geo and technology targeting tables each ad is assigned to, plus daily delivery.
43 tables / 400 fields / Tables from the production sync
Tables and fields
Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.
ad_daily_metrics
13 fields
- account_id
- date
- campaign_id
- ad_id
- placement_id
- impressions
- clicks
- click_rate
- total_conversions
- media_cost
- effective_cpm
- cost_per_click
- cost_per_activity
campaign
11 fields
- cm360_account_id
- id
- name
- advertiser_id
- start_date
- end_date
- archived
- billing_invoice_code
- default_landing_page_id
- id_dimension_value_value
- create_info_time
placement
12 fields
- id
- campaign_id
- site_id
- name
- compatibility
- active_status
- size_width
- size_height
- pricing_schedule_pricing_type
- pricing_schedule_start_date
- lookback_configuration_click_duration
- video_settings_duration_seconds
creative
12 fields
- id
- advertiser_id
- name
- type
- artwork_type
- active
- size_width
- size_height
- media_duration
- skippable
- ssl_compliant
- universal_ad_id_value
account
21 fields, documented schema
- id
- profile_id
- country_id
- account_profile
- active
- active_ads_limit_tier
- active_view_opt_out
- currency_id
- default_creative_size_id
- description
- kind
- locale
- maximum_image_size
- name
- nielsen_ocr_enabled
- reports_configuration_exposure_to_conversion_enabled
- reports_configuration_lookback_configuration_click_duration
- reports_configuration_lookback_configuration_post_impression_activities_duration
- reports_configuration_report_generation_time_zone_id
- share_reports_with_twitter
- teaser_size_limit
advertiser
23 fields, documented schema
- id
- profile_id
- account_id
- advertiser_group_id
- click_through_url_suffix
- default_click_through_event_tag_id
- default_email
- floodlight_configuration_id
- id_dimension_value_dimension_name
- id_dimension_value_etag
- id_dimension_value_id
- id_dimension_value_kind
- id_dimension_value_match_type
- id_dimension_value_value
- kind
- measurement_partner_link_link_status
- measurement_partner_link_measurement_partner
- measurement_partner_link_partner_advertiser_id
- name
- original_floodlight_configuration_id
- status
- subaccount_id
- suspended
ad
50 fields, documented schema
- id
- profile_id
- account_id
- advertiser_id
- audience_segment_id
- campaign_id
- active
- archived
- click_through_url_computed_click_through_url
- click_through_url_custom_click_through_url
- click_through_url_default_landing_page
- click_through_url_landing_page_id
- click_through_url_suffix_properties_click_through_url_suffix
- click_through_url_suffix_properties_override_inherited_suffix
- comments
- compatibility
- create_info_time
- creative_rotation_creative_optimization_configuration_id
- creative_rotation_type
- creative_rotation_weight_calculation_strategy
- delivery_schedule_frequency_cap_duration
- delivery_schedule_frequency_cap_impressions
- delivery_schedule_hard_cutoff
- delivery_schedule_impression_ratio
- delivery_schedule_priority
- dynamic_click_tracker
- end_time
- geo_targeting_exclude_countries
- id_dimension_value_dimension_name
- id_dimension_value_etag
- id_dimension_value_id
- id_dimension_value_kind
- id_dimension_value_match_type
- id_dimension_value_value
- key_value_targeting_expression_expression
- kind
- last_modified_info_time
- name
- remarketing_list_expression_expression
- size_height
- size_iab
- size_id
- size_kind
- size_width
- ssl_compliant
- ssl_required
- start_time
- subaccount_id
- targeting_template_id
- type
creative_field
7 fields, documented schema
- id
- profile_id
- account_id
- advertiser_id
- kind
- name
- subaccount_id
creative_field_value
4 fields, documented schema
- id
- profile_id
- kind
- value
creative_field_assignment
3 fields, documented schema
- creative_field_id
- creative_field_value_id
- creative_id
creative_assignment
13 fields, documented schema
- ad_id
- creative_id
- active
- apply_event_tags
- click_through_url_computed_click_through_url
- click_through_url_custom_click_through_url
- click_through_url_default_landing_page
- click_through_url_landing_page_id
- end_time
- sequence
- ssl_compliant
- start_time
- weight
creative_asset
92 fields, documented schema
- id
- creative_id
- action_script_3
- active
- alignment
- artwork_type
- asset_identifier_name
- asset_identifier_type
- audio_bit_rate
- audio_sample_rate
- backup_image_exit_advertiser_custom_event_id
- backup_image_exit_advertiser_custom_event_name
- backup_image_exit_advertiser_custom_event_type
- backup_image_exit_artwork_label
- backup_image_exit_artwork_type
- backup_image_exit_exit_click_through_url_computed_click_through_url
- backup_image_exit_exit_click_through_url_custom_click_through_url
- backup_image_exit_exit_click_through_url_landing_page_id
- backup_image_exit_id
- backup_image_exit_popup_window_properties_dimension_height
- backup_image_exit_popup_window_properties_dimension_iab
- backup_image_exit_popup_window_properties_dimension_id
- backup_image_exit_popup_window_properties_dimension_kind
- backup_image_exit_popup_window_properties_dimension_width
- backup_image_exit_popup_window_properties_offset_left
- backup_image_exit_popup_window_properties_offset_top
- backup_image_exit_popup_window_properties_position_type
- backup_image_exit_popup_window_properties_show_address_bar
- backup_image_exit_popup_window_properties_show_menu_bar
- backup_image_exit_popup_window_properties_show_scroll_bar
- backup_image_exit_popup_window_properties_show_status_bar
- backup_image_exit_popup_window_properties_show_tool_bar
- backup_image_exit_popup_window_properties_title
- backup_image_exit_target_type
- backup_image_exit_video_reporting_id
- bit_rate
- child_asset_type
- collapsed_size_height
- collapsed_size_iab
- collapsed_size_id
- collapsed_size_kind
- collapsed_size_width
- custom_start_time_value
- display_type
- duration
- duration_type
- expanded_dimension_height
- expanded_dimension_iab
- expanded_dimension_id
- expanded_dimension_kind
- expanded_dimension_width
- file_size
- flash_version
- frame_rate
- hide_flash_objects
- hide_selection_boxes
- horizontally_locked
- id_dimension_value_dimension_name
- id_dimension_value_etag
- id_dimension_value_id
- id_dimension_value_kind
- id_dimension_value_match_type
- id_dimension_value_value
- media_duration
- mime_type
- offset_left
- offset_top
- orientation
- original_backup
- polite_load
- position_left
- position_left_unit
- position_top
- position_top_unit
- progressive_serving_url
- pushdown
- pushdown_duration
- role
- size_height
- size_iab
- size_id
- size_kind
- size_width
- ssl_compliant
- start_time_type
- streaming_serving_url
- transparency
- vertically_locked
- window_mode
- z_index
- zip_filename
- zip_filesize
companion_creative
2 fields, documented schema
- companion_creative_id
- creative_id
site
25 fields, documented schema
- id
- profile_id
- account_id
- ad_serving_platform_id
- approved
- directory_site_id
- id_dimension_value_dimension_name
- id_dimension_value_etag
- id_dimension_value_id
- id_dimension_value_kind
- id_dimension_value_match_type
- id_dimension_value_value
- key_name
- kind
- name
- site_settings_active_view_opt_out
- site_settings_ad_blocking_opt_out
- site_settings_disable_new_cookie
- site_settings_tag_setting_additional_key_values
- site_settings_tag_setting_include_click_through_urls
- site_settings_tag_setting_include_click_tracking
- site_settings_tag_setting_keyword_option
- site_settings_video_active_view_opt_out_template
- site_settings_vpaid_adapter_choice_template
- subaccount_id
placement_assignment
4 fields, documented schema
- ad_id
- placement_id
- active
- ssl_required
pricing_period
6 fields, documented schema
- placement_id
- end_date
- pricing_comment
- rate_or_cost_nanos
- start_date
- units
third_party_tracking_url
3 fields, documented schema
- creative_id
- third_party_url_type
- url
audience_segment_group
3 fields, documented schema
- id
- campaign_id
- name
audience_segment
4 fields, documented schema
- id
- audience_segment_group_id
- allocation
- name
country
5 fields, documented schema
- dart_id
- country_code
- kind
- name
- ssl_enabled
region
6 fields, documented schema
- dart_id
- country_dart_id
- country_code
- kind
- name
- region_code
metro
7 fields, documented schema
- dma_id
- country_dart_id
- country_code
- dart_id
- kind
- metro_code
- name
city
9 fields, documented schema
- dart_id
- country_dart_id
- metro_dma_id
- region_dart_id
- country_code
- kind
- metro_code
- name
- region_code
postal_code
5 fields, documented schema
- id
- country_dart_id
- code
- country_code
- kind
mobile_carrier
5 fields, documented schema
- id
- country_dart_id
- country_code
- kind
- name
connection_type
3 fields, documented schema
- id
- kind
- name
operating_system
5 fields, documented schema
- dart_id
- desktop
- kind
- mobile
- name
operating_system_version
10 fields, documented schema
- id
- operating_system_dart_id
- kind
- major_version
- minor_version
- name
- operating_system_desktop
- operating_system_kind
- operating_system_mobile
- operating_system_name
platform_type
3 fields, documented schema
- id
- kind
- name
browser
6 fields, documented schema
- browser_version_id
- dart_id
- kind
- major_version
- minor_version
- name
languages
4 fields, documented schema
- id
- kind
- language_code
- name
ad_country
2 fields, documented schema
- ad_id
- country_id
ad_region
2 fields, documented schema
- ad_id
- region_id
ad_metro
2 fields, documented schema
- ad_id
- metro_id
ad_city
2 fields, documented schema
- ad_id
- city_id
ad_postal_code
2 fields, documented schema
- ad_id
- postal_code_id
ad_mobile_carrier
2 fields, documented schema
- ad_id
- mobile_carrier_id
ad_connection_type
2 fields, documented schema
- ad_id
- connection_type_id
ad_operating_system
2 fields, documented schema
- ad_id
- operating_system_id
ad_operating_system_version
2 fields, documented schema
- ad_id
- operating_system_version_id
ad_platform_type
2 fields, documented schema
- ad_id
- platform_type_id
ad_browser
2 fields, documented schema
- ad_id
- browser_id
ad_language
2 fields, documented schema
- ad_id
- language_id
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from Campaign Manager 360?
43 tables, including ad_daily_metrics, campaign, placement. ad_daily_metrics is one row per ad, per placement, per day. Every one is listed on this page, with its fields.
Which Campaign Manager 360 fields can I get?
The 400 fields on this page, table by table. Lists marked documented schema follow the published schema for Campaign Manager 360, and your own warehouse may carry a few more or fewer.
How often does Campaign Manager 360 data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Campaign Manager 360 data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Campaign Manager 360 and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
Why ad platform numbers never match on the same campaign.
They are not measuring the same thing. Once you know what each one counts, the gap stops being a mystery.
Read it - 6 min read
Server-side vs client-side tracking, and what changes in client reports.
More conversions, a break in your trend line, and a new way to count one sale twice.
Read it - 6 min read
How to set up alerts across client accounts, and keep them worth reading.
An alert that fires every day becomes a filter rule. Four things are worth interrupting somebody for.
Read it
Get started
Want Campaign Manager 360 in your own warehouse?
A call with someone who can answer the schema questions.