--- title: "Integration: Google Analytics Multi-Channel Funnels Reporting V2" description: This article will help you learn about how Daasity replicates data from Google Analytics Multi-Channel Funnels Reporting, limitations to the data we can extract and where the data is stored in the Google Analytics MCF V2 schema --- [Back to home](https://support.daasity.com/migrated/knowledge) - [ Welcome to Daasity ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity) - [ Integration Setup | Connect Your Data Sources ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-connect-your-data-sources) - [ Integration Setup | Amazon Seller Central ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-amazon-seller-central) - [ Navigating the Daasity App ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#navigating-the-daasity-app) - [ Daasity Platform | Business User Analytics ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics) - [ Brand Supplied Data (BSD) ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#brand-supplied-data-bsd) - [ Dashboards ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#dashboards) - [ Reports ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#reports) - [ Explores ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#explores) - [ Views ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#views) - [ Audiences ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#audiences) - [ Customizations ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#customizations) - [ ELT+ | Technical User Documentation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation) - [ Platform ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#platform) - [ Transformation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#transformation) - [ Integrations ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#integrations) - [ User Manual and Support ](https://support.daasity.com/migrated/knowledge/user-manual-and-support) - [ Daasity Logic and Best Practices ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#daasity-logic-and-best-practices) - [ Marketing Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#marketing-analytics) - [ Customer Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#customer-analytics) - [ Date Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#date-analytics) - [ Inventory and Returns Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#inventory-and-returns-analytics) - [ Submit a Support Request ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#submit-a-support-request) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates#release-updates) # Integration: Google Analytics Multi-Channel Funnels Reporting V2 ## This article will help you learn about how Daasity replicates data from Google Analytics Multi-Channel Funnels Reporting, limitations to the data we can extract and where the data is stored in the Google Analytics MCF V2 schema ### KEY TOPICS Click on the links below to take you to the section where you can learn more about this Integration - [API Endpoints](https://support.daasity.com/migrated/knowledge/google-analytics-mcf-v2#api-endpoints) - [Entity Relationship Diagram](https://support.daasity.com/migrated/knowledge/google-analytics-mcf-v2#erd) - [Google Analytics Multi-Channel Funnels Reporting Schema](https://support.daasity.com/migrated/knowledge/google-analytics-mcf-v2#ga-multi-channel-schema) - [Related Resources](https://support.daasity.com/migrated/knowledge/google-analytics-mcf-v2#related-resources) ### INTEGRATION AVAILABILITY This integration is available for: - Growth - Pro V2 **NOTE: **You are considered V2 if... - You are a Growth customer - Your account says Pro V2 in the Daasity App Not sure? Reach out to [Support@Daasity.com](mailto:Support@Daasity.com)  ### INTEGRATION OVERVIEW Google Analytics Multi-Channel Funnels Reporting API enables you to request Multi-Channel Funnels data which is derived from conversion path data and shows user interactions with various traffic sources over multiple sessions prior to converting. This allows the merchant to analyze how multiple marketing channels influence conversions over time. The Daasity V2 Google Analytics MCF extractor pulls a standard set of data via the Multi-Channel Funnels Reporting API. The Multi-Channel Funnels Reporting API is a report generation API and requires parameters to be passed into the API.   **NOTE: **The API has limitations on the level of granularity that can be returned: - Dimensions are limited to 7 per report - Metrics are limited to 10 per report Daasity queries each report for each day which thus removes the need to include the ga:Date as a parameter and thus allowing the full 7 dimensions to be used. ### API Endpoints The Daasity V2 Google Analytics MCF extractor is built based on this [Google Analytics Multi-Channel Funnels Reporting API Documentation](https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference). The following endpoints are used by Daasity to replicate data from Google Analytics MCF V2: -  [MCF](https://developers.google.com/analytics/devguides/reporting/mcf/dimsmets) ### Entity Relationship Diagram (ERD) The embedded diagram houses the ERD for the Daasity Google Analytics Multi-Channel Funnels integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll. ### Google Analytics Multi-Channel Funnel Reporting Schema The Daasity Google Analytics MCF extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.​ - [Base Multi-Channel](https://support.daasity.com/migrated/knowledge/google-analytics-mcf-v2#base-multi-channel) - [Base Multi-Channel Funnel](https://support.daasity.com/migrated/knowledge/google-analytics-mcf-v2#base-multi-channel-funnel) ### **Base Multi-Channel** - Endpoint: [MCF](https://developers.google.com/analytics/devguides/reporting/mcf/dimsmets) - Update Methdod: UPSERT - Table Name: ga.base_multi_channel | **JSON Element**** ** | **Database Column**** ** | | --- | --- | | MD5(all the dimensions) | id | | View ID selected for the integration | view_id | | mcf:transactionId | transaction_id | | mcf:conversionDate | created_on | | mcf:sourcePath | source_path | | Daasity: 1st node of mcf:sourcePath | source_path_first_node | | Daasity: Last node of mcf:sourcePath | source_path_last_node | | mcf:mediumPath | medium_path | | Daasity: 1st node of mcf:mediumPath | medium_path_first_node | | Daasity: Last node of mcf:mediumPath | medium_path_last_node | | mcf:campaignPath | campaign_path | | Daasity: 1st node of mcf:campaignPath | campaign_path_first_node | | Daasity: Last node of mcf:campaignPath | campaign_path_last_node | | mcf:basicChannelGrouping | basic_channel_grouping_path | | Daasity: 1st node of mcf:basicChannelGrouping | basic_channel_grouping_path_first_node | | Daasity: Last node of mcf:basicChannelGrouping | basic_channel_grouping_path_last_node | | mcf:keywordPath | keyword_path | | Daasity: 1st node of mcf:keywordPath | keyword_path_first_node | | Daasity: Last node of mcf:keywordPath | keyword_path_last_node | | mcf:sourceMediumPath | source_medium_path | | Daasity: 1st node of mcf:sourceMediumPath | source_medium_path_first_node | | Daasity: Last node of mcf:sourceMediumPath | source_medium_path_last_node | | mcf:timeLagInDaysHistogram | time_lag_in_days_histogram | | Daasity: from Channel Mapping Google Sheet | channel_first_click | | Daasity: from Channel Mapping Google Sheet | vendor_first_click | | Daasity: from Channel Mapping Google Sheet | sub_channel_first_click | | Daasity: from Channel Mapping Google Sheet | media_type_first_click | | Daasity: from Channel Mapping Google Sheet | channel_last_click | | Daasity: from Channel Mapping Google Sheet | vendor_last_click | | Daasity: from Channel Mapping Google Sheet | sub_channel_last_click | | Daasity: from Channel Mapping Google Sheet | media_type_last_click | | Daasity: from Channel Mapping Google Sheet | attribution_channel |   **NOTE: **There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys. ### Base Multi-Channel Funnel - Endpoint: [MCF](https://developers.google.com/analytics/devguides/reporting/mcf/dimsmets) - Update Method: UPSERT - Table Name: ga.base_multi_channel_funnel | **JSON Element**** ** | **Database Column**** ** | | --- | --- | | MD5(all the dimensions) | id | | View ID selected for the integration | view_id | | mcf:transactionId | transaction_id | | mcf:conversionDate | created_on | | mcf:sourcePath | source_path | | mcf:basicChannelGrouping | basic_channel_path | | mcf:sourceMediumPath | source_medium_path | | mcf:mediumPath | medium_path | | mcf:campaignPath | campaign_path | | mcf:keywordPath | keyword_path | | Daasity: node number | sequence | | Daasity: from Channel Mapping Google Sheet | channel | | Daasity: from Channel Mapping Google Sheet | vendor | | Daasity: from Channel Mapping Google Sheet | sub_channel | | Daasity: from Channel Mapping Google Sheet | media_type | | Daasity: from Channel Mapping Google Sheet | attribution_channel |     **NOTE: **There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys. ### ​Related Resources Although the GA Multi-Channel Funnel Reporting data extract is API based the best way to sample data is using tools that GA supplies: - MCF Sample Data: [https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference](https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference)​ - Use the **Try this API** section on the right side of the page