Empty response from shopping_performance_view

[Aravind Ramalakshmi]

Hi,

I was trying to query product-level advertising performance data from shopping_performance_view but I didn't get any data in the response (apart from fieldmask and queryResourceConsumption). I can confirm that campaign, ad_group and shopping_product data is available for this particular advertising account. Why is the data missing from shopping_performance_view? Is there any other way to get the product-level advertising performance data? I've added the query used below. Please let me know if you need any other details from us.

shopping_performance_view query:

SELECT

ad_group.name,

campaign.name,

campaign.id,

ad_group.id,

ad_group.type,

campaign.advertising_channel_type,

ad_group.status,

campaign.status,

metrics.impressions,

metrics.clicks,

metrics.cost_micros,

metrics.all_conversions,

metrics.conversions,

metrics.all_conversions_value,

metrics.units_sold,

metrics.conversions_value,

segments.date,

customer.time_zone

FROM shopping_performance_view

WHERE

segments.date DURING LAST_7_DAYS