Can't get invalid_click metrics. while using segments.device

[Cristiano De Luca]

Hi all,

Why I can't use this query to retrieve the number of invalid clicks using also device, when I was using AdWords API this was possibile, why not now?
This is my query:

SELECT
          campaign.id,
          campaign.name,
          segments.date,
          metrics.cost_micros,
          metrics.invalid_clicks,
          metrics.conversions,
          metrics.impressions,
          metrics.interactions,
          metrics.clicks,
          segments.ad_network_type,
          segments.device,
          metrics.all_conversions
FROM campaign
  WHERE segments.date DURING YESTERDAY

[Google Ads API Forum Advisor]

Hi Cristiano,

Thank you for reaching out.

As per the segments.device documentation (see Selectable With section), it is indeed not compatible with the metrics.invalid_clicks field. Generally, the Google Ads API's reports and fields should mirror more the reports and views in the Google Ads UI.

In the event that in the Google Ads UI it is possible to retrieve both the device and invalid clicks in a single report, specifically the UI's Campaigns view (equivalent to the campaign report), you may provide our team with the complete screenshot where both fields are contained. I can then raise a feature request, subject for review, for its support in the API.

Should the screenshot contain your user / account information, you may then send the requested details using the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2Wz7F4:ref

[Khoi Vu]

Hi Peter,

Thanks for your reply. I also need that 2 in the campaign report.

I attached the screenshot in Google Ads UI that both the device and invalid clicks are retrievable in a single report.

Can I request to have this in the Google Ads API please?

Thank you

[Google Ads API Forum Advisor]

Hi Khoi vu,

Thanks for commenting on this forum thread.

I’ve created a feature request in order to support both the device and invalid clicks in a single campaign report using Google Ads API. Please note that this will be subject for review and for now, you may keep an eye on our blog for any update or announcements.

Let us know if you have any further questions.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2Wz7F4:ref