ConversionPerformanceReportColumn Value Set
Defines the data columns that you can include in a conversion performance report.
<xs:simpleType name="ConversionPerformanceReportColumn"> <xs:restriction base="xs:string"> <xs:enumeration value="AccountName" /> <xs:enumeration value="AccountNumber" /> <xs:enumeration value="AccountId" /> <xs:enumeration value="TimePeriod" /> <xs:enumeration value="CampaignName" /> <xs:enumeration value="CampaignId" /> <xs:enumeration value="AdGroupName" /> <xs:enumeration value="AdGroupId" /> <xs:enumeration value="Keyword" /> <xs:enumeration value="KeywordId" /> <xs:enumeration value="Impressions" /> <xs:enumeration value="Clicks" /> <xs:enumeration value="Ctr" /> <xs:enumeration value="Assists" /> <xs:enumeration value="Conversions" /> <xs:enumeration value="ConversionRate" /> <xs:enumeration value="Spend" /> <xs:enumeration value="ExtendedCost" /> <xs:enumeration value="Revenue" /> <xs:enumeration value="ReturnOnAdSpend" /> <xs:enumeration value="CostPerConversion" /> <xs:enumeration value="CostPerAssist" /> <xs:enumeration value="RevenuePerConversion" /> <xs:enumeration value="RevenuePerAssist" /> <xs:enumeration value="DeviceType" /> </xs:restriction> </xs:simpleType>
Values
Value | Description | ||
|---|---|---|---|
AccountId | The report will include a column that contains the account identifier. | ||
AccountName | The report will include a column that contains the account name. | ||
AccountNumber | The report will include a column that contains the account number. | ||
AdGroupId | The report will include a column that contains the ad group identifier. | ||
AdGroupName | The report will include a column that contains the ad group name. | ||
Assists | The report will include a column that contains the number of times an entity (for example, an account, campaign, or ad group) contributed to the conversion on another entity. | ||
CampaignId | The report will include a column that contains the campaign identifier. | ||
CampaignName | The report will include a column that contains the campaign name. | ||
Clicks | The report will include a column that contains the number of times that the ad was clicked. | ||
ConversionRate | The report will include a column that contains the conversion rate as a percentage. The formula for calculating the conversion rate is (conversions / clicks) * 100. | ||
Conversions | The report will include a column that contains the number of conversions. | ||
CostPerAssist | The report will include a column that contains the cost per assist. The formula for calculating the cost per assist is (spend / assists). | ||
CostPerConversion | The report will include a column that contains the cost per conversion. The formula for calculating the cost per conversion is (spend / conversions). | ||
Ctr | The report will include a column that contains the click-through rate. The formula for calculating the click-through rate is (clicks / impressions) * 100. | ||
DeviceType | The report will include a column that contains the type of device on which the ad appeared. For a list of possible values, see DeviceTypeReportFilter. | ||
ExtendedCost | The report will include a column that contains the non-advertising cost (for example, tax and shipping) reported by the advertiser for conversion. | ||
Impressions | The report will include a column that contains the number of times that the ad was displayed on the Bing Ads results page. | ||
Keyword | The report will include a column that contains the keyword that matched the user’s search query. | ||
KeywordId | The report will include a column that contains the keyword identifier. | ||
ReturnOnAdSpend | The report will include a column that contains the return on ad spend (ROAS). The formula for calculating the ROAS is (revenue / spend). | ||
Revenue | The report will include a column that contains the revenue reported by the advertiser from conversions. | ||
RevenuePerAssist | The report will include a column that contains the revenue per assist. The formula for calculating the revenue per assist is (revenue / assists). | ||
RevenuePerConversion | The report will include a column that contains the revenue per conversion. The formula for calculating the revenue per conversion is (revenue / conversions). | ||
Spend | The report will include a column that contains the total spend on the ads for the specified time period. | ||
TimePeriod | The report will include a column that contains the time period of each report row.
|
Required Columns
The report must include the following columns.
Column | ||
|---|---|---|
TimePeriod
|
The report must include one or more of the following columns.
Column |
|---|
Assists |
Conversions |
Clicks |
Ctr |
Impressions |
Revenue |
Spend |
Optional Columns
The following columns are optional.
Column | ||
|---|---|---|
AccountId | ||
AccountNumber | ||
AdGroupId | ||
CampaignId | ||
ConversionRate | ||
CostPerAssist | ||
CostPerConversion | ||
ExtendedCost | ||
Keyword | ||
KeywordId | ||
ReturnOnAdSpend | ||
RevenuePerAssist | ||
RevenuePerConversion | ||
TimePeriod
|
Time-Period Columns
If you include the TimePeriod column, the column label that the report uses depends on the aggregation level that you specify in the report request. For example, if the aggregation level is Daily, the report uses GregorianDate as the column label. The following are the column labels that the report uses based on the specified aggregation level.
Time-Period Column Label | Aggregation | Description |
|---|---|---|
GregorianDate | Daily | Each row of the report identifies the month, day, and year when the transaction occurred. |
MonthStartDate | Monthly | Each row of the report identifies the month when the transaction occurred |
WeekStartDate | Weekly | Each row of the report identifies the week when the transaction occurred. The date value is for the Monday of the week being reported. |
Year | Yearly | Each row of the report identifies the year when the transaction occurred. |
How the value of the statistic columns, such as clicks and impressions, are reflected in the report depends on the group columns that you include in the report and the type of aggregation that you specify. For more information, see Columns that Group the Data.
