android_privacy_shared_key_google_campaign

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

Resource fields android_privacy_interaction_date android_privacy_interaction_type campaign_id resource_name shared_campaign_key

Segments date

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.v17.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