Types

DealReportRow

One deal with its details and event counts, as the analytics store last saw it.

idrequired
string (uuid)
The deal id.
namerequired
string | null
The deal name as the analytics store last saw it.
statusrequired
string | null
The deal status as stored. A published deal past its end date stays published here; see closed.One of: draft, awaiting_approval, ready_to_publish, published, retired, in_progress, rejected
currencyrequired
string | null
The ISO currency code of the deal. Every amount on the row is in this currency; nothing is converted.
funding_soughtrequired
number | null
The amount the deal is raising, in the deal currency.
created_atrequired
string | null (date-time)
When the analytics store first saw the deal.
updated_atrequired
string | null (date-time)
When the analytics store last changed the deal row. Null when the store does not track it.
published_atrequired
string | null (date-time)
When the deal was published. Null until then.
available_fromrequired
string | null (date-time)
When the deal becomes available to investors. Null for no start.
available_torequired
string | null (date-time)
When the deal stops being available to investors. Null for no end.
closedrequired
boolean
True when the deal is retired, or published and past available_to.
viewsrequired
integer
How many view events the deal has.
unique_viewersrequired
integer
How many different users viewed the deal. Entrepreneurs and deleted users are not counted, as in deal-viewers.
enquiriesrequired
integer
How many enquiry events the deal has, leaving out settled ones.
engagementsrequired
integer
How many enquiry, question, favourite and feedback events the deal has, leaving out settled ones.
commitmentsrequired
integer
How many commitments the deal has: committed transaction events only, so one commitment is never counted twice.
committed_amountrequired
number
The sum of the commitment amounts, in the deal currency. Zero when there are none.
funded_amountrequired
number
The sum of the funded amounts, in the deal currency. Zero when there are none.
funded_percentrequired
number
funded_amount over funding_sought as a percentage with two decimals. Zero when funding_sought is zero or missing.
last_event_atrequired
string | null (date-time)
When the latest event on the deal happened. Null when the deal has none.

Used by (1)