storm-googleanalytics-reporting

An abstraction over the Google Analytics v3 Reporting API, providing a clean, fluent method of querying analytics data.

Install

The library is available through NuGet...

install-package storm.googleanalytics.reporting

Usage

Lets get straight to an example.

public class MyData
{
    public DateTime Date { get; set; }
    public string Country { get; set; }
    public int Pageviews { get; set; }
    public int Visits { get; set; }
}

public static void Main(string[] args)
{
    var service = GoogleAnalyticsService.Create("serviceAccountId", "path/to/certificate");

    var result = service.Query(q => q
        .WithProfileId("1111111")
        .ForDateRange(DateTime.Today.AddDays(-1), DateTime.Today)
        .WithMetrics(GaMetadata.Metrics.PageTracking.PageViews, GaMetadata.Metrics.Session.Visits)
        .WithDimensions(GaMetadata.Dimensions.Time.Date, GaMetadata.Dimensions.GeoNetwork.Country)
        .FilterBy(GaMetadata.Dimensions.PlatformDevice.DeviceCategory, GaMetadata.FilterOperator.IsEqual, "tablet")
        .OrFilterBy(GaMetadata.Dimensions.PlatformDevice.DeviceCategory, GaMetadata.FilterOperator.IsEqual, "mobile")
        .SortBy(GaMetadata.Metrics.PageTracking.PageViews, true)
        );

    if (result.Success)
    {
        Console.WriteLine(result.Data.AsJson(true));

        var dt = result.Data.AsDataTable();

        IEnumerable<MyData> entities = result.Data.ToObject<MyData>();
    }
}

Obtaining a Service Account and Certificate

In order to access the Google Analytics Reporting API you must generate a service account using the Google Developers Console (https://console.developers.google.com). Within the console you need to create a project and generate a new "Client ID" credential with the "Service Account" application type.

Once created you will receive a certificate key file and an email address (this is your service account id).