Looker Studio dashboards on reward and engagement data
Analytics teams point Looker Studio at Xoxoday tables in BigQuery and build dashboards on recognition frequency, reward redemption, and loyalty activity - without leaving Google Cloud.
Google BigQueryPipe Xoxoday engagement data
Pipe Xoxoday engagement data
into Google BigQuery
Stream Empuls recognition, Plum reward, and Loyalife transaction data into BigQuery. Build Looker Studio dashboards or run SQL directly on Xoxoday plus HR plus sales data.
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 BigQuery
BigQuery is the analytics foundation. Xoxoday adds the reward and engagement layer so every cross-functional analysis includes the full picture.
Xoxoday engagement data in your BigQuery project
- Empuls, Plum, and Loyalife data in BigQuery tables
- Empuls recognition events, Plum reward sends and redemptions, and Loyalife point transactions all stream into BigQuery tables on a configured schedule. One project for all Xoxoday engagement data.
- Scheduled exports keep your project always up to date
- Configure daily or hourly sync in your data pipeline. BigQuery tables reflect the latest Xoxoday state without manual exports or CSV uploads.
Connect reward data with HR and sales datasets
- Join Xoxoday tables with HRIS and CRM data in BigQuery
- Overlay Xoxoday recognition and reward data with HRIS attrition exports and CRM pipeline data in BigQuery. See the reward impact on retention rates and revenue performance in one SQL query.
- Cross-functional analysis with standard BigQuery SQL
- All your data lives in BigQuery. Analysts join Xoxoday tables with existing HR, finance, and customer datasets using standard SQL - no additional export or transformation steps.
Query directly in BigQuery SQL or visualise in Looker
- BigQuery-native access for any analyst
- Any analyst with BigQuery access can query Xoxoday data using standard SQL. No Xoxoday-specific BI connector or export step required - the data is already in the warehouse.
- Looker Studio and Looker connect directly
- Point Looker Studio or a Looker instance at Xoxoday tables in BigQuery to build dashboards. Add reward redemption rates, recognition frequency, and loyalty points to existing Google Cloud analytics.
Scheduled exports keep your warehouse always up to date
- Hourly, daily, or on-demand refresh
- Set the sync cadence in your ETL tool - Fivetran, Airbyte, or Google Cloud Dataflow - to match your analytics pipeline. Near-real-time or overnight batch; both work.
- No manual steps on the Xoxoday side
- Once the pipeline is configured, data flows automatically. Analysts always query fresh Xoxoday data without waiting for a manual export from the rewards team.
Use cases
Who runs it, and what for
Three ways analytics, people, and finance teams use Xoxoday data in BigQuery.
Join Empuls recognition with HRIS data in BigQuery
HR analytics teams join Empuls recognition events with HRIS attrition and performance data in BigQuery. Quantify the correlation between recognition cadence and employee retention.
Reward program ROI analysis in BigQuery SQL
Finance teams join Xoxoday Plum reward spend with CRM revenue data in BigQuery. Calculate cost per reward send, redemption rate, and revenue uplift per incentivised cohort.
How it works
From Xoxoday API to BigQuery tables
Step 1
Configure Xoxoday API credentials
Generate an API key in the Xoxoday admin panel. This credential authorises the data pipeline to pull reward and engagement data from Xoxoday.
Step 2
Connect via Fivetran, Airbyte, or Cloud Dataflow
Set up your ETL pipeline to pull from the Xoxoday API and load into your BigQuery project. Configure the target dataset, table names, and field mappings.
Step 3
Schedule the data sync
Configure the sync cadence in your pipeline tool - hourly, daily, or triggered on-demand. BigQuery tables update automatically without manual intervention.
Step 4
Query in BigQuery SQL or connect Looker
Run SQL directly on Xoxoday tables in BigQuery, or point Looker Studio or a Looker instance at the tables to build live dashboards on top of the synced data.
Setup
API integration. ETL tool or Cloud Dataflow.
Pull from the Xoxoday API using Fivetran, Airbyte, or Google Cloud Dataflow. Load into BigQuery on your schedule. Query with SQL or connect Looker Studio.
API / custom integration - pipe data via Fivetran, Airbyte, or Google Cloud Dataflow.
Xoxoday API key + Google Cloud project credentials.
Xoxoday → BigQuery, scheduled export.
Available with Empuls, Plum, and Loyalife.
Common Questions
Frequently asked questions
Common questions from data engineering, people analytics, and finance teams evaluating the BigQuery 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 and available fields.
Fivetran and Airbyte both support BigQuery as a destination and can pull from REST APIs like Xoxoday. Google Cloud Dataflow is also an option for teams already in the Google Cloud ecosystem.
The refresh cadence is set in your ETL pipeline. Supported options include near-real-time (streaming with Dataflow), hourly, and daily. The right cadence depends on your analytics pipeline and reporting requirements.
Yes. Once Xoxoday data is in BigQuery, point Looker Studio (formerly Data Studio) at the relevant tables or views. Build dashboards on recognition frequency, reward redemption rates, and loyalty activity alongside existing Google Cloud data.
Yes. Xoxoday provides table schema documentation for all exported datasets. Contact your Xoxoday account team or implementation partner for the current schema reference and field definitions.
See it in your own BigQuery setup
A 30-minute call. We'll walk through the API schema, the ETL options for Google Cloud, and what your analysts can query once Xoxoday data lands in BigQuery.
Book a demo