ChangeStatus
Describes the status of returned resource. ChangeStatus 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 ChangeStatus table has extra limitations. You need to provide a time no older than 30 days, and a limit, for example:
SELECT ChangeStatusCampaign, CustomerId FROM ChangeStatus WHERE ChangeStatusLastChangeDateTime DURING LAST_14_DAYS LIMIT 10
Columns
Name | Type | Behavior | Description |
ChangeStatusAdGroup | String | ATTRIBUTE | Output only. The AdGroup affected by this change. |
ChangeStatusAdGroupAd | String | ATTRIBUTE | Output only. The AdGroupAd affected by this change. |
ChangeStatusAdGroupAsset | String | ATTRIBUTE | Output only. The AdGroupAsset affected by this change. |
ChangeStatusAdGroupBidModifier | String | ATTRIBUTE | Output only. The AdGroupBidModifier affected by this change. |
ChangeStatusAdGroupCriterion | String | ATTRIBUTE | Output only. The AdGroupCriterion affected by this change. |
ChangeStatusAdGroupFeed | String | ATTRIBUTE | Output only. The AdGroupFeed affected by this change. |
ChangeStatusAsset | String | ATTRIBUTE | Output only. The Asset affected by this change. |
ChangeStatusAssetGroup | String | ATTRIBUTE | Output only. The AssetGroup affected by this change. |
ChangeStatusCampaign | String | ATTRIBUTE | Output only. The Campaign affected by this change. |
ChangeStatusCampaignAsset | String | ATTRIBUTE | Output only. The CampaignAsset affected by this change. |
ChangeStatusCampaignCriterion | String | ATTRIBUTE | Output only. The CampaignCriterion affected by this change. |
ChangeStatusCampaignFeed | String | ATTRIBUTE | Output only. The CampaignFeed affected by this change. |
ChangeStatusCampaignSharedSet | String | ATTRIBUTE | Output only. The CampaignSharedSet affected by this change. |
ChangeStatusCombinedAudience | String | ATTRIBUTE | Output only. The CombinedAudience affected by this change. |
ChangeStatusCustomerAsset | String | ATTRIBUTE | Output only. The CustomerAsset affected by this change. |
ChangeStatusFeed | String | ATTRIBUTE | Output only. The Feed affected by this change. |
ChangeStatusFeedItem | String | ATTRIBUTE | Output only. The FeedItem affected by this change. |
ChangeStatusLastChangeDateTime | Date | ATTRIBUTE | Output only. Time at which the most recent change has occurred on this resource. |
ChangeStatusResourceName | String | ATTRIBUTE | Output only. The resource name of the change status. Change status resource names have the form: customers/{customer_id}/changeStatus/{change_status_id} |
ChangeStatusResourceStatus | String | ATTRIBUTE | Output only. Represents the status of the changed resource.
使用できる値は次のとおりです。ADDED, CHANGED, REMOVED, UNKNOWN, UNSPECIFIED |
ChangeStatusResourceType | String | ATTRIBUTE | Output only. Represents the type of the changed resource. This dictates what fields will be set. For example, for AD_GROUP, campaign and ad_group fields will be set.
使用できる値は次のとおりです。AD_GROUP, AD_GROUP_AD, AD_GROUP_ASSET, AD_GROUP_BID_MODIFIER, AD_GROUP_CRITERION, AD_GROUP_FEED, ASSET, ASSET_GROUP, CAMPAIGN, CAMPAIGN_ASSET, CAMPAIGN_CRITERION, CAMPAIGN_FEED, CAMPAIGN_SHARED_SET, COMBINED_AUDIENCE, CUSTOMER_ASSET, FEED, FEED_ITEM, SHARED_SET, UNKNOWN, UNSPECIFIED |
ChangeStatusSharedSet | String | ATTRIBUTE | Output only. The SharedSet affected by 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. |