google ads api query

[maxcode ITSolutions]

Hi,

How to create a manager account under a MCC account using google ads api?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/CACqmN4s151eKpiLiL24-MWJx2sx%3DgMjQ0g69jsHMQkLoiEQYBA%40mail.gmail.com.

RE: Google Ads API Query - segments.date is not working correctly

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Jacob,

Thank you for reaching out to us.

For our team to further check and validate why you are getting a blank result, 
could you provide us the complete API logs(request and response with 
request-id) generated on your end and the whole UI screenshot where you can see 
the expected results?

Note that logs can be requested or provided to the developer handling the 
Google Ads API transactions when logging of the API requests has been enabled. 
You may check here and click your client library for the specific guideline to 
enable it.

For REST interface requests, you can enable logging via the curl command by 
using the -i flag. This will cause the tool to include the HTTP response 
headers in the output.

You may then send the requested information via the Reply privately to author 
option. If this option is not available, you may send the details directly to 
our googleadsapi-supp...@google.com alias instead.

Best regards,

Heidi
Google Ads API Team
ref:_00D1U1174p._5004Q2fnwBj: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/jdGPk0RKBMBX00m9czAsmnTCe1Y2hNN1-hKg%40sfdc.net.

Google Ads API Query - segments.date is not working correctly

['Jacob Garrett' via Google Ads API and AdWords API Forum]

Hi, I am an issue with MANAGED_PLACEMENT_VIEW report when writing a Google 
Script within Google Ads.
I would like to SELECT segments.date but the results return blank.


-- 


Disclaimer The information contained in this communication from the 
sender is confidential. It is intended solely for use by the recipient and 
others authorized to receive it. If you are not the recipient, you are 
hereby notified that any disclosure, copying, distribution or taking action 
in relation of the contents of this information is strictly prohibited and 
may be unlawful. 
This email has been scanned for viruses and malware, and 
may have been automatically archived by Sonobi Inc.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/71798a03-8d28-4251-ad71-255d3cdcaeb0n%40googlegroups.com.

RE: Google Ads API Query vs Google Ads UI Discrepancy in Impressions and Conversions

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi MJ,

Thank you for reaching us out. I am Sherwin from Google Ads API support team. I 
hope that you are doing well today.

To be honest here with you, SQL is not on the list of client libraries being 
used in Google Ads API. Please check this link for the client libraries which 
are supported by Google Ads API. Since, you are using BigQuery, what we can do 
also is to advise you to reach out to the BigQuery support team regarding this 
concern because they are more equipped with regard to this concern.

Kind regards,

Sherwin Vincent
Google Ads API Team
ref:_00D1U1174p._5004Q2bluzC: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/ovX_f0RFBGDX009jwU9c8nTq6jaLf7kaS1sA%40sfdc.net.

Google Ads API Query vs Google Ads UI Discrepancy in Impressions and Conversions

[MJ Steenberg]

Hi Google Ads API Support,

I've pulled my Google Ads data into BigQuery and I'm attempting to pull 
specific data using standard SQL queries - I'm attempting to get my values 
as accurate to the UI as possible.

Campaign Level + Ad Group level all metrics are 100% except for my Impr. 
and Conv.

I've recently learned that these discrepancies in Impressions and 
Conversions are normal. Could you provide me with SQL logic that accurately 
reflects what is shown on the UI?

Here are my queries:

Generic stats at Campaign + Ad Group level:

#standardSQL
SELECT
ADG.date,
CMP.CampaignId,
BASE.CampaignName,
CMP.AdGroupID,
CMP.AdGroupName,
ADG.Cost,
ADG.Clicks,
ADG.Impressions,
ADG.Interactions,
FROM `p_AdGroup_3355755821` as CMP
LEFT JOIN `p_AdGroupBasicStats_3355755821` as ADG 
ON CMP.AdGroupId = ADG.AdGroupId
LEFT JOIN `p_Campaign_3355755821` as BASE
ON CMP.CampaignId = BASE.CampaignId
WHERE ADG.Date >= DATE_ADD(CURRENT_DATE(), INTERVAL -31 DAY)
AND ADG.ExternalCustomerId = {yourid}
GROUP BY 1,2,3,4,5,6,7,8,9;

Conversions at Campaign + Ad Group level:

#standardSQL
SELECT
ADG.date,
CMP.CampaignId,
BASE.CampaignName,
CMP.AdGroupID,
CMP.AdGroupName,
ADG.ConversionTypeName,
ADG.Conversions
FROM `p_AdGroup_3355755821` as CMP
LEFT JOIN `p_AdGroupConversionStats_3355755821` as ADG 
ON CMP.AdGroupId = ADG.AdGroupId
LEFT JOIN `p_Campaign_3355755821` as BASE
ON CMP.CampaignId = BASE.CampaignId
WHERE ADG.Date >= DATE_ADD(CURRENT_DATE(), INTERVAL -31 DAY)
AND ADG.ExternalCustomerId = {yourid}
GROUP BY 1,2,3,4,5,6,7;

Thanks,
MJ

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/fe772a37-3dd3-4504-824a-2e1b321ebdb5n%40googlegroups.com.

Google Ads API query for ad_group_ad and keyword_view returns 0 records

[Ronak Shah]

Hello,

We have completed the Adowrds to GoogleAds Api migration.
We are using Google Ads API to get ad_group_ad and keyword_view report data 
by issuing a GAQL search query.
There are 2 accounts under our managerId: Once for web and one for mobile 
application.
When we issue a query we are able to get the data for the CustomerId for 
web account whereas the customerId for mobile App account returns 0 records.
We see that the customerId for which we are not getting any data ingested 
contains inactive campaigns. 
When we do backfills, the API is not returning any records even if the 
campaigns were active during the previous date range used in backfill, if 
those campaigns are inactive currently.
Is there a way to ingest data even for customerIds currently containing 
inactive campaigns that were active at some point in the past?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/c12320d0-d94f-4d73-bc10-1333fe88ad0fn%40googlegroups.com.

Re: How to retrieve underlying Google Ads API query from existing report?

[Google Ads API Forum Advisor]

Hi Piotr,

Thank you for your follow up. I'm also from the Google Ads API support team and 
allow me to assist you as well.

For campaign (search, videos, and others) level reporting, you can refer to the 
campaign report for all the available attributes, metrics and segments fields 
that you can extract using the Google Ads API. I also recommend that you user 
our Query builder and Query validator to help in constructing the queries 
before using them in your API requests.

Also, if my understanding is correct that you wish to map the fields from an 
existing (downloaded from UI) report to the API's fields, then this is not 
possible via an API request. You will have to map them manually and use the 
documentation I mentioned above to construct the queries.

As for unique users, this is currently not supported. However, our team has 
already previously created a feature request, subject for review, regarding its 
availability in the API. For now, you may keep an eye on our blog for updates 
or announcements.

Furthermore, for the list of fields that you sent over (ex. Performance -> 
Watch time), could you also provide the complete screenshot of the UI where all 
the said fields are visible? This is so that our team can create the feature 
request for the said fields.

Lastly, if the screenshot would contain your user / account information, you 
may then send the requested information via the Reply privately to author 
option. If this option is not available, you may send the details directly to 
our googleadsapi-supp...@google.com alias instead.

Best regards,

Peter Laurence Napa Oliquino
Google Ads API Team
ref:_00D1U1174p._5004Q2OSiEm: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 
"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/FzrOc0R06DZG003pUt5nx1RIqk8n4TN3Tvsg%40sfdc.net.

Re: How to retrieve underlying Google Ads API query from existing report?

[Newell DTC]

Hi Ernie

Thanks for the response. My use case is that business users defined a list 
of metrics they would like to be ingested into a data warehouse (based on 
what is visible in UI) and I wanted to use the Google Ads API to query for 
them. As for campaign types - basically Search and Video ones.

Could you also please check one more metric if it is available in the API?
1. Reach metrics -> Unique users.

Piotr

On Monday, September 27, 2021 at 3:54:54 AM UTC+2 adsapi wrote:

> Hi Piotr,
>
> It appears that the fields you've mentioned currently don't have 
> equivalent fields in the Google Ads API. With this, so that I can raise a 
> feature request to my team for these fields, could you provide a sample use 
> case why you need these fields? Also, could you clarify on what type of 
> campaign you want to retrieve this information?
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2OSiEm: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 
"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/44a4cea3-512a-4a08-8a4b-db33adba46a0n%40googlegroups.com.

Re: How to retrieve underlying Google Ads API query from existing report?

[Google Ads API Forum Advisor]

Hi Piotr,

It appears that the fields you've mentioned currently don't have equivalent 
fields in the Google Ads API. With this, so that I can raise a feature request 
to my team for these fields, could you provide a sample use case why you need 
these fields? Also, could you clarify on what type of campaign you want to 
retrieve this information?

Regards,

Ernie John Blanca Tacata
Google Ads API Team
ref:_00D1U1174p._5004Q2OSiEm: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 
"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/1yr2v0R02LB000Pgd-4f5TQsKj99o4DQ754g%40sfdc.net.

Re: How to retrieve underlying Google Ads API query from existing report?

[Newell DTC]

Hi Matt

Thank you for your answer. Would you be so kind and also provide API 
mappings for the following UI fields at Campaign level:
1. Performance -> Watch time.
2. Viewability -> Non-viewable impr.
3. Viewability -> Non-measurable impr.
4. Viewability -> Non-viewable impr. distrib.
5. Viewability -> Non-measurable impr. distrib.
6. Viewability -> Viewable CTR.
7. Viewability -> Viewable impr. distrib.
8. Conversions -> Orders.
9. Conversions -> Revenue.
10. Attributes -> Campaign group.
11. Attributes -> Campaign subtype.

They can be accessed from UI in this way:
1. Select some Google Ads account.
2. Expand Campaigns and click on Campaigns button.
3. Click on Columns button between the graph and the table.

Thanks in advance.

Piotr

On Wednesday, September 22, 2021 at 8:49:35 PM UTC+2 adsapi wrote:

> Hello,
>
> While it is not fully comprehensive, I would recommend looking over the 
> guide, Reports in the UI 
> . 
> In addition to other information, it provides the resources that map to 
> several predefined reports in the UI. Most attributes and metrics in API 
> reports are named similarly to their UI names. For your ad network example, 
> you can use the AdNetworkType 
> 
>  
> segment. If you have any specific questions, please let us know. 
>
> Regards,
> Matt
> Google Ads API Team
>
> [image: Google Logo] 
> Matt 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2OSiEm: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 
"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/431cb055-42ba-4208-824b-a0cf8cd61c73n%40googlegroups.com.

Re: How to retrieve underlying Google Ads API query from existing report?

[Google Ads API Forum Advisor]

Hello,

While it is not fully comprehensive, I would recommend looking over the guide, 
Reports in the UI. In addition to other information, it provides the resources 
that map to several predefined reports in the UI. Most attributes and metrics 
in API reports are named similarly to their UI names. For your ad network 
example, you can use the AdNetworkType segment. If you have any specific 
questions, please let us know.

Regards,
Matt
Google Ads API Team

Matt
Google Ads API Team
ref:_00D1U1174p._5004Q2OSiEm: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 
"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/rfJfO0QZUMY200jJzByDD-TUWQLwJdyu13fw%40sfdc.net.

Re: How to retrieve underlying Google Ads API query from existing report?

[Newell DTC]

Hi Ernie

Thanks for your response.

And how about the query for predefined reports without any 
customizations/changes? Is it available? I'm aware of this page 
(https://developers.google.com/google-ads/api/docs/query/cookbook#campaigns) 
but that query doesn't contain all fields from predefined Campaign report.

And another question: UI uses user-friendly names of various fields and 
metrics while API doesn't. Sometimes it is obvious how to map one field to 
another but sometimes it isn't, e.g. Targeting -> Network (with search 
partners). Is there any mapping available that translates UI field to API 
field?

Piotr

On Wednesday, September 22, 2021 at 5:08:25 AM UTC+2 adsapi wrote:

> Hi Piotr,
>
> Thank you for posting your concern.
>
> I am afraid that this is not possible as API could not access the query 
> and data in predefined reports made in the UI. You will need to construct 
> the GAQL manually based on the fields you've used in the Reports -> 
> Predefined (Dimensions) -> Basic section. The Google Ads Query Builder 
> 
>  
> could help you to build your query.
>
> Let me know if you have further questions.
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2OSiEm: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 
"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/af6951ce-3136-4d55-bcbc-bd332600da8en%40googlegroups.com.

RE: How to retrieve underlying Google Ads API query from existing report?

[Google Ads API Forum Advisor]

Hi Piotr,

Thank you for posting your concern.

I am afraid that this is not possible as API could not access the query and 
data in predefined reports made in the UI. You will need to construct the GAQL 
manually based on the fields you've used in the Reports -> Predefined 
(Dimensions) -> Basic section. The Google Ads Query Builder could help you to 
build your query.

Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata
Google Ads API Team
ref:_00D1U1174p._5004Q2OSiEm: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 
"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/dSzhP0QZTFDH00FpC6FKe9RweQEYVzuBAOXA%40sfdc.net.

How to retrieve underlying Google Ads API query from existing report?

[Piotr Tybulewicz]

Hi

Let’s say that I’ve used Google Ads UI (ads.google.com) to modify a bit a 
Campaign report that is available in Reports -> Predefined (Dimensions) -> 
Basic section. When I’m satisfied with the report layout, I would like to 
get the underlying GAQL query so I could use it to call the Google Ads API 
by mysefl. Is that query visible somewhere?

Thanks in advance,

Piotr

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/1f5e9dc2-732e-46fc-b7a0-5319aa6ab4f6n%40googlegroups.com.

RE: How to escape single quotes in Google Ads API query language?

[Google Ads API Forum Advisor Prod]

Hello,

Thank you for reaching out. Can you please modify the query so that outer 
single quotes are not escaped and retry the call?

Regards,
Matt
Google Ads API Team

Matt
Google Ads API Team
ref:_00D1U1174p._5004Q28otkR: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 
"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/HvbH70QL6WPM00907sW73aTCCoK2wqhBh1xQ%40sfdc.net.

How to escape single quotes in Google Ads API query language?

[Exos Solutions]

Hi everyone,

I am sending a query with the Google Ads API, in which I search for a 
product_brand that has single quotes and it returns the *BAD_VALUE *error.

This is the query that I send and the error that it returns: 

Request
---
MethodName: google.ads.googleads.v5.services.GoogleAdsService/SearchStream
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=xxx, 
x-goog-api-client=gl-java/11.0.3 gapic/ gax/1.57.0 grpc/1.30.0}
Body: customer_id: "xxx"
query: "SELECT ad_group.id, campaign.id, 
shopping_performance_view.resource_name,  metrics.impressions, 
metrics.clicks, metrics.cost_micros, metrics.average_cpc,  
 metrics.conversions_from_interactions_rate, 
metrics.cost_per_all_conversions,   metrics.search_click_share, 
metrics.search_impression_share,   metrics.all_conversions, 
metrics.conversions,   segments.ad_network_type,   segments.product_brand,  
 segments.product_item_id, segments.product_merchant_id,  
 segments.product_type_l1, segments.product_type_l2, 
segments.product_type_l3,   segments.product_type_l4, 
segments.product_type_l5  FROM shopping_performance_view   WHERE 
segments.product_brand = \'joe\'s\'  and segments.date BETWEEN 
\'2020-11-13\' AND \'2020-12-02\'"


Response

Headers: 
Metadata(content-type=application/grpc,request-id=0kZ5xU1wAU2rTjFt-9cHgg,date=Thu,
 
10 Dec 2020 07:36:29 GMT,alt-svc=h3-29=":443"; ma=2592000,h3-T051=":443"; 
ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; 
ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43")
Body: null
Failure message: errors {
  error_code {
query_error: BAD_VALUE
  }
  message: "Error in WHERE clause: invalid value \'."
}

Status: Status{code=INVALID_ARGUMENT, description=Request contains an 
invalid argument., cause=null}.

How can I escape *joe's* single quote? 

Thanks and regards,
Gloria Muñoz.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/f1707973-98e0-402a-99ed-9ae1bb418e04n%40googlegroups.com.

RE: How can i best make sense of the potential outcome for every 'Resource' in Google Ads API query?

[Google Ads API Forum Advisor Prod]

Hi Marco,

Thanks for reaching out. With regards to your concern, you can use reporting 
guide for understanding each field of the Resource.

Let me know if you have any questions.

Thanks,
Nirmita Patel Google Ads Team
ref:_00D1U1174p._5004Q20Xx43: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 
"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/dKgej0QBRTUC006AJFGEhETGmcnidKMidUeg%40sfdc.net.

How can i best make sense of the potential outcome for every 'Resource' in Google Ads API query?

[Marco Casucci]

Hello,

Please bare with me as I try to explain what I am looking for... I work in 
marketing and I am looking for a simple way to identify what each Resource, 
in the Interactive Query Builder tool 
,
 
will provide in terms of data, etc. In other words, what is the best 
possible way to identify and understand each Resource and/or reporting type 
available for me in Google Ad API and what each Field available per 
Resource based query, means?

Thanks,
MC

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/105ed6bc-f01c-4a10-a8ea-b20dfd818730o%40googlegroups.com.

Google Ads API. Query does not return DATE

[Inspired UM]

Hi,

I noticed that all segment fields (like DEVICE, DATE) do not return any 
values after v0.7 update.
My query looks like this:

query = ('SELECT campaign.name, campaign.id,  campaign.status, 
campaign.start_date, campaign.end_date, metrics.impressions, 
metrics.clicks, '
'metrics.ctr, metrics.average_cpc,  
metrics.all_conversions, metrics.cost_micros, segments.date, 
campaign.status,campaign.advertising_channel_type, segments.date '
'FROM campaign '
'WHERE segments.date DURING YESTERDAY')


Can you please advice how can I retrieve DATE field?

Thank you.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/d50c0da9-87dd-43fd-8b78-93a337465e2d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.