dynamic_search_ads_search_term_view

[beyond Clicks]

Hi Guys, I'm trying to use AWQL to get a list of all the target URL's of a campaign, so I can have my web app scour them and check for 404's and the like, using this ; https://developers.google.com/google-ads/api/docs/query/interactive-gaql-builder

I have been given the query SELECT
     campaign.name,
     dynamic_search_ads_search_term_view.page_url
FROM
    dynamic_search_ads_search_term_view
WHERE
    campaign.status = 'ENABLED'

However, whenever I run it I am told that [fieldPath: ; trigger: ; errorString: QueryError.INVALID_FROM_CLAUSE]

What query can I use to get a campaign name and page_url? I've been stuck on this for a while and each solution seems to keep returning errors or null values.

[Google Ads API Forum Advisor Prod]

Hi,

Thanks for posting your concern.

Could you provide a sample screenshot of the field in the UI that you are referring to 'target URL' so that I can provide the possible field that you can use?

One of the possible report that you can use to get the campaign's data/statistic is the campaign report and you can refer to this document to read more about this report type and the fields that you can include.

Also, so I can investigate the QueryError.INVALID_FROM_CLAUSE you are encountering, could you provide as well your customer ID and the complete request and response logs?

For all the requested details, you may send them using the Reply privately to author option.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q277fCB:ref

[beyond Clicks]

Hi Ernie,

The below screenshot is what I'm looking for. a list of each of them for every campaign available to be specific.

[Google Ads API Forum Advisor Prod]

Hello,

You mentioned that you are using AWQL in your initial post, but the query language given is actually GAQL. The error query error you are getting is given by the AdWords API, not the Google Ads API. Is it possible that you are using GAQL in an AdWords API context? This would explain why the 'from' clause was recognized as invalid. 

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q277fCB:ref