Data Warehouse
Query and analyze your workspace data with RankGun's Data Warehouse. Build custom reports and insights. Elite subscription required.
Elite Subscription Required
The Data Warehouse feature requires an Elite subscription.
The Data Warehouse provides advanced analytics capabilities with a powerful query builder. Access your workspace data for in-depth analysis and reporting.
Overview
The Data Warehouse allows you to:
- Build custom queries using an intuitive filter-based interface
- Save frequently used queries for quick access
- Export query results in multiple formats
- Analyze trends over time
Accessing the Data Warehouse
- Navigate to your workspace dashboard
- Click Analytics in the sidebar
- Select Data Warehouse
Available Tables
Query data from these workspace tables:
| Table | Description |
|---|---|
| Audits | Complete workspace audit history |
| Rank Actions | All ranking operations (promotes, demotes, setrank) |
| Activity Logs | Player activity tracking records |
| Activity Users | Player activity summaries and stats |
| Sessions | Scheduled session data |
| Session Participants | Session attendance and RSVP data |
| Workspace Members | Current workspace member list |
| Applications | Application centre submissions |
| API Request Logs | API usage and analytics |
Building Queries
Use the query builder to create custom queries:
Select Fields
Choose which fields to include in your results. Each table has a set of available fields you can select.
Add Filters
Filter your data using these operators:
| Operator | Description | Example |
|---|---|---|
| Equals | Exact match | action = "promote" |
| Not equals | Exclude matches | status != "pending" |
| Greater than | Numeric comparison | duration > 60 |
| Less than | Numeric comparison | count < 100 |
| Contains | Partial text match | username contains "admin" |
| In | Match any in list | role in ["admin", "moderator"] |
Date Range
Filter results to a specific time period by setting start and end dates.
Group By
Group results by a field to aggregate data. Useful for creating summaries like "rank actions per user" or "activity by day".
Aggregations
Apply aggregations to grouped data:
| Aggregation | Description |
|---|---|
| Count | Number of records |
| Sum | Total of numeric field |
| Average | Mean of numeric field |
| Min | Minimum value |
| Max | Maximum value |
Ordering & Limits
- Order by: Sort results by any field (ascending or descending)
- Limit: Restrict the number of results returned
Saved Queries
Save queries you use frequently:
- Build your query in the editor
- Click Save Query
- Give it a descriptive name
- Access saved queries from the sidebar
Sharing Queries
Saved queries can be shared with workspace admins. Toggle the Share with admins option when saving.
Exporting Data
Export query results in multiple formats:
| Format | Best For |
|---|---|
| CSV | Spreadsheets, data analysis tools |
| JSON | API integrations, custom processing |
| Markdown | Documentation, reports |
Export Options
- Run your query
- Click Export Results
- Select your preferred format
- Download or copy to clipboard
Best Practices
- Use date filters — Always filter by date range to avoid large result sets
- Limit results — Use limits for exploratory queries
- Save frequently — Save useful queries for quick access
- Use grouping — Group data to create meaningful summaries
Rate Limits
To ensure fair usage:
- Maximum query execution time: 30 seconds
- Maximum result rows: 10,000
- Queries per hour: 100
Contact support if you need higher limits for specific use cases.