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