Data Export
Export raw datasets as CSV. Use Excel / BI tools for any reporting / analytics needs.
MVP scope — no built-in dashboards or charts. All numbers are raw event data; pivot in Excel or Looker as needed. Each export is a single CSV with all columns shown below.
Points Issuance Log
Every points-earning event across all installers
Columns (12)
txn_id license org_name country
tier source_type (base / promotion / ops / refund)
amount_pts device_sn inverter_kw
battery_kwh formula created_at
Redemption Orders
All redemption orders with status flow
Columns (11)
order_id license org_name
sku_code sku_name cost_pts
status (Pending / Processing / Shipped / Delivered / Cancelled)
tracking_no ship_address
created_at updated_at
Tier Snapshot
Current tier state of every license
Columns (8)
license org_name country
current_tier multiplier
2025_commissioned lifetime_systems
last_updated_at
Tier Change History
Append-only audit log of every tier change
Columns (8)
change_id license org_name
from_tier to_tier
changed_by reason changed_at
Operational Points Log
Direct issuances by Channel Mgmt
Columns (8)
issuance_id license org_name
amount_pts activity
justification issued_by issued_at
Promotion Log
All promotion configurations + actual bonus paid
Columns (10)
promo_id name countries
start_date end_date multiplier
status (Live / Scheduled / Ended / Disabled)
bonus_pts_paid created_by created_at
Bulk Export
Generate a single ZIP containing all 6 datasets above for the selected date range. Useful for monthly closeout / financial reconciliation.
Email link sent when ready · typically < 2 minutes