Pull Visit Data for external analysis

We are trying to pull our collected visitor data across a few hundred sites so that we can perform aggregate visitor analysis across sites, among other things. What is the best process for us to be pull out the raw visit information we need? The visitor logs are not indexed in such a way that the data retrieval is reasonably quick.

The current best way to fetch this data is to use the Live API, which can be slow if you need to export Gb of data: Reporting API Reference: API Reference - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3