Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Accessing Google Analtyics with v3 client library is really nice tbh. The only thing i havent worked out is how to send it a refreshtoken i have stored in the database. Im stuck with the one it stores for me on the Pc. </p> <p>Request autentication: All the client scret stuff is stored in client_secret.json you can download the file from google apis consol. It will pop up a browser window if it doesnt have approval if it does it will just continue on.</p> <pre><code>private void Form1_Load(object sender, EventArgs e) { UserCredential credential; using (var stream = new System.IO.FileStream("client_secret.json", System.IO.FileMode.Open, System.IO.FileAccess.Read)) { credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, new[] { AnalyticsService.Scope.AnalyticsReadonly }, "user", CancellationToken.None, new FileDataStore("Analytics.Auth.Store")).Result; } </code></pre> <p>}</p> <p>Now to access Google Analytics you need to make an analytics Service.</p> <pre><code>AnalyticsService service = new AnalyticsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = "Analytics API sample", }); </code></pre> <p>All your calls will now be run against that. </p> <p>Yours should end up being something like:</p> <pre><code>DataResource.GaResource.GetRequest request = service.Data.Ga.Get(ga:34197921, new DateTime(2012, 1, 2).ToString("yyyy-MM-dd"), DateTime.Now.ToString("yyyy-MM-dd"), ""ga:visits,ga:visitors,ga:visitBounceRate,ga:goalStartsAll,ga:goalCompletionsAll,ga:goal1Starts,ga:goal1Completions,ga:goal2Starts,ga:goal2Completions,ga:goal3Starts,ga:goal3Completions,ga:goal4Starts,ga:goal4Completions,ga:adCost,ga:totalValue"); request.Dimensions = "ga:medium,ga:campaign,ga:date,ga:isMobile,ga:isTablet,ga:searchKeyword,ga:hostname"; </code></pre> <p>I have a blog post that runs though most of the diffrent calls you can make. <a href="http://daimto.com/google-analytics-api-v3-with-c/" rel="nofollow">http://daimto.com/google-analytics-api-v3-with-c/</a></p>
    singulars
    1. This table or related slice is empty.
    1. POGoogle c# Api, changing from v2.3 to v3
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDaImTo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGoogle c# Api, changing from v2.3 to v3
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for getting back to me :-) Your step by step article is excellent for newbie's like me! On thing I was wondering, I attempt to run the code after installing the relevant packages from NuGet and I get the following error: Could not load file or assembly 'Microsoft.Threading.Tasks.Extensions.Desktop, Version=1.0.16.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. Have you ever seen this before? The dll is definitely there and gets copied into the bin folder correctly at run time. Thanks!
      singulars
      1. PO
      1. USRob McCabe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload