Export (0) Print
Expand All

SegmentationReportColumn Value Set

Defines the data columns that you can include in a segmentation report.

<xs:simpleType name="SegmentationReportColumn">
  <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="Goal" />
    <xs:enumeration value="AgeGroup" />
    <xs:enumeration value="Gender" />
    <xs:enumeration value="Country" />
    <xs:enumeration value="State" />
    <xs:enumeration value="MetroArea" />
    <xs:enumeration value="Step1Count" />
    <xs:enumeration value="Step2Count" />
    <xs:enumeration value="Step3Count" />
    <xs:enumeration value="Step4Count" />
    <xs:enumeration value="Step5Count" />
    <xs:enumeration value="Conversions" />
    <xs:enumeration value="Assists" />
    <xs:enumeration value="Spend" />
    <xs:enumeration value="FunnelConversionRate" />
    <xs:enumeration value="Revenue" />
    <xs:enumeration value="ReturnOnAdSpend" />
  </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.

AgeGroup

The report will include a column that contains the age group of the users who clicked an ad in the ad group. For possible values, see the AgeGroupReportFilter value set.

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.

Conversions

The report will include a column that contains the number of conversions for this goal. A conversion is considered step 6 of the funnel.

Country

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

FunnelConversionRate

Include a column in the report that contains the funnel conversion rate. The formula for calculating the conversion rate is (conversions / number of times that the user entered step 1 of the funnel) * 100.

Gender

The report will include a column that contains the gender of users who clicked an ad in the ad group. For possible values, see the GenderReportFilter value set.

Goal

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

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.

MetroArea

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

ReturnOnAdSpend

The report will include a column that contains the return on ad spend (ROAS). The formula for calculating the ROAS is (revenue that the ad generates / spend).

Revenue

The report will include a column that contains the revenue reported by the advertiser from conversions.

Spend

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

State

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

Step1Count

The report will include a column that contains the number of times that a user entered step 1 of the funnel.

Step2Count

The report will include a column that contains the number of times that a user entered step 2 of the funnel.

Step3Count

The report will include a column that contains the number of times that a user entered step 3 of the funnel.

Step4Count

The report will include a column that contains the number of times that a user entered step 4 of the funnel.

Step5Count

The report will include a column that contains the number of times that a user entered step 5 of the funnel.

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 element of the SegmentationReportRequest object is set to Summary.

Required Columns

The report must include the following column.

Column

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 key performance index (KPI) columns.

Column

Assists

Conversions

Revenue

Spend

Optional Columns

The following columns are optional.

Column

AccountId

AccountName

AccountNumber

AdGroupId

AdGroupName

AgeGroup

CampaignId

CampaignName

Country

FunnelConversionRate

Gender

Goal

Keyword

KeywordId

MetroArea

ReturnOnAdSpend

Step1Count

Step2Count

Step3Count

Step4Count

Step5Count

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 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 assists and conversions, 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 v8

Namespace: https://adcenter.microsoft.com/v8

Community Additions

Show:
© 2014 Microsoft