Hello Qaiser,
Could you please confirm if you are testing using the AdWords API or the
Google Ads API? If you are using AdWords API, you could run the report with
just the keyword and impression metrics by avoiding the segment fields.
This will help in reducing the size of the downloaded file. There is no
explicit limit to the rows the API can extract in one go. But if the report
is too big, the API may timeout
<https://developers.google.com/adwords/api/docs/guides/reporting#timeouts>.
In such cases, you may need to group your campaigns to limit the number of
keywords in one report call. Additionally you can try to use the gzip
compressed
<https://developers.google.com/adwords/api/docs/guides/reporting#supported_download_formats>
report data formats as well. One option maybe to use the labels
<https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#labels>
when you create the keyword to group them as 1 word keyword, 2 word keyword
etc. In your report, you could filter based on the labels instead of
campaigns.
If you are using Google Ads API, you should ideally be able to extract
bigger data-set without issues. It would still be recommended to use only
the required attributes and metrics in your call.
Thanks,
Sreelakshmi, Google Ads API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
On 03/20/19 07:08:15 [email protected] 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/8258cf54-b28c-487f-87f2-5e3a55d760e3%40googlegroups.com
<https://groups.google.com/d/msgid/adwords-api/8258cf54-b28c-487f-87f2-5e3a55d760e3%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/ijlio1gj0o0000018nvi4q000mkv1uz6kmj6d9m6so30c1g68qj6d1g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
