RelativeCTR not available in Account Performance reports?

[Zweitze]

Well, the subject says it all: the adhoc report ACCOUNT_PERFORMANCE_REPORT lacks a column RelativeCTR.
This information is available in the web interface, can it be added to the Account Performance report?

I think this information can be derived from a campaign report, using the following SQL-ish expression:
SUM(RelativeCTR * Impressions) / SUM(Impressions)
Any comment on that?

Thanks in advance!

[Zweitze]

I tried it anyway and got ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT

This is the request XML:

<reportDefinition>
  <selector xmlns="https://adwords.google.com/api/adwords/cm/v201209">
    <fields>Month</fields>
    <fields>AdNetworkType1</fields>
    <fields>AveragePosition</fields>
    <fields>Clicks</fields>
    <fields>Cost</fields>
    <fields>Impressions</fields>
    <fields>ContentBudgetLostImpressionShare</fields>
    <fields>ContentImpressionShare</fields>
    <fields>ContentRankLostImpressionShare</fields>
    <fields>SearchBudgetLostImpressionShare</fields>
    <fields>SearchExactMatchImpressionShare</fields>
    <fields>SearchImpressionShare</fields>
    <fields>SearchRankLostImpressionShare</fields>
    <fields>RelativeCtr</fields>
    <dateRange>
      <min>20121001</min>
      <max>20130313</max>
    </dateRange>
  </selector>
  <reportName xmlns="https://adwords.google.com/api/adwords/cm/v201209">AccountImpressionShare_20121001_20130313</reportName>
  <reportType xmlns="https://adwords.google.com/api/adwords/cm/v201209">ACCOUNT_PERFORMANCE_REPORT</reportType>
  <dateRangeType xmlns="https://adwords.google.com/api/adwords/cm/v201209">CUSTOM_DATE</dateRangeType>
  <downloadFormat xmlns="https://adwords.google.com/api/adwords/cm/v201209">GZIPPED_XML</downloadFormat>
  <includeZeroImpressions xmlns="https://adwords.google.com/api/adwords/cm/v201209">false</includeZeroImpressions>
</reportDefinition>

The response:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<reportDownloadError>
  <ApiError>
    <type>ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT</type>
    <trigger>
    </trigger>
    <fieldPath>RelativeCtr</fieldPath>
  </ApiError>
</reportDownloadError>

Thanks in advance!

[Paul Matthews (AdWords API Team)]

Hi Zweitze,

I can confirm that it does not exist in that report. I'm looking into the for working out the RelativeCTR for a given account and will get back to you as soon as I have more information.

Regards,

- Paul, AdWords API Team.

[Zweitze]

It's been well over a year. Any updates?

Thanks!

[Zweitze]

It's three years now... Any updates?

[Anthony Madrigal]

Hi,

Unfortunately, this field is still not available in the Account Performance Report.

Please follow our blog in case there are any updates.

Regards,

Anthony

AdWords API Team

[Zweitze]

We're close to it's first lustrum (five year celebration)... Any updates?
Has anyone found a way to derive an account-level RelativeCtr from its campaign-level RelativeCtrs?

Thanks in advance!

[Sreelakshmi Sasidharan (AdWords API Team)]

Hi Zweitze, 

The RelativeCtr is still available only at Campaign and AdGroup level. You could also post this on the advertisers community forum to see if there is a means to derive this value at the account level. 

Thanks,
Sreelakshmi, AdWords API Team