Revenue Types

Semantic Contract

Definitions

Column	Description
id	Unique identifier for the period.
name	Revenue type name. Allowed values are New Booking, Upsell, Downsell, and Churn.

Revenue Type	Description
New Booking	Revenue from a brand-new customer.
Upsell	Revenue increase from an existing customer.
Downsell	Revenue decrease from an existing customer.
Churn	Revenue lost due to customers leaving or canceling contracts.

Sample & Implementation

A list of Revenue Types
id	name
1	new_booking
2	upsell
3	downsell
4	churn

CREATE TABLE IF NOT EXISTS revenue_types (
    id INTEGER PRIMARY KEY,
    name VARCHAR NOT NULL CHECK (name IN ('new_booking', 'upsell', 'downsell', 'churn'))
)

Data Format

Field

Type

Dependencies

None.

Semantic Contract

Definitions

Sample & Implementation

Data Format

Dependencies

On this page