https://ads-developers.googleblog.com/2024/08/google-ads-shopping-report-outage.html
Le vendredi 2 août 2024 à 08:03:16 UTC+2, Subodh Kalika a écrit :
> Hi Google Support Team,
>
> We have been encountering a 500 Internal Server Error when running the
> following query on the asset_group_product_group_view:
>
>
> SELECT
> Date,
> CampaignName,
> CampaignId,
> AssetGroupId,
> AssetGroupName,
> AssetGroupStatus,
> AssetGroupListingGroupFilterType,
> Impressions,
> Clicks,
> Cost,
> Conversions,
> ConversionsValue,
> CostUsd,
> CostBrl,
> CostEur,
> CostAud,
> CostGbp
> FROM
> asset_group_product_group_view
> WHERE
> segments.date BETWEEN '%s' AND '%s'
> AND asset_group_listing_group_filter.type != "SUBDIVISION"
> AND campaign.id IN ({','.join(campaign_ids)})
> AND metrics.cost_micros > 0
> ORDER BY
> campaign.id
>
>
> *Issue Description*
> We receive a 500 Internal Server Error response when executing the above
> query. The error does not occur while fetching other entities like
> campaign, asset_group_asset, group_placement_view etc. but is only
> occuring on asset_group_product_group_view.
>
> *Additional Information*
> We have been downloading this report for 2-3 years without issues.
> This is a critical report for our platform.
> The 500 errors started occurring suddenly from this morning.
> No changes have been made on our end that could have triggered this issue.
> We are using v17 of google ads api.
> We are using the googleads python client library v42.0.0.
>
> *Steps Taken*
> Verified that all campaign IDs and date ranges are valid.
> Checked for any recent changes in the schema or data that might affect
> this view.
>
> We appreciate your urgent assistance in resolving this issue as this
> report is critical for our platform's operation. Please investigate the
> cause of the error and provide a solution or workaround.
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/c5bf5d4e-822d-4109-a520-3e61ff02ae3en%40googlegroups.com.
