Age_Performance_Report strange results

[Justin Coon]

Hi

I'm witnessing some odd behavior that I cant explain with AGE_PERFORMANCE_REPORT. The only campaign/AdGroups returning results are CPM, the other campaigns/AdGroups under the same account aren't returning any results. However under the AdWords UI I can see results, so something is off. Is there explanation for this behavior? Something I'm doing incorrect how I'm structuring the report definition? I'm seeing the same behavior with the GENDER_PERFORMANCE_REPORT, just FYI.

Thanks
Justin

[Josh Radcliff (AdWords API Team)]

Hi Justin,

I just ran the AGE_RANGE_PERFORMANCE_REPORT on your account and the month of December 2014, and I get back non-zero results for multiple ad group IDs.

13922813482

13922815042

14213257042

17152499002

Could you send over the complete report request (with any sensitive information removed) so I can compare it to what I'm running?

Thanks,

Josh, AdWords API Team

[Justin Coon]

Hi Josh,

Here's the report definition XML

<?xml version="1.0" encoding="utf-8"?>

<reportDefinition xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <selector xmlns="https://adwords.google.com/api/adwords/cm/v201406">

    <fields>AdGroupId</fields>

    <fields>Criteria</fields>

    <fields>Cost</fields>

    <fields>Clicks</fields>

    <fields>Impressions</fields>

    <fields>Ctr</fields>

    <predicates>

      <field>Status</field>

      <operator>IN</operator>

      <values>ENABLED</values>

      <values>PAUSED</values>

    </predicates>

    <predicates>

      <field>AdGroupId</field>

      <operator>IN</operator>

      <values>13922813482</values>

      <values>13922815042</values>

      <values>14213257042</values>

      <values>17152499002</values>

    </predicates>

  </selector>

  <reportName xmlns="https://adwords.google.com/api/adwords/cm/v201406">AGE_RANGE_PERFORMANCE_REPORT</reportName>

  <reportType xmlns="https://adwords.google.com/api/adwords/cm/v201406">AGE_RANGE_PERFORMANCE_REPORT</reportType>

  <dateRangeType xmlns="https://adwords.google.com/api/adwords/cm/v201406">THIS_MONTH</dateRangeType>

  <downloadFormat xmlns="https://adwords.google.com/api/adwords/cm/v201406">GZIPPED_XML</downloadFormat>

  <includeZeroImpressions xmlns="https://adwords.google.com/api/adwords/cm/v201406">true</includeZeroImpressions>

</reportDefinition>

[Justin Coon]

Here is the results I get - not what I expect compared to what AdWords UI shows

<report>

  <report-name name="AGE_RANGE_PERFORMANCE_REPORT" />

  <date-range date="Jan 1, 2015-Jan 2, 2015" />

  <table>

    <columns>

      <column name="adGroupID" display="Ad group ID" />

      <column name="ageRange" display="Age Range" />

      <column name="cost" display="Cost" />

      <column name="clicks" display="Clicks" />

      <column name="impressions" display="Impressions" />

      <column name="ctr" display="CTR" />

    </columns>

    <row adGroupID="14213257042" ageRange="18-24" cost="351030" clicks="0" impressions="1203" ctr="0.00%" />

    <row adGroupID="14213257042" ageRange="25-34" cost="234830" clicks="1" impressions="800" ctr="0.12%" />

    <row adGroupID="14213257042" ageRange="35-44" cost="166410" clicks="0" impressions="576" ctr="0.00%" />

    <row adGroupID="14213257042" ageRange="45-54" cost="117070" clicks="0" impressions="393" ctr="0.00%" />

    <row adGroupID="14213257042" ageRange="Undetermined" cost="461130" clicks="0" impressions="1564" ctr="0.00%" />

    <row adGroupID="13922813482" ageRange="65 or more" cost="0" clicks="0" impressions="0" ctr="0.00%" />

    <row adGroupID="14213257042" ageRange="55-64" cost="0" clicks="0" impressions="0" ctr="0.00%" />

    <row adGroupID="13922813482" ageRange="55-64" cost="0" clicks="0" impressions="0" ctr="0.00%" />

    <row adGroupID="14213257042" ageRange="65 or more" cost="0" clicks="0" impressions="0" ctr="0.00%" />

  </table>

</report>

[Josh Radcliff (AdWords API Team)]

Hi Justin,

If you remove the predicate on the Status field, you'll see that several of the age ranges have status REMOVED. For example, on the campaign named CPC - Display, the age ranges 55-64 and 65 or more have been removed. You can see this in the UI if you change the selection at the top from All eligible ages to All ages.

Cheers,

Josh, AdWords API Team

[Justin Coon]

Hi Josh

That worked! My report result set matches what I see in the AdWords UI - however I think I'm now eve more confused. I am asking the API for only active/paused Status, and there are no impressions/metrics on the "removed" ones, so why are the active ones filtered from the result set? Seems unintuitive to me, unless I am doing something wrong, or am misunderstanding

Thanks

Justin

[Josh Radcliff (AdWords API Team)]

Hi Justin,

I agree - the Status column doesn't seem to be working correctly, or at least it isn't consistent with the UI. I'm following up with the reporting team and will post back once I hear from them.

In the meantime, I'd recommend not filtering by Status to ensure you get back all relevant rows.

Cheers,

Josh, AdWords API Team