Skip to main content

Application: content-data-api

Data warehouse that stores content and content metrics to help content owners measure and improve content on GOV.UK

AWS, on the backend machine class
Rake tasks
Integration, Staging or ⚠️ Production ⚠️

Imported documents


A data warehouse that stores content and content metrics, and exposes this information via an API, to help content owners measure and improve content on GOV.UK.

Data is combined from multiple sources, including Publishing API, Feedback and Google Analytics.

Live examples


  • Data warehouse - The database where we store all the metrics
  • Fact - A record containing measurements/metrics
  • Dimension - A characteristic that provides context for a fact (such as the time it was extracted, or the content item it belongs to)
  • Star schema - The way we structure data in the data warehouse using fact and dimension tables
  • ETL (extract, transform, load) - How we get data into the data warehouse

Technical documentation

This is a Ruby on Rails app, and should follow our Rails app conventions.

You can use the GOV.UK Docker environment to run the application and its tests with all the necessary dependencies. Follow the usage instructions to get started.

Use GOV.UK Docker to run any commands that follow.

Running the test suite

To run the test suite:

bundle exec rake

Further documentation


MIT License