You need to use IN( FirstiD, SecondID ) On Thursday, April 14, 2022 at 11:44:22 AM UTC-4 [email protected] wrote:
> 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 > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords 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/d5d27765-19a2-488f-a829-f7d50fd262ban%40googlegroups.com.
