Hello, I'm trying to get some metrics from the hotel_performance_view from
the Google Ads API but somehow I'm not getting the correct ones for
metrics.clicks and metrics.cost_micros (the metrics.impressions works fine).
Could you please tell me if I'm choosing any segment combination that
duplicates cost and clicks metrics?
This is my query.
SELECT
ad_group.cpc_bid_micros,
ad_group.cpm_bid_micros,
ad_group.cpv_bid_micros,
ad_group.id,
ad_group.name,
campaign.dynamic_search_ads_setting.domain_name,
campaign.dynamic_search_ads_setting.language_code,
campaign.id,
campaign.name,
campaign.payment_mode,
campaign.shopping_setting.sales_country,
metrics.average_position,
metrics.clicks,
metrics.cost_micros,
metrics.impressions,
segments.date,
segments.device,
segments.hotel_booking_window_days,
segments.hotel_center_id,
segments.hotel_check_in_date,
segments.hotel_length_of_stay,
segments.hotel_country,
segments.partner_hotel_id
FROM hotel_performance_view
WHERE segments.date BETWEEN '${startDate}' AND '${endDate}'
Thanks a lot in advance.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/2341f8e4-2df8-4572-90ef-8b95426dbb54%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
