android_privacy_shared_key_google_campaign

Page Summary

outlined_flag

• The Android privacy shared key view for Google campaign key provides data related to user interactions and campaigns within the Android Privacy Sandbox.

• This view allows selection of fields from the customer resource, but these fields will not segment metrics.

• Fields available include interaction date, interaction type, campaign ID, resource name, and the shared campaign key.

• The segments.date field is available for segmenting the data by date.

Help me build a query

An Android privacy shared key view for Google campaign key.

Attributed resources
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of android_privacy_shared_key_google_campaign. However, when you specify android_privacy_shared_key_google_campaign in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when android_privacy_shared_key_google_campaign is specified in the FROM clause.

Is android_privacy_shared_key_google_campaign specified in the FROM clause of your query?

No Yes, it is

android_privacy_shared_key_google_campaign.android_privacy_interaction_date Field description Output only. The interaction date used in the shared key encoding in the format of "YYYY-MM-DD" in UTC timezone. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

android_privacy_shared_key_google_campaign.android_privacy_interaction_type Field description Output only. The interaction type enum used in the share key encoding. Category ATTRIBUTE Data Type ENUM CLICK ENGAGED_VIEW UNKNOWN UNSPECIFIED VIEW Type URL google.ads.googleads.v20.enums.AndroidPrivacyInteractionTypeEnum.AndroidPrivacyInteractionType Filterable True Selectable True Sortable True Repeated False

android_privacy_shared_key_google_campaign.campaign_id Field description Output only. The campaign ID used in the share key encoding. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

android_privacy_shared_key_google_campaign.resource_name Field description Output only. The resource name of the Android privacy shared key. Android privacy shared key resource names have the form: customers/{customer_id}/androidPrivacySharedKeyGoogleCampaigns/{campaign_id}~{android_privacy_interaction_type}~{android_privacy_interaction_date(yyyy-mm-dd)} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

android_privacy_shared_key_google_campaign.shared_campaign_key Field description Output only. 128 bit hex string of the encoded shared campaign key, including a '0x' prefix. This key can be used to do a bitwise OR operator with the aggregate conversion key to create a full aggregation key to retrieve the Aggregate API Report in Android Privacy Sandbox. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.date Field description Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False Selectable with The following fields/resources can be selected with this field: ad_group ad_group_ad ad_group_ad_asset_combination_view ad_group_ad_asset_view ad_group_asset ad_group_audience_view ad_schedule_view age_range_view android_privacy_shared_key_google_ad_group android_privacy_shared_key_google_campaign android_privacy_shared_key_google_network_type asset_field_type_view asset_group asset_group_asset asset_group_product_group_view asset_group_top_combination_view asset_set_asset asset_set_type_view bidding_strategy campaign campaign_aggregate_asset_view campaign_asset campaign_audience_view campaign_budget campaign_group campaign_search_term_insight channel_aggregate_asset_view click_view content_criterion_view conversion_action customer customer_asset customer_search_term_insight detail_placement_view display_keyword_view distance_view dynamic_search_ads_search_term_view expanded_landing_page_view gender_view geographic_view group_placement_view hotel_group_view hotel_performance_view hotel_reconciliation income_range_view keyword_view landing_page_view location_view managed_placement_view metrics.absolute_top_impression_percentage metrics.active_view_cpm metrics.active_view_ctr metrics.active_view_impressions metrics.active_view_measurability metrics.active_view_measurable_cost_micros metrics.active_view_measurable_impressions metrics.active_view_viewability metrics.all_conversions metrics.all_conversions_by_conversion_date metrics.all_conversions_from_click_to_call metrics.all_conversions_from_directions metrics.all_conversions_from_interactions_rate metrics.all_conversions_from_interactions_value_per_interaction metrics.all_conversions_from_location_asset_click_to_call metrics.all_conversions_from_location_asset_directions metrics.all_conversions_from_location_asset_menu metrics.all_conversions_from_location_asset_order metrics.all_conversions_from_location_asset_other_engagement metrics.all_conversions_from_location_asset_store_visits metrics.all_conversions_from_location_asset_website metrics.all_conversions_from_menu metrics.all_conversions_from_order metrics.all_conversions_from_other_engagement metrics.all_conversions_from_store_visit metrics.all_conversions_from_store_website metrics.all_conversions_value metrics.all_conversions_value_by_conversion_date metrics.all_conversions_value_per_cost metrics.all_new_customer_lifetime_value metrics.auction_insight_search_absolute_top_impression_percentage metrics.auction_insight_search_impression_share metrics.auction_insight_search_outranking_share metrics.auction_insight_search_overlap_rate metrics.auction_insight_search_position_above_rate metrics.auction_insight_search_top_impression_percentage metrics.average_cart_size metrics.average_cost metrics.average_cpc metrics.average_cpe metrics.average_cpm metrics.average_cpv metrics.average_impression_frequency_per_user metrics.average_order_value_micros metrics.average_page_views metrics.average_target_cpa_micros metrics.average_target_roas metrics.average_time_on_site metrics.benchmark_average_max_cpc metrics.benchmark_ctr metrics.biddable_app_install_conversions metrics.biddable_app_post_install_conversions metrics.biddable_cohort_app_post_install_conversions metrics.bounce_rate metrics.clicks metrics.combined_clicks metrics.combined_clicks_per_query metrics.combined_queries metrics.content_budget_lost_impression_share metrics.content_impression_share metrics.content_rank_lost_impression_share metrics.conversions metrics.conversions_by_conversion_date metrics.conversions_from_interactions_rate metrics.conversions_from_interactions_value_per_interaction metrics.conversions_value metrics.conversions_value_by_conversion_date metrics.conversions_value_per_cost metrics.cost_converted_currency_per_platform_comparable_conversion metrics.cost_micros metrics.cost_of_goods_sold_micros metrics.cost_per_all_conversions metrics.cost_per_conversion metrics.cost_per_current_model_attributed_conversion metrics.cost_per_platform_comparable_conversion metrics.coviewed_impressions metrics.cross_device_conversions metrics.cross_device_conversions_value_micros metrics.cross_sell_cost_of_goods_sold_micros metrics.cross_sell_gross_profit_micros metrics.cross_sell_revenue_micros metrics.cross_sell_units_sold metrics.ctr metrics.current_model_attributed_conversions metrics.current_model_attributed_conversions_from_interactions_rate metrics.current_model_attributed_conversions_from_interactions_value_per_interaction metrics.current_model_attributed_conversions_value metrics.current_model_attributed_conversions_value_per_cost metrics.eligible_impressions_from_location_asset_store_reach metrics.engagement_rate metrics.engagements metrics.general_invalid_click_rate metrics.general_invalid_clicks metrics.gmail_forwards metrics.gmail_saves metrics.gmail_secondary_clicks metrics.gross_profit_margin metrics.gross_profit_micros metrics.historical_creative_quality_score metrics.historical_landing_page_quality_score metrics.historical_quality_score metrics.historical_search_predicted_ctr metrics.hotel_average_lead_value_micros metrics.hotel_commission_rate_micros metrics.hotel_eligible_impressions metrics.hotel_expected_commission_cost metrics.hotel_price_difference_percentage metrics.impressions metrics.interaction_event_types metrics.interaction_rate metrics.interactions metrics.invalid_click_rate metrics.invalid_clicks metrics.lead_cost_of_goods_sold_micros metrics.lead_gross_profit_micros metrics.lead_revenue_micros metrics.lead_units_sold metrics.message_chat_rate metrics.message_chats metrics.message_impressions metrics.mobile_friendly_clicks_percentage metrics.new_customer_lifetime_value metrics.orders metrics.organic_clicks metrics.organic_clicks_per_query metrics.organic_impressions metrics.organic_impressions_per_query metrics.organic_queries metrics.percent_new_visitors metrics.phone_calls metrics.phone_impressions metrics.phone_through_rate metrics.platform_comparable_conversions metrics.platform_comparable_conversions_by_conversion_date metrics.platform_comparable_conversions_from_interactions_rate metrics.platform_comparable_conversions_from_interactions_value_per_interaction metrics.platform_comparable_conversions_value metrics.platform_comparable_conversions_value_by_conversion_date metrics.platform_comparable_conversions_value_per_cost metrics.primary_impressions metrics.publisher_organic_clicks metrics.publisher_purchased_clicks metrics.publisher_unknown_clicks metrics.relative_ctr metrics.revenue_micros metrics.search_absolute_top_impression_share metrics.search_budget_lost_absolute_top_impression_share metrics.search_budget_lost_impression_share metrics.search_budget_lost_top_impression_share metrics.search_click_share metrics.search_exact_match_impression_share metrics.search_impression_share metrics.search_rank_lost_absolute_top_impression_share metrics.search_rank_lost_impression_share metrics.search_rank_lost_top_impression_share metrics.search_top_impression_share metrics.search_volume metrics.sk_ad_network_installs metrics.sk_ad_network_total_conversions metrics.speed_score metrics.top_impression_percentage metrics.unique_users metrics.units_sold metrics.valid_accelerated_mobile_pages_clicks_percentage metrics.value_per_all_conversions metrics.value_per_all_conversions_by_conversion_date metrics.value_per_conversion metrics.value_per_conversions_by_conversion_date metrics.value_per_current_model_attributed_conversion metrics.value_per_platform_comparable_conversion metrics.value_per_platform_comparable_conversions_by_conversion_date metrics.video_quartile_p100_rate metrics.video_quartile_p25_rate metrics.video_quartile_p50_rate metrics.video_quartile_p75_rate metrics.video_view_rate metrics.video_views metrics.view_through_conversions metrics.view_through_conversions_from_location_asset_click_to_call metrics.view_through_conversions_from_location_asset_directions metrics.view_through_conversions_from_location_asset_menu metrics.view_through_conversions_from_location_asset_order metrics.view_through_conversions_from_location_asset_other_engagement metrics.view_through_conversions_from_location_asset_store_visits metrics.view_through_conversions_from_location_asset_website paid_organic_search_term_view parental_status_view per_store_view performance_max_placement_view product_group_view search_term_view segments.activity_account_id segments.activity_city segments.activity_country segments.activity_rating segments.activity_state segments.ad_destination_type segments.ad_format_type segments.ad_group segments.ad_network_type segments.adjusted_age_range segments.adjusted_gender segments.asset_group segments.asset_interaction_target.asset segments.asset_interaction_target.interaction_on_this_asset segments.auction_insight_domain segments.budget_campaign_association_status.campaign segments.budget_campaign_association_status.status segments.campaign segments.click_type segments.conversion_action segments.conversion_action_category segments.conversion_action_name segments.conversion_adjustment segments.conversion_attribution_event_type segments.conversion_lag_bucket segments.conversion_or_adjustment_lag_bucket segments.conversion_value_rule_primary_dimension segments.day_of_week segments.device segments.external_activity_id segments.external_conversion_source segments.geo_target_airport segments.geo_target_canton segments.geo_target_city segments.geo_target_country segments.geo_target_county segments.geo_target_district segments.geo_target_metro segments.geo_target_most_specific_location segments.geo_target_postal_code segments.geo_target_province segments.geo_target_region segments.geo_target_state segments.hotel_booking_window_days segments.hotel_center_id segments.hotel_check_in_date segments.hotel_check_in_day_of_week segments.hotel_city segments.hotel_class segments.hotel_country segments.hotel_date_selection_type segments.hotel_length_of_stay segments.hotel_price_bucket segments.hotel_rate_rule_id segments.hotel_rate_type segments.hotel_state segments.hour segments.interaction_on_this_extension segments.keyword.ad_group_criterion segments.keyword.info.match_type segments.keyword.info.text segments.month segments.month_of_year segments.new_versus_returning_customers segments.partner_hotel_id segments.product_aggregator_id segments.product_brand segments.product_category_level1 segments.product_category_level2 segments.product_category_level3 segments.product_category_level4 segments.product_category_level5 segments.product_channel segments.product_channel_exclusivity segments.product_condition segments.product_country segments.product_custom_attribute0 segments.product_custom_attribute1 segments.product_custom_attribute2 segments.product_custom_attribute3 segments.product_custom_attribute4 segments.product_feed_label segments.product_item_id segments.product_language segments.product_merchant_id segments.product_store_id segments.product_title segments.product_type_l1 segments.product_type_l2 segments.product_type_l3 segments.product_type_l4 segments.product_type_l5 segments.quarter segments.search_engine_results_page_type segments.search_subcategory segments.search_term segments.search_term_match_type segments.sk_ad_network_ad_event_type segments.sk_ad_network_attribution_credit segments.sk_ad_network_coarse_conversion_value segments.sk_ad_network_fine_conversion_value segments.sk_ad_network_postback_sequence_index segments.sk_ad_network_redistributed_fine_conversion_value segments.sk_ad_network_source_app.sk_ad_network_source_app_id segments.sk_ad_network_source_domain segments.sk_ad_network_source_type segments.sk_ad_network_user_type segments.sk_ad_network_version segments.slot segments.travel_destination_city segments.travel_destination_country segments.travel_destination_region segments.webpage segments.week segments.year shopping_performance_view shopping_product smart_campaign_search_term_view topic_view travel_activity_group_view travel_activity_performance_view user_location_view video webpage_view