Export (0) Print
Expand All

MetroAreaDemographicReportColumn Value Set

Defines the data columns that you can include in a metropolitan-area demographic report.


<xs:simpleType name="MetroAreaDemographicReportColumn">
  <xs:restriction base="xs:string">
    <xs:enumeration value="AccountName"/>
    <xs:enumeration value="AccountNumber"/>
    <xs:enumeration value="TimePeriod"/>
    <xs:enumeration value="CampaignName"/>
    <xs:enumeration value="AdGroupName"/>
    <xs:enumeration value="Country"/>
    <xs:enumeration value="State"/>
    <xs:enumeration value="MetroArea"/>
    <xs:enumeration value="CurrencyCode"/>
    <xs:enumeration value="AdDistribution"/>
    <xs:enumeration value="Impressions"/>
    <xs:enumeration value="Clicks"/>
    <xs:enumeration value="Ctr"/>
    <xs:enumeration value="AverageCpc"/>
    <xs:enumeration value="Spend"/>
    <xs:enumeration value="AveragePosition"/>
    <xs:enumeration value="AverageCpm"/>
    <xs:enumeration value="ProximityTargetLocation" />
    <xs:enumeration value="Radius" />
    <xs:enumeration value="Language"/>
    <xs:enumeration value="City"/>
    <xs:enumeration value="QueryIntentCountry"/>
    <xs:enumeration value="QueryIntentState"/>
    <xs:enumeration value="QueryIntentCity"/>
    <xs:enumeration value="QueryIntentDMA"/>
  </xs:restriction>
</xs:simpleType>

Values

Value

Description

AccountName

The report will include a column that contains the account name.

AccountNumber

The report will include a column that contains the account number.

AdDistribution

The report will include a column that contains the ad distribution medium. For possible values, see the AdDistributionReportFilter value set.

AdGroupName

The report will include a column that contains the name of the ad group.

AverageCpc

The report will include a column that contains the average cost per click (CPC). The formula for calculating the average CPC is (cost of clicks / clicks).

AverageCpm

The report will include a column that contains the average of the cost per thousand impressions (CPM) of the ad.

The value will be 0 (zero) if the ad group to which the ad belongs does not specify the Content ad distribution medium or if the user does not belong to the CPM pilot program.

AveragePosition

The report will include a column that contains the average position of the ad on the Bing Ads results page.

CampaignName

The report will include a column that contains the campaign name.

City

Not supported. The report will include a column that contains the city where the user who clicked the ad is located.

Clicks

The report will include a column that contains the number of times that the ad was clicked.

Country

The report will include a column that contains the country where the user that clicked the ad is located.

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.

CurrencyCode

The report will include a column that contains the currency used by the account to which the ad belongs. For possible values, see Currencies.

Impressions

The report will include a column that contains the number of times that the ad was displayed on the Bing Ads results page.

Language

The report will include a column that contains the language used by the website that displayed the ad.

MetroArea

The report will include a column that contains the metropolitan area where the user who clicked the ad is located.

ProximityTargetLocation

The report will include a column that contains the address or name of a landmark if radius targeting is specified.

QueryIntentCity

Not supported. The report will include a column that contains the name of a city if the user’s geographical intent can be determined. The city is set if the user’s intent is a city. For example, the user’s search query was rental cars in Portland.

QueryIntentCountry

The report will include a column that contains the name of a country if the user’s geographical intent can be determined. The country is set if the user’s intent is a country or sub geography of the country.

QueryIntentDMA

The report will include a column that contains the name of a metro area if the user’s geographical intent can be determined. The metro area is set if the user’s intent is a metro area or city within the metro area.

QueryIntentState

The report will include a column that contains the name of a state if the user’s geographical intent can be determined. The state is set if the user’s intent is a state or sub geography of the state.

Radius

The report will include a column that contains the radius, in miles, of the target area surrounding the business or landmark specified in the ProximityTargetLocation column.

Spend

The report will include a column that contains the total spend on the ad for the specified time period.

State

The report will include a column that contains the state where the user who clicked the ad is located.

TimePeriod

The report will include a column that contains the time period of each report row.

System_CLiX_noteNote

You cannot include this column if the Aggregation field of the MetroAreaDemographicReportRequest object is set to Summary.

Required Columns

The following columns are required (you must include these columns in your metropolitan area demographics report request).

Column

AccountName

AdGroupName

TimePeriod

System_CLiX_noteNote

This column is required for all aggregation types except Summary. If you specify Summary aggregation, you must not include this column; however, you must include at least one column from the list of optional columns.

The report must include one or more of the following columns.

Column

AverageCpc

AveragePosition

Clicks

Ctr

Impressions

Spend

Optional Columns

The following columns are optional.

Column

AccountNumber

AdDistribution

AverageCpm

CampaignName

City

Country

CurrencyCode

Language

MetroArea

ProximityTargetLocation

QueryIntentCity

QueryIntentCountry

QueryIntentDMA

QueryIntentState

Radius

State

TimePeriod

System_CLiX_noteNote

This column is optional only if you specify Summary aggregation; otherwise, it is required.

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 will identify the month, day, and year when the transaction occurred.

MonthStartDate

Monthly

Each row of the report will identify the month when the transaction occurred.

WeekStartDate

Weekly

Each row of the report will identify the week when the transaction occurred. The date value represents the Monday of the week being reported.

Year

Yearly

Each row of the report will identify 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.

Requirements

ReportingService.svc v9

Namespace: https://bingads.microsoft.com/Reporting/v9

Community Additions

Show:
© 2014 Microsoft