# Subscript schema ERD

Table and field reference for the Fivetran Subscript connector.

## 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 |  |