Hi,
Please suggest the quick way to process Google Ads Big Data. Using Google
Ads API with gzip compression data format is implemented.
Case Study 1:
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?
Case Study 2:
Actually the solution for case study 1 comes in my mind there should be an
option to apply regular expressions to filer data and get only total row
(one row).
If we get bulk rows then we have to filter rows by sending keyword IDs in
where clause, there is also a limit of 10000 keywords in where clause in
operator. Some metrics possible to total manually like impressions, clicks
etc. But %age metrics like Impression Share, EMIS etc not match correctly
with Google Ads GUI. So to match these values we have to get Total column
from Google Ads.
I hope can elaborate my problem well. Please suggest me.
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/1f9bb900-8e70-44da-9dbb-27842b04347d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
