Why can not get campaign cost when using segments.device

[Allylikes Common]

Hi,

I would like to get metics cost by segments.device but i can not get any return data.

my query sql is like bellow:

"SELECT segments.device, campaign.id,campaign.advertising_channel_type, campaign.status FROM campaign  where campaign.id=13880131199"

the request information is（ CustomerID: 7049669050, RequestID: FVfXt640nfErUOXTxxMrmg）

when i removed the segments.device in query sql. such likes

"SELECT  campaign.id,campaign.advertising_channel_type, campaign.status FROM campaign  where campaign.id=13880131199"

the request information is (CustomerID: 7049669050, RequestID: 49RU7PGMRpzE44cahNGPbg)

and this time. i could get return data likes:

results {

  campaign {

    resource_name: "customers/7049669050/campaigns/13880131199"

    status: ENABLED

    advertising_channel_type: SEARCH

    id: 13880131199

  }

}

I'm confused about this problem.and i hope someone could help me.

Thanks

[Google Ads API Forum Advisor]

Hi,

Thanks for posting your concern.

You may refer to this document as it discussed that zero impressions are always excluded when segmenting a report, provided all metrics are zero. Upon checking your account, I can see that this issue is indeed related to the provided document as this campaign is not generating any metrics and specifically the impression metric.

Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2Kc7Kw:ref