Your next GAQL query search result can be "one search" away

[Zeyuan Gu]

Hey all, we've been working on Adzviser  for over 6 
months (YT demo ). We aim to enable the 
non-technical marketers to quickly search their marketing data like they 
would on Google Search, inspired by ChatGPT. The theory is that dashboards 
built on Google Looker Studio or Tableau don't offer enough flexibility so 
it could take marketers time to build one-off data reports to validate 
their hypothesis and answer their clients' questions. You can think of 
Adzviser as a chatbot interface that bubbles up your marketing data for 
you. Here is a one-page playbook 

 that 
explains what type of questions could be answered with Adzviser.

We've currently only integrated with Google Ads, as we expect to integrate 
FB next.

Your feedback will be what drives us to build more helpful and powerful 
tools for marketers. Our believe is that marketers deserve a tool that 
helps them understand whatever the hell is going on with their clients' 
campaigns WITHOUT ANY engineering.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/0f75f572-e079-4c62-b71a-9e111fe95374n%40googlegroups.com.

Re: Conversions value per cost (ROAS) - Cannot select or filter

[Zeyuan Gu]

Hey, 

Were you able to pull roas (conversion_value_per_cost) from campaigns? 

On Tuesday, May 31, 2022 at 7:28:25 AM UTC-5 Hubert Jaworski wrote:

> How do I do that in Python?
>
> Here's a snippet of how I use the Python library to send requests to the 
> API:
> ga_service = googleads_client.get_service("GoogleAdsService")
> search_request = googleads_client.get_type("SearchGoogleAdsStreamRequest")
> search_request.customer_id = customer['id']
> search_request.query = query
> search_request.summary_row_setting = googleads_client.get_type(
> 'SummaryRowSettingEnum').SummaryRowSetting.SUMMARY_ROW_WITH_RESULTS
>
> stream = ga_service.search_stream(search_request)
> for batch in stream:
> (...)
>
> Not quite sure how to obtain the complete logs here :(
> czwartek, 26 maja 2022 o 07:48:18 UTC+2 adsapi napisał(a):
>
>> Hi Hubert,
>>
>> Thank you for raising your concern to the team.
>>
>> Upon checking our document 
>> , I 
>> can see that it should be supported for the said report type. However, 
>> you've encountered the error where it says that the field is not compatible 
>> with the said report type. Also, I tried it in the query validator and I 
>> can see the same error.
>>
>> With this, so that I can further investigate or raise it to the team, 
>> would you be able to provide the complete request 
>> 
>>  and response 
>> 
>>  logs 
>> with request ID 
>> 
>>  and request header 
>> 
>>  generated 
>> on your end? You can provide it via *Reply privately to author* option. 
>> If this option is not available, then send it instead on this email address 
>> googleadsa...@google.com.
>>
>> Regards,
>> [image: Google Logo] 
>> Ernie John 
>> Google Ads API Team 
>>   
>>
>> ref:_00D1U1174p._5004Q2bDLrx:ref
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/7523b678-825b-4383-9b55-5b3a5753e9d1n%40googlegroups.com.

Re: Total active products in each Performance Campaign

[Zeyuan Gu]

Hi Benjamin,

I came across your question on the Google Ads API forum. I‘m still 
interested in the problem you raised in the forum. Is it possible if we can 
schedule some time to chat and talk about the challenges you have getting 
reports from Google Ads using GAQL? 

I'm a ex-Google software engineer and I worked on Google Ads for 3.5 years. 
I'm currently building this software called Adzviser  
which takes your natural language query and translates it to GAQL. You can 
ask questions in lines of "How much did I spend on search campaigns last 
month" and the results will be shown right there for you (video demo 
). However, the use case that you have 
related with performance max campaigns and product counts is not something 
I'm familiar with yet. I'd love to understand your problem better and see 
if I could solve it with natural language understanding. 

Thank you. This is my schedule . 

On Thursday, March 9, 2023 at 4:24:39 AM UTC-6 Benjamin Davis wrote:

> I'd love to be able to get a report that had a list of all my PMax 
> campaigns and then the total active product count next to it. Is this 
> possible with Google Ads Script?
>
> For example,
>
> Campaign Name x, 35 products
> Campaign Name x, 1000 products
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/1ae2b00d-ee2c-4a11-a367-8eca0995a06bn%40googlegroups.com.

Re: Private message regarding: INVALID_CUSTOMER_ID while accessing KeywordPlanIdeaService

[Zeyuan Gu]

Hi Ajay,

I came across your question on the Google Ads API forum. You asked some 
intriguing and challengine question! Did you your "INVALID_CUSTOMER_ID" 
problem fixed? I bet you are constantly running into issues when developing 
with GAQL just like me when I first started 3.5 years ago. I am an 
ex-Google software engineer and I worked on Google Ads. I understand how 
painful it is to use the API and decided to quit Google and work on solving 
peoples' problem with GAQL full-time.

I built this software called Adzviser <http://adzviser.com/> which takes 
your natural language query and translates it to GAQL. You can ask 
questions in lines of "How much did I spend on search campaigns last month" 
and the results will be shown right there for you (video demo 
<https://youtu.be/O7CWf5Kaypg>). I'm also very open to discuss literally 
ANY challenges that you will come across. Just keep me as point of contact 
if you ever run into any problems pulling data from Google Ads.

Look forward to hearing from you.

Zeyuan Gu
Adzviser <http://www.adzviser.com/>
Log Angeles, US

On Sunday, April 30, 2023 at 5:41:57 AM UTC-5 Ajay Balgovind Kuril wrote:

> Hi ,
> Sharing logs here, have removed credentials due to company policies.
> [nltk_data]   Package stopwords is already up-to-date!
>  {'developer_token': '-', 'refresh_token': '1//XX-', 
> 'client_id': 'X', 'client_secret': 'XX-XXX', 
> 'use_proto_plus': False, 'login_customer_id': '9237865946'}
> Request made: ClientCustomerId: , Host: googleads.googleapis.com, Method: 
> /google.ads.googleads.v13.services.KeywordPlanIdeaService/GenerateKeywordIdeas,
>  
> RequestId: bAjMOKyHSBEgff1RSaJwiA, IsFault: True, FaultMessage: Invalid 
> customer ID ''.
> Traceback (most recent call last):
>   File 
> "/Users/admin/Desktop/Ajay/Youtube_API/colabnotebook_f/colabnotebook/driver.py",
>  
> line 29, in 
> getkeywords(site, input_keywords_list)
>   File 
> "/Users/admin/Desktop/Ajay/Youtube_API/colabnotebook_f/colabnotebook/driver.py",
>  
> line 20, in getkeywords
> google_df = get_df(input_keywords_list, site, 'Direct (Product 
> Keywords)')
>   File 
> "/Users/admin/Desktop/Ajay/Youtube_API/colabnotebook_f/colabnotebook/search_volume_puller.py",
>  
> line 270, in get_df
> keyword_ideas = keyword_plan_idea_service.generate_keyword_ideas(
>   File 
> "/usr/local/lib/python3.9/site-packages/google/ads/googleads/v13/services/services/keyword_plan_idea_service/client.py",
>  
> line 436, in generate_keyword_ideas
> response = rpc(
>   File 
> "/usr/local/lib/python3.9/site-packages/google/api_core/gapic_v1/method.py", 
> line 113, in __call__
> return wrapped_func(*args, **kwargs)
>   File 
> "/usr/local/lib/python3.9/site-packages/google/api_core/grpc_helpers.py", 
> line 72, in error_remapped_callable
> return callable_(*args, **kwargs)
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 247, in __call__
> response, ignored_call = self._with_call(request,
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 290, in _with_call
> return call.result(), call
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 146, in result
> raise self._exception
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 274, in continuation
> response, call = self._thunk(new_method).with_call(
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 301, in with_call
> return self._with_call(request,
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 290, in _with_call
> return call.result(), call
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 146, in result
> raise self._exception
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 274, in continuation
> response, call = self._thunk(new_method).with_call(
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 301, in with_call
> return self._with_call(request,
>   File "/usr/local/lib/python3.9/site-packages/grpc/_interceptor.py", line 
> 287, in _with_call
> call = self._interceptor.intercept_unary_unary(continuation,
>   File 
> "/usr/local/lib/python3.9/site-packages/google/ads/googleads/interceptors/exception_interceptor.py",
>  
> line 99, in intercept_unary_unary
> self._handle_grpc_failure(response)
>   File 
> "/usr/local/lib/python3

Re: you don't need to write gaql anymore. intro adzviser - google search for google ads (demo attached)

[Zeyuan Gu]

Thanks for letting me know. 

Is it cool if I could post again but without my email address this time? 

On Tuesday, May 2, 2023 at 11:21:08 AM UTC-5 Google Ads API Forum Advisor 
wrote:

> Hi Zeyuan,
>
> Thanks for reaching out to Google Ads API Forum.
>
> I just want you to know that I am going to remove your recent post in this 
> thread because it contains private information which is not allowed to be 
> posted in this forum for security purposes.
>
> For the reference, you may refer below without sensitive information:
>
>
>
>
>
> *“Hello friends - I spent the past 6 months building this search bar for 
> marketers so that they can get their Google Ads campaign performance data 
> easier and faster. Currently they either have to manually pull those data 
> from the website or to use Supermetrics/Fivetran, to automate the data 
> pulling process. Furthermore, referring to the Google Ads Query Builder is 
> painful for beginners if you want to write your own code. I believe that 
> those marketing data and reports can be "one search away" (**yt video 
> demo* *). So I built a software prototype 
> that *
>
>1. *has OAuth2.0 connections to Google Ads* 
>2. *translates natural language prompt to Google Ads Query Language * 
>3. *generates table and visualization output* 
>
> *I worked at Google Ads for 3.5 years and brought this idea up to the 
> management, but got turned down. Therefore I decided to pursue this idea on 
> my own. I call this project **Adzviser* 
>
> *.  Thanks! ”*
>
> If you have any questions related to *Google Ads API*, feel free to 
> contact us and give further context about the issue so that we can provide 
> guidance accurately. You response is highly appreciated.
>
> Links included in this email:
>
>- *Google Ads API - *
>*https://developers.google.com/google-ads/api/docs/start* 
>  
>
>
> Regards,
> [image: Google Logo] Google Ads API Team 
>
> ref:_00D1U1174p._5004Q2l95YV:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/a6262dce-9ca1-4575-b7e9-01da4c4d7395n%40googlegroups.com.

You don't need to write GAQL anymore. Intro Adzviser - Google Search for Google Ads (demo attached)

[Zeyuan Gu]

Hello friends -

I spent the past 6 months building this search bar for marketers so that 
they can get their Google Ads campaign performance data easier and faster. 
Currently they either have to manually pull those data from the website or 
to use  Supermetrics/Fivetran, to automate the data pulling process. 
Furthermore, referring to the Google Ads Query Builder is painful for 
beginners if you want to write your own code.

I believe that those marketing data and reports can be "one search away" (yt 
video demo ). So I built a software prototype 
that 

   1. has OAuth2.0 connections to Google Ads
   2. translates natural language prompt to Google Ads Query Language 
   3. generates table and visualization output

I worked at Google Ads for 3.5 years and brought this idea up to the 
management, but got turned down. Therefore I decided to pursue this idea on 
my own. I call this project Adzviser . 

My email address is zeyuan...@adzviser.com.

Thanks! 

 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/53d34626-da4f-4162-a10b-83f23ab3a773n%40googlegroups.com.

Re: Help on generating historical data for a few keywords

[Zeyuan Gu]

Hi Peter,

I came across your question on Google Ads API forum. You asked a great 
question about generating historical data for keywords. I'm an ex-Google 
software engineer working on Google Ads. I am now building a software that 
operates as a search engine for your marketing data. I would love to 
introduce you to Adzviser . It should help you with 
your daily job and keep you productive. 

I'm excited to hear back from you and chat more about the product that we 
offer. My email address is zeyuan...@adzviser.com

On Monday, February 20, 2023 at 9:57:32 AM UTC-6 Peter Thyssen wrote:

> Hi,
>
> I want to generate some historical data for the past year or two for a few 
> keywords for research purposes and found this page which seems to be 
> relevant: 
> https://developers.google.com/google-ads/api/docs/keyword-planning/generate-historical-metrics
>
> However I am unsure where to begin - I have a google ads account and I 
> have made a keyword plan with a list of keywords. 
>
> If someone could be of help I would greatly appreciate it!
>
> Thanks, 
>
> Peter
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/d1900fb1-6017-48c0-86d4-eff1f39d1a5bn%40googlegroups.com.