Digest for adsense-api@googlegroups.com - 10 Messages in 3 Topics

  Today's Topic Summary

Group: http://groups.google.com/group/adsense-api/topics

• Error while accessing AdSense data through API (BigQuery) with server2server authentication [5 Updates]
• google adsense not displaying reports since 3 hours, anyone having the same problem? [2 Updates]
• ::Error - User does not have an AdSense account. [403]:: [3 Updates]

 Error while accessing AdSense data through API (BigQuery) with server2server authentication

"A. Burchert" <a.burchert@scasoft.de> Jul 09 10:42PM -0700  

Hi everyone,
 
I tried to access the AdSense data of a project with the experimental
approach via BigQuery which returns an error: "Unexpected. Please try
again.". For testing I used the query example stated here<https://developers.google.com/adsense/bigquery>
:
 
> SELECT date, SUM(earnings) FROM
> [google.com:adsense-reports:Reports.DailyReport] GROUP BY date
 
Executing this in the BigQuery browser tool produces the expected results.
To ensure my authentication works and I have access to BigQuery I executed
a query using the sample data which returned without errors:
 
> SELECT word FROM [publicdata:samples.shakespeare] WHERE word="sleep"
 
Does anyone else tried this approach and can share experiences?
 
Further information: I'm using the php googe lib with
Google_BigqueryService(), using a server2server authentication
Scopes: 'https://www.googleapis.com/auth/bigquery',
'https://www.googleapis.com/auth/bigquery.readonly',
'https://www.googleapis.com/auth/adsense'
Failing job: job_034df770bf77401d91613240a4cfb0f6
 
Thanks in advance!


 

Louis Collard <louis.collard1@gmail.com> Jul 10 06:38AM -0700  

So to clarify - running the query in the BigQuery browser tool does work as
expected?
 
It's only when using the server2server authentication that you're having
problems?
 
Are you authenticating as the same user in both situations?
 
On Wednesday, July 10, 2013 6:42:47 AM UTC+1, A. Burchert wrote:


 

"A. Burchert" <a.burchert@scasoft.de> Jul 10 07:33AM -0700  

Exactly.
If I login to the account connected to AdSense, which is the owner of the
google project, and run the command by hand in the browser tool I get the
expected result.
Using a service account with server2server authentication I receive the
error.
 
I tried to access the AdSense Management API with the service account too
but received "User is not registered to AdSense" (or something like that,
don't remember exactly).
 
Am Mittwoch, 10. Juli 2013 15:38:50 UTC+2 schrieb Louis Collard:


 

Louis Collard <louis.collard1@gmail.com> Jul 10 10:00AM -0700  

Right - you have to access the AdSense BigQuery tables with an account that
you can log in to AdSense with, this is the same as with the Management API.
 
Can you use a different type of authentication?
 
On Wednesday, July 10, 2013 3:33:11 PM UTC+1, A. Burchert wrote:


 

"A. Burchert" <a.burchert@scasoft.de> Jul 10 10:58PM -0700  

This is the setup of accounts and what I tried so far:
 
Google Account X: Owner of Project XX, Owner of AdSense
BigQuery
> s2s: does not work
> with a Client ID for web applications: no sufficient permission
AdSense Management API
> s2s: does not work
> with a Client ID for web applications: works
 
Google Account Y: Owner of Project YY, can access AdSense of X
BigQuery
> browser: worked
> s2s: does not work
AdSense Management API
> s2s: does not work
 
What makes me wonder is: why can I access BigQuery with s2s but then cannot
access the adsense database?
And which other authentication can I try? I probably won't be able to
access the database too I guess?
 
Warning: Very few Google APIs currently support Service Accounts. Service
> Google URL Shortener
> Google OAuth 2.0 Authorization Server
> Google BigQuery
 
Am Mittwoch, 10. Juli 2013 19:00:27 UTC+2 schrieb Louis Collard:


 

 google adsense not displaying reports since 3 hours, anyone having the same problem?

Maria Shan <mariashanin@gmail.com> Jul 10 05:35AM -0700  

google adsense not displaying reports since 3 hours, anyone having the same
problem?


 

"Jose Alcérreca (AdSense API Team)" <adsenseapiadvisor+jose@google.com> Jul 10 06:27AM -0700  

Hi there,
 
Can you please send us the account you're using so that we can chase the
error?
 
Thank you!
Jose
 
---
Jose Alcérreca
Developer Relations
 
Google UK Limited
Registered Office: Belgrave House, 76 Buckingham Palace Road, London SW1W
9TQ
Registered in England Number: 3977902
 
On Wednesday, 10 July 2013 13:35:16 UTC+1, Maria Shan wrote:


 

 ::Error - User does not have an AdSense account. [403]::

hkaup@everydayhealthinc.com Jul 08 12:50AM -0700  

I have been pulling Adsense data for over an year now...Today I am getting
an error
 
Google.Apis.Requests.RequestError
User does not have an AdSense account. [403]
Errors [
Message[User does not have an AdSense account.] Location[ - ]
Reason[noAdSenseAccount] Domain[global]
]
 
 
Can anyone help?


 

"Jose Alcérreca (AdSense API Team)" <adsenseapiadvisor+jose@google.com> Jul 10 01:29AM -0700  

Hi there,
 
Can you send us the account you are using to authenticate so we can have a
look?
 
Thanks!
Jose
---
 
Jose Alcérreca
Developer Relations
 
Google UK Limited
Registered Office: Belgrave House, 76 Buckingham Palace Road, London SW1W
9TQ
Registered in England Number: 3977902
 
 


 

"Jose Alcérreca (AdSense API Team)" <adsenseapiadvisor+jose@google.com> Jul 10 02:29AM -0700  

Hi again,
 
We had an transient issue yesterday, but it should be fixed now. Can you
check that everything is working again?
 
Thanks!
Jose
 
---
Jose Alcérreca
Developer Relations
 
Google UK Limited
Registered Office: Belgrave House, 76 Buckingham Palace Road, London SW1W
9TQ
Registered in England Number: 3977902
 
 
 
On Wednesday, 10 July 2013 09:29:19 UTC+1, Jose Alcérreca (AdSense API
Team) wrote:


 

You received this message because you are subscribed to the Google Group adsense-api.
You can post via email.
To unsubscribe from this group, send an empty message.
For more options, visit this group.

--
You received this message because you are subscribed to the Google Groups "AdSense API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adsense-api+unsubscribe@googlegroups.com.
To post to this group, send email to adsense-api@googlegroups.com.
Visit this group at http://groups.google.com/group/adsense-api.
For more options, visit https://groups.google.com/groups/opt_out.