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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/a077464c-0412-4a58-8353-a47fe4807382n%40googlegroups.com.
  • In... Radosław Pociecha
    • ... 'Google Ads API Forum Advisor' via AdWords API and Google Ads API Forum
    • ... 'Google Ads API Forum Advisor' via AdWords API and Google Ads API Forum

Reply via email to