Columbia Daily Spectator Analytics

Automates Columbia Daily Spectator Weekly Analytics Report generation using Google Analytics Reporting and Google Docs APIs. See CDS Weekly Report Guide for more info.

Key Files

• index.js

  • Main file

• auth.js

  • Handles authorization for Google APIs

• processData.js

  • Generates Columbia Daily Spectator Weekly Report Data for each journalism section through Google Analytics API v4

• requestBodies.js

  • Functions to create JSON objects for Google Analytics API Queries

• outputFunctions.js

  • Handles formatting and output of corresponding Google Analytics request body

• googleDocs.js

  • Functions which merge Google Analytics data with Weekly Report Template.

Built With

• Google Analaytics Reporting API v4
• Google Docs API v1

Authors

• Andrew Sirenko - Initial work - AndrewSirenko

Acknowledgments

• Thank you to Columbia Daily Spectator's Engagement Team for being the friendliest faces on campus :)