Test script - for "could not read from google ads" error

[Mike Rhodes]

Google Ads Scripts FAILING?

It seems like lots of people are affected by this today... 
If you'd like to test your account, run this little test script I just wrote.
It tries to run various queries, just to see which 'resources' are failing & which are ok.

I’m seeing intermittent fails - not always the same queries falling over (which is harder for Google to fix)... But mostly it’s the assetGroupQuery & changeQuery that are failing.
**What are you seeing?**

Free Test Script:
https://gist.github.com/mikerhodesideas/d1713f45eec33cbf6977ba8eab3ce972

Note this is causing my main PMax script to fail.
You'll see a "Ba: Could not read from Google Ads" error in your pmax script logs.

[Nils Rooijmans]

8/2/2024 10:15:42 AM
--- Testing API v15 ---
8/2/2024 10:15:42 AM
Trying query: SELECT campaign.name, asset_group.name, asset_group.id, asset.resource_name, asset_group_asset.field_type, campaign.id, asset_group_asset.performance_label FROM asset_group_asset WHERE asset_group_asset.field_type NOT IN ("LOGO", "LANDSCAPE_LOGO", "BUSINESS_NAME", "LONG_HEADLINE", "CALL_TO_ACTION_SELECTION") AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX")
8/2/2024 10:15:42 AM
assetGroupAssetQuery: Success
8/2/2024 10:15:42 AM
Trying query: SELECT segments.date, campaign.name, segments.asset_interaction_target.asset, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.video_views, metrics.average_cpv, metrics.impressions, metrics.clicks, campaign.advertising_channel_type, segments.asset_interaction_target.interaction_on_this_asset, campaign.id FROM campaign WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") AND segments.asset_interaction_target.interaction_on_this_asset != "TRUE" ORDER BY campaign.name
8/2/2024 10:15:43 AM
displayVideoQuery: Success
8/2/2024 10:15:43 AM
Trying query: SELECT segments.date, campaign.name, asset_group.name, asset_group.ad_strength, asset_group.status, asset_group_listing_group_filter.type, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM asset_group_product_group_view WHERE segments.date = "2024-08-01" AND asset_group_listing_group_filter.type != "SUBDIVISION"
8/2/2024 10:15:44 AM
assetGroupQuery: Fail
8/2/2024 10:15:44 AM
Trying query: SELECT segments.date, campaign.name, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.video_views, metrics.average_cpv, metrics.impressions, metrics.clicks, campaign.advertising_channel_type, campaign.id FROM campaign WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") ORDER BY campaign.name
8/2/2024 10:15:45 AM
campaignQuery: Success
8/2/2024 10:15:45 AM
Trying query: SELECT asset.resource_name, asset.source, asset.youtube_video_asset.youtube_video_title, asset.youtube_video_asset.youtube_video_id, asset.name, asset.image_asset.full_size.url, asset.text_asset.text, asset.image_asset.full_size.height_pixels, asset.image_asset.full_size.width_pixels, asset.image_asset.mime_type FROM asset
8/2/2024 10:15:45 AM
assetQuery: Success
8/2/2024 10:15:45 AM
Trying query: SELECT campaign.name, asset_group.name, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.impressions, metrics.clicks, asset_group.primary_status, asset_group.status FROM asset_group WHERE segments.date = "2024-08-01" AND metrics.impressions > 0
8/2/2024 10:15:48 AM
assetGroupMetricsQuery: Fail
8/2/2024 10:15:48 AM
Trying query: SELECT campaign.name, change_event.user_email, change_event.change_date_time, change_event.change_resource_type, change_event.changed_fields, change_event.client_type, change_event.feed, change_event.feed_item, change_event.new_resource, change_event.old_resource, change_event.resource_change_operation FROM change_event WHERE change_event.change_date_time DURING YESTERDAY AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") ORDER BY change_event.change_date_time DESC LIMIT 9999
8/2/2024 10:15:49 AM
changeQuery: Fail
8/2/2024 10:15:49 AM
Trying query: SELECT landing_page_view.unexpanded_final_url, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value, campaign.advertising_channel_type FROM landing_page_view WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type = "PERFORMANCE_MAX" ORDER BY metrics.impressions DESC
8/2/2024 10:15:49 AM
landingPageQuery: Success
8/2/2024 10:15:49 AM
Trying query: SELECT campaign.name, detail_placement_view.group_placement_target_url, detail_placement_view.placement_type, metrics.impressions, metrics.interactions, metrics.video_views, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM detail_placement_view WHERE segments.date = "2024-08-01" ORDER BY metrics.impressions DESC
8/2/2024 10:15:50 AM
placementQuery: Fail
8/2/2024 10:15:50 AM
--- Testing API v16 ---
8/2/2024 10:15:50 AM
Trying query: SELECT campaign.name, asset_group.name, asset_group.id, asset.resource_name, asset_group_asset.field_type, campaign.id, asset_group_asset.performance_label FROM asset_group_asset WHERE asset_group_asset.field_type NOT IN ("LOGO", "LANDSCAPE_LOGO", "BUSINESS_NAME", "LONG_HEADLINE", "CALL_TO_ACTION_SELECTION") AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX")
8/2/2024 10:15:50 AM
assetGroupAssetQuery: Success
8/2/2024 10:15:50 AM
Trying query: SELECT segments.date, campaign.name, segments.asset_interaction_target.asset, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.video_views, metrics.average_cpv, metrics.impressions, metrics.clicks, campaign.advertising_channel_type, segments.asset_interaction_target.interaction_on_this_asset, campaign.id FROM campaign WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") AND segments.asset_interaction_target.interaction_on_this_asset != "TRUE" ORDER BY campaign.name
8/2/2024 10:15:51 AM
displayVideoQuery: Success
8/2/2024 10:15:51 AM
Trying query: SELECT segments.date, campaign.name, asset_group.name, asset_group.ad_strength, asset_group.status, asset_group_listing_group_filter.type, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM asset_group_product_group_view WHERE segments.date = "2024-08-01" AND asset_group_listing_group_filter.type != "SUBDIVISION"
8/2/2024 10:15:52 AM
assetGroupQuery: Fail
8/2/2024 10:15:52 AM
Trying query: SELECT segments.date, campaign.name, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.video_views, metrics.average_cpv, metrics.impressions, metrics.clicks, campaign.advertising_channel_type, campaign.id FROM campaign WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") ORDER BY campaign.name
8/2/2024 10:15:52 AM
campaignQuery: Success
8/2/2024 10:15:53 AM
Trying query: SELECT asset.resource_name, asset.source, asset.youtube_video_asset.youtube_video_title, asset.youtube_video_asset.youtube_video_id, asset.name, asset.image_asset.full_size.url, asset.text_asset.text, asset.image_asset.full_size.height_pixels, asset.image_asset.full_size.width_pixels, asset.image_asset.mime_type FROM asset
8/2/2024 10:15:53 AM
assetQuery: Success
8/2/2024 10:15:53 AM
Trying query: SELECT campaign.name, asset_group.name, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.impressions, metrics.clicks, asset_group.primary_status, asset_group.status FROM asset_group WHERE segments.date = "2024-08-01" AND metrics.impressions > 0
8/2/2024 10:15:53 AM
assetGroupMetricsQuery: Success
8/2/2024 10:15:54 AM
Trying query: SELECT campaign.name, change_event.user_email, change_event.change_date_time, change_event.change_resource_type, change_event.changed_fields, change_event.client_type, change_event.feed, change_event.feed_item, change_event.new_resource, change_event.old_resource, change_event.resource_change_operation FROM change_event WHERE change_event.change_date_time DURING YESTERDAY AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") ORDER BY change_event.change_date_time DESC LIMIT 9999
8/2/2024 10:15:54 AM
changeQuery: Fail
8/2/2024 10:15:54 AM
Trying query: SELECT landing_page_view.unexpanded_final_url, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value, campaign.advertising_channel_type FROM landing_page_view WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type = "PERFORMANCE_MAX" ORDER BY metrics.impressions DESC
8/2/2024 10:15:55 AM
landingPageQuery: Success
8/2/2024 10:15:55 AM
Trying query: SELECT campaign.name, detail_placement_view.group_placement_target_url, detail_placement_view.placement_type, metrics.impressions, metrics.interactions, metrics.video_views, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM detail_placement_view WHERE segments.date = "2024-08-01" ORDER BY metrics.impressions DESC
8/2/2024 10:15:56 AM
placementQuery: Fail
8/2/2024 10:15:56 AM
--- Testing API v17 ---
8/2/2024 10:15:56 AM
Trying query: SELECT campaign.name, asset_group.name, asset_group.id, asset.resource_name, asset_group_asset.field_type, campaign.id, asset_group_asset.performance_label FROM asset_group_asset WHERE asset_group_asset.field_type NOT IN ("LOGO", "LANDSCAPE_LOGO", "BUSINESS_NAME", "LONG_HEADLINE", "CALL_TO_ACTION_SELECTION") AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX")
8/2/2024 10:15:56 AM
assetGroupAssetQuery: Success
8/2/2024 10:15:56 AM
Trying query: SELECT segments.date, campaign.name, segments.asset_interaction_target.asset, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.video_views, metrics.average_cpv, metrics.impressions, metrics.clicks, campaign.advertising_channel_type, segments.asset_interaction_target.interaction_on_this_asset, campaign.id FROM campaign WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") AND segments.asset_interaction_target.interaction_on_this_asset != "TRUE" ORDER BY campaign.name
8/2/2024 10:15:57 AM
displayVideoQuery: Success
8/2/2024 10:15:57 AM
Trying query: SELECT segments.date, campaign.name, asset_group.name, asset_group.ad_strength, asset_group.status, asset_group_listing_group_filter.type, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM asset_group_product_group_view WHERE segments.date = "2024-08-01" AND asset_group_listing_group_filter.type != "SUBDIVISION"
8/2/2024 10:15:58 AM
assetGroupQuery: Fail
8/2/2024 10:15:58 AM
Trying query: SELECT segments.date, campaign.name, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.video_views, metrics.average_cpv, metrics.impressions, metrics.clicks, campaign.advertising_channel_type, campaign.id FROM campaign WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") ORDER BY campaign.name
8/2/2024 10:15:58 AM
campaignQuery: Success
8/2/2024 10:15:58 AM
Trying query: SELECT asset.resource_name, asset.source, asset.youtube_video_asset.youtube_video_title, asset.youtube_video_asset.youtube_video_id, asset.name, asset.image_asset.full_size.url, asset.text_asset.text, asset.image_asset.full_size.height_pixels, asset.image_asset.full_size.width_pixels, asset.image_asset.mime_type FROM asset
8/2/2024 10:15:59 AM
assetQuery: Success
8/2/2024 10:15:59 AM
Trying query: SELECT campaign.name, asset_group.name, metrics.cost_micros, metrics.conversions, metrics.conversions_value, metrics.impressions, metrics.clicks, asset_group.primary_status, asset_group.status FROM asset_group WHERE segments.date = "2024-08-01" AND metrics.impressions > 0
8/2/2024 10:15:59 AM
assetGroupMetricsQuery: Success
8/2/2024 10:15:59 AM
Trying query: SELECT campaign.name, change_event.user_email, change_event.change_date_time, change_event.change_resource_type, change_event.changed_fields, change_event.client_type, change_event.feed, change_event.feed_item, change_event.new_resource, change_event.old_resource, change_event.resource_change_operation FROM change_event WHERE change_event.change_date_time DURING YESTERDAY AND campaign.advertising_channel_type IN ("SHOPPING","PERFORMANCE_MAX") ORDER BY change_event.change_date_time DESC LIMIT 9999
8/2/2024 10:16:00 AM
changeQuery: Fail
8/2/2024 10:16:00 AM
Trying query: SELECT landing_page_view.unexpanded_final_url, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value, campaign.advertising_channel_type FROM landing_page_view WHERE segments.date = "2024-08-01" AND campaign.advertising_channel_type = "PERFORMANCE_MAX" ORDER BY metrics.impressions DESC
8/2/2024 10:16:01 AM
landingPageQuery: Success
8/2/2024 10:16:01 AM
Trying query: SELECT campaign.name, detail_placement_view.group_placement_target_url, detail_placement_view.placement_type, metrics.impressions, metrics.interactions, metrics.video_views, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM detail_placement_view WHERE segments.date = "2024-08-01" ORDER BY metrics.impressions DESC
8/2/2024 10:16:01 AM
placementQuery: Fail

[Nils Rooijmans]

looks like there's an issue on Google's end,

see https://groups.google.com/g/adwords-api/c/a6VvepS3MQ0

Hope this helps,

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Mike Rhodes]

thanks mate - I'll bookmark that!
went looking for a status site & couldn't find any. I should have thought o this.
Hopefully it'll be back up soon

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/R1y8htAaqVw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/5e651482-1229-454c-a177-d45e28dc5d09n%40googlegroups.com.

[Timothy Blevins]

8/2/2024 8:31:18 AM

--- Testing API v15 ---

8/2/2024 8:31:19 AM
assetGroupAssetQuery: Success
8/2/2024 8:31:19 AM
displayVideoQuery: Fail
8/2/2024 8:31:20 AM
assetGroupQuery: Fail
8/2/2024 8:31:20 AM
campaignQuery: Success
8/2/2024 8:31:21 AM
assetQuery: Success
8/2/2024 8:31:23 AM
assetGroupMetricsQuery: Fail
8/2/2024 8:31:24 AM
changeQuery: Success
8/2/2024 8:31:25 AM
lpQuery: Fail
8/2/2024 8:31:26 AM
placeQuery: Fail
8/2/2024 8:31:26 AM

--- Testing API v16 ---

8/2/2024 8:31:26 AM
assetGroupAssetQuery: Success
8/2/2024 8:31:27 AM
displayVideoQuery: Fail
8/2/2024 8:31:27 AM
assetGroupQuery: Fail
8/2/2024 8:31:28 AM
campaignQuery: Success
8/2/2024 8:31:28 AM
assetQuery: Success
8/2/2024 8:31:28 AM
assetGroupMetricsQuery: Fail
8/2/2024 8:31:31 AM
changeQuery: Success
8/2/2024 8:31:31 AM
lpQuery: Fail
8/2/2024 8:31:32 AM
placeQuery: Fail
8/2/2024 8:31:32 AM

--- Testing API v17 ---

8/2/2024 8:31:32 AM
assetGroupAssetQuery: Success
8/2/2024 8:31:32 AM
displayVideoQuery: Fail
8/2/2024 8:31:33 AM
assetGroupQuery: Fail
8/2/2024 8:31:34 AM
campaignQuery: Success
8/2/2024 8:31:34 AM
assetQuery: Success
8/2/2024 8:31:35 AM
assetGroupMetricsQuery: Fail
8/2/2024 8:31:35 AM
changeQuery: Success
8/2/2024 8:31:36 AM
lpQuery: Fail
8/2/2024 8:31:36 AM
placeQuery: Fail