Aplauso uses Google BigQuery as the analytics engine behind the dashboards, leaderboards, and reports available to employees and managers. Understanding how this works helps you get the most out of the reporting features.
What BigQuery Powers
All analytics in the following places are driven by BigQuery queries:
| Feature | Where You See It |
|---|---|
| Employee earnings totals and averages | Mobile app Home tab, Dashboard Overview |
| Week-over-week and month-over-month comparisons | Dashboard Insights tab |
| Property-level leaderboards | Property Analytics > Leaderboards |
| Department and outlet performance summaries | Manage > Departments/Outlets > Analytics |
| Tip conversion funnel (visits to tips) | Property Analytics > Funnel |
| Time-series charts (daily, weekly, monthly) | Dashboard Insights, Reports |
Data Freshness
BigQuery analytics are updated on a schedule - typically every few minutes for recent activity. Very new tips may appear in your wallet before they show in chart-based analytics. Real-time tip notifications (push/email) come directly from Firestore, not BigQuery.
Available Analytics Metrics
For each employee, the analytics API returns:
| Metric | Description |
|---|---|
totalTips | Count of finalized tips received |
totalAmount | Lifetime earnings total |
avgTipAmount | Average tip amount per transaction |
totalRatings | Total star ratings received |
averageRating | Average star rating (1-5) |
availableBalance | Current withdrawable wallet balance |
thisWeekTips | Earnings in the current calendar week |
lastWeekTips | Earnings in the prior calendar week |
thisWeekTipCount | Number of tips this week |
lastWeekTipCount | Number of tips last week |
For properties and organizations, analytics also include department breakdowns, outlet breakdowns, and full leaderboards.
Exporting Data
Reports from Mission Control (Admins)
Property Admins and Org Admins can generate and download reports from the Insights section in Mission Control:
- Format: PDF, Excel, CSV, or JSON
- Scope: Employee, department, outlet, property, or organization
- Date range: Custom or preset (this week, this month, YTD)
- Contents: Earnings totals, tip counts, average ratings, time-series data
To export: Mission Control > Insights > Reports > Generate Report, set your filters, and click Download.
Scheduled Reports
Scheduled reports can be configured to automatically email analytics summaries on a weekly or monthly basis to designated recipients. Configure these under Mission Control > Insights > Settings > Scheduled Reports.
Raw Data (Enterprise)
For enterprise customers who need access to raw transaction data for payroll systems or BI tools, Aplauso can provision direct BigQuery dataset access or set up a scheduled CSV export to a cloud storage bucket. Contact your account manager for enterprise data access options.
Automatic Firestore Fallback
If BigQuery is temporarily unavailable, Aplauso automatically falls back to querying Firestore directly for analytics data. This ensures dashboards remain functional during maintenance windows, though some advanced aggregations may be simplified during fallback mode.