Experience League
Sign In
Learn
Courses
Recommended courses
Tutorials
Certification
Events
Instructor-led training
Browse content library
View all learning options
Documentation
Community
Quick links
Experience Cloud Advocates
Meet our community of customer advocates
Events
Attend local and virtual events
Employee Advisors
Connect with one of our experts
Experience League Showcase
Read real-world use cases of Experience Cloud products written by your peers
Communities by product
Community home
Advertising
Analytics
Audience Manager
Campaign Classic v7 & Campaign v8
Campaign Standard
Developer
Experience Cloud
Experience Manager Sites & More
Experience Platform
Journey Optimizer
Target
Real-Time Customer Data Platform
Workfront
Creative Cloud
Document Cloud
Commerce
Marketo Engage
Support
Sign In
All
All
Certification
Community
Courses
Documentation
Events
Troubleshooting
Tutorials
Deutsch
English
Español
Français
Italiano
Nederlands
Português
Svenska
中文 (简体)
中文 (繁體)
日本語
한국어
Adobe Experience Cloud
Adobe Document Cloud
Profile
Profile
Achievements
View your awards after completing your profile.
Bookmarks
View your bookmarks after completing your profile.
Sign out
Learn
Courses
Recommended courses
Tutorials
Certification
Events
Instructor-led training
Browse content library
View all learning options
Search Results
Documentation
Community
Communities by product
Community home
Advertising
Analytics
Audience Manager
Campaign Classic v7 & Campaign v8
Campaign Standard
Developer
Experience Cloud
Experience Manager Sites & More
Experience Platform
Journey Optimizer
Target
Real-Time Customer Data Platform
Workfront
Creative Cloud
Document Cloud
Commerce
Marketo Engage
Quick links
Experience Cloud Advocates
Events
Employee Advisors
Experience League Showcase
Support
Home
Opening a case requires entitlement.
Open Ticket
Opening a case requires entitlement.
My Cases
Request a session
Profile
Profile
Achievements
View your awards after completing your profile.
Bookmarks
View your bookmarks after completing your profile.
Adobe Experience Cloud
Adobe Document Cloud
Search
Sign Out
Change language
Deutsch
English
Español
Français
Italiano
Nederlands
Português
Svenska
中文 (简体)
中文 (繁體)
日本語
한국어
Table of contents
Commerce Intelligence User Guide
Commerce Intelligence Introduction
Getting Started
Onboarding
Activate your Commerce Intelligence Account
Sign in to your Commerce Intelligence Account
Commerce Intelligence Essentials vs Commerce Intelligence Pro
Administrator
Account Management
Benefits of New Architecture
Display Dashboards around the office
Manage your Account
Restrict Database Access
User Management
Create/Edit User
Delete/Reactivate User
Manage User Permissions
Reset Password
Restrict Metric Access
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
Introduction
customer_entity
enterprise_rma
enterprise_rma_item_entity
sales_order
sales_order_item
quote
quote_item
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
Introduction
Formatting and importing eCommerce data
Importing Bing Ad Spend Data
Importing CJ Affiliate (Commission Junction) Marketing Data
Importing Linkshare data
Importing MailChimp data
Importing offline / other ad spend data
Using the File Uploader
Data Migration Services
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
Coupon code analysis (basic)
Coupon code analysis (advanced)
Free shipping threshold
Analyzing coupon impact
Analyzing coupon usage
Increasing ROI on your advertising campaigns
Marketing ROI
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
Introduction
Build Reports and Share Data
Data User
Reports
Report Fundamentals
Which Report Builder should I use?
Visual Report Builder
Visualization Options
Visual Report Builder filters
Visual Report Builder formulas
Manage data
Metrics
Filter sets
Copy report
Chart analyzing
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
Share Data
Exporting chart data
Automated email summaries
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
Naming Reports and Elements in Commerce Intelligence
Consolidating your tables
Declutter your Commerce Intelligence account
Working with Dashboards
Sharing Dashboards
Building an Investor Dashboard
Tutorials
Using the Visual Report Builder
Using Time Options in the Visual Report Builder
Creating Visualizations fro an SQL Query
Exporting Raw Data
Related Topics
Related Content
Documentation
Commerce
Commerce Intelligence User Guide
Export my query results
Export my query results
Last update:
2023-07-25
Topics:
Commerce Tables
View more on this topic
Data Warehouse Manager
View more on this topic
Reports
View more on this topic
Created for:
Beginner
Intermediate
Admin
Developer
User
Click
Export Data
in the
Results
pane to export your results to a
.csv
file.
Previous page
Next page
On this page
View next: