Google Analytics Management
Adding Google Analytics to the OntoPortal Virtual Appliance
BioPortal uses the Google API to process our website data.
If you want to use the Google in your OntoPortal site, you will need a Google developer account to use the Google API, and a Google Analytics account to see the analytics. The Google API is used to process the web site’s data.
Google Developer Account
You can create an account at https://console.developers.google.com/project
. Use the following steps to do so.
- Create an account
- Generate credentials (p12 key & email) and save it for later
- API Manager > Credentials > Add credentials > Service account
- Note: default password of the p12 keys is notasecret
- Enable Analytics API
- API Manager > Overview > Advertising APIs > Analytics API
- Copy p12 keys to the appliance (in the /srv directory for example)
- Example:
scp myontoportal-analytics.p12 {my_appliance_hostname}:/srv/ontoportal/virtual_appliance/config/ncbo_cron
- Example:
Google Analytics Account
You use Google Analytics to get your website’s data.
- Create an account at
https://www.google.com/analytics/web
- Add the “tracking ID” of this account in ` vim /srv/ontoportal/virtual_appliance/appliance_config/site_config.rb`
- Example:
$ANALYTICS_ID = "UA-12345678-1"
- Example:
- Give permission to your developer credential (previously generated at the Google Developer Account step) to be able to retrieve the data
- Admin tab > Property (typically, the website you are doing analytics on) > User Management
- Add permissions for the google developer credential email (also generated in the previous section)
- Modify
/srv/ontoportal/virtual_appliance/appliance_config/ncbo_cron/config/config.rb
# Google Analytics config
config.enable_ontology_analytics = true
config.cron_ontology_analytics = '30 */4 * * *'
config.analytics_service_account_email_address = 'myontoportal@developer.gserviceaccount.com'
config.analytics_path_to_key_file = 'config/myontoportal-analytics.p12'
config.analytics_profile_id = 'ga:1234567'
config.analytics_app_name = 'MyOntoPortal'
config.analytics_app_version = '1.0.0'
config.analytics_start_date = '2020-01-01'
config.analytics_filter_str = ''
- Perform deployment of UI, API and ncbo_cron which will copy configuration files to the appropriate application directories
sudo su - ontoportal cd /srv/ontoportal/virtual_appliance/deployment ./setup_deploy_env.sh ./deploy_ui.sh ./deploy_ncbo_cron.sh
Enabling Analytics Cron Job
The Analytics data is stored in Redis data store and is scheduled to be refreshed weekly. The refresh is done via an automatically scheduled Cron job. By default, that Cron job is disabled in the OntoPortal Appliance. Below are the steps to enable the Analytics refresh job:
- Restart ncbo_cron services:
sudo systemctl stop ncbo_cron sudo systemctl start ncbo_cron
By default, the Analytics refresh job is scheduled to run on Mondays at 12:15am. If you need to change the frequency or the run time, you can add the parameter:
config.cron_ontology_analytics = "your cron expression"
to theNcboCron.config do |config|
block:config.cron_ontology_analytics = "15 0 * * 1"
If you modify this setting, be sure to restart ncbo_cron services (see previous step).
If you need to manually refresh the Analytics data without having to wait for the Cron job to execute, you can run the ncbo_ontology_analytics_rebuild
script, located in the ncbo_cron/bin
folder:
# sudo su - ontoportal
# cd /srv/ontoportal/ncbo_cron
# ./bin/ncbo_ontology_analytics_rebuild
Note that this script DOES NOT exist in Virtual Appliance versions prior to v3.0.2!
The script does not require any arguments; simply execute it, and your Analytics data will get pulled from Google Analytics into the Redis datastore and will be immediately picked up by your OntoPortal services. Note that this step is optional. It should be used only when you need the absolute latest Analytics data, and you don’t want to wait until the Analytics Cron job gets executed.
Tests using API explorer
Relevant links are
- https://developers.google.com/apis-explorer/#search/analytics/m/analytics/v2.4/analytics.data.get
- https://ga-dev-tools.appspot.com/query-explorer/
id = ga:111821946
start-date = 30daysAgo
end-date = yesterday
metrics = ga:pageviews
dimensions = ga:pagePath,ga:year,ga:month
filters
Removing Analytics from OntoPortal UI
In /srv/ontoportal/bioportal_web_ui/current/app/views/home/index.html.haml
add:
display: none;
%fieldset{style: "display: none;"}
%legend
Ontology Visits #{"in full #{$SITE} " if at_slice?} (#{@analytics.date.strftime("%B %Y")})
In /srv/ontoportal/bioportal_web_ui/current/app/views/ontologies/_visits.html.haml
add:
display:none;
#visits_content{:style => "margin: 2em 1em 0;"}