BI dashboards on reward and engagement data
Analytics teams connect Looker, Tableau, or Power BI to Xoxoday tables in Snowflake. Add recognition frequency, reward redemption rates, and engagement scores to existing business dashboards.
SnowflakeSync Xoxoday engagement data
Sync Xoxoday engagement data
into Snowflake for analytics
Pipe Empuls recognition, Plum reward, and Loyalife transaction data into Snowflake. Join it with HR, sales, and customer data to prove program ROI.
Book a demo
Get a personalised walkthrough. We respond within one business day.
What you can do
Four things you can do once Xoxoday data is in Snowflake
Snowflake is your analytics foundation. Xoxoday adds the reward and engagement layer so every cross-functional analysis includes the full picture.
All Xoxoday data in your Snowflake warehouse
- Empuls, Plum, and Loyalife data in one warehouse
- Empuls recognition events, Plum reward sends and redemptions, and Loyalife point transactions all flow into Snowflake tables on a scheduled sync. One warehouse for all Xoxoday data.
- Scheduled sync keeps the warehouse current
- Configure the refresh cadence that fits your analytics pipeline - hourly, daily, or on-demand. Snowflake always reflects the latest Xoxoday state without manual exports.
Join reward and recognition data with any dataset
- Overlay Xoxoday data with HR, sales, and customer data
- Join Xoxoday engagement tables with HRIS exports, CRM pipeline data, or customer datasets in Snowflake SQL. See reward impact on retention, quota attainment, and customer lifetime value.
- Cross-functional analysis without data movement
- All your data lives in Snowflake. Analysts join Xoxoday tables with existing datasets using standard SQL - no additional data pipelines or export steps.
BI-ready schema - direct to your analytics stack
- Clean, documented schema out of the box
- Xoxoday exports clean, documented table schemas so Looker, Tableau, and Power BI analysts can build dashboards immediately after setup - no schema reverse-engineering required.
- Looker, Tableau, and Power BI connect directly
- Point your existing BI tool at Xoxoday tables in Snowflake. Add reward and engagement KPIs to dashboards that already show HR, sales, and customer metrics.
Real-time sync with scheduled automatic refresh
- Hourly, daily, or on-demand refresh cadence
- Configure the sync frequency from the Xoxoday side to match your analytics pipeline. Near-real-time dashboards or overnight batch refreshes - both are supported.
- No manual export steps
- The sync runs automatically on the configured schedule. Analysts always query fresh Xoxoday data without waiting for someone to export and upload a CSV.
Use cases
Who runs it, and what for
Three ways analytics, people, and finance teams use Xoxoday data in Snowflake.
Join engagement data with attrition and performance metrics
HR analytics teams join Xoxoday Empuls recognition data with HRIS attrition and performance tables in Snowflake. Quantify the link between recognition frequency and retention rates.
Prove reward program ROI with cross-dataset analysis
Finance teams overlay Xoxoday reward spend data with sales pipeline and revenue tables in Snowflake. Calculate cost per reward send, redemption rate, and revenue lift per incentivised cohort.
How it works
From Xoxoday API to Snowflake tables
Step 1
Configure Xoxoday API credentials
Generate an API key in the Xoxoday admin panel. This credential authorises the ETL tool or custom pipeline to pull data from Xoxoday.
Step 2
Connect via ETL tool or Snowflake data share
Use Fivetran, Airbyte, or a custom ETL pipeline to pull from the Xoxoday API and load into your Snowflake project. Configure the destination schema and tables.
Step 3
Schedule the data refresh
Set the sync cadence - hourly, daily, or on-demand - in your ETL tool. Snowflake tables update automatically on the configured schedule.
Step 4
Query Xoxoday data in Snowflake or connect a BI tool
Run SQL directly on Xoxoday tables in Snowflake, or point Looker, Tableau, or Power BI at the tables to build dashboards on top of the synced data.
Setup
API integration. ETL tool or custom pipeline.
Pull from the Xoxoday API using Fivetran, Airbyte, or a custom ETL pipeline. Load into Snowflake on your schedule. Connect your BI tool and go.
API / custom integration - requires a data pipeline tool (Fivetran, Airbyte, or custom ETL).
Xoxoday API key + Snowflake credentials.
Xoxoday → Snowflake, scheduled sync.
Available with Empuls, Plum, and Loyalife.
Common Questions
Frequently asked questions
Common questions from data engineering, people analytics, and finance teams evaluating the Snowflake integration.
Still have a question? Talk to usAvailable tables include Empuls recognition events, Plum reward sends and redemption events, and Loyalife point transaction logs. Contact your Xoxoday account team for the full schema documentation.
The recommended approach is an ETL pipeline using Fivetran or Airbyte, which pulls from the Xoxoday API and loads into your Snowflake project. Snowflake Data Sharing directly from Xoxoday is not currently available.
The refresh cadence is configured in your ETL tool. Supported options include near-real-time (streaming), hourly, daily, and on-demand. The right cadence depends on your analytics pipeline requirements.
Yes. Xoxoday provides table schema documentation for all exported datasets. Contact your Xoxoday account team or implementation partner for the current schema reference.
Any BI tool that connects to Snowflake works with Xoxoday data - including Looker, Tableau, Power BI, Metabase, Mode, and others. No Xoxoday-specific BI connector is required.
See it in your own Snowflake setup
A 30-minute call. We'll walk through the API schema, the ETL options, and what your analysts can query once Xoxoday data lands in Snowflake.
Book a demo