ADO.NET Provider for Google Ads

Build 26.0.9655

ChangeStatus

Describes the status of returned resource. ChangeStatus could have up to 3

View-Specific Information

Select

Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are 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 using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.

The ChangeStatus view has additional API restrictions. When executing the following query:

SELECT * FROM ChangeStatus
the provider automatically applies the following constraints:

  • A filter on the ChangeStatusLastChangeDateTime column restricted to the last 90 days (the maximum allowed range, as data older than 90 days cannot be retrieved through this view).
  • A LIMIT clause capped at 10,000 records (the maximum allowed per request).
Note: These constraints are applied automatically to prevent an API error. You can restrict the results even further by passing smaller filters, such as a shorter date range or a lower 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.
ChangeStatusAsset String ATTRIBUTE Output only. The Asset affected by this change.
ChangeStatusAssetGroup String ATTRIBUTE Output only. The AssetGroup affected by this change.
ChangeStatusAssetSet String ATTRIBUTE Output only. The AssetSet 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.
ChangeStatusCampaignAssetSet String ATTRIBUTE Output only. The CampaignAssetSet affected by this change.
ChangeStatusCampaignBudget String ATTRIBUTE Output only. The CampaignBudget affected by this change.
ChangeStatusCampaignCriterion String ATTRIBUTE Output only. The CampaignCriterion 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.
ChangeStatusLastChangeDateTime Datetime ATTRIBUTE Output only. Time at which the most recent change has occurred on this
ChangeStatusResourceName String ATTRIBUTE Output only. The resource name of the change status.
ChangeStatusResourceStatus String ATTRIBUTE Output only. Represents the status of the changed resource.

The allowed values are ADDED, CHANGED, REMOVED, UNKNOWN.

ChangeStatusResourceType String ATTRIBUTE Output only. Represents the type of the changed resource. This dictates

The allowed values are AD_GROUP, AD_GROUP_AD, AD_GROUP_ASSET, AD_GROUP_BID_MODIFIER, AD_GROUP_CRITERION, AD_GROUP_FEED, ASSET, ASSET_GROUP, ASSET_SET, CAMPAIGN, CAMPAIGN_ASSET, CAMPAIGN_ASSET_SET, CAMPAIGN_BUDGET, CAMPAIGN_CRITERION, CAMPAIGN_FEED, CAMPAIGN_SHARED_SET, COMBINED_AUDIENCE, CUSTOMER_ASSET, FEED, FEED_ITEM, SHARED_SET, UNKNOWN.

ChangeStatusSharedSet String ATTRIBUTE Output only. The SharedSet affected by this change.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

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

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655