Schema
This documentation describes the standard tables in your Bonsai data warehouse, enabling reliable access to core marketing and business data with consistent naming, data types, and performance.
Overview
These tables support controlled audience and geographic A/B testing within the Bonsai platform. They consolidate test configurations, performance metrics, and statistical lift results to quantify causal impact and determine whether marketing investments drive measurable business improvement.
Performance Stats
inc_test_daily_stats_table schema
Description: The daily performance stats for business and marketing channels included in audience A/B tests measured by the Bonsai platform.
client_number
YES
INT64
An internal client identifier.
date
YES
DATE
The calendar date of the event.
test_id
YES
INT64
The ID number for the test in the Bonsai platform.
test_group
YES
STRING
The test group assignment in the Bonsai platform.
test_period
YES
STRING
The test period designation in the Bonsai platform.
test_type
YES
STRING
The type of test.
customer_id
YES
STRING
The ad platform customer ID, where applicable.
dma_id
YES
STRING
Bonsai's DMA ID.
impressions
YES
FLOAT64
Ad impressions.
clicks
YES
FLOAT64
Ad clicks.
cost
YES
FLOAT64
Media ad cost.
google_impressions
YES
FLOAT64
Ad impressions from Google Ads.
google_clicks
YES
FLOAT64
Ad clicks from Google Ads.
google_cost
YES
FLOAT64
Media cost from Google Ads.
facebook_impressions
YES
FLOAT64
Ad impressions from Meta Ads.
facebook_clicks
YES
FLOAT64
Ad clicks from Meta Ads.
facebook_cost
YES
FLOAT64
Media cost from Meta Ads.
metric1–metric10
YES
FLOAT64
Business-specific metrics (e.g., revenue, page views, conversions) associated with the test measurement.
mmt_table schema
Description: Record of Incrementality Tests measured by the Bonsai Platform.
client_number
YES
INTEGER
An internal client identifier.
test_id
YES
INTEGER
The ID number for the test in the Bonsai platform.
test_desc
YES
STRING
test_name
YES
STRING
test_hypothesis
YES
STRING
methodology
YES
STRING
channels
YES
STRING
success_metrics
YES
STRING
test_dma
YES
STRING
control_dma
YES
STRING
test_pre_date
YES
DATE
test_pre_end_date
YES
DATE
test_start_date
YES
DATE
test_end_date
YES
DATE
iroi_metric
YES
STRING
inc_vpc_metric
YES
STRING
aud_ab_test_id
YES
INTEGER
live_flag
YES
BOOLEAN
Denotes whether an Incrementality model is live in the Bonsai platform.
metric1_name
YES
STRING
metric2_name
YES
STRING
metric3_name
YES
STRING
metric4_name
YES
STRING
metric5_name
YES
STRING
metric6_name
YES
STRING
metric7_name
YES
STRING
metric8_name
YES
STRING
metric9_name
YES
STRING
metric10_name
YES
STRING
metric11_name
YES
STRING
metric12_name
YES
STRING
metric13_name
YES
STRING
metric14_name
YES
STRING
metric15_name
YES
STRING
metric16_name
YES
STRING
metric17_name
YES
STRING
metric18_name
YES
STRING
metric19_name
YES
STRING
metric20_name
YES
STRING
mmt_metric_1_type
YES
STRING
mmt_metric_2_type
YES
STRING
mmt_metric_3_type
YES
STRING
mmt_metric_4_type
YES
STRING
mmt_metric_5_type
YES
STRING
mmt_metric_6_type
YES
STRING
mmt_metric_7_type
YES
STRING
mmt_metric_8_type
YES
STRING
mmt_metric_9_type
YES
STRING
mmt_metric_10_type
YES
STRING
mmt_metric_11_type
YES
STRING
mmt_metric_12_type
YES
STRING
mmt_metric_13_type
YES
STRING
mmt_metric_14_type
YES
STRING
mmt_metric_15_type
YES
STRING
mmt_metric_16_type
YES
STRING
mmt_metric_17_type
YES
STRING
mmt_metric_18_type
YES
STRING
mmt_metric_19_type
YES
STRING
mmt_metric_20_type
YES
STRING
accepted_flag
YES
INTEGER
test_type
YES
STRING
The type of test.
Lift Stats
mmt_difference_significance_python_table schema
Description: The lift statistics measured, by test, in the Bonsai platform.
client_number
YES
INT64
An internal client identifier.
test_id
YES
INT64
The ID number for the test in the Bonsai platform.
test_type
YES
STRING
The type of test.
metric_name
YES
STRING
The name of the business metric measured in the test.
lift
YES
FLOAT64
The test result lift metric for a Bonsai test.
CI
YES
STRING
The confidence interval level for the test result.
lower_CI
YES
FLOAT64
The lower bound of the lift result for the given confidence level.
higher_CI
YES
FLOAT64
The upper bound of the lift result for the given confidence level.
Last updated