Gender and Age Range Performance Reports are very slow

[theadsguy]

Hi,

I'm noticing that for some reason, gender and age range performance reports are very slow. I'm using the Python API to fetch reports for 30 days. Campaign performance report is a lot faster. Here are some times I profiled:

Time for campaign performance report: 5.35 secs
Time for gender performance report: 27.56 secs
Time for age range performance report: 67.18 secs

Is there a reason for this? And how can I speed them up?

Here are the queries for each:

1) Campaign performance:

SELECT CampaignId, CampaignName, Device, Date, CampaignStatus, Clicks, Impressions, Conversions, ConversionValue, Cost, ConversionRate, CostPerConversion FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignStatus IN ["ENABLED", "PAUSED"] AND CampaignId IN [<list_of_ids>] DURING 20200901,20200930

2) Gender performance:

SELECT Date, Criteria, Clicks, Impressions, Conversions FROM GENDER_PERFORMANCE_REPORT WHERE CampaignStatus IN ["ENABLED", "PAUSED"] AND CampaignId IN [<list_of_ids>] DURING 20200901,20200930

3) Age range performance:

SELECT CampaignId, Date, Criteria, Clicks, Impressions, Conversions FROM AGE_RANGE_PERFORMANCE_REPORT WHERE CampaignStatus IN ["ENABLED", "PAUSED"] AND CampaignId IN [<list_of_ids>] DURING 20200901,20200930

Any help would be greatly appreciated.

Thanks!

[theadsguy]

And for all of these, this is how I'm getting the report stream:

client = adwords.AdWordsClient.LoadFromString(yaml_config_string)

stream = client.GetReportDownloader(version='v201809').DownloadReportAsStreamWithAwql(report_query, 'CSV', skip_report_header=True, skip_column_header=True, skip_report_summary=True, include_zero_impressions=True, use_raw_enum_values=True)

while True:
     line = stream.readline()

     if not line: break

    <more_processing>

[Google Ads API Forum Advisor Prod]

Hello,

Thank you for your patience on this inquiry. Can you please provide us with the full request and response logs associated with each of these queries? Also, can you please confirm if this discrepancy happens on a consistent basis?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q269osO:ref

[theadsguy]

Yes, it's consistently higher. I also counted the number of lines my report aggregator is reading from each of the streams, and for some reason the number of lines for gender and age range are MANY times higher:

    campaign performance lines: 3680
Time for campaign performance report aggregation: 2.1
    gender performance lines: 64032
Time for gender performance report aggregation: 4.41
    age range performance lines: 149408
Time for age range performance report aggregation: 9.23

I kind of understand that age range is about 2x gender lines, because the number of criteria in age range enum is about 2x that of gender's enum. But why is campaign performance report so short while the others so much larger? Device enum values are roughly the same number as age range, so I'd expect roughly the same number of lines.

NOTE: I removed the CampaignId grouping from AgeRange report since I didn't need that, so it brought down the time a lot, but still confusingly high.

How do I provide the request/response logs from a Python script? It's a stream HTTPResponseObject and there's no way to serialize it. And I've already provided the report query for the request side of things.

Let me know how else I can help in debugging this.

[Google Ads API Forum Advisor Prod]

Hello,

Could you click Reply Privately to Author and send me either campaign IDs that you are using or the customer ID of the Google Ads account? It would help us to double-check if there is something unique about your account that could affect the numbers.

Thanks,
Nadine Wang, Google Ads API Team 

ref:_00D1U1174p._5004Q269osO:ref

[theadsguy]

It says I don't have permission to reply to author in this group. Is there any other way to give you the ids and customer id?

[Google Ads API Forum Advisor Prod]

Hi,

Since you are unable to respond privately, could you instead send all the relevant details (campaignIDs, and customer IDs) directly to our alias googleadsa...@google.com? This is so we can continue the discussion of your issue privately.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q269osO:ref