How can i use GAQL to find out ads campaign cost divided by mobile operating system

[Andres]

Hi,

I am wondering whether i can use GAQL to get ads campaign cost data group by mobile operating system, such as iOS and android.

According to this issue: https://groups.google.com/g/adwords-api/c/tJM04aQt4FQ/m/dsDQFjK0AQAJ

 I tried this before: 

SELECT 

operating_system_version_constant.name,

mobile_device_constant.operating_system_name

FROM campaign_criterion

WHERE campaign.id IN (xxx, xxx)

but the returned data does not contain the filed i want

Could someone kindly give me any resolution ?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

After reviewing your concern, I understand that you want to fetch the data of ads campaign cost data group by mobile operating system, such as iOS and android through a query.

In order to assist you further, please provide us with the uncropped UI screenshot of the report that you are trying to replicate via the Google Ads API.

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02q9Sw8:ref"

Thanks,
 

Google Ads API Team