SSIS Components for Google Ads

Build 24.0.9062

AndroidPrivacySharedKeyGoogleAdGroup

An Android privacy shared key view for Google ad group key.

Columns

Name Type Behavior Description
AndroidPrivacySharedKeyGoogleAdGroupAdGroupId Long ATTRIBUTE Output only. The ad group ID used in the share key encoding.
AndroidPrivacySharedKeyGoogleAdGroupAndroidPrivacyInteractionDate Date ATTRIBUTE Output only. The interaction date used in the shared key encoding in the format of 'YYYY-MM-DD' in UTC timezone.
AndroidPrivacySharedKeyGoogleAdGroupAndroidPrivacyInteractionType String ATTRIBUTE Output only. The interaction type enum used in the share key encoding.

使用できる値は次のとおりです。CLICK, ENGAGED_VIEW, UNKNOWN, UNSPECIFIED, VIEW

AndroidPrivacySharedKeyGoogleAdGroupAndroidPrivacyNetworkType String ATTRIBUTE Output only. The network type enum used in the share key encoding.

使用できる値は次のとおりです。DISPLAY, SEARCH, UNKNOWN, UNSPECIFIED, YOUTUBE

AndroidPrivacySharedKeyGoogleAdGroupCampaignId Long ATTRIBUTE Output only. The campaign ID used in the share key encoding.
AndroidPrivacySharedKeyGoogleAdGroupResourceName String ATTRIBUTE Output only. The resource name of the Android privacy shared key. Android privacy shared key resource names have the form: customers/{customer_id}/androidPrivacySharedKeyGoogleAdGroups/{campaign_id}~{ad_group_id}~{android_privacy_interaction_type}~{android_privacy_network_type}~{android_privacy_interaction_date(yyyy-mm-dd)}
AndroidPrivacySharedKeyGoogleAdGroupSharedAdGroupKey String ATTRIBUTE Output only. 128 bit hex string of the encoded shared ad group 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.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
Date Date SEGMENT Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
Period String SEGMENT Predefined date range.

使用できる値は次のとおりです。TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062