RFID Lifecycle Dashboard

Upload Active + Terminated RFID data and explore growth, churn, and revenue impact

Upload Workbook
Session-isolated uploads

Upload a single Excel workbook. It may contain multiple sheets (e.g., “Active RFIDs”, “Terminated RFIDs”). You’ll choose which sheet is which after upload.

Click to upload or drag and drop

Excel files only (.xlsx, .xls)

-
Active RFIDs
-
Terminated RFIDs
-
Net Change
-
Active MRR (Monthly Fee)
-
Data Issues (Missing Term Dates)
Filters
No selections
-
Selected accounts
Selected programs
RFID activity over time
RFID activations
Terminated RFIDs (by termination date)

Rows without a date are omitted from these timelines. The status chart below uses unique RFID values.

Issued RFID status (unique RFIDs)
  • Active — in the active file only.
  • Terminated — in the terminated file only.
  • Lost — appears in both files (overlap).
Top Drivers (Net Change by Account)
Program Mix (Activations)
RFID Distribution by FLA Account Name
View
All Accounts
Total: -
Tip: apply filters above to see distribution for a subset.
Card Program Breakdown (Percent)
Price List Breakdown (Percent)
Card Program Breakdown (Count)
Price List Breakdown (Count)
Retention by activation cohort (% still not terminated)

Rows: activation month cohort. Columns: months since cohort. Cell = % of that cohort’s RFIDs with no termination on/before that month-end (or blank termination date).

Time from activation to termination

RFIDs present in both files with both dates; days = termination − activation.

“Stale” active-only RFIDs

In active file only, activation older than 540 days (oldest first, max 400 rows).

RFID Account Program Activated Days
MRR-style bridge (monthly fee sums)

New = fees on activations in that month. Lost = fees on terminations in that month. Net = new − lost.

MRR by card program
MRR by price list
MRR by account (top)
Period comparison

Recent window vs the same-length period immediately before it. Row counts use dated rows; unique RFID counts dedupe within each window. Account drivers use the same filters as other tabs.

Recent —
Prior —
Δ Activations (rows)
—
Δ Terminations (rows)
—
Δ Net unique RFID (activations − terminations, unique)
—

Accounts driving change in net flow (recent activations − recent terminations, minus same for prior)
Top accounts by Δ activations
AccountRecentPriorΔ
Top accounts by Δ terminations
AccountRecentPriorΔ
Termination anomalies

Lightweight check: — vs trailing 6-month average of termination row counts. Program and price list come from the active file joined on RFID. Dimensions with low volume are omitted.

By card program
ProgramDirectionLast moTrail avgRatio
By price list
Price listDirectionLast moTrail avgRatio