Overview
CUL Exhibits has a site-wide dashboard publicly viewable here: https://exhibits.library.cornell.edu/dashboard
Code: https://github.com/cul-it/exhibits-library-cornell-edu/blob/dev/public/dashboard.html
Embedded Looker Studios (formerly Google Data Studios) report: https://lookerstudio.google.com/u/0/reporting/c43e35ad-f829-4f54-8b8c-7554e7710ba3/page/glhpB
Documentation
Curator/admin documentation: https://wiki.lyrasis.org/display/SPOTLIGHT/Analytics+Dashboard
CUL-specific developer documentation: https://github.com/elrayle/spotlight_utils/wiki/Data-Studio-Dashboard
A couple of the fields and filters applied to the Looker Studios report are manually generated. Every time the following events occur, these fields or filters will need to be updated:
- Any exhibit is created, deleted, or updates its slug or title: DataStudio.exhibits_field
- Any admin page is created, deleted, or changes its route: DataStudio.admin_pages_field, DataStudio.exclude_admin_pages_filter
Step 1: SSH into the prod web server to run:
sudo su - webapp cd /var/app/current RAILS_ENV=production bundle exec rails c load 'scripts/data_studio.rb' DataStudio.exhibits_field
Step 2: Copy results into the Looker Studios field or filter definition.