Re: Google Analytics API v3 - Get data with c#

[GRodrigues]

Olá Bruno,

 

Estou com um problema semelhante. Preciso de extrair data do GA para SQL Server 2008.

 

Conseguiste arranjar alguma solução?

 

Um abraço,

Gonçalo

Sexta-feira, 14 de Setembro de 2012 16:06:33 UTC+1, bruno ortiz escreveu:

hi everybody, i was using the code to get data from google analytics api with c#, and tried to change to new version v3, but i dont know how to get de data in this new version v3, someone can help me? i´m sorry for my poor english.

thanks for any help.

            const string USERNAME = "MYUSER"; //Usuario

            const string PASSWORD = "MYPASSWORD"; //Senha

            const string dataFeedUrl = "https://www.googleapis.com/analytics/v3/data/";

            string profileId = ga;

            AnalyticsService service = new AnalyticsService("AnalyticsSampleApp");

            service.setUserCredentials(USERNAME, PASSWORD);

            DataQuery query = new DataQuery(dataFeedUrl);

            DataQuery query2 = new DataQuery(dataFeedUrl);

         

            int mesAtual = DateTime.Today.Month;

            int anoAtual = DateTime.Now.Year;            

            int mesAnterior = (mesAtual - 1);

            int diasMes = DateTime.DaysInMonth(2012, mesAnterior);

            query.Ids = profileId;            

            query.Metrics = "ga:visits,ga:visitors,ga:pageviews"; //pegar métricas

            query.Dimensions = "ga:date"; 

            query.Sort = "ga:date"; //Ordenar

            query.GAStartDate = DateTime.Now.AddDays(-7).ToString(2012+"-0"+mesAnterior +"-01");

            query.GAEndDate = DateTime.Now.ToString(2012 + "-0" + mesAnterior + "-" + diasMes);

[Mike Sullivan]

Check the docs...you can't use username/password (a.k.a. ClientLogin) with V3 API. You need to use Oauth.

[John Jones]

This is my v3 code to pull reports, profile xxxxx@developer.gserviceaccount.com needs to be a User on the account and not Admin

https://groups.google.com/forum/?fromgroups=#!topic/google-analytics-data-export-api/quIN0vX-psw

[Brian White]

How do you tell if a user is an administrator or not?

--
 
 

[John Jones]

From the Google Analytics dashboard  -> Account List -> Click on the account and you should see the user tab -> Role make sure the service account is a user.

--
 
 

[Til]

get code from below link for the new updation -
http://stackoverflow.com/questions/12527610/execution-of-request-failed-https-www-google-com-analytics-feeds-accounts-def