Hi,
I've already posted error which I'm facing to fetch data older than 90 days
actually I can able to fetch campaign impression, ctr, clicks etc.. detail
which older than 90 days.
I'm fetching my campaign detail
below query I've used to fetch campaign details :-
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,
campaign.bidding_strategy_type,
metrics.cost_micros
FROM campaign
WHERE segments.date BETWEEN '{start_date}' AND
'{end_date}'
So when i try to fetch gclid with "SELECT click_view.gclid, campaign.id
FROM click_view WHERE segments.date BETWEEN '2022-10-01' AND '2022-10-30'
AND campaign.id = 14529401748" this query getting error [Queries including
ClickView must have a filter limiting the results to one day].
I want to fetch gclid such like this , please give me solution to resolve
this error.
On Thursday 16 May 2024 at 22:03:11 UTC+5:30 Google Ads API Forum Advisor
wrote:
> Hi,
>
> Thank you for reaching out to the Google Ads API support team.
>
> Please refer to this Rest API endpoint :
> https://developers.google.com/google-ads/api/rest/reference/rest/v16/customers.googleAds/searchStream
>
> Also, kindly try the below provided query to get the GCLID using campaign
> id.
>
> Query : "SELECT click_view.gclid, campaign.id FROM click_view WHERE
> segments.date = '2024-05-16' AND campaign.id = 123456789"
>
> You may use this Google Ads Query Builder
> <https://developers.google.com/google-ads/api/fields/v16/click_view_query_builder>
>
> to build your own query with the click_view
> <https://developers.google.com/google-ads/api/fields/v16/click_view>
> resource.
>
> Hope this helps. If you have any more queries, please feel free to get
> back to us.
>
> This message is in relation to case
> "ref:!00D1U01174p.!5004Q02tJ01J:ref" (ADR-00235302)
>
> Thanks,
>
> [image: Google Logo] Google Ads API Team
>
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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 adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/6389a71b-055f-455c-a9bd-778e4d53a25fn%40googlegroups.com.
