SearchCampaignChangeHistoryReportColumn Value Set - Reporting
Defines the attribute columns that you can include in the SearchCampaignChangeHistoryReportRequest.
For a list of columns that you must include, please see the Required Columns section below.
Syntax
<xs:simpleType name="SearchCampaignChangeHistoryReportColumn" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:restriction base="xs:string">
<xs:enumeration value="DateTime" />
<xs:enumeration value="AccountId" />
<xs:enumeration value="AccountName" />
<xs:enumeration value="AccountNumber" />
<xs:enumeration value="ChangedBy" />
<xs:enumeration value="CampaignName" />
<xs:enumeration value="CampaignId" />
<xs:enumeration value="AdGroupName" />
<xs:enumeration value="AdGroupId" />
<xs:enumeration value="AdTitle" />
<xs:enumeration value="AdDescription" />
<xs:enumeration value="DisplayUrl" />
<xs:enumeration value="Keyword" />
<xs:enumeration value="ItemChanged" />
<xs:enumeration value="AttributeChanged" />
<xs:enumeration value="HowChanged" />
<xs:enumeration value="OldValue" />
<xs:enumeration value="NewValue" />
<xs:enumeration value="EntityName" />
<xs:enumeration value="EntityId" />
<xs:enumeration value="Tool" />
</xs:restriction>
</xs:simpleType>
Values
The SearchCampaignChangeHistoryReportColumn value set has the following values: AccountId, AccountName, AccountNumber, AdDescription, AdGroupId, AdGroupName, AdTitle, AttributeChanged, CampaignId, CampaignName, ChangedBy, DateTime, DisplayUrl, EntityId, EntityName, HowChanged, ItemChanged, Keyword, NewValue, OldValue, Tool.
| Value | Description |
|---|---|
| AccountId | The Microsoft Advertising assigned identifier of an account. |
| AccountName | The account name. |
| AccountNumber | The Microsoft Advertising assigned number of an account. |
| AdDescription | The first ad description that appears below the path in your ad. This column will be empty if ItemChanged is not Ad. |
| AdGroupId | The Microsoft Advertising assigned identifier of an ad group. This column will be empty if ItemChanged is not Ad , Ad group, or Keyword. |
| AdGroupName | The ad group name. This column will be empty if ItemChanged is not Ad , Ad group, or Keyword. |
| AdTitle | The ad title parts. This column will be empty if ItemChanged is not Ad. |
| AttributeChanged | Identifies the attribute or property of the entity from the ItemChanged column that changed. For a list of elements whose change history is reported, see the Attribute Changed column within Remarks. This column is empty if a campaign, ad group, or ad entity was added or deleted. |
| CampaignId | The Microsoft Advertising assigned identifier of a campaign. |
| CampaignName | The campaign name. |
| ChangedBy | The username of the user that made the change to settings within the account. If the system made the change, the value will be Administrator. |
| DateTime | The date and time of the change. The date and time will be in the time zone of the campaign. |
| DisplayUrl | The ad display URL. This column will be empty if ItemChanged is not Ad. |
| EntityId | The Microsoft Advertising system identifier of the entity that was updated. |
| EntityName | The name of the entity that was updated. |
| HowChanged | The value that indicates whether the element was added, updated, or deleted. For possible values, see ChangeTypeReportFilter Value Set. For adds, the NewValue column contains the added entity. For deletes, the OldValue column contains the deleted entity. For updates, the NewValue column contains the new value and the OldValue column contains the old value. If an entity which has a delivery status property was added, for example a campaign, the value of HowChanged is Added. To report a deleted entity, the ItemChanged field is Status, the HowChanged field is Changed, and the NewValue field is Deleted. Associating a target with a campaign or ad group will be reported as an add change. The AttributeChanged column will identify the target types contained in the target object. Updates to a target object will be reported as a delete change and an add change. Removing a campaign's or ad group's association with a target object will be reported as a delete change. |
| ItemChanged | The value that identifies the entity that changed. If the change is an update to an element of the entity or is related to a target associated with a campaign or ad group, the AttributeChanged column contains the element of the entity that changed or the type of target that was changed. |
| Keyword | The keyword text. This column will be empty if ItemChanged is not Keyword. |
| NewValue | The value after the change. For more information, see the HowChanged column. |
| OldValue | The value before the change. For more information, see the HowChanged column. |
| Tool | The Microsoft Advertising tool used to make changes. The possible values include "API", "Automated rules", "Bulk upload", "Imports", "Editor", "Mobile Apps", "Other", "Scripts", and "Web client (manual)". New values can be added in the future, so you should not take any dependency on a fixed set of values. |
Remarks
Required Columns
The report must include the following columns at a minimum. As a general rule, each report must include at least one attribute column and at least one non-impression share performance statistics column. For more information, see Report Attributes and Performance Statistics.
| Column |
|---|
| DateTime |
Change History Details
The following are the entity types whose change history is reported.
Note
If the AttributeChanged field is blank or empty, and the HowChanged field is Added or Deleted, then the contents of the NewValue or OldValue field represents an element of the entity that was added or deleted, respectively. For example if a keyword is added, the NewValue field contains the keyword text.
- Account
- Ad
- Ad group
- Call extension
- Campaign
- Keyword
- Location extension
- Negative Keyword List
- Sitelink extension
- User
Account
When the ItemChanged field's value is Account, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| None (blank) | Refers to the name of the account that was added. The value of the corresponding HowChanged field is Added. |
| Account | Refers to the name of the account that was changed. |
| Agency contact | Refers to the name of the agency contact. |
| Sales house customer | Refers to the sales house customer. |
| Bill-to customer | Refers to the bill-to customer |
| Financial status | Refers to the financial status |
| Lock status | Refers to the lock status |
| Payment option | Refers to the payment option |
| Preferred bill-to payment method | Refers to the preferred bill-to payment method |
| Preferred language | Refers to the preferred language |
| Sold-to payment method | Sold-to payment method |
| Status | Refers to the account status. |
| Preferred user | Refers to the preferred user |
| Spend limit | Refers to the spend limit |
| Tracking template | Refers to the tracking template of the account. |
Ad
When the ItemChanged field's value is Ad, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| None (blank) | Refers to the title of the ad that was added. The value of the corresponding HowChanged field is Added. |
| Ad text | Refers to the description of the ad copy. |
| Ad title | Refers to the title of the ad that was changed. |
| Custom parameters | Refers to the custom parameters of the ad. |
| Destination URL | Refers to the destination URL of the ad. |
| Display URL | Refers to the display URL of the ad. |
| Editorial status | Refers to the editorial status of the ad. If the ad is pending offline editorial review, then within a downloaded change history report the editorial status is represented as either Pending - Active or Pending - Inactive. For more information, see Entities and Delivery Status. |
| Final URL | Refers to the Final URL of the ad. |
| Mobile URL | Refers to the Final Mobile URL of the ad. |
| Status | Refers to the delivery status of the ad. If reporting a deleted ad, the ItemChanged field is Status, the HowChanged field is Changed, and the NewValue field is Deleted. |
| Tracking template | Refers to the tracking template of the ad. |
Ad group
When the ItemChanged field's value is Ad group, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| None (blank) | Refers to the name of the ad group that was added. The value of the corresponding HowChanged field is Added. |
| Ad group | Refers to the name of the ad group that was changed. |
| Advanced location targeting | Refers to intent option of the location target that is associated with the ad group. |
| Age | Refers to the age target. |
| Custom parameters | Refers to the custom parameters of the ad group. |
| Day | Refers to the day target that was deprecated after Bing Ads API version 9. |
| Default broad match bid | Refers to the default broad match bid |
| Default content match bid | Refers to the default content match bid |
| Default exact match bid | Refers to the default exact match bid |
| Default phrase match bid | Refers to the default phrase match bid |
| Device | Refers to the defers to the device target. |
| Distance | Refers to the distance of the radius target. |
| End date | Refers to the scheduled end date for the ad group. |
| End time | Refers to the combined To Hour and To Minute of the DayTime target. The bid adjustment is also included in this field, delimited from the time by a single vertical bar character. |
| Gender | Refers to the gender target. |
| Hour | Refers to the hour target that was deprecated after Bing Ads API version 9. |
| Location | Refers to the location target. |
| Location exclusion | Refers to excluding locations from a location target. |
| Medium | Refers to the Search or Content ad distribution. |
| Negative keyword | Refers to a negative keyword associated with the ad group. Updates to negative keywords are reported as a Removed and Added change in two rows. The Removed record corresponds to the old value, and the Added record reflects the new value. |
| Pause status | Refers to the any of the paused states of the ad group. |
| Product group | The product conditions of a product group are delimited from each other by a backward slash (''), and delimited from the bid by a single space character. |
| Site Exclusion | Refers to the ad group's negative site URLs. An ad group can have multiple site exclusions, and each site exclusion is represented separately in its own report row. |
| Start time | Refers to the combined From Hour and From Minute of the DayTime target. The bid adjustment is also included in this field, delimited from the time by a single vertical bar character. |
| Status | Refers to the delivery status of the ad group. If reporting a deleted ad group, the ItemChanged field is Status, the HowChanged field is Changed, and the NewValue field is Deleted. |
| Targeted days | Refers day of the DayTime target. The bid adjustment is also included in this field, delimited from the day by a single vertical bar character. |
| Tracking template | Refers to the tracking template of the ad group. |
Call extension
When the ItemChanged field's value is Call extension, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| Association | Refers to the association of a call extension with an entity. For example, if the extension is associated with a campaign, CampaignName field's value is the name of the associated campaign, the ItemChanged field's value is Call extension, the AttributeChanged field's value is Association, and the HowChanged field's value is Added. As another example, if the extension is associated or disassociated with a campaign, the respective NewValue or OldValue is the name of the campaign, and the EntityName column contains the name of the ad extension. |
| Country/region | Refers to the country/region of the call extension. |
| Phone Number | Refers to the phone number of the call extension. |
| Show website or phone | Refers to whether the website should be displayed with the phone number of the call extension. Possible values in the OldValue and NewValue columns are Phone and Website and phone. |
| Use forward number | Refers to whether forwarding is set up for the call extension. Possible values in the OldValue and NewValue columns are No and Yes. |
Campaign
When the ItemChanged field's value is Campaign, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| None (blank) | Refers to the name of the campaign that was added. The value of the corresponding HowChanged field is Added. |
| Advanced location targeting | Refers to intent option of the location target that is associated with the campaign. |
| Age | Refers to the age target. |
| Budget type | Refers to the campaign budget type. Possible values in the OldValue and NewValue columns are as follows: - Value of Daily target (accelerated) corresponds to the Microsoft Advertising web application Daily Accelerated setting. - Value of Daily target (standard) corresponds to the Microsoft Advertising web application Daily Standard setting. |
| Campaign priority | Refers to the priority of a Microsoft Shopping campaign. |
| Custom parameters | Refers to the custom parameters of the campaign. |
| Daily budget | Refers to the campaign daily budget amount. |
| Day | Refers to the day target that was deprecated after Bing Ads API version 9. |
| Device | Refers to the device target. |
| Distance | Refers to the distance of the radius target. |
| End date | Refers to the scheduled end date for the ad group. |
| End time | Refers to the combined To Hour and To Minute of the DayTime target. The bid adjustment is also included in this field, delimited from the time by a single vertical bar character. |
| Gender | Refers to the gender target. |
| Hour | Refers to the hour target that was deprecated after Bing Ads API version 9. |
| IP exclusion | Refers to the IP exclusions created via the Microsoft Advertising web application. |
| Location | Refers to the location target. |
| Location exclusion | Refers to excluding locations from a location target. |
| Name | Refers to the name of the campaign that was changed. |
| Negative keyword | Refers to a negative keyword associated with the campaign. Updates to negative keywords are reported as a Removed and Added change in two rows. The Removed record corresponds to the old value, and the Added record reflects the new value. |
| Pause status | Refers to the any of the paused states of the campaign. Possible values in the OldValue and NewValue columns are "Budget Paused", "Budget and user Paused", "Not paused", and "Paused". |
| Product filter | Refers to the product scope or condition of a Microsoft Shopping campaign. A Microsoft Shopping campaign can have multiple product conditions, and each condition is represented separately in its own report row. |
| Shared budget | Refers to the budget shared by multiple campaigns. |
| Site Exclusion | Refers to the campaign's negative site URLs. A campaign can have multiple site exclusions, and each site exclusion is represented separately in its own report row. |
| Start date | For internal use. |
| Start time | Refers to the combined From Hour and From Minute of the DayTime target. The bid adjustment is also included in this field, delimited from the time by a single vertical bar character. |
| Status | Refers to the delivery status of the campaign. If reporting a deleted campaign, the ItemChanged field is Status, the HowChanged field is Changed, and the NewValue field is Deleted. |
| Targeted days | Refers day of the DayTime target. The bid adjustment is also included in this field, delimited from the day by a single vertical bar character. |
| Tracking template | Refers to the Tracking template of the campaign. |
Keyword
When the ItemChanged field's value is Keyword, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| None (blank) | Refers to the text of the keyword that was added. The value of the corresponding HowChanged field is Added. |
| Broad match bid | Refers to the broad match bid amount for the keyword. |
| Content match bid | Refers to the content match bid amount for the keyword. |
| Custom parameters | Refers to the custom parameters of the keyword. |
| Editorial status | Refers to the editorial status of the keyword. If the keyword is pending offline editorial review, then within a downloaded change history report the editorial status is represented as either Pending - Active or Pending - Inactive. For more information, see Entities and Delivery Status. |
| Exact match bid | Refers to the exact match bid amount for the keyword. |
| Final URL | Refers to the Final URL of the keyword. |
| Mobile URL | Refers to the Final Mobile URL of the keyword. |
| Match type | Refers to the bid match type for the keyword. The bid match type cannot be updated using Bing Ads API; however, it is possible to change the bid match type using the Microsoft Advertising web application. |
| Phrase match bid | Refers to the phrase match bid amount for the keyword. |
| Status | Refers to the delivery status of the keyword. If reporting a deleted keyword, the ItemChanged field is Status, the HowChanged field is Changed, and the NewValue field is Deleted. |
| Tracking template | Refers to the tracking template of the keyword. |
Location extension
When the ItemChanged field's value is Location extension, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| Association | Refers to the association of a location extension with an entity. For example if the extension is associated with a campaign, CampaignName field's value is the name of the associated campaign, the ItemChanged field's value is Location extension, the AttributeChanged field's value is Association, and the HowChanged field's value is Added. |
Negative Keyword List
When the ItemChanged field's value is Negative Keyword List, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| Association | Refers to the association of a Negative Keyword List with a campaign. For example if the negative keyword list is associated with a campaign, CampaignName field's value is the name of the associated campaign, the ItemChanged field's value is Negative Keyword List, the AttributeChanged field's value is Association, and the HowChanged field's value is Added. |
| Negative keyword | Refers to the negative keyword that was added or removed from the negative keyword list. |
| Negative Keyword List Name | Refers to the name of the negative keyword list. |
Sitelink extension
When the ItemChanged field's value is Sitelink extension, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| Association | Refers to the association of a sitelink extension with an entity. For example if the extension is associated with a campaign, CampaignName field's value is the name of the associated campaign, the ItemChanged field's value is Sitelink extension, the AttributeChanged field's value is Association, and the HowChanged field's value is Added. |
| Custom parameters | Refers to the custom parameters of a sitelink. |
| Destination URL | Refers to the destination URL of the sitelink extension. |
| Display Text | Refers to the display text of the sitelink extension. |
| Final URL | Refers to the Final URL of a sitelink. |
| Mobile URL | Refers to the Final Mobile URL of a sitelink. |
| Tracking template | Refers to the tracking template of a sitelink. |
User
When the ItemChanged field's value is User, change history for the following attributes are available.
| Attribute Changed | Description |
|---|---|
| None (blank) | Refers to the user name of the user that was added. The value of the corresponding HowChanged field is Added. |
| Code | For internal use. |
| Refers to the contact email address of the user. | |
| First name | Refers to the first name of the user. |
| Last name | Refers to the last name of the user. |
| Status | Refers to the status of the user. |
Requirements
Service: ReportingService.svc v13
Namespace: https://bingads.microsoft.com/Reporting/v13