How do I export the Raw data from Matomo (users, actions, clicks)?

Matomo Analytics is designed to ensure full data ownership and easy access to your data. You can export RAW data (users, actions, clicks) using the following methods:

  • BigQuery & Data Warehouse Export – Exports data directly from Matomo’s database in a structured format for analysis in BigQuery or other data warehouses. Learn how to set up the data warehouse export (Cloud only).
  • HTTP API Data Export – Retrieves data via Matomo’s API for integration with external tools (Cloud and On-premise).
  • Direct Database Export – Extracts raw data directly from the Matomo database for custom processing (On-premise only).

This guide explains how to use the Live.getLastVisitsDetails API to access RAW visit data.

We offer many APIs which let you get all of your data, and one API in particular that lets you get all of the RAW data is Live.getLastVisitsDetails, listed here: developer.matomo.org/api-reference/reporting-api#Live

You can use this API to download the data for a given website (or all websites), for given day / week / month / year (or all-time), and you can even specify a Custom Segment to filter out the data and return only the users that match a particular criteria.

If there is any data that you cannot export via our standard APIs, you may want to consider the Custom Reports premium feature which lets you create any report based on your requirements in seconds. It is our mission to help you keep full control of your data!

See also: How do I make the Matomo Analytics data available to my data warehouse?

Previous FAQ: How do I make the Matomo Analytics RAW data available to my data warehouse?