search query performance report missing location(country) information

2020-09-10 Thread Suraj Chopade
Hi
I am generating the search query performance report using google ads API. 
In the report I am not getting the location information. Is there any way 
to get location information?

-- 
*
***Disclaimer**
*This email communication (including any attachments) 
contains information which is confidential and may be legally privileged. 
It is for the exclusive use of the intended recipient/s. If you are not the 
intended recipient, please delete this email communication (including any 
attachments) and hard copies immediately, please preserve its 
confidentiality and notify the sender. Any unauthorized use or 
dissemination of this email communication (including any attachments) in 
any manner whatsoever, in whole or in part, is strictly prohibited. This 
email communication (including any attachments), may not be free of 
viruses, you should carry out your own virus checks before opening any 
attachment to this e-mail. The sender of this e-mail and Cuelogic 
Technologies shall not be liable for any damage that you may sustain as a 
result of viruses, in completeness of this message, a delay in receipt of 
this message. Any views or opinions presented in this email are solely 
those of the author and do not necessarily represent those of Cuelogic 
Technologies. Cuelogic Technologies will not accept any liability in 
respect of such content of this email, and the author shall be solely 
responsible and will be personally liable for any damages or other 
liability.*

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/b52f46ff-11be-4915-96f2-61fdf8939416n%40googlegroups.com.


DSA ads and final url

2020-09-08 Thread Suraj Chopade
Hi
How to get the final urls for DSA ads? 

I have loaded all raw data to bigquery and I am trying to get the final 
urls for DSA ads but I am not getting ways to do it.
Could you please suggest?

-- 
*
***Disclaimer**
*This email communication (including any attachments) 
contains information which is confidential and may be legally privileged. 
It is for the exclusive use of the intended recipient/s. If you are not the 
intended recipient, please delete this email communication (including any 
attachments) and hard copies immediately, please preserve its 
confidentiality and notify the sender. Any unauthorized use or 
dissemination of this email communication (including any attachments) in 
any manner whatsoever, in whole or in part, is strictly prohibited. This 
email communication (including any attachments), may not be free of 
viruses, you should carry out your own virus checks before opening any 
attachment to this e-mail. The sender of this e-mail and Cuelogic 
Technologies shall not be liable for any damage that you may sustain as a 
result of viruses, in completeness of this message, a delay in receipt of 
this message. Any views or opinions presented in this email are solely 
those of the author and do not necessarily represent those of Cuelogic 
Technologies. Cuelogic Technologies will not accept any liability in 
respect of such content of this email, and the author shall be solely 
responsible and will be personally liable for any damages or other 
liability.*

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/97238df5-eb8d-4b9d-96cf-84a7971d02cen%40googlegroups.com.


keyword tables & search query stats

2020-09-08 Thread Suraj Chopade
Hi
Could anyone help me to know what should be the join criteria I should use 
to join the keyword and search_query_stats table. I have loaded the google 
adwords data to bigquery using transfer services.
Basically I want to know which keywords triggered the ads for given search 
terms.
-- 
*
***Disclaimer**
*This email communication (including any attachments) 
contains information which is confidential and may be legally privileged. 
It is for the exclusive use of the intended recipient/s. If you are not the 
intended recipient, please delete this email communication (including any 
attachments) and hard copies immediately, please preserve its 
confidentiality and notify the sender. Any unauthorized use or 
dissemination of this email communication (including any attachments) in 
any manner whatsoever, in whole or in part, is strictly prohibited. This 
email communication (including any attachments), may not be free of 
viruses, you should carry out your own virus checks before opening any 
attachment to this e-mail. The sender of this e-mail and Cuelogic 
Technologies shall not be liable for any damage that you may sustain as a 
result of viruses, in completeness of this message, a delay in receipt of 
this message. Any views or opinions presented in this email are solely 
those of the author and do not necessarily represent those of Cuelogic 
Technologies. Cuelogic Technologies will not accept any liability in 
respect of such content of this email, and the author shall be solely 
responsible and will be personally liable for any damages or other 
liability.*

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/f60231c3-3c57-419c-9750-35c7867c304an%40googlegroups.com.


Search terms and final urls

2020-09-07 Thread Suraj Chopade
Hi Team,

As per my understanding we can set final urls at keywords and ad level. 
When user type search query if he see ads and if there is keyword match 
with search query and if keyword has final url set then that will take more 
precedence than ad level url. 
In case if there is no url associated with keywords it will use ads final 
urls to navigate user to our site.

so is there any way to get which URL has been used by customer to land on 
our site when he came by typing search query.

basically I want to know for search queries which urls has been clicks by 
customer which lands them on our site.
Although there is ads table which has creativeFinalUrl field which we can 
not say always lands customer on our site, he might have used keyword level 
urls as well.

I have loaded the google ads data into bigquery from there I am trying 
extract this data.

Could you please help me to get search query respective urls data?

-- 
*
***Disclaimer**
*This email communication (including any attachments) 
contains information which is confidential and may be legally privileged. 
It is for the exclusive use of the intended recipient/s. If you are not the 
intended recipient, please delete this email communication (including any 
attachments) and hard copies immediately, please preserve its 
confidentiality and notify the sender. Any unauthorized use or 
dissemination of this email communication (including any attachments) in 
any manner whatsoever, in whole or in part, is strictly prohibited. This 
email communication (including any attachments), may not be free of 
viruses, you should carry out your own virus checks before opening any 
attachment to this e-mail. The sender of this e-mail and Cuelogic 
Technologies shall not be liable for any damage that you may sustain as a 
result of viruses, in completeness of this message, a delay in receipt of 
this message. Any views or opinions presented in this email are solely 
those of the author and do not necessarily represent those of Cuelogic 
Technologies. Cuelogic Technologies will not accept any liability in 
respect of such content of this email, and the author shall be solely 
responsible and will be personally liable for any damages or other 
liability.*

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/a6c3a5db-a789-4bda-ba88-b6c50f72e5a3n%40googlegroups.com.


Search term reports by location and device

2020-09-03 Thread Suraj Chopade
Hi,

I am trying to generate the search term report by device & location. I have 
data loaded in bigquery and I have search_query_stats which has metrics for 
search term with device information. But it has missing location details 
like country. How would I get the country/location details and how can 
generate the data group by device & location.

Thanks

-- 
*
***Disclaimer**
*This email communication (including any attachments) 
contains information which is confidential and may be legally privileged. 
It is for the exclusive use of the intended recipient/s. If you are not the 
intended recipient, please delete this email communication (including any 
attachments) and hard copies immediately, please preserve its 
confidentiality and notify the sender. Any unauthorized use or 
dissemination of this email communication (including any attachments) in 
any manner whatsoever, in whole or in part, is strictly prohibited. This 
email communication (including any attachments), may not be free of 
viruses, you should carry out your own virus checks before opening any 
attachment to this e-mail. The sender of this e-mail and Cuelogic 
Technologies shall not be liable for any damage that you may sustain as a 
result of viruses, in completeness of this message, a delay in receipt of 
this message. Any views or opinions presented in this email are solely 
those of the author and do not necessarily represent those of Cuelogic 
Technologies. Cuelogic Technologies will not accept any liability in 
respect of such content of this email, and the author shall be solely 
responsible and will be personally liable for any damages or other 
liability.*

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/4c7c3c3e-6db1-41a5-bc86-499b1687c0afn%40googlegroups.com.