This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB3%3C/text%3E%3C/svg%3E)
Linked Service connects but I am getting error when trying query:
SELECT campaign.name, campaign_budget.amount_micros, campaign.status, campaign.optimization_score, campaign.advertising_channel_type, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros, campaign.bidding_strategy_type FROM campaign WHERE segments.date DURING LAST_7_DAYS AND campaign.status != 'REMOVED'
Error code 9602
DetailsERROR [42000] [Microsoft][SQLEngine] (31480) syntax error near 'SELECT campaign.name,
campaign_budget.amount_micros,
campaign.status,
campaign.optimization_score,
campaign.advertising_channel_type,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros,
campaign.bidding_strategy_type
FROM campaign
WHERE segments.date DURING<<< ??? >>> LAST_7_DAYS
AND campaign.status != 'REMOVED'
Hello @BobGang-3117 : Can you provide more details like source, sink etc.
Is your Source Adwords API or a SQL DB?
Can you check quotation marks in your SELECT query, I think this is an issue related to that as I can see a start quotation ' but not at the trail of the query as added in https://developers.google.com/google-ads/api/docs/migration/overview
@Pratik Somaiya
I am using the GoogleAdWords Linked Service and able to connect. When I create a data set, it also returns data
When I create a source in Pipeline, I use the example from https://developers.google.com/google-ads/api/docs/migration/overview
"SELECT campaign.name, campaign.status, segments.device, metrics.impressions, metrics.clicks, metrics.ctr, metrics.average_cpc, metrics.cost_micros
FROM campaign WHERE segments.date DURING LAST_30_DAYS"
this returns
ERROR [42000] [Microsoft][SQLEngine] (31480) syntax error near 'SELECT campaign.name, campaign.status, segments.device, metrics.impressions,
metrics.clicks, metrics.ctr, metrics.average_cpc, metrics.cost_micros
FROM campaign
WHERE segments.date DURING<<< ??? >>> LAST_30_DAYS'.
Activity ID: 8dfffb6c-d456-4552-a75a-b982945caee6
@Pratik Somaiya - I am not adding quotation marks in the query box, but they are added in json.
"typeProperties": {
"source": {
"type": "GoogleAdWordsSource",
"query": "SELECT campaign.name, campaign.status, segments.device, metrics.impressions, metrics.clicks, metrics.ctr, metrics.average_cpc, metrics.cost_micros FROM campaign WHERE segments.date DURING LAST_30_DAYS"
},
ERROR [42000] [Microsoft][SQLEngine] (31480) syntax error near '**SELECT campaign.name, campaign.status, segments.device, metrics.impressions, metrics.clicks, metrics.ctr, metrics.average_cpc, metrics.cost_micros FROM campaign WHERE segments.date DURING<<< ??? >>> LAST_30_DAYS'**.
In JSON it will be there because values in JSON for string are stored in quotes format
quotes return same error
So I changed the query and this works but only date is yesterday 3/20/2022 not matter the date I entered. I will run tomorrow and see if it is returning 3/21/2022, if that is the case then I am good.
SELECT date,campaign_name,campaign_id,clicks,impressions,costmicros ,keyword_info_text,campaign_status
FROM ad_group_ad where campaign_status = 'ENABLED'
The interesting thing is that the documentation does not match what is actually needed in Copy Activity
Good to hear it worked, do check the date part and let me know of any concern(s) and if my response helped you then please mark it as an answer or you can ask query if any
Today I am getting all the data for Yesterday, the query has no date where clause. The API must be set to only return yesterday's data. Can anyone verify that they can pull different date ranges?