Ad_group_asset query no rows returned

[tonero]

Hello,

I am trying to get the assets insights through the Google Ads API, however, every time I run this query I am not getting any row back.

SELECT
    ad_group_asset.ad_group,
    ad_group_asset.asset,
    ad_group_asset.resource_name,
    ad_group_asset.status,
    ad_group_asset.asset,
    ad_group_asset.field_type,
    metrics.impressions,
    metrics.clicks,
    metrics.cost_micros,
    metrics.conversions,
    metrics.conversions_value,
    metrics.all_conversions,
    metrics.all_conversions_value,
    segments.ad_network_type,
    segments.date
FROM ad_group_asset
WHERE segments.date BETWEEN '2022-11-01' AND '2022-11-30'
ORDER BY segments.date ASC

The values we get from ad_group_ad_asset_view do not match what we see on the Ads manager hence the need to try another approach.

Could you tell me what could be the cause of this behavior?

[Google Ads API Forum Advisor]

Hi,

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

To investigate the issue further, could you please provide the complete request and response logs, with the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.You can provide it via Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead. Let me know if you have any questions.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2h31Di:ref