---
title: Google Analytics First Click Extractor Documentation (V1)
description: "This V1 integration is available for: Pro V1 *You are considered V1 if you have your own Looker instance and signed up for Daasity BEFORE July 15, 2020. If unsure, please reach out to Support@Daasity."
---

[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)

# Google Analytics First Click Extractor Documentation (V1)

### KEY TOPICS

- [ERD](https://support.daasity.com/migrated/knowledge/google-analytics-first-click-extractor-info-v1#erd)
- [ENDPOINTS](https://support.daasity.com/migrated/knowledge/google-analytics-first-click-extractor-info-v1#endpoints)

### INTEGRATION AVAILABILITY

This V1 integration is available for:

- Pro V1

*You are considered V1 if you have your own Looker instance and signed up for Daasity BEFORE July 15, 2020. If unsure, please reach out to [Support@Daasity.com](mailto:Support@Daasity.com) for assistance

### INTEGRATION OVERVIEW

Google Analytics Multi-Channel Funnels Reporting API enables you to request Multi-Channel Funnel 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 V1 Google Analytics First Click Data 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 used.

### 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 ](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](https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference)​ 
    - Use the **Try this API** section on the right side of the page.