How do I select both campaign status ENABLED and PAUSED.

[Rannie John Lopez]

Current query

"SELECT campaign.id, "
. "campaign.name, "
. "segments.date, "
. "metrics.cost_micros "
. "FROM campaign "
. "WHERE segments.date = '$date' "
. "AND campaign.status = 'ENABLED' "
. "AND metrics.cost_micros > 0 "

. "ORDER BY segments.date DESC";

I want to select campaign.status = 'PAUSED' as well. How do I do that? Thanks in advance.

[Google Ads API Forum Advisor]

Hi Rannie,

Thanks for reaching out to the Google Ads API Forum.

You may try to use below GAQL:

​​

SELECT 

  campaign.id, 

  campaign.name, 

  metrics.cost_micros, 

  segments.date 

FROM campaign 

WHERE 

  segments.date = '20221012' 

  AND campaign.status IN ('ENABLED' , 'PAUSED') 

  AND metrics.cost_micros > 0 

ORDER BY 

  segments.date DESC 

Let me know if this helps.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2f4VA2:ref

[Rannie John Lopez]

Yes it did. Thank you so much!