analytics.js

// Description
//   A hubot script to get google analytics reports
//
// Configuration:
//   GOOGLE_API_CLIENT_EMAIL
//   GOOGLE_API_PRIVATE_KEY
//
// Commands:
//   analytics profiles - Shows profiles to which the bot has access
//   analytics pageviews 123123123 - Shows pageviews and visits of website with id 123123123
//   analytics devices 123456 - Get percentage mobile x desktop access of website with id 123456
//   analytics browsers 654321 - Get browsers percentage access with id 654321
//   analytics email - Get email account api configured to give access to others analytics profiles.
//
// Notes:
//   <optional notes required for the script>
//
// Author:
//   Plan B Comunicação <dev@planb.com.br>

var google = require("googleapis");
require("date-utils");

var analytics = google.analytics("v3");
var globalError;

module.exports = function(robot) {

  try {
    var GOOGLE_API_CLIENT_EMAIL = process.env.GOOGLE_API_CLIENT_EMAIL;
    var GOOGLE_API_PRIVATE_KEY = process.env.GOOGLE_API_PRIVATE_KEY.replace(/\\n/g, "\n");

    var oauth2Client = new google.auth.JWT(GOOGLE_API_CLIENT_EMAIL, null, GOOGLE_API_PRIVATE_KEY, ["https://www.googleapis.com/auth/analytics.readonly"], null);
  } catch(err) {
    globalError = "Error on load - check your environments variables GOOGLE_API_CLIENT_EMAIL and GOOGLE_API_PRIVATE_KEY.";
  }

  robot.hear(/analytics profiles/, function(res)
  {
    if(globalError) {
      return res.reply(globalError);
    }
    oauth2Client.authorize(function(err)
    {
      analytics.management.profiles.list(
        {
          auth: oauth2Client,
          accountId: "~all",
          webPropertyId: "~all"
        },
        function(err, entries) {
          if (err) {
            return res.reply(err);
          }

          var response = entries.items.map(function(item) {
            return item.id + " - " + item.name;
          }).join("\n");

          return res.reply(response);
        }
      );
    });
  });


  robot.hear(/analytics pageviews\s+(\d+)/i, function(res)
  {
    var siteId = res.match[1];
    var today = Date.today();
    var startDate = today.removeDays(30).toYMD("-");
    var endDate = today.toYMD("-");

    if(globalError) {
      return res.reply(globalError);
    }
    oauth2Client.authorize(function(err)
    {
      analytics.data.ga.get({
        auth: oauth2Client,
        "ids": "ga:"+siteId,
        "start-date": startDate,
        "end-date": endDate,
        "metrics": "ga:visits, ga:pageviews"
      },
      function(err, entries) {
        if (err) {
          console.log(err);
          return res.reply(err);
        }
        var visits = entries.totalsForAllResults["ga:visits"];
        var pageviews = entries.totalsForAllResults["ga:pageviews"];
        var profileName = entries.profileInfo.profileName;

        return res.reply(profileName+": "+visits+" visits and "+pageviews+" pageviews.");
      });
    });
  });


  robot.hear(/analytics devices?\s+(\d+)/i, function(res)
  {
    var siteId = res.match[1];
    var today = Date.today();
    var startDate = today.removeDays(30).toYMD("-");
    var endDate = today.toYMD("-");

    if(globalError) {
      return res.reply(globalError);
    }
    oauth2Client.authorize(function(err)
    {
      analytics.data.ga.get({
        auth: oauth2Client,
        "ids": "ga:"+siteId,
        "start-date": startDate,
        "end-date": endDate,
        "metrics": "ga:sessions",
        "dimensions": "ga:deviceCategory"
      },
      function(err, entries) {
        if (err) {
          console.log(err);
          return res.reply(err);
        }

        var total = parseInt(entries.totalsForAllResults['ga:sessions'])
        var result = entries.rows.map(function(item) {
          var percentage = (parseInt(item[1]) / total) * 100;
          return item[0] + " - " + item[1] + " sessions (" + (percentage.toFixed(2)) + "%)";
        }).join("\n");

        return res.reply(result);
      });
    });
  });

  robot.hear(/analytics browsers?\s+(\d+)/i, function(res)
  {
    var siteId = res.match[1];
    var today = Date.today();
    var startDate = today.removeDays(30).toYMD("-");
    var endDate = today.toYMD("-");

    if(globalError) {
      return res.reply(globalError);
    }
    oauth2Client.authorize(function(err)
    {
      analytics.data.ga.get({
        auth: oauth2Client,
        "ids": "ga:"+siteId,
        "start-date": startDate,
        "end-date": endDate,
        "metrics": "ga:sessions",
        "dimensions": "ga:browser",
        "sort": "-ga:sessions"
      },
      function(err, entries) {
        if (err) {
          console.log(err);
          return res.reply(err);
        }

        // console.log(entries);
        var total = parseInt(entries.totalsForAllResults['ga:sessions'])
        var result = entries.rows.map(function(item) {
          var percentage = (parseInt(item[1]) / total) * 100;
          return item[0] + " - " + item[1] + " sessions (" + (percentage.toFixed(2)) + "%)";
        }).join("\n");

        return res.reply(result);
      });
    });
  });

  robot.hear(/analytics email/i, function(res)
  {
    return res.send(GOOGLE_API_CLIENT_EMAIL||"Blank - you must config your environment variables.");
  });

};