ChangeEvent
Describes the granular change of returned resources of certain resource types. Changes made through the UI or API in the past 30 days are included. Previous and new values of the changed fields are shown. ChangeEvent could have up to 3 minutes delay to reflect a new change.
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.
The ChangeEvent table has extra limitations. You need to provide a time no older than 30 days, and a limit, for example:
SELECT ChangeEventCampaign, CustomerId FROM ChangeEvent WHERE ChangeEventChangeDateTime DURING LAST_14_DAYS LIMIT 10
Columns
| Name | Type | Behavior | Description |
| ChangeEventAdGroup | String | ATTRIBUTE | Output only. The AdGroup affected by this change. |
| ChangeEventAsset | String | ATTRIBUTE | Output only. The Asset affected by this change. |
| ChangeEventCampaign | String | ATTRIBUTE | Output only. The Campaign affected by this change. |
| ChangeEventChangeDateTime | Date | ATTRIBUTE | Output only. Time at which the change was committed on this resource. |
| ChangeEventChangeResourceName | String | ATTRIBUTE | Output only. The Simply resource this change occurred on. |
| ChangeEventChangeResourceType | String | ATTRIBUTE | Output only. The type of the changed resource. This dictates what resource will be set in old_resource and new_resource.
使用できる値は次のとおりです。AD, AD_GROUP, AD_GROUP_AD, AD_GROUP_ASSET, AD_GROUP_BID_MODIFIER, AD_GROUP_CRITERION, AD_GROUP_FEED, ASSET, ASSET_SET, ASSET_SET_ASSET, CAMPAIGN, CAMPAIGN_ASSET, CAMPAIGN_ASSET_SET, CAMPAIGN_BUDGET, CAMPAIGN_CRITERION, CAMPAIGN_FEED, CUSTOMER_ASSET, FEED, FEED_ITEM, UNKNOWN, UNSPECIFIED |
| ChangeEventChangedFields | String | ATTRIBUTE | Output only. A list of fields that are changed in the returned resource. |
| ChangeEventClientType | String | ATTRIBUTE | Output only. Where the change was made through.
使用できる値は次のとおりです。GOOGLE_ADS_API, GOOGLE_ADS_AUTOMATED_RULE, GOOGLE_ADS_BULK_UPLOAD, GOOGLE_ADS_EDITOR, GOOGLE_ADS_MOBILE_APP, GOOGLE_ADS_RECOMMENDATIONS, GOOGLE_ADS_RECOMMENDATIONS_SUBSCRIPTION, GOOGLE_ADS_SCRIPTS, GOOGLE_ADS_WEB_CLIENT, INTERNAL_TOOL, OTHER, SEARCH_ADS_360_POST, SEARCH_ADS_360_SYNC, UNKNOWN, UNSPECIFIED |
| ChangeEventFeed | String | ATTRIBUTE | Output only. The Feed affected by this change. |
| ChangeEventFeedItem | String | ATTRIBUTE | Output only. The FeedItem affected by this change. |
| ChangeEventNewResource | String | ATTRIBUTE | Output only. The new resource after the change. Only changed fields will be populated. |
| ChangeEventOldResource | String | ATTRIBUTE | Output only. The old resource before the change. Only changed fields will be populated. |
| ChangeEventResourceChangeOperation | String | ATTRIBUTE | Output only. The operation on the changed resource.
使用できる値は次のとおりです。CREATE, REMOVE, UNKNOWN, UNSPECIFIED, UPDATE |
| ChangeEventResourceName | String | ATTRIBUTE | Output only. The resource name of the change event. Change event resource names have the form: customers/{customer_id}/changeEvents/{timestamp_micros}~{command_index}~{mutate_index} |
| ChangeEventUserEmail | String | ATTRIBUTE | Output only. The email of the user who made this change. |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |