Campaign And Budget select query

[anzor urdia]

Hi there,

I want to fetch data for Campaign and Budget, my problem is that I want to do it for a couple of campaigns in one request.
Let's say I have Campaign-1 with ID: FirstID and Campaign-2 with ID: SecondID
If I run a query:

SELECT
campaign.id,
campaign.advertising_channel_type,
campaign.bidding_strategy,
campaign.bidding_strategy_type,
campaign.campaign_budget,
campaign.name,
campaign.serving_status,
campaign.start_date,
campaign.status,
campaign_budget.amount_micros,
campaign_budget.delivery_method,
campaign_budget.explicitly_shared,
campaign_budget.id,
campaign_budget.name,
campaign_budget.period,
campaign_budget.resource_name,
campaign_budget.status,
campaign_budget.type
FROM
campaign
WHERE
campaign.status = 'ENABLED' AND campaign.id = FirstID

OR 

SELECT
campaign.id,
campaign.advertising_channel_type,
campaign.bidding_strategy,
campaign.bidding_strategy_type,
campaign.campaign_budget,
campaign.name,
campaign.serving_status,
campaign.start_date,
campaign.status,
campaign_budget.amount_micros,
campaign_budget.delivery_method,
campaign_budget.explicitly_shared,
campaign_budget.id,
campaign_budget.name,
campaign_budget.period,
campaign_budget.resource_name,
campaign_budget.status,
campaign_budget.type
FROM
campaign
WHERE
campaign.status = 'ENABLED' AND campaign.id = SecondID

It works fine, but when I run the query:

SELECT
campaign.id,
campaign.advertising_channel_type,
campaign.bidding_strategy,
campaign.bidding_strategy_type,
campaign.campaign_budget,
campaign.name,
campaign.serving_status,
campaign.start_date,
campaign.status,
campaign_budget.amount_micros,
campaign_budget.delivery_method,
campaign_budget.explicitly_shared,
campaign_budget.id,
campaign_budget.name,
campaign_budget.period,
campaign_budget.resource_name,
campaign_budget.status,
campaign_budget.type
FROM
campaign
WHERE
campaign.status = 'ENABLED' AND campaign.id = SecondID AND campaign.id = FirstID
GROUP BY
campaign.id

It does not work. Any suggestion how to group this?

Thanks

[Ian Prentice]

You need to use IN( FirstiD, SecondID ) 

[Google Ads API Forum Advisor]

Hi Ian,

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

To investigate the issue further, could you please provide the complete request and response logs, with the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2a3I1c:ref

[Ian Prentice]

I answered OP's question.

[anzor urdia]

Hello Ian

Thanks a lot. It works.