Hello,

I would like to fetch product performance for a given merchant center id 
and period.

Here is my GAQL :

SELECT
metrics.conversions, metrics.impressions, metrics.cost_micros, 
metrics.clicks, metrics.conversions_value,
segments.device, segments.product_item_id, segments.product_merchant_id
FROM 
shopping_performance_view
WHERE 
segments.product_merchant_id = 12345678
AND segments.date BETWEEN '2024-01-01' AND '2024-06-31'

The query builder return me as error:


*Malformed operand: "12345678 AND segments.date BETWEEN '2024-01-01' AND 
'2024-06-31'". Filtering conditions on the "segments.product_merchant_id" 
field using the "=" operator must contain an operand that takes the format 
of an integer.*

I don't really understand why I'm getting this error because I'm actually 
using an integer for the merchant center ID.

Thanks for your help :)


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/871bf37a-2ebd-449e-bcef-bb826c2373f3n%40googlegroups.com.
  • Sh... 'Romain' via Google Ads API and AdWords API Forum
    • ... 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum

Reply via email to