- Commerce Intelligence User Guide
- Commerce Intelligence Introduction
- Getting Started
- Administrator
- Analyze Data
- Data Analyst
- Data Warehouse Manager
- Introduction
- Advanced Calculated Column Types
- Building Google Ecommerce dimensions
- Calculated Column Types
- Configuring Replication Methods
- Configuring Data Rechecks
- Changing a metric’s operational table
- Creating and Using Data Warehouse Views
- Creating / Deleting paths for calculated columns
- Creating / Using a SQL Calculated Column
- Creating calculated columns
- Data and Updates Information
- Guest orders
- How Commerce Stores Data
- Entity Relationship Diagrams
- Managing data dimensions in metrics
- MongoDB data modeling guide
- Replicating Google Analytics channels
- Standardizing data with mapping tables
- Translating SQL queries into Commerce Intelligence reports
- Understanding and Evaluating Table Relationships
- Using the Date Difference Calculated
- Using Dashboard Wide Filtering
- Using the Event Number Calculated Column
- Using the Sequential Comparison Calculated Column
- Common Commerce Tables
- SQL Report Builder
- Using the Cohort Report Builder
- Using the Cohort Report Builder for Non-Date Based Cohorts
- Creating a qualitative cohort analysis
- Explore special filter operators
- Export the results of my query
- Using Formulas in the [Report Builder]
- Create Google Analytics charts
- Importance of the Lifetime Revenue Cohort Analysis
- Ordering data using the Show Top/Bottom feature
- Using the SQL Report Builder
- First purchase report
- Understanding the Repeat Order Probability Report
- Auditing Metrics using the SQL Report Builder
- Differences in Columns Between SQL and Data Warehouse Manager
- Connecting Data
- SaaS Integrations
- SaaS Integrations
- Understand Results Between Database and SQL Editor
- Connecting Adobe Analytics
- Expected Adobe Analytics Data
- Connecting Facebook Ads
- Expected Facebook Ads data
- Connecting Google Adwords
- Expected Google Adword data
- Auditing Google Adwords data
- Connecting Google Analytics Warehoused
- Expected Google Analytics Warehoused Data
- Connecting Google Analytics
- Expected Google Analytics data
- Connecting Google ECommerce
- Expected Google ECommerce data
- Connecting Mixpanel
- Expected Mixpanel data
- Data Validation in Mixpanel
- Connecting PrestaShop
- Connecting Quickbooks
- Expected Quickbooks data
- Connecting Salesforce
- Expected Salesforce data
- Connecting Spree
- Expected Spree Data
- Connecting Stripe
- Expected Stripe data
- Connecting WooCommerce
- Connecting Zendesk
- Expected Zendesk data
- Analyzing Zendesk data
- Auditing Zendesk data
- Database Integrations
- Connecting Amazon RDS
- Connecting Databases via VPN
- Connect Your MySQL Database to Commerce Intelligence
- Connecting Adobe Commerce
- Expected Commerce Data
- Connecting Microsoft SQL Server
- Connecting MongoDB via SSH Tunnel
- Connecting MySQL via a direct connection
- Connecting MySQL via cPanel
- Connecting MySQL via SSH Tunnel
- Connecting PostgreSQ
- Analyze Campaigns
- Analyze Customers
- Calculating Commerce churn rates
- Defining customer concentration
- Defining customer churn
- Expected Lifetime Value (LTV) analysis (basic)
- Expected Lifetime Value (LTV) analysis (advanced)
- Track User Acquisition Source Data Overview
- Track User Device and Browser Data in your Database
- Analyzing customer repurchasing behavior
- Analyzing Website Activity and Customer Conversion Rates
- Recency, frequency, monetary (RFM) analysis
- Analyze Business Performance
- Tracking goals against actual metrics
- Analyzing returned orders
- Year-over-year, month-over-month, week-over-week
- Analyzing holiday season performance
- Analyzing repeat probability decay and churn
- Understanding and building a basic analytics
- Identifying your most valuable marketing sources and channels
- Understanding Google Analytics UTM attribution
- Analyzing inventory levels
- Reporting a retail calendar
- Forecasting
- Build Reports and Share Data
- Data User
- Reports
- Dashboards
- Create Dashboards
- Out-of-the-box dashboards
- Dashboard Pro
- Importing charts from another user
- Permanently deleting a chart
- Using Dashboard Groups
- Managing Dashboards
- Deleting Dashboards
- Renaming Dashboards
- Setting a default Dashboard
- Adding charts to Dashboards
- Removing charts from Dashboards
- Sizing and arranging charts in a Dashboard
- Bulk-editing charts in Dashboards
- Cloning Dashboards
- Searching for Dashboards
- Sharing Dashboards with other users
- Sharing Dashboards organization-wide
- Accessing shared Dashboards
- Changing access to shared Dashboards
- Leaving (unsharing) a Dashboard
- Sharing Data
- Best Practices
- Working with Data
- Working with data
- UTM tagging in Google Analytics
- Formatting and Importing Financial Data
- Recommended Data Dimensions for Segmentation and Filtering
- Checking the Update Cycle Status
- Reducing Your Update Cycle Time
- Modifying Your Database to Support Incremental Replication
- Optimizing your Database for Analysis
- Optimizing Your SQL Queries
- Understanding your Commerce Intelligence Environment
- Project Organization
- Working with Dashboards
- Working with Data
- Tutorials
Google Analytics using Acquisition Sources
What are Channels?
Creating custom segments to see how different traffic performs and observe trends is one of the most powerful uses for Google Analytics. One class of segments that exist by default in Google Analytics are Channels. Channels are a grouping of common ways that people come to your site. Google Analytics automatically sorts the many ways that you acquire a user - whether it is social media, pay-per-click, email, or referral links - and bundles them into a bucket, or Channel.
Why do not I see my channels in Commerce Intelligence?
Channels are simple, aggregate buckets of data. To sort your acquisitions into Channel buckets, Google sets distinct rules and definitions using specific parameters: a combination of acquisition Source (the origin of your traffic) and acquisition Medium (the general category of the source).
While having these buckets can help you make sense of where your traffic is coming from, this data is not tagged by channel but by a combination of Source and Medium. Because Google sends channel information as two separate data points, channel groupings do not automatically show up in Commerce Intelligence.
What are the default channel groupings? How are they created?
By default, Google sets up eight different channels. The rules that determine how channels are created are below.
| Channel | What is it? | How is it created? |
|---|---|---|
| Direct | Anyone who comes directly into your site. | Source = DirectAND Medium = (not set); OR Medium = (none) |
| Organic Search | Traffic that has been organically ranked in unpaid search engines. | Medium = organic |
| Referral | Traffic that comes in from an external link that is not Organic Search or from websites that are not social networks. | Medium = referral |
| Paid Search | Traffic that has a UTM Tracking code where the medium is either “cpc”, “ppc”, or “paidsearch” AND is an ad distribution network that does not match “Content.” | Medium = `^(cpc |
| Social | Referral traffic that comes from any of approximately 400 social networks and are not tagged as ads. | Social Source referral = YesOR Medium = `^(social |
| Traffic from sessions that are tagged with a medium of “email.” | UTM Tracking code of Medium = email |
|
| Display | Traffic that has a UTM Tracking code where the medium is either display or cpm. Also includes AdWords interaction where the ad distribution network matches “Content” | Medium = `^(display |
| Other | Sessions from other advertising channels (not including Paid Search) that are tagged with a medium of “cpc”, “ppc”, "cpm, “cpv”, “cpa”, “cpp”, “affiliate”. | Medium = `^(cpv |
How can I recreate these channel groupings in my Data Warehouse?
Now that you know channels are just combinations of sources and mediums, it is an easy 3-step process to recreate these groupings in your Data Warehouse.
-
Enable yourGoogle ECommerceintegration
When enabled, make sure to sync the medium and source fields in your Data Warehouse. After this is completed, medium and source acquisition data will be brought into your Data Warehouse.
-
Upload a mapping of Google’s channel groupings
Adobe Commerce creates a table with the default groupings mapped as a file that you can download.
If you are a Google Analytics pro and created your own channels, you want to add your specific rules to the mapping table before uploading the file into Commerce Intelligence.
Bring it into your Data Warehouse as a File Upload.
-
Establish a relationship betweenGoogle ECommerceand Mappings File Upload
To establish a relationship between theGoogle ECommerce and the mapping table, submit a support request to your Data Analyst team and reference this topic. The analyst creates a new calculated column called Channel in the ECommerce table. After a full update cycle, this column will be ready to use in a
FilterorGroup by.
You now have Google Analytics Channel groupings in your Data Warehouse, which means you can analyze your data from a new perspective:
In this example, you started simple with segmenting the Number of Orders metric by Channel. Test out your new column and see what trends you can identify in your Google Analytics Channel data!
Related documentation
Resources
Adobe Account
