Data Buckets
Data Buckets
A Data Bucket is your program’s central data source for performance tracking. You define Category Keys (KPI categories), upload targets and progress data, optionally configure Target Points Rules, then save so linked apps—Target Trackers, Leaderboards, and others—stay in sync.
Think of a bucket as: structure (Builder) → targets (goals) → data (actuals) → rules (optional points) → save (publish to apps).
Overview
From Data → Data Buckets you can:
- Create and manage buckets (Active, Inactive, Archive)
- Define Category Keys and choose which columns appear in the preview grid
- Upload targets and import progress data via CSV (detailed in linked guides)
- Review calculated columns — Target, Actual, Difference, Percentage, Target Points, and totals
- Configure or review point rules that drive the Target Points column
- Save to recalculate results and sync linked Tables and Leaderboards
Inside a Data Bucket
| Tab | Purpose |
|---|---|
| Builder | Category Keys, preview columns, participant preview, import history |
| Data | Progress/actual data imports — see Data imports |
| Targets | Goal/target CSV uploads — see Targets |
| Target Points Rules | IF/THEN rules for Target Points — see Target Points Rules |
| Settings | Status, title, redeemable points, delete/archive |
Where to find it
- List route:
/databuckets/{programId} - Bucket detail:
/databuckets/{programId}/databucket/{databucketId} - Side navigation: Data → Data Buckets
Prerequisites
- An open program with program administrator access
- Admin role — required to access Data → Data Buckets (Editor or Observer alone is not sufficient)
- Members or Companies on file with Data Keys set, depending on bucket Data Type — see Members and Companies
- Linked apps (Target Trackers, Leaderboards) created separately under Apps when you are ready to publish data to the member site
List page
The list has three tabs:
| Tab | Shows |
|---|---|
| Data Buckets | Active buckets |
| Inactive | Hidden from normal use but retained |
| Archive | Retired buckets kept for history |
Each card shows the bucket name, last updated date, status, and chips when points are configured:
| Chip | Meaning |
|---|---|
| Points | At least one Target Points Rule exists |
| Redeemable | Points from this bucket can credit member balances when saved |
| Redeemable (No points set up) | Redeemable is enabled but no rules are defined yet |
Use Search to filter cards by name. Click a card or the arrow button to open the bucket.
Create a Data Bucket
- On the Data Buckets tab, click Create a Databucket (or the + button).
- Enter Databucket Name.
- Choose Data Type:
- Member — rows match members by Data Key; redeemable points are supported
- Company — rows match companies by Data Key; redeemable points are not available
- Click Save.
New buckets start with Data Bucket has Targets enabled and no Category Keys yet. You add keys on the Builder tab.
Builder tab
The Builder is your configuration and preview workspace.
Category Keys
Category Keys (shown under Rows in the UI) are the KPI categories for this bucket—for example Q1_Sales, Warranty, or Training. Each key becomes a row in the preview table.
- Under Rows → Category Key(s), click +.
- Enter a Category Key name and confirm.
- Repeat for each KPI category you need.
After adding keys, upload targets that include a column for each Category Key.
Preview columns
Under Columns, add calculated columns to the preview grid:
| Column | Description |
|---|---|
| Target | Goal values from your targets upload |
| Actual | Progress values from your data imports |
| Difference | Actual minus Target |
| Percentage | Actual divided by Target (as %) |
| Target Points | Points from Target Points Rules |
| Claim Points | Points from linked Claims app activity |
| Quiz Points | Points from linked Quiz activity |
| Total Points | Sum of points columns |
Drag Category Key row order to control display sequence in apps that use this bucket.
Participant preview
Use the dropdown at the top of Builder to Select Member or Select Company (based on bucket Data Type). The table shows that participant’s values across all Category Keys and visible columns, plus a Totals row.
Import history (sidebar)
The right-hand Import History timeline lists progress data imports for the selected participant. Click an entry to:
- Expand batch details (Category Key values from that file)
- Snapshot the bucket as of that import date—preview recalculates using data available up to that point
Click Current or Show Current to return to live data.
Settings tab
| Field | Notes |
|---|---|
| Status | Active, Inactive, or Archive |
| Title | Display name (editable) |
| Databucket ID | System identifier (read-only) |
| Participant Type | Member or Company — set at creation, read-only |
| Points are redeemable | When enabled (member buckets only), saving can award points to member balances per rules — see Target Points Rules |
| Data Bucket has Targets | Read-only; new buckets are created with targets enabled |
Delete Data Bucket is available only when the bucket has never had Category Keys used in imports (targetCodes empty). Otherwise use Archive status instead.
Save Data Bucket
Changes across Builder, rules, and settings are staged until you save. When pending changes exist, Save Data Bucket activates in the sticky footer.
- Review the Builder preview for expected Target/Actual/Points values.
- Click Save Data Bucket.
- Wait for processing—Do Not Close Browser while the dialog runs.
On save, the system:
- Persists bucket configuration and calculated results
- Syncs linked Target Trackers (Tables) and Leaderboards that use this bucket
- Queues redeemable point processing when Points are redeemable is enabled and rules apply—member balances update after processing completes
A sync log lists each linked Table and Leaderboard updated. Allow a few moments after save for redeemable points to appear on member accounts.
How buckets connect to apps
| App | Relationship |
|---|---|
| Target Trackers | Display bucket columns as KPI tables on the member site |
| Leaderboards | Rank participants using bucket totals or columns |
| Awards / Tiers | May reference bucket data depending on program setup |
| Points Import | Separate bulk point tool—use Target Points Rules when points should track target achievement automatically |
Apps reference a bucket by selection at app setup; saving the bucket pushes fresh results to those apps.
Tips and limitations
- Admin role required — Only Admin role users see Data → Data Buckets.
- Data Keys are essential — Targets and data imports match Account Key in CSV to member or company Data Key. Fix unmatched rows before relying on preview or apps.
- Targets before data — You must upload targets before progress data.
- Targets replace; data accumulates — A new targets file replaces the previous targets upload. Each progress import adds to (merges with) earlier actual data unless you Undo Import on a specific file.
- Point formulas — Adding or changing calculation logic on Target Points Rules is handled with your Incentable team for most programs; see Target Points Rules.
- Company buckets — No redeemable member points; use for company-level KPI tables and leaderboards.
- Demo programs — Upload and save actions are disabled on demo programs.
- Archive instead of delete — Once a bucket has been used with imports, delete is blocked; set status to Archive.
Related
- Targets — Upload goal CSVs
- Data imports — Upload progress/actual CSVs
- Target Points Rules — Point calculation and redeemable awards
- Members — Member Data Keys
- Companies — Company Data Keys
- Target Trackers — Member-facing KPI tables
- Leaderboards — Rankings driven by bucket data
- Points Import — Manual or batch point awards outside buckets
