Hello Xiaoming,

As suggested here, we switched to Google Ads API and performance is still 
bad. It took more than 3 hours to download RSA from 3 campaigns. This seems 
too slow. 

Here is the query which you can try out. Please let us know if any 
optimization we can do from our side. Thanks !

Downloading via delegate: SELECT ad_group_ad.ad.final_urls, 
ad_group_ad.ad.final_mobile_urls, ad_group_ad.ad.id, 
ad_group_ad.ad.responsive_search_ad.descriptions, 
ad_group_ad.ad.responsive_search_ad.headlines, 
ad_group_ad.ad.responsive_search_ad.path1, 
ad_group_ad.ad.responsive_search_ad.path2, 
ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.url_custom_parameters, 
ad_group_ad.ad.final_url_suffix, ad_group_ad.status, ad_group.id, 
ad_group.name, campaign.name
FROM ad_group_ad
WHERE campaign.id IN (88845851, 105682211, 105682451)
AND ad_group_ad.ad.type = 'RESPONSIVE_SEARCH_AD'
AND ad_group.status != 'REMOVED'
AND ad_group_ad.status != 'REMOVED'
ORDER BY ad_group_ad.ad.id ASC

Caihua.
On Tuesday, April 6, 2021 at 11:44:44 AM UTC-7 adsapiforumadvisor wrote:

> Hi Binbin,
>
> Thank you for reaching out. Please give it a try to query the ad_group_ad 
> <https://developers.google.com/google-ads/api/fields/v6/ad_group_ad> 
> resource via the Google Ads API instead.
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>  
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2EqJ7A:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/847b3583-38d2-455d-95ca-d8f078d18168n%40googlegroups.com.

Reply via email to