Multi-Touch Attribution API Overview
This documentation describes the standard tables in your BigQuery data warehouse, enabling reliable access to core marketing and business data with consistent naming, data types, and performance.
Table Description and Definitions
This table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
mta_dev.cjv_table
mta_dev.cjv_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the most common marketing channels (e.g., source and medium) that lead to a first-time customer order (order_flag = 1).
cjv_table properties
journey_customer_id Type: STRING Required The unique internal identifier for the customer's journey.
key Type: STRING A primary key for the specific interaction or event within the journey.
client_number Type: INTEGER An internal client identifier.
journey_time Type: INTEGER The timestamp of the event or interaction within the journey.
order_flag Type: INTEGER A binary flag (1 = order, 0 = no order) indicating if an order was placed as a result of the journey.
metric1-10 Type: NUMERIC/INT64 A set of business-specific metrics (e.g., revenue, page views, clicks) to track key performance indicators.
key_interaction_number Type: INTEGER A chronological numeric identifier for a key interaction type (when key_interaction is true).
key_interaction_weight Type: INTEGER A value representing the weight or importance of a key interaction.
key_interaction_future Type: INTEGER The total number of key interactions occurring after this touchpoint, by journey_customer_id.
attributed_metric1-15 Type: NUMERIC Fractional attributed metric associated with this touchpoint using Bonsai’s multi-touch attribution model.
key_interaction_flag Type: INTEGER A flag indicating if the event was a key interaction.
date Type: DATE The calendar date of the event.
continent Type: STRING Geographical dimension related to the user's location.
sub_continent Type: STRING Geographical dimension related to the user's location.
country Type: STRING Geographical dimension related to the user's location.
region Type: STRING Geographical dimension related to the user's location.
metro Type: STRING Geographical dimension related to the user's location.
campaign Type: STRING An organized effort to promote a product or service. Used to group and track performance data.
source Type: STRING The origin of a user or event. Used to identify where traffic or conversions came from.
medium Type: STRING The category of the source. Used to classify the type of channel that drove traffic (e.g., CPC, organic, email).
gclid Type: STRING A Google click ID used by Google Ads.
dclid Type: STRING A click ID used by DoubleClick.
fbclid Type: STRING A click ID used by Facebook and Instagram Ads.
gbraid Type: 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)
wbraid Type: STRING A Google click ID for iOS campaigns, used for web-to-app measurement.
ko_click_id Type: STRING A click ID used by TikTok for its advertising campaigns.
li_fat_id Type: STRING A click ID used by LinkedIn.
twclid Type: STRING A click ID used by Twitter (X) for its advertising platform.
msclid Type: STRING A click ID used by Microsoft Advertising (formerly Bing Ads).
deviceCategory Type: STRING User device.
mobile_brand_name Type: STRING User mobile brand.
operating_system Type: STRING User operating system.
landing_page Type: STRING The URL of the landing page for the interaction.
dim1-10 Type: STRING Client-defined custom 1st-party touch point dimensions.
order_id Type: STRING The unique identifier for an order, if one was placed.
order_dim1-10 Type: STRING Client-defined custom 1st-party order dimensions.
mta_dev.cjv_0_table
mta_dev.cjv_0_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the most common marketing channels (e.g., source and medium) that lead to a first-time customer order (order_flag = 1).
cjv_0_table properties
key Type: STRING A primary key for the specific interaction or event within the journey.
client_number Type: INTEGER An internal client identifier.
journey_customer_id Type: STRING Required The unique internal identifier for the customer's journey.
cookie_id Type: STRING A unique cookie identifier associated with the journey.
journey_time Type: INTEGER The timestamp of the event or interaction within the journey.
key_interaction_flag Type: INTEGER A flag indicating if the event was a key interaction.
key_interaction_number Type: INTEGER A chronological numeric identifier for a key interaction type (when key_interaction is true).
key_interaction_total Type: INTEGER The total number of key interactions occurring after this touchpoint, by journey_customer_id.
key_interaction_weight Type: INTEGER A value representing the weight or importance of a key interaction.
order_flag Type: INTEGER A binary flag (1 = order, 0 = no order) indicating if an order was placed as a result of the journey.
metric1-10 Type: MIXED Client-defined custom metrics.
mta_dev.cjv_attribution_table
mta_dev.cjv_attribution_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the most common marketing channels (e.g., source and medium) that lead to a first-time customer order (order_flag = 1).
cjv_attribution_table properties
journey_customer_id Type: STRING Required The unique internal identifier for the customer's journey.
key Type: STRING A primary key for the specific interaction or event within the journey.
client_number Type: INTEGER An internal client identifier.
journey_time Type: INTEGER The timestamp of the event or interaction within the journey.
order_flag Type: INTEGER A binary flag (1 = order, 0 = no order) indicating if an order was placed as a result of the journey.
metric1-10 Type: NUMERIC/INT64 A set of business-specific metrics (e.g., revenue, page views, clicks) to track key performance indicators.
key_interaction_number Type: INTEGER A chronological numeric identifier for a key interaction type (when key_interaction is true).
key_interaction_weight Type: INTEGER A value representing the weight or importance of a key interaction.
key_interaction_future Type: INTEGER The total number of key interactions occurring after this touchpoint, by journey_customer_id.
attributed_metric1-10 Type: NUMERIC Fractional attributed metric associated with this touchpoint using Bonsai’s multi-touch attribution model.
mta_dev.cjv_dashboard_channel_platform_campaign_table
mta_dev.cjv_dashboard_channel_platform_campaign_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the custom attributed metrics against each campaign.
cjv_dashboard_channel_platform_campaign_table properties
client_number Type: INTEGER Required A unique numerical identifier for a client.
date Type: DATE Required The date the data was recorded.
channel Type: STRING The marketing channel used, such as email or social media.
platform Type: STRING The specific platform where the campaign ran, like Facebook or Google Ads.
campaign Type: STRING The name of the advertising campaign.
cost Type: FLOAT The total cost of the campaign.
clicks Type: FLOAT The number of times the campaign's ad was clicked.
impressions Type: FLOAT The number of times the campaign's ad was displayed to a user.
visits Type: INTEGER The number of times users visited the website as a result of the campaign.
attributed_metric1-15 Type: NUMERIC Fractional attributed metric associated with this touchpoint using Bonsai’s multi-touch attribution model.
mta_dev.cjv_dashboard_channel_platform_campaign_dma_table
mta_dev.cjv_dashboard_channel_platform_campaign_dma_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the custom attributed metrics against each campaign in any DMA.
cjv_dashboard_channel_platform_campaign_dma_table properties
client_number Type: INTEGER Required A unique numerical identifier for a client.
date Type: DATE Required The date the data was recorded.
channel Type: STRING The marketing channel used, such as email or social media.
platform Type: STRING The specific platform where the campaign ran, like Facebook or Google Ads.
dma_id Type: INTEGER A numerical identifier for a Designated Marketing Area (DMA), which is a geographical region used for marketing and advertising purposes.
campaign Type: STRING The name of the advertising campaign.
cost Type: FLOAT The total cost of the campaign.
clicks Type: FLOAT The number of times the campaign's ad was clicked.
impressions Type: FLOAT The number of times the campaign's ad was displayed to a user.
visits Type: INTEGER The number of times users visited the website as a result of the campaign.
attributed_metric1-15 Type: NUMERIC Fractional attributed metric associated with this touchpoint using Bonsai’s multi-touch attribution model.
mta_dev.cjv_dashboard_channel_platform_dma_table
mta_dev.cjv_dashboard_channel_platform_dma_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the custom attributed metrics against each campaign in any DMA.
cjv_dashboard_channel_platform_dma_table properties
client_number Type: INTEGER Required A unique numerical identifier for a client.
date Type: DATE Required The date the data was recorded.
channel Type: STRING The marketing channel used, such as email or social media.
platform Type: STRING The specific platform where the campaign ran, like Facebook or Google Ads.
dma_id Type: INTEGER A numerical identifier for a Designated Marketing Area (DMA), which is a geographical region used for marketing and advertising purposes.
cost Type: FLOAT The total cost of the campaign.
clicks Type: FLOAT The number of times the campaign's ad was clicked.
impressions Type: FLOAT The number of times the campaign's ad was displayed to a user.
visits Type: INTEGER The number of times users visited the website as a result of the campaign.
attributed_metric1-15 Type: NUMERIC Fractional attributed metric associated with this touchpoint using Bonsai’s multi-touch attribution model.
WIP mta_dev.event_touchpoint_dim_table
mta_dev.event_touchpoint_dim_tableThis table consolidates customer journey data, linking key interactions to subsequent events such as orders. It serves as a single source of truth for understanding how different marketing touchpoints contribute to customer purchase.
A comprehensive table that records a customer's journey, including touchpoints, campaign data, and attributed metrics, to facilitate marketing effectiveness analysis.
Updated daily via an ETL process that aggregates data from various source systems.
This table is not currently partitioned.
Analyze the custom attributed metrics against each campaign in any DMA.
mta_dev.event_touchpoint_dim_table properties
client_number Type: INTEGER An internal client identifier.
key Type: STRING A primary key for the specific interaction or event within the journey.
cookie_id Type: STRING Unique identifier assigned to a browser or device via cookie tracking.
user_id Type: STRING Unique identifier associated with a known or logged-in user.
event_name Type: STRING Name of the event captured (e.g., page_view, purchase, click).
journey_time Type: INTEGER The timestamp of the event or interaction within the journey.
session_id Type: INTEGER Unique identifier for the user’s session, grouping related events together.
continent Type: STRING Geographical dimension related to the user's location. Used for broad geographic segmentation.
sub_continent Type: STRING Geographical dimensions related to the user's location. Used for more granular geographic grouping.
country Type: STRING Geographical dimensions related to the user's location. Used for national-level data segmentation and filtering.
region Type: STRING Geographical dimensions related to the user's location. Can represent a state, province, or postal grouping.
metro Type: STRING A metropolitan area, which includes a city and its surrounding suburbs. Used for local-level targeting and analysis.
campaign Type: STRING An organized effort to promote a product or service. Used to group and track performance data.
source Type: STRING The origin of a user or event. Used to identify where traffic or conversions came from.
medium Type: STRING The category of the source. Used to classify the type of channel (e.g., CPC, organic, email).
operating_system Type: STRING User operating system.
operating_system_version Type: STRING User operating system version.
deviceCategory Type: STRING Category of the device used (e.g., desktop, mobile, tablet).
mobile_brand_name Type: STRING Brand name of the mobile device.
mobile_model_name Type: STRING Model name of the mobile device.
mobile_marketing_name Type: STRING Marketi
Last updated