Smart Shopping Campaign

[Rodrigo Ampuero]

Hello, I need to export the products associated with Smart Shopping campaigns, I am pointing to the shopping_performance_view table, but I find products that do not appear in the ADS platform and if it gives me the API. Could you tell me if it is necessary to apply a filter to the query. attached query and screenshot of Platform. Greetings.

SELECT
    campaign.name,
    ad_group.name,
    campaign.id,
    segments.date,
    segments.product_item_id,
    segments.product_brand,
    segments.product_title,
    segments.product_type_l1,
    segments.product_type_l2,
    segments.product_type_l3,
    metrics.cost_micros,
    metrics.clicks,
    metrics.impressions,
    metrics.conversions,
    metrics.conversions_value,
    metrics.ctr  
FROM shopping_performance_view
WHERE
  segments.date ='2022-03-01'

[Google Ads API Forum Advisor]

Hi Rodrigo,

Thanks for reaching out. If I understand, you are finding products returned from the shopping_performance_view that are not present in the Ads UI?

Can you please specify which products are coming through the API report that aren't present in the Ads UI? Please privately provide your request and response logs so that we can investigate the issue.

Thanks,

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2cCbbH:ref