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