Need to fetch summary row for huge data in Google Ads?
Qaiser Javed
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
Google Ads API Forum Advisor Prod
Hi Qaiser,
Thank you for reaching out. For both case studies, we do not recommend fetching huge amounts of data. Fetching huge amount of data in the API would lead to timeout errors. To prevent this, our recommendation is that you breakdown the report by using filters. Based on the number of records you described, it is most likely that you may run into operational limits due to generating too many reports (1,000 reports per day limit). If you think you will hit the operation limit for basic access, you can apply for standard access so that you would have unlimited operation limit.
Let me know if this helps.
Regards,
Dave
Google Ads API Team
ref:_00D1U1174p._5001UApuo8:ref
Qaiser Javed
Google Ads API Forum Advisor Prod
Hi Qaiser,
There isn't currently a feature that gets the keyword tail length. However, you may use this guide for your reference for all the fields that you could use for filtering keywords that is currently available in Google Ads API.
Here is an example of GAQL query with date filter:
SELECT metrics.impressions, segments.date FROM keyword_view WHERE segments.date BETWEEN '2019-01-01' AND '2019-01-31'
Regards,
Dave
Google Ads API Team
ref:_00D1U1174p._5001UApuo8:ref