Re: 403 forbidden when call google ads restful API

2021-08-10 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Anyway, I have sent a email to  googleadsapi-supp...@google.com 
 with all the details

Thanks
Daniel

在2021年8月10日星期二 UTC+8 下午3:14:45 写道:

> Hi Ernie, Yes, I haven't received any reply after I reply in private and 
> even I can not found my replies.
>
> To make the conversion more efficient. Can we talk it just in email?
> Please send email to dc...@marinsoftware.com
>
> Thanks,
> Daniel
> 在2021年8月10日星期二 UTC+8 下午2:05:14 写道:
>
>> Hi Daniel,
>>
>> Thank you for following up. It appears that you did not receive the reply 
>> of my colleague, Yasar. With this, allow me to reiterate the information 
>> that my colleague is requesting to further check the issue.
>>
>> "*For us to raise this issue with the rest of our team, could you please 
>> provide the user / email address you used when generated the OAuth2 
>> credentials? You may send the requested information via the Reply privately 
>> to author option. *"
>>
>> Regards,
>> [image: Google Logo] 
>> Ernie John Blanca Tacata 
>> Google Ads API Team 
>>   
>>
>> ref:_00D1U1174p._5004Q2Ll65G: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/1caf19ab-0659-4b2d-87f4-136ea3a53594n%40googlegroups.com.


Re: 403 forbidden when call google ads restful API

2021-08-10 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Hi Ernie, Yes, I haven't received any reply after I reply in private and 
even I can not found my replies.

To make the conversion more efficient. Can we talk it just in email?
Please send email to dc...@marinsoftware.com

Thanks,
Daniel
在2021年8月10日星期二 UTC+8 下午2:05:14 写道:

> Hi Daniel,
>
> Thank you for following up. It appears that you did not receive the reply 
> of my colleague, Yasar. With this, allow me to reiterate the information 
> that my colleague is requesting to further check the issue.
>
> "*For us to raise this issue with the rest of our team, could you please 
> provide the user / email address you used when generated the OAuth2 
> credentials? You may send the requested information via the Reply privately 
> to author option. *"
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2Ll65G: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/1aa0c25c-1726-415c-a731-e2eb9898d778n%40googlegroups.com.


Re: 403 forbidden when call google ads restful API

2021-08-09 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Thanks, I have send you the infos in private.

在2021年8月9日星期一 UTC+8 下午2:41:05 写道:

> Hi Daniel,
>
> Thanks for reaching out to us.
>
> Could you please provide us with the following information so we could 
> investigate further?
>
>1. Complete *Request* 
>
> 
> logs 
>2. Complete *Response* 
>
> 
> logs 
>3. Provide us the login-customer-id 
>
> If you haven't yet, logging can be enabled by navigating to the *Client 
> libraries > Your client library (ex. Java) > Logging* documentation, 
> which you can access from this *link* 
> . 
> 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.
>
> Regards, 
> [image: Google Logo] 
> Yasar Ramjan Makandar 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2Ll65G: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/ca6f7830-160d-4f49-b6f4-48ba488c44e8n%40googlegroups.com.


Re: 403 forbidden when call google ads restful API

2021-08-06 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
PS: It works fine when call AdWords API with the same credentials. Since no
need to pass the logInCustomerId in AdWords API.

'Daniel Chen' via AdWords API and Google Ads API Forum <
adwords-api@googlegroups.com> 于2021年8月6日周五 下午7:48写道:

> Hi,
>
> I am using the google ads restful API to download cost reports
> https://googleads.googleapis.com/v8/customers/$clientCustomerId
> /googleAds:searchStream
>
> I passed thhis in the headers: loginCustomerId is the mcc accountId
> "login-customer-id" -> loginCustomerId,
>
> Then I got the the following error in response:
> HTTP/1.1 403 Forbidden [Request-Id: u4KBpTrKotiCxn8Loh3__Q, Vary: Origin,
> Vary: X-Origin, Vary: Referer, Content-Type: application/json;
> charset=UTF-8, Content-Encoding: gzip, Date: Fri, 06 Aug 2021 10:20:31 GMT,
> Server: ESF, Cache-Control: private, X-XSS-Protection: 0, X-Frame-Options:
> SAMEORIGIN, X-Content-Type-Options: nosniff, Alt-Svc: h3=":443";
> ma=2592000,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",
> Transfer-Encoding: chunked]
>
> What's doing wrong here?
>
> Thanks,
> Daniel Chen
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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/371b91a2-2b93-4ab1-b1f8-a1015c2716b7n%40googlegroups.com
> <https://groups.google.com/d/msgid/adwords-api/371b91a2-2b93-4ab1-b1f8-a1015c2716b7n%40googlegroups.com?utm_medium=email_source=footer>
> .
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/CAJFPsReKicN6C%2Ba3%2Bz8kc9QS_uUv_mJB%3D7K%2BY%3DL4YQUjAGmJQA%40mail.gmail.com.


403 forbidden when call google ads restful API

2021-08-06 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Hi,

I am using the google ads restful API to download cost reports
https://googleads.googleapis.com/v8/customers/$clientCustomerId
/googleAds:searchStream

I passed thhis in the headers: loginCustomerId is the mcc accountId
"login-customer-id" -> loginCustomerId,

Then I got the the following error in response:
HTTP/1.1 403 Forbidden [Request-Id: u4KBpTrKotiCxn8Loh3__Q, Vary: Origin, 
Vary: X-Origin, Vary: Referer, Content-Type: application/json; 
charset=UTF-8, Content-Encoding: gzip, Date: Fri, 06 Aug 2021 10:20:31 GMT, 
Server: ESF, Cache-Control: private, X-XSS-Protection: 0, X-Frame-Options: 
SAMEORIGIN, X-Content-Type-Options: nosniff, Alt-Svc: h3=":443"; 
ma=2592000,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", 
Transfer-Encoding: chunked]

What's doing wrong here?

Thanks,
Daniel Chen

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/371b91a2-2b93-4ab1-b1f8-a1015c2716b7n%40googlegroups.com.


Why can not get adGroupCriterion.bidModifier and adGroupCriterion.qualityInfo.qualityScore in keyword_view

2021-07-01 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
 Hi,
I would like to get ad_group_criterion.quality_info.quality_score and 
ad_group_criterion.bid_modifier 
from keyword_view. But they are not appearing in the response result.

My query sql is like bellow:
SELECT
campaign.id,
ad_group.id,
ad_group_criterion.criterion_id,
ad_group_criterion.effective_cpc_bid_micros,
ad_group_criterion.position_estimates.first_page_cpc_micros,
ad_group_criterion.quality_info.quality_score,
ad_group_criterion.bid_modifier,
segments.date,
segments.device,
segments.ad_network_type,
metrics.clicks,
metrics.cost_micros,
metrics.impressions,
metrics.search_impression_share,
metrics.search_exact_match_impression_share,
metrics.search_rank_lost_impression_share,
metrics.top_impression_percentage,
metrics.absolute_top_impression_percentage,
metrics.search_top_impression_share,
metrics.search_absolute_top_impression_share
FROM keyword_view
WHERE segments.date BETWEEN 'START_DATE' AND 'END_DATE'
AND campaign.id in (CAMPAIGN_IDS)
AND metrics.impressions > 0

Results:
[{
"results": [
{
"campaign": {
"resourceName": "customers/5075447427/campaigns/11573139262",
"id": "11573139262"
},
"adGroup": {
"resourceName": "customers/5075447427/adGroups/116801381254",
"id": "116801381254"
},
"metrics": {
"clicks": "0",
"searchAbsoluteTopImpressionShare": 0.0999,
"searchExactMatchImpressionShare": 0.0999,
"searchImpressionShare": 0.0999,
"searchRankLostImpressionShare": 0.039585882910268051,
"searchTopImpressionShare": 0.0999,
"topImpressionPercentage": 0.50769230769230766,
"costMicros": "0",
"absoluteTopImpressionPercentage": 0.046153846153846156,
"impressions": "86"
},
"adGroupCriterion": {
"resourceName": "customers/5075447427/adGroupCriteria/116801381254~1380"
,
"qualityInfo": {
"qualityScore": 5
},
"positionEstimates": {
"firstPageCpcMicros": "96"
},
"criterionId": "1380",
"effectiveCpcBidMicros": "100"
},
"keywordView": {
"resourceName": "customers/5075447427/keywordViews/116801381254~1380"
},
"segments": {
"device": "MOBILE",
"adNetworkType": "SEARCH",
"date": "2021-06-19"
}
},
{
"campaign": {
"resourceName": "customers/5075447427/campaigns/11573139262",
"id": "11573139262"
},
"adGroup": {
"resourceName": "customers/5075447427/adGroups/116801381254",
"id": "116801381254"
},
"metrics": {
"clicks": "0",
"costMicros": "0",
"impressions": "8"
},
"adGroupCriterion": {
"resourceName": "customers/5075447427/adGroupCriteria/116801381254~10292761"
,
"qualityInfo": {
"qualityScore": 2
},
"positionEstimates": {
"firstPageCpcMicros": "127"
},
"criterionId": "10292761",
"effectiveCpcBidMicros": "100"
},
"keywordView": {
"resourceName": "customers/5075447427/keywordViews/116801381254~10292761"
},
"segments": {
"device": "TABLET",
"adNetworkType": "SEARCH_PARTNERS",
"date": "2021-06-19"
}
}
],
"fieldMask": 
"segments.date,campaign.id,adGroup.id,adGroupCriterion.criterionId,segments.device,segments.adNetworkType,metrics.clicks,metrics.costMicros,metrics.impressions,adGroupCriterion.effectiveCpcBidMicros,adGroupCriterion.positionEstimates.firstPageCpcMicros,adGroupCriterion.qualityInfo.qualityScore,metrics.searchImpressionShare,metrics.searchExactMatchImpressionShare,metrics.searchRankLostImpressionShare,metrics.topImpressionPercentage,metrics.absoluteTopImpressionPercentage,metrics.searchTopImpressionShare,metrics.searchAbsoluteTopImpressionShare,adGroupCriterion.bidModifier"
,
"requestId": "elzAkOfUkxxEq3YdtRRe0Q"
}
]

Thanks,
Daniel

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/1944f7a6-6c80-4b2b-a441-2c6a29b92825n%40googlegroups.com.


How to join multiple tables in GAQL?

2021-06-22 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Hi,
I want to get the campaign bid modifiers and campaign budge amount along 
with the keyword performance report. Can I join campaign and 
campaign_criterion tables?

SELECT
  segments.date,
  campaign.id,
  ad_group.id,
  ad_group_criterion.criterion_id,
  segments.device,
  segments.ad_network_type,
  metrics.clicks,
  metrics.cost_micros,
  metrics.impressions,
  ad_group_criterion.effective_cpc_bid_micros,
  ad_group_criterion.position_estimates.first_page_cpc_micros,
  ad_group_criterion.quality_info.quality_score,
  metrics.search_impression_share,
  metrics.search_exact_match_impression_share,
  metrics.search_rank_lost_impression_share,
  metrics.top_impression_percentage,
  metrics.absolute_top_impression_percentage,
  metrics.search_top_impression_share,
  metrics.search_absolute_top_impression_share,
  cr.bid_modifier,
  cp.campaign_budget.amount_micros
FROM keyword_view kv
LEFT JOIN campaign cp ON (cp.campaign.id = kw.campaign.id)
LEFT JOIN campaign_criterion cr ON (cr.criterion_id = cp.campaign.id)
  WHERE segments.date BETWEEN '2021-04-01' AND '2021-04-01'
AND campaign.id in (1053569228,9444625651)
AND metrics.impressions > 0

The query validator here reports errors:
https://developers.google.com/google-ads/api/fields/v8/query_validator
*The input provided in the FROM clause, 'keyword_view kv LEFT JOIN campaign 
cp ON (cp.campaign.id = kw.campaign.id) LEFT JOIN campaign_criterion cr ON 
(cr.criterion_id = cp.campaign.id)', is not a valid resource.*
   
What's going wrong here? How should I do this?

Thanks,
Daniel

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/3d6ba1c8-dff7-4eb5-9068-7534832a50b2n%40googlegroups.com.


Some questions about download performance report via google ads api restful endpoint

2021-06-21 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Hi there,
I have some questions when trying to download performance report via google 
ads api, restful endpoint: https://googleads.googleapis.com/v8/customers/$
clientCustomerId/googleAds:searchStream
My query is like bellow:























*SELECT segments.date, campaign.id , ad_group.id 
, ad_group_criterion.criterion_id, segments.device, 
segments.ad_network_type, metrics.clicks, metrics.cost_micros, 
metrics.impressions, ad_group_criterion.effective_cpc_bid_micros, 
ad_group_criterion.position_estimates.first_page_cpc_micros, 
ad_group_criterion.quality_info.quality_score, 
metrics.search_impression_share, 
metrics.search_exact_match_impression_share, 
metrics.search_rank_lost_impression_share, 
metrics.top_impression_percentage, 
metrics.absolute_top_impression_percentage, 
metrics.search_top_impression_share, 
metrics.search_absolute_top_impression_shareFROM keyword_viewWHERE 
segments.date BETWEEN 'START_DATE' AND 'END_DATE' AND campaign.id 
 in (CAMPAIGN_IDS) AND metrics.impressions > 0*

The return result is a json string like this:
*[*


















































































* { "results": [ { "campaign": { "resourceName": 
"customers/2786116170/campaigns/1053569228", "id": "1053569228" }, 
"adGroup": { "resourceName": "customers/2786116170/adGroups/53369497842", 
"id": "53369497842" }, "metrics": { "clicks": "0", 
"searchAbsoluteTopImpressionShare": 0.625, 
"searchExactMatchImpressionShare": 0.875, "searchImpressionShare": 0.875, 
"searchRankLostImpressionShare": 0.125, "searchTopImpressionShare": 0.875, 
"topImpressionPercentage": 1, "costMicros": "0", 
"absoluteTopImpressionPercentage": 0.7142857142857143, "impressions": "7" 
}, "adGroupCriterion": { "resourceName": 
"customers/2786116170/adGroupCriteria/53369497842~1298530505", 
"positionEstimates": { "firstPageCpcMicros": "18" }, "criterionId": 
"1298530505", "effectiveCpcBidMicros": "100" }, "keywordView": { 
"resourceName": "customers/2786116170/keywordViews/53369497842~1298530505" 
}, "segments": { "device": "DESKTOP", "adNetworkType": "SEARCH", "date": 
"2020-10-11" } }, { "campaign": { "resourceName": 
"customers/2786116170/campaigns/1053569228", "id": "1053569228" }, 
"adGroup": { "resourceName": "customers/2786116170/adGroups/53369497842", 
"id": "53369497842" }, "metrics": { "clicks": "3", 
"searchAbsoluteTopImpressionShare": 0.83337, 
"searchExactMatchImpressionShare": 1, "searchImpressionShare": 1, 
"searchRankLostImpressionShare": 0, "searchTopImpressionShare": 1, 
"topImpressionPercentage": 1, "costMicros": "209", 
"absoluteTopImpressionPercentage": 0.83337, "impressions": "6" 
}, "adGroupCriterion": { "resourceName": 
"customers/2786116170/adGroupCriteria/53369497842~296824961709", 
"positionEstimates": { "firstPageCpcMicros": "14" }, "criterionId": 
"296824961709", "effectiveCpcBidMicros": "69" }, "keywordView": { 
"resourceName": 
"customers/2786116170/keywordViews/53369497842~296824961709" }, "segments": 
{ "device": "DESKTOP", "adNetworkType": "SEARCH", "date": "2020-10-11" } } 
], "fieldMask": "segments.date,campaign.id 
,adGroup.id,adGroupCriterion.criterionId,segments.device,segments.adNetworkType,metrics.clicks,metrics.costMicros,metrics.impressions,adGroupCriterion.effectiveCpcBidMicros,adGroupCriterion.positionEstimates.firstPageCpcMicros,adGroupCriterion.qualityInfo.qualityScore,metrics.searchImpressionShare,metrics.searchExactMatchImpressionShare,metrics.searchRankLostImpressionShare,metrics.topImpressionPercentage,metrics.absoluteTopImpressionPercentage,metrics.searchTopImpressionShare,metrics.searchAbsoluteTopImpressionShare",
 
"requestId": "8UVf4B6uosuLVrb5t9Fk8A" }]*

My questions are:
1) Can we get a result as xml or csv format? if yes, how to pass the 
parameter?
2) In the json result, some values are not string, this made it hard to 
parser it.
*searchAbsoluteTopImpressionShare": 0.625,*
3) The json node have multiple levels, 
like adGroupCriterion.positionEstimates.effectiveCpcBidMicros, can we get a 
normalized json node which has only 2 levels. I have tried using "AS" to 
rename the query columns, but it does not work.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 

Re: OAuth 2.0 Playground

2021-06-21 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Including this header is equivalent to choosing an account in the Google
Ads UI after signing in or clicking on your profile image at the top-right
corner of the page. When specifying the customer ID, be sure to remove any
hyphens (—), for example: 1234567890, not 123-456-7890.

Test Testoviy  于2021年6月21日周一 下午8:22写道:

> Hello, please tell me how I can request an API from the Google ADS service
> (google advertising), I'm trying to get an API in the format JSON, for the
> start, got all, but in the list of opieration got this message (when step
> 3  Configure request to API)
> Available operations
> Unfortunately no listed API operations were found for your access token.
> When I make a request with my own link, I have this answer from OAuth 2.0
> playgroung
> (for example
> https://googleads.googleapis.com/v8/customers/999-999-/paymentsAccounts
> )
> "error": {
> "status": "INVALID_ARGUMENT",
> "message": "Request contains an invalid argument.",
> "code": 400,
> "details": [
>   {
> "errors": [
>   {
> "errorCode": {
>   "requestError": "DEVELOPER_TOKEN_PARAMETER_MISSING"
> },
> "message": "developer-token parameter is missing."
>   }
> ],
> "@type": "
> type.googleapis.com/google.ads.googleads.v8.errors.GoogleAdsFailure",
> Can you explain how it work,  because i can't undrestand what request
> should i make.
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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/ac8d1798-4871-4863-adda-2184e112294bn%40googlegroups.com
> 
> .
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/CAJFPsRciYZOS6dR87%3DAGnPegbHjRvJQ%2BtR5PAQ4L7Ne%3DHxNOpA%40mail.gmail.com.


Re: Google Ads API Insufficient authentication scopes error

2021-06-20 Thread 'Daniel Chen' via AdWords API and Google Ads API Forum
Hi Sriram,

Are you using restful API or client libraries?
I have tried the restful API and get the reports successfully.
Some notes might be helpful for you:
1) The clientCustomerId is a long value, not a string, without "-"
2) Need to pass the login-customer-id=6642246847 if the account is marin
mcc account.
3) Access token has a prefix "Bearer "

Thanks,
Daniel

Sriram Sivaraman  于2021年6月20日周日 上午1:01写道:

> Hello, I am trying to use the Google Ads API to try and get reports from
> Google ADs.
> I am using the code similar to this.
> https://developers.google.com/google-ads/api/docs/reporting/example
> I also have a basic access to the Google Ads Account.
> Everytime I run the script to get reports I get the following error.
> status = StatusCode.PERMISSION_DENIED
> "Request had insufficient authentication scopes.","grpc_status":7
>
> I have also turned the Google Ads Scope in Google Cloud but still getting
> the same error.
> Can someone please help me with this?
> Regards,
> Sriram
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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/76f5186a-be84-41ee-8d19-90aa5a7a6463n%40googlegroups.com
> 
> .
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/CAJFPsRfCTYyT5-jrhd5TDMDfMiZiyf9iF8CbGS7KMjxcNC3LNQ%40mail.gmail.com.