Analytics Export — Analytics

Export Formats

CSV Export

Raw row-level data. Each row represents one event or one aggregated period (depending on the dataset). Best for importing into spreadsheets, SQL databases, or BI tools that consume flat files. Column headers are included in the first row.

JSON Export

Pre-aggregated time series data. The JSON structure mirrors the data as displayed in the analytics charts — arrays of period objects with metrics. Best for programmatic consumption, API integrations, or feeding custom dashboards.

Available Export Datasets

Dataset	Available To	Contents
Install events	Publisher (own packages), Admin (all)	One row per install event: package_id, version, tenant_region, install_date
Review data	Publisher (own packages), Admin (all)	One row per review: package_id, star_rating, review_date (no reviewer identity)
Version adoption snapshot	Publisher (own packages), Admin (all)	One row per package-version combination: active_tenant_count, snapshot_date
Geographic summary	Publisher (own packages), Admin (all)	One row per country per period: install_count, country_code, period_date
Reputation event log	Publisher (own account), Admin (all)	One row per reputation event: event_type, points, event_date, source_id
Marketplace summary (admin only)	Admin only	Aggregated daily platform metrics: total_installs, active_publishers, new_packages, certifications_granted
Publisher leaderboard history (admin only)	Admin only	Daily leaderboard snapshot: publisher_id, rank, weighted_score, tier

Exporting Data

Navigate to Analytics → Export — Available in both Publisher Dashboard analytics and Admin Portal analytics.

Select dataset — Choose the dataset from the available list. Datasets the user doesn't have access to are grayed out.

Set date range — Select the start and end date for the export. Maximum range is 24 months (the full data retention period).

Choose format — CSV or JSON.

Export — For small exports (under 100,000 rows), the file downloads immediately. For large exports, a background job is queued and a download link is emailed when ready (typically within 5 minutes).

Scheduled Report Emails

Publishers and admins can configure scheduled exports that run automatically on a weekly or monthly cadence and deliver the export file via email.

Schedule Option	Delivery Day	Data Scope
Weekly	Monday morning	Prior 7 days
Monthly	1st of each month	Prior calendar month

Scheduled reports can be configured at Analytics → Export → Scheduled Reports. Each scheduled report specifies: dataset, format (CSV or JSON), schedule frequency, and recipient email addresses. Multiple recipients are supported — useful for team reporting where multiple stakeholders need the data.

Export data before the 24-month retention limit

Analytics data older than 24 months is permanently deleted. If historical data is needed for compliance, trend analysis, or any other purpose, export and archive it before it ages out. Scheduled monthly exports are the recommended approach for maintaining a long-term archive without manual intervention.

← Admin Leaderboard Analytics