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>
On Friday, October 16, 2020 at 9:50:04 AM UTC-4 theadsguy wrote:
>
> 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/5384c61d-adb6-430e-809c-2c09c7d8e527n%40googlegroups.com.
