Integration Specifications

This article will help you learn about how Daasity replicates data from GA First Click, limitations to the data we can extract and where the data is stored in the GA First Click schema.

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.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

The Daasity GA First Click extractor is built based on the Google Analytics Multi-Channel Funnel Reporting API. The following endpoint is used by Daasity to replicate data from GA:

Entity Relationship Diagram (ERD)

Click here to view the Daasity GA First Click integration illustrating the different tables and keys to join across tables.

GA First Click Schema

The Daasity GA First Click 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.

Multi-Channel

JSON Element Database Column

MD5 Hash of 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

Multi-Channel Funnel

JSON Element Database Column

MD5 Hash of 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

Last updated