INTEGRATION OVERVIEW
*You are considered V2 if..
- You have your own Looker instance and signed up for Daasity AFTER July 15, 2020
- You're utilizing our Growth Platform
Not sure? Reach out to Support@Daasity.com
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 Funnel Reporting API. The Multi-Channel Funnel Reporting API is a report generation API and requires parameters to be passed into the API.
The API has limitations on the level of granularity that can be returned as follows:
- 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 use
This V2 integration is available for:
- Pro V2
- Growth
ERD EMBED
ENDPOINT: Multi-Channel Funnel Reporting API
Documentation on the Google Analytics Multi-Channel Funnel Reporting API can be found here: https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference
Multi-Channel TABLE
Data Mapping
| JSON Element | Database Column | Dataype |
| MD5 Hash of all the Dimensions | id | VARCHAR |
| View ID selected for the integration | view_id | VARCHAR |
| mcf:transactionId | transaction_id | VARCHAR |
| mcf:conversionDate | created_on | TIMESTAMP |
| mcf:sourcePath | source_path | VARCHAR |
| Daasity: 1st node of mcf:sourcePath | source_path_first_node | VARCHAR |
| Daasity: Last node of mcf:sourcePath | source_path_last_node | VARCHAR |
| mcf:mediumPath | medium_path | VARCHAR |
| Daasity: 1st node of mcf:mediumPath | medium_path_first_node | VARCHAR |
| Daasity: Last node of mcf:mediumPath | medium_path_last_node | VARCHAR |
| mcf:campaignPath | campaign_path | VARCHAR |
| Daasity: 1st node of mcf:campaignPath | campaign_path_first_node | VARCHAR |
| Daasity: Last node of mcf:campaignPath | campaign_path_last_node | VARCHAR |
| mcf:basicChannelGrouping | basic_channel_grouping_path | VARCHAR |
| Daasity: 1st node of mcf:basicChannelGrouping | basic_channel_grouping_path_first_node | VARCHAR |
| Daasity: Last node of mcf:basicChannelGrouping | basic_channel_grouping_path_last_node | VARCHAR |
| mcf:keywordPath | keyword_path | VARCHAR |
| Daasity: 1st node of mcf:keywordPath | keyword_path_first_node | VARCHAR |
| Daasity: Last node of mcf:keywordPath | keyword_path_last_node | VARCHAR |
| mcf:sourceMediumPath | source_medium_path | VARCHAR |
| Daasity: 1st node of mcf:sourceMediumPath | source_medium_path_first_node | VARCHAR |
| Daasity: Last node of mcf:sourceMediumPath | source_medium_path_last_node | VARCHAR |
| mcf:timeLagInDaysHistogram | time_lag_in_days_histogram | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | channel_first_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | vendor_first_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | sub_channel_first_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | media_type_first_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | channel_last_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | vendor_last_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | sub_channel_last_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | media_type_last_click | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | attribution_channel | VARCHAR |
Business Rules
| Business Rule | Value |
| Load Type | Upsert |
| Extraction Frequency | Daily |
| Sync Key | All dimensions |
Base Multi-Channel Funnel TABLE
Data Mapping
| JSON Element | Database Column | Datatype |
| MD5 Hash of all the Dimensions | id | VARCHAR |
| View ID selected for the integration | view_id | VARCHAR |
| mcf:transactionId | transaction_id | VARCHAR |
| mcf:conversionDate | created_on | TIMESTAMP |
| mcf:sourcePath | source_path | VARCHAR |
| mcf:basicChannelGrouping | basic_channel_path | VARCHAR |
| mcf:sourceMediumPath | source_medium_path | VARCHAR |
| mcf:mediumPath | medium_path | VARCHAR |
| mcf:campaignPath | campaign_path | VARCHAR |
| mcf:keywordPath | keyword_path | VARCHAR |
| Daasity: node number | sequence | INT |
| Daasity: from Channel Mapping Google Sheet | channel | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | vendor | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | sub_channel | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | media_type | VARCHAR |
| Daasity: from Channel Mapping Google Sheet | attribution_channel | VARCHAR |
Business Rules
| Business Rule | Value |
| Load Type | Upsert |
| Extraction Frequency | Daily |
| Sync Key | All dimensions |
EXTRACTION EXAMPLE
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
- Use the Try this API section on the right side of the page
- Video showing how to use API: https://daasitycom.sharepoint.com/:v:/s/Daasity-Product/EXUZkyoxU4VPoqcQPy5ojk8B8BRQLqgzKAQOncDHVvi8hQ?e=8ZBy2k