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! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/71320015-45e1-43fa-93c8-3b5347fa5b4an%40googlegroups.com.
