Error in query: unexpected input ,. when using LIMIT with offset

2021-12-29 Thread Jurijs P.
I have a query: SELECT campaign.id, campaign.name, label.id, label.name, campaign.campaign_budget, campaign.status FROM campaign_label WHERE campaign.status = 'ENABLED' LIMIT 5 which works fine and returns the data I need. But If I want to use LIMIT with offset, it fails: SELECT campaign.id, c

Re: Update budget money amount for campaigns

2021-12-17 Thread Jurijs P.
I'm struggling to get a budget object using such approach: $googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient(); $query = "SELECT campaign.id, campaign.name, campaign.campaign_budget, label.id, label.name " . "FROM campaign_label LIMIT 2"; $response

Update budget money amount for campaigns

2021-12-15 Thread Jurijs P.
I have a need to sort campaigns by labels and change the money amount of the campaign budget. I'm using google-ads-php. Ideally I want to loop through the campaigns selected by label like in "Get Campaigns By Label" example and mutate the Budget amount. Budget example only shows how to create