Get empty campaign list with AWQL for production MCC with several more than 1000 active campaigns

2017-01-23 Thread km 
Hi all, 

I use Java examples and get standard access dev token for production MCC. I 
use standard lib from google and sample code to test basic moves. I 
followed guides for OAuth and API basics.

On test account I used sample GetCampaigns.java from github and tune it a 
little to get relevant data rows and find possible grouping issues. For 
test MCC I use my personal email. Same example with production credentials 
and my work email return empty list. I used typical scheme with client id 
and client secret. Make bind it to my account used for production MCC and 
create refresh token with sample RefreshToken.java from same rep. Put 
production's MCC client customer ID, and company name as suggested in one 
guide. Get empty list with AWQL request.

My first guess I don't have some right to access reporting and try to make 
service account for my needs. Next I grant it domain wide access rights and 
start trying to pose as different user in domain. It was a big quest to 
pass it java, there are no examples for this case in library but I found 
one in java docs for inner class example that I have to adapt. Typical 
example with service account return NO_ADS_USER. I fixed with example 
founded in Java doc for GoogleCredentials.Builder class. Different people 
in our domain have different rights for our MCC. I ried them all. Each time 
I get empty list. Whats is can be a catch? Problem with credentials? 
Problem with credential types (service account against id-secret pair give 
same result)? Problem with some access rights for API (we have standard 
level dev token and several analytics providers don't have problem to 
donwload our stats)? Problem with query? I'm out of Ideas.

In production our traders create performance campaigns for mobile and buy 
installs. We have about 1000+ campaigns This is my query that work for test 
account and don't work for production environment:

String query = "SELECT "
+ " CampaignStatus"
+ ",CampaignId"
+ ",CampaignName"
+ ",ExternalCustomerId"
+ ",CustomerDescriptiveName"
+ ",Amount"
+ ",BiddingStrategyId"
+ ",Impressions"
+ ",Conversions"
+ ",Cost"
+ ",CostPerAllConversion"
+ " FROM CAMPAIGN_PERFORMANCE_REPORT DURING LAST_7_DAYS";

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 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/49ea28d0-4f21-4a78-b973-ddc315361f33%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: AuthenticationError.NOT_ADS_USER with service account

2017-01-19 Thread km 
That property I need to set in case of Java? I filled up 
api.adwords.jsonKeyFilePath, api.adwords.clientCustomerId, 
api.adwords.developerToken 
but no person or anything close to this in config. 


понедельник, 27 октября 2014 г., 19:34:25 UTC+3 пользователь Anash P. 
Oommen (AdWords API Team) написал:
>
> Hi,
>
> You should also set oauth2_prn to identify the OAuth2 user. This should be 
> the login email of your AdWords account, or your AdWords MCC account. If 
> you are setting the email address of your AdWords account, 
> then client_customer_id should contain your AdWords account's CID. If you 
> are setting the email address of your AdWords MCC account, then 
> client_customer_id 
> should be beneath the MCC.
>
> Cheers,
> Anash P. Oommen,
> AdWords API Advisor.
>
> On Friday, October 24, 2014 8:01:18 AM UTC-4, Ismary Cruz wrote:
>>
>> I have a services account , I been trying to get adwords data without 
>> success. I have a MCC account.
>>
>> I followed, step by step, the user guide.
>>
>> I created the project, then I created new credentials. I selected 
>> 'services account' and generated public/secret key.
>>
>> I followed the guide to delegating domain-wide authority to the service 
>> account (I used https://www.googleapis.com/auth/adwords as scope).
>>
>> I got the authorization token without any problem. But when I try to call 
>> any service of Adwords, I got the same error: 
>>
>>
>> AdwordsApi::V201409::CampaignService::ApiException at ...
>> [AuthenticationError.NOT_ADS_USER @ ; trigger:'']
>>
>> This is my adwords_api.yml configuration:
>>
>> :authentication:
>>   :method: OAuth2_JWT
>>   :oauth2_client_id: 
>>   :oauth2_issuer: 
>>   :oauth2_keyfile: 
>>   :oauth2_secret: 
>>   :developer_token: 
>>   :client_customer_id: 
>>
>> :service:
>>   :environment: 'PRODUCTION'
>> :connection:
>>   :enable_gzip: false
>> :library:
>>   :log_level: DEBUG
>>
>>
>> Other informations: 
>> gem google-adwords-api (0.13.2)
>> gem oauth2 (1.0.0)
>> API versio v:201409
>>
>> For some reason my service account doesn't have permission for Adwords, 
>> although I had defined them as indicated it in the user guide.
>>
>> If you have any ideas, I will be very grateful you.
>>
>> Thanks in advanced,
>>
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 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/613fbdd7-931d-4090-8c84-7bac57c80dec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: API connection between Oracle and Adwords

2015-12-18 Thread KM 
Hi Michael

Thanks for your reply. I had a check, really useful. The field "costs" in 
the reporting is not really what I need. What we are looking for is to have 
the billing cost and not the costs mentioned in campaign report. 

Do you see what I means ?

Many thanks
Kevin

On Monday, 14 December 2015 19:00:44 UTC+1, Michael Cloonan (AdWords API 
Team) wrote:
>
> Hello,
>
> You can fetch statistics from the AdWords API using reporting 
> . For 
> example, the Campaign Performance Report 
> 
>  
> has statistics like clicks, impressions, and conversions broken down at the 
> campaign level. Here is a page indexing all of the available report types: 
> https://developers.google.com/adwords/api/docs/appendix/reports
>
> The reporting basics guide, linked above, will go into details on how to 
> filter, for example by last month or a custom time frame. There are also 
> examples of how to run reports in each client library 
> .
>
> Regards,
> Mike, AdWords API Team
>
> On Monday, December 14, 2015 at 8:58:24 AM UTC-5, Ketida wrote:
>>
>> Hi there
>>
>> I need your advice because I'm not a technical guy.
>>
>> We actually use a intern tool to manage our client orders, invoices, etc. 
>> The platform is developed in Oracle, Apex, Javascript,.. 
>>
>> Everything is managed manually which means that every months we input 
>> real costs spend in Adwords (via an Agency MCC) by our clients (amount that 
>> Google charges us and that we then charge to our client). The objective 
>> will then to add more metrics (conversions, CPA,...) but the priority is 
>> the media spend (not the costs but well the invoice spend). 
>>
>> Period time frame : last month.
>>
>> Is someone have more documentation about the process, which variables we 
>> have to call, which repetition, etc ? It will be really appreciate :)
>>
>> Thanks in advance for your advice/support
>>
>> K
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 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/b2cb8cb0-6c08-4bee-91e8-7306e03630b7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.