# Schema
## Overview
These tables standardize marketing platform data across channels into a unified schema, normalizing campaign structure, spend, impressions, clicks, and conversion metrics. They serve as the integration layer between external ad platforms and the Bonsai platform, ensuring consistent cross-channel reporting, attribution, and modeling readiness.
***
### Customer Journey Views
cjv_key_gclid_map_table schema
Description: A mapping table for Google click IDs used by the Bonsai platform.
| field\_name | is\_nullable | data\_type | definition |
| ----------- | ------------ | ---------- | ------------------------------------- |
| gclid | YES | STRING | A Google click ID used by Google Ads. |
### Event Touchpoint
event_touchpoint_dim_table schema
Description: A table of characteristics about each touchpoint used by the Bonsai platform
| field\_name | is\_nullable | data\_type | definition |
| ------------------------ | ------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| key | YES | STRING | A primary key for the specific interaction or event within the journey. |
| journey\_time | YES | INT64 | The timestamp, in UNIX seconds, of the event or interaction within the journey. |
| cookie\_id | YES | STRING | the 1P cookie id from web & app event tracking |
| cookie\_match\_dim1 | YES | STRING | the 1P event parameter utilized to match event data to business results data |
| cookie\_match\_dim2 | YES | STRING | an alternative 1P event parameter utilized to match event data to business results data |
| cookie\_match\_flag | YES | INT64 | denotes if a 1P event will be utilzed for cookie\_match\_dim |
| region | YES | STRING | Geographical dimension related to the user's location. |
| continent | YES | STRING | Geographical dimension related to the user's location. |
| dayofweek | YES | INT64 | The day of the week, 1 = Sunday |
| medium | YES | STRING | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| referrer | YES | STRING | web or app event referrer information |
| mobile\_brand\_name | YES | STRING | User's mobile brand. |
| mobile\_model\_name | YES | STRING | The mobile device's model name |
| deviceCategory | YES | STRING | User's device category |
| product\_category | YES | STRING | The category of the product |
| item\_category5 | YES | STRING | the product 5th-level category |
| netsalesquantity | YES | INT64 | Sales Quantity |
| net\_sales\_amount\_usd | YES | FLOAT64 | Net Sales in US Dollars |
| key\_interaction\_flag | YES | INT64 | A binary flag, indicating if an event in the customer journey is eligible for attributed impact |
| key\_interaction\_weight | YES | FLOAT64 | the attributable weight assigned for a key event |
| dclid | YES | STRING | A click ID used by DoubleClick. |
| fbclid | YES | STRING | A click ID used by Facebook and Instagram Ads. |
| gbraid | YES | STRING | A Google click ID used for iOS campaigns, specifically for app-to-web measurement on browsers that do not support third-party cookies. (Google Brand Referrer ID) |
| gclid | YES | STRING | A Google click ID used by Google Ads. |
| ko\_click\_id | YES | STRING | |
| li\_fat\_id | YES | STRING | A click ID used by LinkedIn. |
| msclkid | YES | STRING | A click ID used by Microsoft Advertising (formerly Bing Ads). |
| ttclid | YES | STRING | A click ID used by TikTok for its advertising campaigns. |
| twclid | YES | STRING | A click ID used by Twitter (X) for its advertising platform. |
| wbraid | YES | STRING | A Google click ID for iOS campaigns, used for web-to-app measurement. |
| dim1–dim10 | YES | STRING | Client-defined custom 1st-party touch point dimensions. |
| flag1–flag10 | YES | STRING | a logical field, identifying event types for custom configured events in Bonsai customer journey tables |
event_touchpoint_facts_table schema
Description: A table of critical characteristics for each touchpoint in the Bonsai Platform
| field\_name | is\_nullable | data\_type | definition |
| ------------------------ | ------------ | ---------- | ----------------------------------------------------------------------------------------------- |
| client\_number | YES | INT64 | An internal client identifier. |
| cookie\_id | YES | STRING | the 1P cookie id from web & app event tracking |
| cookie\_match\_dim1 | YES | STRING | the 1P event parameter utilized to match event data to business results data |
| cookie\_match\_dim2 | YES | STRING | an alternative 1P event parameter utilized to match event data to business results data |
| cookie\_match\_flag | YES | INT64 | denotes if a 1P event will be utilzed for cookie\_match\_dim |
| journey\_time | YES | INT64 | The timestamp, in UNIX seconds, of the event or interaction within the journey. |
| key | YES | STRING | A primary key for the specific interaction or event within the journey. |
| key\_interaction\_flag | YES | INT64 | A binary flag, indicating if an event in the customer journey is eligible for attributed impact |
| key\_interaction\_weight | YES | FLOAT64 | the attributable weight assigned for a key event |
| user\_id | YES | STRING | the user ID captured in 1P event tracking |
### Google Search Console
google_search_console_brand_demand_daily_table schema
Description: A table of data utilized by the Bonsai Platform to measure a client's brand demand, using Google Search Console data
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | -------------------------------------------- |
| brand\_demand | YES | FLOAT64 | The ad platform account ID, where applicable |
| client\_number | YES | INT64 | An internal client identifier. |
| date | YES | DATE | The calendar date of the event. |
google_search_console_category_demand_daily_table schema
Description: A table of data utilized by the Bonsai Platform to measure a client's category demand, using Google Search Console data
| field\_name | is\_nullable | data\_type | definition |
| ---------------- | ------------ | ---------- | ---------------------------------- |
| Category\_Demand | YES | FLOAT64 | An index of category search demand |
| client\_number | YES | INT64 | An internal client identifier. |
| date | YES | DATE | The calendar date of the event. |
### Performance Marketing
performance_marketing_campaign_key_all_table schema
Description: A dimension table for all marketing campaigns available in a client's Bonsai platform
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| Platform | YES | STRING | the ad platform |
performance_marketing_campaign_key_table schema
Description: A dimension table for all marketing campaigns available in a client's Bonsai platform
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| medium | NO | ARRAY | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| Platform | YES | STRING | the ad platform |
| source | NO | ARRAY | The website origination of a customer journey touchpoint |
performance_marketing_daily_campaign_dma_stats_table schema
Description: A daily stats table, segmented by campaign and DMA, utilized by the Bonsai platform, covering all integrated marketing channels.
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| dma\_id | YES | INT64 | Bonsai's DMA ID |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
performance_marketing_daily_campaign_stats_table schema
Description: A daily stats table, segmented by campaign , utilized by the Bonsai platform, covering all integrated marketing channels.
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | FLOAT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
performance_marketing_daily_dma_stats_table schema
Description: A daily stats table, segmented by DMA, utilized by the Bonsai platform, covering all integrated marketing channels.
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ------------------------------------------------------------ |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| dma\_id | YES | INT64 | Bonsai's DMA ID |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
performance_marketing_daily_region_stats_campaign_table schema
Description: A daily stats table, segmented by campaign and region, utilized by the Bonsai platform, covering all integrated marketing channels.
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| country | YES | STRING | Geographical dimension related to the user's location. |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| region | YES | STRING | Geographical dimension related to the user's location. |
| spend | YES | FLOAT64 | ad spend |
performance_marketing_daily_stats_table schema
Description: A daily stats table, utilized by the Bonsai platform, covering all integrated marketing channels.
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ------------------------------------------------------------ |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
### Google Analytics 4
ga4_event_dim_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------------------- | ------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| client\_number | YES | INT64 | An internal client identifier. |
| key | YES | STRING | A primary key for the specific interaction or event within the journey. |
| journey\_time | YES | INT64 | The timestamp, in UNIX seconds, of the event or interaction within the journey. |
| date | YES | DATE | The calendar date of the event. |
| year | YES | INT64 | the year, YYYY |
| month | YES | INT64 | The calendar month |
| week | YES | INT64 | the week of the year (1-53) |
| dayofweek | YES | INT64 | The day of the week, 1 = Sunday |
| event\_name | YES | STRING | the name of the customer behavior event |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| source | YES | STRING | The website origination of a customer journey touchpoint |
| medium | YES | STRING | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| cookie\_id | YES | STRING | the 1P cookie id from web & app event tracking |
| cookie\_match\_dim1 | YES | STRING | the 1P event parameter utilized to match event data to business results data |
| cookie\_match\_dim2 | YES | STRING | an alternative 1P event parameter utilized to match event data to business results data |
| cookie\_match\_flag | YES | INT64 | denotes if a 1P event will be utilzed for cookie\_match\_dim |
| session\_id | YES | INT64 | the 1P event tracking session ID |
| stream\_id | YES | STRING | the 1P event stream ID |
| user\_id | YES | STRING | the user ID captured in 1P event tracking |
| transaction\_id | YES | STRING | the Order ID used in the Bonsai Platform |
| continent | YES | STRING | Geographical dimension related to the user's location. |
| sub\_continent | YES | STRING | Geographical dimension related to the user's location. |
| country | YES | STRING | Geographical dimension related to the user's location. |
| region | YES | STRING | Geographical dimension related to the user's location. |
| metro | YES | STRING | Geographical dimension related to the user's location. |
| deviceCategory | YES | STRING | User's device category |
| mobile\_brand\_name | YES | STRING | User's mobile brand. |
| mobile\_marketing\_name | YES | STRING | The mobile device's marketing name |
| mobile\_model\_name | YES | STRING | The mobile device's model name |
| operating\_system | YES | STRING | User's operating system. |
| operating\_system\_version | YES | STRING | User's operating system, version segmented. |
| referrer | YES | STRING | web or app event referrer information |
| item\_category | YES | STRING | the highest-level product category |
| item\_category2 | YES | STRING | the product sub-category |
| item\_category3 | YES | STRING | the product 3rd-level category |
| item\_category4 | YES | STRING | the product 4th-level category |
| item\_category5 | YES | STRING | the product 5th-level category |
| product\_category | YES | STRING | The category of the product |
| product\_brand | YES | STRING | The Brand of the product |
| product\_name | YES | STRING | The name of the product |
| product\_sku | YES | STRING | The product SKU |
| netsalesquantity | YES | INT64 | Sales Quantity |
| net\_sales\_amount\_usd | YES | FLOAT64 | Net Sales in US Dollars |
| key\_interaction\_flag | YES | INT64 | A binary flag, indicating if an event in the customer journey is eligible for attributed impact |
| key\_interaction\_weight | YES | FLOAT64 | the attributable weight assigned for a key event |
| dclid | YES | STRING | A click ID used by DoubleClick. |
| fbclid | YES | STRING | A click ID used by Facebook and Instagram Ads. |
| gbraid | YES | STRING | A Google click ID used for iOS campaigns, specifically for app-to-web measurement on browsers that do not support third-party cookies. (Google Brand Referrer ID) |
| gclid | YES | STRING | A Google click ID used by Google Ads. |
| ko\_click\_id | YES | STRING | |
| li\_fat\_id | YES | STRING | A click ID used by LinkedIn. |
| msclkid | YES | STRING | A click ID used by Microsoft Advertising (formerly Bing Ads). |
| ttclid | YES | STRING | A click ID used by TikTok for its advertising campaigns. |
| twclid | YES | STRING | A click ID used by Twitter (X) for its advertising platform. |
| wbraid | YES | STRING | A Google click ID for iOS campaigns, used for web-to-app measurement. |
| dim1–dim10 | YES | STRING | Client-defined custom 1st-party touch point dimensions. |
| flag1–flag10 | YES | STRING | a logical field, identifying event types for custom configured events in Bonsai customer journey tables |
ga4_reservepageinstantiated_daily schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ------------------------------ |
| client\_number | YES | INT64 | An internal client identifier. |
| event\_ts | YES | TIMESTAMP | the event timestamp |
| metric\_date | YES | TIMESTAMP | The calendar date |
ga4_reservepageinstantiated_event schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ---------------- | ------------ | ---------- | -------------------------------------------- |
| client\_number | NO | INT64 | An internal client identifier. |
| event\_date | YES | STRING | The calendar date of the event. |
| event\_id | YES | STRING | the event ID |
| event\_timestamp | YES | INT64 | the event timestamp, in UNIX seconds |
| event\_ts | YES | TIMESTAMP | the event timestamp |
| ga\_session\_id | YES | INT64 | the session ID from a 1P event tracking tool |
| metric\_date | YES | TIMESTAMP | The calendar date |
### Google Ads
google_ads_campaign_key_all_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| Platform | YES | STRING | the ad platform |
google_ads_campaign_key_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| medium | NO | ARRAY | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| Platform | YES | STRING | the ad platform |
| source | NO | ARRAY | The website origination of a customer journey touchpoint |
google_ads_daily_dma_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| dma\_id | YES | INT64 | Bonsai's DMA ID |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
google_ads_daily_region_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| country | YES | STRING | Geographical dimension related to the user's location. |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| region | YES | STRING | Geographical dimension related to the user's location. |
| spend | YES | FLOAT64 | ad spend |
google_ads_daily_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
### Facebook Ads
facebook_ads_campaign_key_all_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| Platform | YES | STRING | the ad platform |
facebook_ads_campaign_key_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| medium | NO | ARRAY | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| Platform | YES | STRING | the ad platform |
| source | NO | ARRAY | The website origination of a customer journey touchpoint |
facebook_ads_daily_dma_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| Date | YES | DATE | The calendar date of the event. |
| dma\_id | YES | INT64 | Bonsai's DMA ID |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
facebook_ads_daily_region_stats_campaign_table schema
Description: A daily Facebook Ads stats table segmented by campaign and region.
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| country | YES | STRING | Geographical dimension related to the user's location. |
| Date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| region | YES | STRING | Geographical dimension related to the user's location. |
| spend | YES | FLOAT64 | ad spend |
facebook_ads_daily_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
### Instagram Ads
instagram_ads_campaign_key_all_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| Platform | YES | STRING | the ad platform |
instagram_ads_campaign_key_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| medium | NO | ARRAY | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| Platform | YES | STRING | the ad platform |
| source | NO | ARRAY | The website origination of a customer journey touchpoint |
instagram_ads_daily_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
### Reddit Ads
reddit_ads_campaign_key_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| medium | NO | ARRAY | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| Platform | YES | STRING | the ad platform |
| source | NO | ARRAY | The website origination of a customer journey touchpoint |
reddit_ads_daily_dma_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| dma\_id | YES | INT64 | Bonsai's DMA ID |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
reddit_ads_daily_region_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| country | YES | STRING | Geographical dimension related to the user's location. |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| region | YES | STRING | Geographical dimension related to the user's location. |
| spend | YES | FLOAT64 | ad spend |
reddit_ads_daily_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | INT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | INT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
### Youtube Ads
youtube_ads_campaign_key_all_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| Platform | YES | STRING | the ad platform |
youtube_ads_campaign_key_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| -------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign | YES | STRING | An organized effort to promote a product or service. Used to group and track performance data. |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| Channel | YES | STRING | the marketing channel associated with the row of data |
| client\_number | YES | INT64 | An internal client identifier. |
| medium | NO | ARRAY | The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email). |
| Platform | YES | STRING | the ad platform |
| source | NO | ARRAY | The website origination of a customer journey touchpoint |
youtube_ads_daily_region_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| country | YES | STRING | Geographical dimension related to the user's location. |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| region | YES | STRING | Geographical dimension related to the user's location. |
| spend | YES | FLOAT64 | ad spend |
youtube_ads_daily_stats_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |
youtube_ads_daily_stats_dma_campaign_table schema
Description:
| field\_name | is\_nullable | data\_type | definition |
| ----------------- | ------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------- |
| account\_id | YES | STRING | The ad platform account ID, where applicable |
| campaign\_id | YES | STRING | The campaign ID utilized in the Bonsai platform, applicable to different levels of marketing depending on the input platform |
| clicks | YES | INT64 | ad clicks |
| client\_number | YES | INT64 | An internal client identifier. |
| conversion\_value | YES | FLOAT64 | ad platform conversion value, as reported by the ad platform |
| conversions | YES | FLOAT64 | ad platform conversions, as reported by the ad platform |
| date | YES | DATE | The calendar date of the event. |
| dma\_id | YES | INT64 | Bonsai's DMA ID |
| impressions | YES | INT64 | ad impressions |
| Platform | YES | STRING | the ad platform |
| reach | YES | INT64 | ad reach, in Users |
| spend | YES | FLOAT64 | ad spend |