500 Internal server Error on asset_group_product_group_view

[Subodh Kalika]

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.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Kindly note that we are aware of this issue and the team is working on the fix and one of my team members will reach out to you once we have an update. Meanwhile, your patience is highly appreciated.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vER2g:ref" (ADR-00260607)

Thanks,
 

Google Ads API Team

[Constantin Cebanu]

https://ads-developers.googleblog.com/2024/08/google-ads-shopping-report-outage.html

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Kindly note that we are aware of this issue and the team is working on the fix and one of my team members will reach out to you once we have an update. Meanwhile, your patience is highly appreciated.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vERWH:ref" (ADR-00260665)

Thanks,
 

Google Ads API Team

[Google Ads API Forum Advisor]

Hi,

We have an update on this issue and it has been resolved on 08/08/2024. I would suggest you to retry your request once. For more information, you can check the details about the outage in the dashboard at ads.google.com/status for updates. See this Google Ads entry for details on this outage. If you have any queries related to the Google Ads API, please feel free to get back to us.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vER2g:ref" (ADR-00260607)

Thanks,
 

Google Ads API Team

Register for the upcoming workshop: Performance Max and the Google Ads API!