Power BI Connector for Google Ads

Build 24.0.9062

ConversionAction

A conversion action.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

Columns

Name Type Behavior Description
ConversionActionAppId String ATTRIBUTE App ID for an app conversion action.
ConversionActionAttributionModelSettingsAttributionModel String ATTRIBUTE The attribution model type of this conversion action.

使用できる値は次のとおりです。EXTERNAL, GOOGLE_ADS_LAST_CLICK, GOOGLE_SEARCH_ATTRIBUTION_DATA_DRIVEN, GOOGLE_SEARCH_ATTRIBUTION_FIRST_CLICK, GOOGLE_SEARCH_ATTRIBUTION_LINEAR, GOOGLE_SEARCH_ATTRIBUTION_POSITION_BASED, GOOGLE_SEARCH_ATTRIBUTION_TIME_DECAY, UNKNOWN, UNSPECIFIED

ConversionActionAttributionModelSettingsDataDrivenModelStatus String ATTRIBUTE Output only. The status of the data-driven attribution model for the conversion action.

使用できる値は次のとおりです。AVAILABLE, EXPIRED, NEVER_GENERATED, STALE, UNKNOWN, UNSPECIFIED

ConversionActionCategory String ATTRIBUTE The category of conversions reported for this conversion action.

使用できる値は次のとおりです。ADD_TO_CART, BEGIN_CHECKOUT, BOOK_APPOINTMENT, CONTACT, CONVERTED_LEAD, DEFAULT, DOWNLOAD, ENGAGEMENT, GET_DIRECTIONS, IMPORTED_LEAD, OUTBOUND_CLICK, PAGE_VIEW, PHONE_CALL_LEAD, PURCHASE, QUALIFIED_LEAD, REQUEST_QUOTE, SIGNUP, STORE_SALE, STORE_VISIT, SUBMIT_LEAD_FORM, SUBSCRIBE_PAID, UNKNOWN, UNSPECIFIED

ConversionActionClickThroughLookbackWindowDays Long ATTRIBUTE The maximum number of days that may elapse between an interaction (for example, a click) and a conversion event.
ConversionActionCountingType String ATTRIBUTE How to count conversion events for the conversion action.

使用できる値は次のとおりです。MANY_PER_CLICK, ONE_PER_CLICK, UNKNOWN, UNSPECIFIED

ConversionActionFirebaseSettingsEventName String ATTRIBUTE Output only. The event name of a Firebase conversion.
ConversionActionFirebaseSettingsProjectId String ATTRIBUTE Output only. The Firebase project ID of the conversion.
ConversionActionFirebaseSettingsPropertyId Long ATTRIBUTE Output only. The GA property ID of the conversion.
ConversionActionFirebaseSettingsPropertyName String ATTRIBUTE Output only. The GA property name of the conversion.
ConversionActionGoogleAnalytics4SettingsEventName String ATTRIBUTE Output only. The name of the GA 4 event.
ConversionActionGoogleAnalytics4SettingsPropertyId Long ATTRIBUTE Output only. The ID of the GA 4 property.
ConversionActionGoogleAnalytics4SettingsPropertyName String ATTRIBUTE Output only. The name of the GA 4 property.
ConversionActionId Long ATTRIBUTE Output only. The ID of the conversion action.
ConversionActionIncludeInConversionsMetric Bool ATTRIBUTE Whether this conversion action should be included in the 'conversions' metric.
ConversionActionMobileAppVendor String ATTRIBUTE Output only. Mobile app vendor for an app conversion action.

使用できる値は次のとおりです。APPLE_APP_STORE, GOOGLE_APP_STORE, UNKNOWN, UNSPECIFIED

ConversionActionName String ATTRIBUTE The name of the conversion action. This field is required and should not be empty when creating new conversion actions.
ConversionActionOrigin String ATTRIBUTE Output only. The conversion origin of this conversion action.

使用できる値は次のとおりです。APP, CALL_FROM_ADS, GOOGLE_HOSTED, STORE, UNKNOWN, UNSPECIFIED, WEBSITE, YOUTUBE_HOSTED

ConversionActionOwnerCustomer String ATTRIBUTE Output only. The resource name of the conversion action owner customer, or null if this is a system-defined conversion action.
ConversionActionPhoneCallDurationSeconds Long ATTRIBUTE The phone call duration in seconds after which a conversion should be reported for this conversion action. The value must be between 0 and 10000, inclusive.
ConversionActionPrimaryForGoal Bool ATTRIBUTE If a conversion action's primary_for_goal bit is false, the conversion action is non-biddable for all campaigns regardless of their customer conversion goal or campaign conversion goal. However, custom conversion goals do not respect primary_for_goal, so if a campaign has a custom conversion goal configured with a primary_for_goal = false conversion action, that conversion action is still biddable. By default, primary_for_goal will be true if not set. In V9, primary_for_goal can only be set to false after creation through an 'update' operation because it's not declared as optional.
ConversionActionResourceName String ATTRIBUTE Immutable. The resource name of the conversion action. Conversion action resource names have the form: customers/{customer_id}/conversionActions/{conversion_action_id}
ConversionActionStatus String ATTRIBUTE The status of this conversion action for conversion event accrual.

使用できる値は次のとおりです。ENABLED, HIDDEN, REMOVED, UNKNOWN, UNSPECIFIED

ConversionActionTagSnippets String ATTRIBUTE Output only. The snippets used for tracking conversions.
ConversionActionThirdPartyAppAnalyticsSettingsEventName String ATTRIBUTE Output only. The event name of a third-party app analytics conversion.
ConversionActionThirdPartyAppAnalyticsSettingsProviderName String ATTRIBUTE Output only. Name of the third-party app analytics provider.
ConversionActionType String ATTRIBUTE Immutable. The type of this conversion action.

使用できる値は次のとおりです。AD_CALL, ANDROID_APP_PRE_REGISTRATION, ANDROID_INSTALLS_ALL_OTHER_APPS, CLICK_TO_CALL, FIREBASE_ANDROID_CUSTOM, FIREBASE_ANDROID_FIRST_OPEN, FIREBASE_ANDROID_IN_APP_PURCHASE, FIREBASE_IOS_CUSTOM, FIREBASE_IOS_FIRST_OPEN, FIREBASE_IOS_IN_APP_PURCHASE, FLOODLIGHT_ACTION, FLOODLIGHT_TRANSACTION, GOOGLE_ANALYTICS_4_CUSTOM, GOOGLE_ANALYTICS_4_PURCHASE, GOOGLE_HOSTED, GOOGLE_PLAY_DOWNLOAD, GOOGLE_PLAY_IN_APP_PURCHASE, LEAD_FORM_SUBMIT, SALESFORCE, SEARCH_ADS_360, SMART_CAMPAIGN_AD_CLICKS_TO_CALL, SMART_CAMPAIGN_MAP_CLICKS_TO_CALL, SMART_CAMPAIGN_MAP_DIRECTIONS, SMART_CAMPAIGN_TRACKED_CALLS, STORE_SALES, STORE_SALES_DIRECT_UPLOAD, STORE_VISITS, THIRD_PARTY_APP_ANALYTICS_ANDROID_CUSTOM, THIRD_PARTY_APP_ANALYTICS_ANDROID_FIRST_OPEN, THIRD_PARTY_APP_ANALYTICS_ANDROID_IN_APP_PURCHASE, THIRD_PARTY_APP_ANALYTICS_IOS_CUSTOM, THIRD_PARTY_APP_ANALYTICS_IOS_FIRST_OPEN, THIRD_PARTY_APP_ANALYTICS_IOS_IN_APP_PURCHASE, UNIVERSAL_ANALYTICS_GOAL, UNIVERSAL_ANALYTICS_TRANSACTION, UNKNOWN, UNSPECIFIED, UPLOAD_CALLS, UPLOAD_CLICKS, WEBPAGE, WEBPAGE_CODELESS, WEBSITE_CALL

ConversionActionValueSettingsAlwaysUseDefaultValue Bool ATTRIBUTE Controls whether the default value and default currency code are used in place of the value and currency code specified in conversion events for this conversion action.
ConversionActionValueSettingsDefaultCurrencyCode String ATTRIBUTE The currency code to use when conversion events for this conversion action are sent with an invalid or missing currency code, or when this conversion action is configured to always use the default value.
ConversionActionValueSettingsDefaultValue Double ATTRIBUTE The value to use when conversion events for this conversion action are sent with an invalid, disallowed or missing value, or when this conversion action is configured to always use the default value.
ConversionActionViewThroughLookbackWindowDays Long ATTRIBUTE The maximum number of days which may elapse between an impression and a conversion without an interaction.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
AllConversions Double METRIC The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric.
AllConversionsValue Double METRIC The value of all conversions.
ConversionLastConversionDate Date METRIC The date of the most recent conversion for this conversion action. The date is in the customer's time zone.
ConversionLastReceivedRequestDateTime Date METRIC The last date/time a conversion tag for this conversion action successfully fired and was seen by Google Ads. This firing event may not have been the result of an attributable conversion (for example, because the tag was fired from a browser that did not previously click an ad from an appropriate advertiser). The date/time is in the customer's time zone.
Date Date SEGMENT Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
Month Date SEGMENT Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
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

Quarter Date SEGMENT Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.

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