Subscript

Explore the interactive ERD

Table & Field Reference

business_snapshot_cost_stat

Column	Type	Keys
`period_key`	String	PK
`cogs`	Double
`marketing`	Double
`sales`	Double

business_snapshot_revenue_stat

Column	Type	Keys
`period_key`	String	PK
`amount_renewed_that_was_up_gross`	Double
`amount_renewed_that_was_up_net`	Double
`bookings`	Double
`churn`	Double
`downsell`	Double
`existing`	Double
`influx`	Double
`metered`	Double
`new_bookings`	Double
`new_count`	Double
`non_recurring`	Double
`non_renewal_upsell`	Double
`percent_recurring`	Double
`reactivated_bookings`	Double
`recurring_period_growth`	Double
`recurring_revenue_with_rolling_metered`	Double
`renewal_bookings`	Double
`rolling_metered`	Double
`total`	Double
`total_period_growth`	Double
`total_period_revenue`	Double
`up_for_renewal`	Double
`upsell`	Double
`upsell_bookings`	Double

business_snapshot_seat_stat

Column	Type	Keys
`period_key`	String	PK
`churn`	Double
`downsell`	Double
`existing`	Double
`influx`	Double
`influx_movement`	Double
`new_count`	Double
`total`	Double
`upsell`	Double

business_snapshot_saas_stat

Column	Type	Keys
`period_key`	String	PK
`all_cac_cost_marketing`	Double
`all_cac_cost_sales`	Double
`all_cac_customer_stats_new_all_customers`	Double
`all_cac_ttm_cost_marketing`	Double
`all_cac_ttm_cost_sales`	Double
`all_cac_ttm_customer_stats_new_all_customers`	Double
`all_cac_ttm_value`	Double
`all_cac_value`	Double
`arpa_customer_stats_total`	Double
`arpa_revenue_stats_total`	Double
`arpa_ttm_customer_stats_total`	Double
`arpa_ttm_revenue_stats_total`	Double
`arpa_ttm_value`	Double
`arpa_value`	Double
`burn_multiple_net_new_revenue`	Double
`burn_multiple_ttm_net_new_revenue`	Double
`burn_multiple_ttm_net_profit`	Double
`burn_multiple_ttm_value`	Double
`burn_multiple_value`	Double
`gross_customer_retention_churn_amount`	Double
`gross_customer_retention_churned_customers`	Double
`gross_customer_retention_customers_previous_total`	Double
`gross_customer_retention_downsell_amount`	Double
`gross_customer_retention_downsell_customers`	Double
`gross_customer_retention_existing_amount`	Double
`gross_customer_retention_existing_customers`	Double
`gross_customer_retention_new_amount`	Double
`gross_customer_retention_new_customers`	Double
`gross_customer_retention_ttm_churn_amount`	Double
`gross_customer_retention_ttm_churned_customers`	Double
`gross_customer_retention_ttm_customers_previous_total`	Double
`gross_customer_retention_ttm_downsell_amount`	Double
`gross_customer_retention_ttm_downsell_customers`	Double
`gross_customer_retention_ttm_existing_amount`	Double
`gross_customer_retention_ttm_existing_customers`	Double
`gross_customer_retention_ttm_new_amount`	Double
`gross_customer_retention_ttm_new_customers`	Double
`gross_customer_retention_ttm_upsell_amount`	Double
`gross_customer_retention_ttm_upsell_customers`	Double
`gross_customer_retention_ttm_value`	Double
`gross_customer_retention_upsell_amount`	Double
`gross_customer_retention_upsell_customers`	Double
`gross_customer_retention_value`	Double
`gross_margin_cost_cogs`	Double
`gross_margin_revenue_total_period`	Double
`gross_margin_value`	Double
`gross_revenue_churn_rate_gross_revenue_retention`	Double
`gross_revenue_churn_rate_ttm_gross_revenue_retention`	Double
`gross_revenue_churn_rate_ttm_value`	Double
`gross_revenue_churn_rate_value`	Double
`gross_revenue_retention_revenue_previous_total`	Double
`gross_revenue_retention_revenue_renewed`	Double
`gross_revenue_retention_ttm_revenue_previous_total`	Double
`gross_revenue_retention_ttm_revenue_renewed`	Double
`gross_revenue_retention_ttm_value`	Double
`gross_revenue_retention_value`	Double
`gross_up_for_renewal_retention_amount_renewed_that_was_up_gross`	Double
`gross_up_for_renewal_retention_up_for_renewal`	Double
`gross_up_for_renewal_retention_value`	Double
`ltv_arpa`	Double
`ltv_gross_customer_retention`	Double
`ltv_ttm_arpa_avg`	Double
`ltv_ttm_gross_customer_retention`	Double
`ltv_ttm_value`	Double
`ltv_value`	Double
`ltvcac_ratio_cac`	Double
`ltvcac_ratio_ltv`	Double
`ltvcac_ratio_ttm_cac`	Double
`ltvcac_ratio_ttm_ltv`	Double
`ltvcac_ratio_ttm_value`	Double
`ltvcac_ratio_value`	Double
`ltvgm_laden_arpa`	Double
`ltvgm_laden_gross_customer_retention`	Double
`ltvgm_laden_gross_margin`	Double
`ltvgm_laden_ttm_arpa_avg`	Double
`ltvgm_laden_ttm_gross_customer_retention`	Double
`ltvgm_laden_ttm_gross_margin`	Double
`ltvgm_laden_ttm_value`	Double
`ltvgm_laden_value`	Double
`net_new_revenue_churn_revenue`	Double
`net_new_revenue_downsell_revenue`	Double
`net_new_revenue_new_revenue`	Double
`net_new_revenue_upsell_revenue`	Double
`net_new_revenue_value`	Double
`net_revenue_retention_ending_revenue_from_starting`	Double
`net_revenue_retention_revenue_previous_total`	Double
`net_revenue_retention_ttm_ending_revenue_from_starting`	Double
`net_revenue_retention_ttm_revenue_previous_total`	Double
`net_revenue_retention_ttm_value`	Double
`net_revenue_retention_value`	Double
`net_up_for_renewal_retention_amount_renewed_that_was_up_net`	Double
`net_up_for_renewal_retention_non_renewal_upsell`	Double
`net_up_for_renewal_retention_up_for_renewal`	Double
`net_up_for_renewal_retention_value`	Double
`new_arpa_customer_stats_new`	Double
`new_arpa_revenue_stats_new`	Double
`new_arpa_ttm_customer_stats_new`	Double
`new_arpa_ttm_revenue_stats_new`	Double
`new_arpa_ttm_value`	Double
`new_arpa_value`	Double
`new_revenue_to_costs_ratio_cost_marketing`	Double
`new_revenue_to_costs_ratio_cost_sales`	Double
`new_revenue_to_costs_ratio_new_revenue`	Double
`new_revenue_to_costs_ratio_value`	Double
`payback_period_cost_marketing`	Double
`payback_period_cost_sales`	Double
`payback_period_gross_margin`	Double
`payback_period_revenue_stats_new`	Double
`payback_period_value`	Double
`recurring_arpu_recurring_revenue_total`	Double
`recurring_arpu_total_seats`	Double
`recurring_arpu_value`	Double
`recurring_cac_cost_marketing`	Double
`recurring_cac_cost_sales`	Double
`recurring_cac_customer_stats_new`	Double
`recurring_cac_ttm_cost_marketing`	Double
`recurring_cac_ttm_cost_sales`	Double
`recurring_cac_ttm_customer_stats_new`	Double
`recurring_cac_ttm_value`	Double
`recurring_cac_value`	Double
`rule_of_40_ttm_net_profit`	Double
`rule_of_40_ttm_recurring_period_growth`	Double
`rule_of_40_ttm_total_period_revenue`	Double
`rule_of_40_ttm_value`	Double

business_snapshot_customer_stat

Column	Type	Keys
`period_key`	String	PK
`all_customers`	Double
`all_recurring_customers`	Double
`churn`	Double
`customers_renewed`	Double
`customers_up_for_renewal`	Double
`customers_with_open_contracts`	Double
`downsell`	Double
`existing`	Double
`influx`	Double
`influx_movement`	Double
`new_all_customers`	Double
`new_count`	Double
`total`	Double
`upsell`	Double

business_snapshot_summary_stat

Column	Type	Keys
`period_key`	String	PK
`all_arpa_customer_stats_total`	Double
`all_arpa_revenue_stats_total`	Double
`all_arpa_ttm_customer_stats_total`	Double
`all_arpa_ttm_revenue_stats_total`	Double
`all_arpa_ttm_value`	Double
`all_arpa_value`	Double
`all_cac_cost_marketing`	Double
`all_cac_cost_sales`	Double
`all_cac_customer_stats_new_all_customers`	Double
`all_cac_ttm_cost_marketing`	Double
`all_cac_ttm_cost_sales`	Double
`all_cac_ttm_customer_stats_new_all_customers`	Double
`all_cac_ttm_value`	Double
`all_cac_value`	Double
`all_customers`	Double
`amount_renewed_that_was_up_gross`	Double
`amount_renewed_that_was_up_net`	Double
`bookings`	Double
`burn_multiple_net_new_revenue`	Double
`burn_multiple_net_profit`	Double
`burn_multiple_ttm_net_new_revenue`	Double
`burn_multiple_ttm_net_profit`	Double
`burn_multiple_ttm_value`	Double
`burn_multiple_value`	Double
`committed_customer_count`	Double
`committed_recurring`	Double
`customers_renewed`	Double
`customers_up_for_renewal`	Double
`customers_with_open_contracts`	Double
`gross_customer_retention_churn_amount`	Double
`gross_customer_retention_churned_customers`	Double
`gross_customer_retention_customers_previous_total`	Double
`gross_customer_retention_downsell_amount`	Double
`gross_customer_retention_downsell_customers`	Double
`gross_customer_retention_existing_amount`	Double
`gross_customer_retention_existing_customers`	Double
`gross_customer_retention_new_amount`	Double
`gross_customer_retention_new_customers`	Double
`gross_customer_retention_ttm_churn_amount`	Double
`gross_customer_retention_ttm_churned_customers`	Double
`gross_customer_retention_ttm_customers_previous_total`	Double
`gross_customer_retention_ttm_downsell_amount`	Double
`gross_customer_retention_ttm_downsell_customers`	Double
`gross_customer_retention_ttm_existing_amount`	Double
`gross_customer_retention_ttm_existing_customers`	Double
`gross_customer_retention_ttm_new_amount`	Double
`gross_customer_retention_ttm_new_customers`	Double
`gross_customer_retention_ttm_upsell_amount`	Double
`gross_customer_retention_ttm_upsell_customers`	Double
`gross_customer_retention_ttm_value`	Double
`gross_customer_retention_upsell_amount`	Double
`gross_customer_retention_upsell_customers`	Double
`gross_customer_retention_value`	Double
`gross_margin_cost_cogs`	Double
`gross_margin_revenue_total_period`	Double
`gross_margin_value`	Double
`gross_revenue_churn_rate_gross_revenue_retention`	Double
`gross_revenue_churn_rate_ttm_gross_revenue_retention`	Double
`gross_revenue_churn_rate_ttm_value`	Double
`gross_revenue_churn_rate_value`	Double
`gross_revenue_retention_revenue_previous_total`	Double
`gross_revenue_retention_revenue_renewed`	Double
`gross_revenue_retention_ttm_revenue_previous_total`	Double
`gross_revenue_retention_ttm_revenue_renewed`	Double
`gross_revenue_retention_ttm_value`	Double
`gross_revenue_retention_value`	Double
`gross_up_for_renewal_retention_amount_renewed_that_was_up_gross`	Double
`gross_up_for_renewal_retention_up_for_renewal`	Double
`gross_up_for_renewal_retention_value`	Double
`ltv_arpa_avg`	Double
`ltv_gross_customer_retention`	Double
`ltv_ttm_arpa_avg`	Double
`ltv_ttm_gross_customer_retention`	Double
`ltv_ttm_value`	Double
`ltv_value`	Double
`ltvcac_ratio_cac`	Double
`ltvcac_ratio_ltv`	Double
`ltvcac_ratio_ttm_cac`	Double
`ltvcac_ratio_ttm_ltv`	Double
`ltvcac_ratio_ttm_value`	Double
`ltvcac_ratio_value`	Double
`ltvgm_laden_arpa_avg`	Double
`ltvgm_laden_gross_customer_retention`	Double
`ltvgm_laden_gross_margin`	Double
`ltvgm_laden_ttm_arpa_avg`	Double
`ltvgm_laden_ttm_gross_customer_retention`	Double
`ltvgm_laden_ttm_gross_margin`	Double
`ltvgm_laden_ttm_value`	Double
`ltvgm_laden_value`	Double
`magic_number_cost_marketing_last_quarter`	Double
`magic_number_cost_sales_last_quarter`	Double
`magic_number_growth_in_arr`	Double
`magic_number_value`	Double
`metered`	Double
`net_new_revenue_churn_revenue`	Double
`net_new_revenue_downsell_revenue`	Double
`net_new_revenue_new_revenue`	Double
`net_new_revenue_upsell_revenue`	Double
`net_new_revenue_value`	Double
`net_revenue_retention_ending_revenue_from_starting`	Double
`net_revenue_retention_revenue_previous_total`	Double
`net_revenue_retention_ttm_ending_revenue_from_starting`	Double
`net_revenue_retention_ttm_revenue_previous_total`	Double
`net_revenue_retention_ttm_value`	Double
`net_revenue_retention_value`	Double
`net_up_for_renewal_retention_amount_renewed_that_was_up_net`	Double
`net_up_for_renewal_retention_non_renewal_upsell`	Double
`net_up_for_renewal_retention_up_for_renewal`	Double
`net_up_for_renewal_retention_value`	Double
`new_arpa_customer_stats_new`	Double
`new_arpa_revenue_stats_new`	Double
`new_arpa_ttm_customer_stats_new`	Double
`new_arpa_ttm_revenue_stats_new`	Double
`new_arpa_ttm_value`	Double
`new_arpa_value`	Double
`new_bookings`	Double
`new_count`	Double
`new_revenue_to_costs_ratio_cost_marketing`	Double
`new_revenue_to_costs_ratio_cost_sales`	Double
`new_revenue_to_costs_ratio_new_revenue`	Double
`new_revenue_to_costs_ratio_value`	Double
`non_recurring`	Double
`non_renewal_upsell`	Double
`payback_period_cost_marketing`	Double
`payback_period_cost_sales`	Double
`payback_period_gross_margin`	Double
`payback_period_revenue_stats_new`	Double
`payback_period_value`	Double
`percent_recurring`	Double
`reactivated_bookings`	Double
`recurring_arpu_recurring_revenue_total`	Double
`recurring_arpu_total_seats`	Double
`recurring_arpu_value`	Double
`recurring_cac_cost_marketing`	Double
`recurring_cac_cost_sales`	Double
`recurring_cac_customer_stats_new`	Double
`recurring_cac_ttm_cost_marketing`	Double
`recurring_cac_ttm_cost_sales`	Double
`recurring_cac_ttm_customer_stats_new`	Double
`recurring_cac_ttm_value`	Double
`recurring_cac_value`	Double
`recurring_customers`	Double
`recurring_period_growth`	Double
`recurring_revenue_total`	Double
`recurring_revenue_with_rolling_metered`	Double
`renewal_bookings`	Double
`rolling_metered`	Double
`rule_of_40_ttm_net_profit`	Double
`rule_of_40_ttm_recurring_period_growth`	Double
`rule_of_40_ttm_total_period_revenue`	Double
`rule_of_40_ttm_value`	Double
`sales_efficiency_ratio_cost_marketing_this_quarter`	Double
`sales_efficiency_ratio_cost_sales_this_quarter`	Double
`sales_efficiency_ratio_growth_in_arr`	Double
`sales_efficiency_ratio_value`	Double
`total_period_growth`	Double
`total_period_revenue`	Double
`total_seats`	Double
`up_for_renewal`	Double
`upsell_bookings`	Double

waterfall_revenue_stat

Column	Type	Keys
`period_key`	String	PK
`churn`	Double
`downsell`	Double
`existing`	Double
`influx`	Double
`influx_movement`	Double
`new_count`	Double
`total`	Double
`upsell`	Double

waterfall_customer_stat

Column	Type	Keys
`period_key`	String	PK
`churn`	Double
`downsell`	Double
`existing`	Double
`influx`	Double
`influx_movement`	Double
`new_count`	Double
`total`	Double
`upsell`	Double

spread

Column	Type	Keys
`_fivetran_id`	String	PK
`amount`	Unknown
`created_at`	Unknown
`customer_external_id`	Unknown
`customer_id`	Unknown
`date`	Unknown
`id`	Unknown
`seats`	Unknown
`spread_external_id`	Unknown
`status`	Unknown
`transaction_external_id`	Unknown
`transaction_id`	Unknown
`type`	Unknown
`updated_at`	Unknown