Skip to main content
  1. Home
  2. Apps
  3. content-data-api
Warning This document has not been updated for a while now. It may be out of date.
Last updated: 22 Apr 2024

content-data-api: Set up Google Analytics credentials in development

To import data from Google Analytics, you must set some environment variables.

Create the file config/local_env.yml if it does not already exist. This file will contain the environment variables for Google Analytics.

N.B. This file has been added to .gitignore, so you don't need to worry about accidentally checking it in.

GA4 analytics

Add an entry to config/local_env.yml for each of the following:

  • BIGQUERY_PROJECT
  • BIGQUERY_CLIENT_EMAIL
  • BIGQUERY_PRIVATE_KEY

You can copy the credentials from the AWS Secrets Manager under content-data-api/ga4.

e.g.

BIGQUERY_PROJECT: "bigquery-project-name"

This will make "bigquery-project-name" available as ENV["BIGQUERY_PROJECT"]. These variables are used to authenticate and create the BigQuery client.

BIGQUERY_PROJECT is the project ID in the Google Cloud console.

See "Option Three" in Rails Environment Variables for more information

Update facts table with GA metrics

To populate GA metrics for a given day, open a Rails console and run:

> GA.process(Date.today)

It is recommended you disable logging to speed up the process:

Google::Apis.logger.level = Logger::ERROR
ActiveRecord::Base.logger = nil