subject:"Re\: find gclid using campaign id"

Re: find gclid using campaign id

2024-05-20 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum

Hi,

As per the click_view document, queries including ClickView must have a filter 
limiting the results to one day and can be requested for dates back to 90 days 
before the time of the request.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJ01J:ref" 
(ADR-00235302)

Thanks,

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/DOrbs0SDS7UU00G72g4Gl1Rr6a_gFjGAKD4w%40sfdc.net.

Re: find gclid using campaign id

2024-05-19 Thread D. H.

And with apologies for missing the 90 days part, as well as limiting 
results to one day, you cannot fetch results older than 90 days.

This query returns an error for me:
SELECT click_view.gclid, campaign.id FROM click_view WHERE segments.date = 
'2024-02-01'

GoogleAdsException: (<_SingleThreadedRendezvous of RPC that terminated 
with: status = StatusCode.INVALID_ARGUMENT details = "Request contains an 
invalid argument." debug_error_string = "UNKNOWN:Error received from peer 
ipv4:xxx.xxx.xxx.xx:xxx {created_time:"2024-05-20T09:30:00.00+00:00", 
grpc_status:3, grpc_message:"Request contains an invalid argument."}" >, 
<_SingleThreadedRendezvous of RPC that terminated with: status = 
StatusCode.INVALID_ARGUMENT details = "Request contains an invalid 
argument." debug_error_string = "UNKNOWN:Error received from peer 
ipv4:xxx.xxx.xxx.xx:xxx {created_time:"2024-05-20T09:30:00.00+00:00", 
grpc_status:3, grpc_message:"Request contains an invalid argument."}" >, 
errors { error_code { request_error: UNKNOWN } message: "The requested date 
is too old. It cannot be older than 90 days." } request_id: "
xx"
, 'xx')

D.H.
On Saturday, May 18, 2024 at 6:22:10 AM UTC+8 bhavya dev wrote:

> 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 
>> 
>>  
>> to build your own query with the 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/cd7d14dd-aa49-44a9-a3ec-e8a4c13e54bbn%40googlegroups.com.

Re: find gclid using campaign id

2024-05-19 Thread D. H.

Hi,

You need to include a filter to limit the results to a single day.

This query works for me:
SELECT click_view.gclid, campaign.id FROM click_view WHERE segments.date = 
'2024-05-01'

As does this:
SELECT click_view.gclid, campaign.id FROM click_view WHERE segments.date 
BETWEEN '2024-05-01' AND '2024-05-01'

But if I extend it to even two days I return the same error you have:
SELECT click_view.gclid, campaign.id FROM click_view WHERE segments.date 
BETWEEN '2024-05-01' AND '2024-05-02'

GoogleAdsException: (<_SingleThreadedRendezvous of RPC that terminated 
with: status = StatusCode.INVALID_ARGUMENT details = "Request contains an 
invalid argument." debug_error_string = "UNKNOWN:Error received from peer 
ipv4:xxx.xx.xxx.xxx:xxx {created_time:"2024-05-20T09:30:00.00+00:00", 
grpc_status:3, grpc_message:"Request contains an invalid argument."}" >, 
<_SingleThreadedRendezvous of RPC that terminated with: status = 
StatusCode.INVALID_ARGUMENT details = "Request contains an invalid 
argument." debug_error_string = "UNKNOWN:Error received from peer 
ipv4:xxx.xx.xxx.xxx:xxx {created_time:"2024-05-20T09:30:00.00+00:00", 
grpc_status:3, grpc_message:"Request contains an invalid argument."}" >, 
errors { error_code { request_error: UNKNOWN } message: "Queries including 
ClickView must have a filter limiting the results to one day." } 
request_id: "xx" , 'xx')

Hope this helps,

D.H.

On Saturday, May 18, 2024 at 6:22:10 AM UTC+8 bhavya dev wrote:

> 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 
>> 
>>  
>> to build your own query with the 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/3fb24a86-5141-4e10-b4f2-a4fea5277309n%40googlegroups.com.

Re: find gclid using campaign id

2024-05-17 Thread bhavya dev

Hi,

Thank you for your response. 

Can you please provide me Rest API endpoint and query to find Campaign_id 
using gclid.

For ex :- I've gclid , so can I able to find campaign_id using that gclid 
?? 

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 
> 
>  
> to build your own query with the 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/e4681db3-f028-48c5-bce8-e4f53acef8b0n%40googlegroups.com.

Re: find gclid using campaign id

2024-05-17 Thread bhavya dev

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 
> 
>  
> to build your own query with the 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.

Re: find gclid using campaign id

2024-05-17 Thread bhavya dev

Hi, Thank you for your response

I'm getting error when i try to call Rest Api :- 
https://googleads.googleapis.com/v16/customers/{customer.id}/googleAds:searchStream

Request Body :- "SELECT click_view.gclid, campaign.id FROM click_view WHERE 
segments.date = '2023-12-10' AND campaign.id = {my_campaign_id}"

Response :- {
"error": {
"code": 400,
"message": "Request contains an invalid argument.",
"status": "INVALID_ARGUMENT",
"details": [
{
"@type": 
"type.googleapis.com/google.ads.googleads.v16.errors.GoogleAdsFailure",
"errors": [
{
"errorCode": {
"requestError": "UNKNOWN"
},
"message": "The requested date is too old. It cannot be older than 90 days."
}
],
"requestId": "6p9T_bHXo7cIp1O-gBfIeg"
}
]
}
}

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 
> 
>  
> to build your own query with the 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/fb326233-17dc-40bf-ba5a-bee7b4307364n%40googlegroups.com.

RE: find gclid using campaign id

2024-05-16 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum

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 to build your own query with the 
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,

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/NPsLM0SDL7AC00v1YYYsS3TyixGNccAEqXog%40sfdc.net.

Re: find gclid using campaign id

Re: find gclid using campaign id

Re: find gclid using campaign id

Re: find gclid using campaign id

Re: find gclid using campaign id

Re: find gclid using campaign id

RE: find gclid using campaign id

7 matches

Site Navigation

Mail list logo

Footer information