You will need one report. I am pretty sure one report should be enough to get all records.
Did you try this? I looked in my logs this morning, and saw that the software downloaded a keyword report with 750,000+ records. Its format was XML_GZIP, 26 MB. Downloading (the time between the request and the last byte received, storing in a memory buffer) took 24 seconds. Note: that particular report was a keyword structure report - it had much more columns then you need, but impressions were not among them. Anyway, just try. If you get timeouts, you may want to look at your internet connection. Or consider moving your software in the cloud. If you tried but didn't get timeouts, what is the exact problem? On Wednesday, March 20, 2019 at 12:08:15 PM UTC+1, Qaiser Javed wrote: > > Hi, > > Please suggest the quick way to process Google Ads Big Data. > > Case Study: > > Let's suppose there is an account having 1000 campaigns and 1 million > keywords. > > I want to get account level insight that how many impressions are there > for keyword tail length like 1 word keyword, 2 word keyword up to 5 word > keyword. For example: > > 1 Word Keywords = xxxxx impressions > 2 Words Keywords = xxxxx impressions > . > . > 5+ Words Keywords = xxxxx impressions > > For this type of analysis I have to get 1 million keywords in my local > database then process locally and make required result. > > But this is very expensive call to get 1 million keywords. > > What you suggest what is best practice? > OR > Can I process this huge dataset on Google Ads platform and get only > required row? > > Regards, > Qaiser > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/b3ffaeaa-91f1-47a6-ad5f-694677cc0993%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
