Integrations
      Back to home
      1. Help Center
      2. ELT+ | Technical User Documentation
      3. Integrations

      Google Analytics First Click Extractor Documentation (V1)

      KEY TOPICS

      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 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 ​

      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: