> For the complete documentation index, see [llms.txt](https://documentation.bonsaidata.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://documentation.bonsaidata.io/developer-docs/unified-marketing-api/schema.md).
# 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 |
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://documentation.bonsaidata.io/developer-docs/unified-marketing-api/schema.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.