CommercialTraction

Commercial performance data held against an Organization, grouped into six JSON sections.

Purpose

The investors view presents commercial traction — revenue, pipeline, go-to-market conversion, deal economics and loss analysis. Rather than modelling each metric as a column, each section is stored as a JSON document so the shape can evolve without migrations. One row holds the current picture for an organisation.

Usage

Read as a whole and rendered on the investors page.

• app/Http/Controllers/Investors/InvestorsController.php — loads the record for the investors view
• app/Models/Organization.php — declares the inverse relation

Relationships

Relation	Type	Related model
organization	belongsTo	Organization

Data shape

Table: commercial_tractions

Column	Type	Notes
id	uuid	Primary key
organization_id	uuid	FK organizations, cascade delete
revenue	json	Nullable, cast to array
pipeline_quality	json	Nullable, cast to array
pipeline_mix	json	Nullable, cast to array
gtm_conversion	json	Nullable, cast to array
deal_economics	json	Nullable, cast to array
loss_analysis	json	Nullable, cast to array
created_at, updated_at	timestamp	Nullable

Scoped to the organisation

This record hangs off the organisation, not a project, and is removed when the organisation is deleted.