search_impression_share not available for Shopping campaign at hour level

[Emilien Giard]

Hello,

We are using the API to get campaign metrics and we have noticed that we cannot get search_impression_share metric (or all other predicated metrics) at an hour level for shopping campaigns. The API always returns 0.0 for those metrics.

I was not able to find any justification in the documentation. Could you please explain to me this behaviour?

We use the GoogleAdsService version="v5" and the query is:

SELECT campaign.id, campaign.name, campaign.status, metrics.clicks, metrics.conversions, metrics.conversions_value,

metrics.cost_micros, metrics.impressions, metrics.search_impression_share,

metrics.search_budget_lost_impression_share, metrics.search_top_impression_share, metrics.search_rank_lost_impression_share,

customer.currency_code, segments.date, segments.hour,

bidding_strategy.type, bidding_strategy.id, bidding_strategy.name

FROM campaign

WHERE segments.date >= '{start_date.strftime("%Y-%m-%d")}' AND segments.date <= '{end_date.strftime("%Y-%m-%d")}'

ORDER BY segments.date DESC

Thanks,

Emilien

[Google Ads API Forum Advisor Prod]

Hi Emilien,

Any value below 0.1 is reported as 0.099. If you believe that the value is above 0.1, then please send the following details using 'Reply privately to author' option:

1. Client customer id
2. Sample result set of UI report

https://developers.google.com/google-ads/api/fields/v5/campaign?hl=en#metrics.search_impression_share

Thanks,

Lakshmi Prathipati Google Ads API Team

ref:_00D1U1174p._5004Q29UMTY:ref

[Emilien Giard]

Hi,

The problem is that my values are different of 0 when I get the report without "segments.hour". With "segments.hours", they are always equal to 0.

I have the same issue on the Google Ads UI, here is an example where the first line is aggregated at the daily level but then I have nothing on a hourly level:

I don't have the permission to 'Reply privately to author', if you explain to me how I could do it I will give you more information.

Thanks

[Google Ads API Forum Advisor Prod]

Hi Emilien,

Since you are seeing the same behavior in the UI as well, I recommend reaching out to the product team first and get more insights on this combination. Once you are able to get at product level and still seeing the issue at API level, then please send all the details to 'googleadsa...@google.com'.

Product team contact: https://support.google.com/google-ads/gethelp