Incompatibility between AdWords and GoogleAds apis regarding invalid_clicks and device

[Radosław Pociecha]

Hello,

In AdWords api it is possible to fetch CAMPAIGN_PERFORMANCE_REPORT with field InvalidClicks segmented by Device, but when we try to get using new api we are getting error PROHIBITED_SEGMENT_WITH_METRIC_IN_SELECT_OR_WHERE_CLAUSE with message "Cannot select the following segments because at least one unsupported metric is found in SELECT or WHERE clause: 'segments.device'(unsupported metrics: 'invalid_clicks').". It looks like GoogleAds api does not allow to segment campaign report the same way as AdWords api when field invalid_clicks is used.

Working AWQL query for AdWords api:

SELECT
                    CampaignId,
                    Cost,
                    InvalidClicks,
                    Clicks,
                    Device,
                    Date
                FROM
                    CAMPAIGN_PERFORMANCE_REPORT
                WHERE
                    CampaignStatus IN ["ENABLED", "PAUSED"]
                DURING
                    LAST_30_DAYS

GoogleAds query resulting in error:

SELECT
                    campaign.id,
                    metrics.cost_micros,
                    metrics.invalid_clicks,
                    metrics.clicks,
                    segments.device,
                    segments.date,
                FROM campaign
                WHERE campaign.status IN ("ENABLED", "PAUSED")
                    AND segments.date DURING LAST_30_DAYS

Is this change intended or is it a bug ? Or maybe there is another resource we can use to achieve invalid_clicks segmentation by device for campaigns ?

Regards

Radosław Pociecha

[Google Ads API Forum Advisor]

Hi Radosław,

I checked in the UI's campaign screen and couldn't find segmentation of invalid clicks based on device. Can you send us a full screen screenshot wherein the UI segments campaign invalid clicks by device? You can follow up with product support as the Ads API can only be a conduit for the product, just like the old AdWords API is a conduit for the old product UI.

Regards,

Aryeh Baker Google Ads API Team

 

ref:_00D1U1174p._5004Q2UiMIj:ref

[Google Ads API Forum Advisor]

Hi Radosław,

You can send this requested screenshot privately.