How to Export CSV Data from Matomo and Import It into clariBI

Matomo (formerly Piwik) is a privacy-focused web analytics platform available as both a self-hosted and cloud solution. Exporting your Matomo data into clariBI allows you to combine website analytics with other business data for comprehensive AI-driven analysis.

What You Can Export from Matomo

• Visitor data (visits, unique visitors, bounce rate, visit duration)
• Page performance (page views, entry/exit pages, page titles)
• Referrer data (search engines, websites, campaigns, social networks)
• Goal and conversion tracking data
• E-commerce metrics (revenue, orders, product performance)
• User flow and behavior patterns
• Custom dimensions and variable data
• Event tracking data (category, action, name, value)

Export CSV Data from Matomo

Method 1: Export Individual Reports

1. Log in to your Matomo instance (your self-hosted URL or matomo.cloud)
2. Select the correct website from the website selector at the top
3. Navigate to any report section — Visitors, Behaviour, Acquisition, or Goals
4. Open the specific report you want to export (e.g., Behaviour > Pages, Acquisition > All Channels)
5. Set your desired date range using the date picker (top right)
6. Look for the export options at the bottom of the report widget — click the link/gear icon that shows export formats
7. Select CSV from the available formats (CSV, TSV, XML, JSON, etc.)
8. The CSV file will download with the report data for your selected date range

Method 2: Export via the API (Advanced)

1. Navigate to Administration (gear icon) > Platform > API in your Matomo dashboard
2. Browse the API documentation to find the method for the data you need (e.g., `VisitsSummary.get`, `Actions.getPageUrls`)
3. Set parameters including `format=CSV`, `period`, `date`, and `idSite`
4. Execute the API call to download the CSV directly
5. This method allows for automated and larger data exports compared to the UI

Tips for Clean Exports

• Self-hosted Matomo has no data limits on exports, giving you full control over your analytics data
• The report widget export links are easy to miss — look for a small icon row at the bottom of each report table
• For comprehensive data exports, the Matomo API is more reliable than the UI and supports pagination for large datasets

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Matomo - Visitor Overview Q4 2024")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What are the top traffic sources driving conversions on my website?"
- "How does the bounce rate differ between mobile and desktop visitors?"
- "Which pages have the highest exit rate and what is the average time on page?"

clariBI's AI will automatically analyze your data and suggest relevant insights.