Version 10.2
Reports Guide
Oracle ATG
One Main Street
Cambridge, MA 02142
USA
ATG Reports Guide
Product version: 10.2
Release date: 04-30-13
Document identifier: ReportsGuide1403311801
Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are
protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy,
reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any
means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please
report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government,
the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the
hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable
Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or
documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S.
Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended
for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or
hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures
to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in
dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are
trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or
registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
Portions of this product may contain the following: EditLive Authoring Software Copyright © 2004 Ephox Corporation. All rights reserved.
Some code licensed from RSA Security, Inc. Some portions licensed from IBM, which are available at http://oss.software.ibm.com/icu4j/.
This product may include software developed by the Apache Software Foundation (http://www.apache.org/). Spell checking software from
Wintertree Software Inc. The Sentry Spell Checker Engine © 2000 Wintertree Software Inc. This product also includes software developed
by the following: Free Software Foundation, GNU Operating System, Incanto, JSON.org, JODA.org, The Dojo Foundation, Adobe Systems
Incorporated, Eclipse Foundation and Singular Systems.
The software is based in part on the work of the Independent JPEG Group.
This software or hardware and documentation may provide access to or information on content, products, and services from third parties.
Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party
content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to
your access to or use of third-party content, products, or services.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/
topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support: Oracle customers have access to electronic support through My Oracle Support. For information, visit http://
www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing
impaired.
The MIT License
Copyright (c) 2007 FlexLib Contributors. See: http://code.google.com/p/flexlib/wiki/ProjectContributors
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the
"Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute,
sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following
conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS
OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR
OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
ATG Reports Guide v
Table of Contents
1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2. Accessing Dashboards and Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
3. Reporting Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Default Date Range . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Gross Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Net Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Revenue Attributed to Promotions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
Filtering Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4. Dashboards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
ATG Web Commerce Performance Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
ATG Product Performance Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
ATG Promotion Performance Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
ATG Search Performance Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
5. Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Site Traffic Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Hourly Traffic (Week/Week) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Key Conversion Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
Key Traffic Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
Site Conversion Analysis (Week/Week) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Weekly Traffic (Week/Week) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Sales Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Age Group Sales Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Channel Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Gender Sales Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Key Product Sales Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Key Sales Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Product Sales Share . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Sales Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Sales Component Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Segment Order Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Segment Sales Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Site Order Analysis (Week/Week) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
SKU Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Top Product Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Promotions Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Age Group Promotional Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Avg Order Discount Per Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Discounted Products . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Gender Promotional Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Key Promotion Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Promotion Summary Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Promotional Revenue Impact . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Segment Promotional Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Search Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Key Search Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Query Type Breakdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Response Time Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
Search Conversion Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
Search Conversion Funnel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
Search Terms Not in the Dictionary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
Search Terms Not in the Indexed Content . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
vi ATG Reports Guide
Search Terms with No Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Searches per Visit by Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Searches Resulting in Most Purchases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Top Firing Search Configuration Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Top Products associated with Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Top Search Terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Customer Service Center Analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Agent Summary Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Key Call Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Key Service Indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Top Product Returns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
1 Introduction 1
1 Introduction
This book provides information about the business intelligence content that is provided with Oracle ATG Web
Commerce. These analyses are based on the data gathered in the Oracle ATG Web Commerce data warehouse
and they run in the Oracle Business Intelligence Middleware Platform.
You must have installed Oracle Business Intelligence to use the business intelligence content described in this
book. See instructions for deploying the content in Oracle Business Intelligence in the ATG Business Intelligence
Installation and Configuration Guide. See complete information about installing and using Oracle Business
Intelligence in the documentation for that product (http://www.oracle.com/technetwork/middleware/bi-
enterprise-edition/documentation/bi-ee-087853.html).
See information about the Oracle ATG Web Commerce data warehouse and the information it contains in the
ATG Data Warehouse Guide.
2 1 Introduction
2 Accessing Dashboards and Analyses 3
2 Accessing Dashboards and Analyses
The dashboards and analyses provided with Oracle ATG Web Commerce run on an Oracle Business Intelligence
server. After the Oracle ATG Web Commerce dashboard and analysis definitions have been deployed on an
Oracle Business Intelligence server you will find a folder labeled “ATG” in the Oracle Business Intelligence catalog
and a category of dashboards also labeled “ATG.”
Oracle ATG Web Commerce and Oracle Business Intelligence are independent products and your organization
may choose to make Oracle Business Intelligence available through a variety of network configurations. Find the
Web address of your Oracle Business Intelligence server from your organization.
To view Oracle ATG Web Commerce dashboards and analyses in the Oracle Business Intelligence user interface:
1. Log in to Oracle Business Intelligence. The Web address for the Oracle Business Intelligence user interface is
typically similar to:
http://server-name:7001/analytics
2. Open an Oracle ATG Web Commerce Business Intelligence dashboard from the Dashboards menu. Choose
Catalog > ATG to browse through individual Oracle ATG Web Commerce Business Intelligence analyses.
See information about the specific dashboards and analyses that are provided with Oracle ATG Web Commerce
in Dashboards (page 7) and Analyses (page 11).
See comprehensive information about working with dashboards and analyses in the documentation for the
Oracle Business Intelligence product (http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/
documentation/bi-ee-087853.html).
4 2 Accessing Dashboards and Analyses
3 Reporting Concepts 5
3 Reporting Concepts
This section explains concepts that are important to understand when you interpret the reports provided for
Oracle ATG Web Commerce.
In addition to the concepts specific to Oracle ATG Web Commerce, make sure you understand how to use
the Oracle Business Intelligence reporting tools. See complete information about installing and using Oracle
Business Intelligence in the documentation for that product.
Default Date Range
You can open the analyses provided with Oracle ATG Web Commerce directly from the Oracle Business
Intelligence presentation catalog. Most of the analyses do not include controls for setting the date range for the
data they include. The analyses typically use the date range set by the dashboards that they appear on. If you
open an analysis that has no date range controls, it will select data from the default date range.
The default date range is the 60 day period preceding the current date.
Gross Revenue
Gross revenue is the total price of the items that have been sold. It is calculated by multiplying the number
of items sold by the prices for those items. Gross revenue does not include tax or shipping revenue and it is
calculated before any discounts are deducted.
gross revenue = number of items sold X item price
Net Revenue
Net revenue is the total currency amount that your organization receives as a result of sales. It includes the Gross
Revenue (page 5) for your sales and also the shipping and tax revenue. Any discounts are subtracted from
the net revenue.
6 3 Reporting Concepts
net revenue = (gross revenue + shipping + tax) - (markdown discounts + promotional discounts)
Revenue Attributed to Promotions
The Oracle ATG Web Commerce data warehouse collects information about the promotional programs that your
customers use. One piece of this information is the currency value of the sales in which those promotions are
used. The revenue resulting from the sales is attributed to the promotions.
The net revenue from sales is attributed to promotions. See information about the way net revenue is calculated
in Net Revenue (page 5).
If a customer uses more than one promotion when making a purchase, the revenue is divided equally between
each of the promotions.
Filtering Options
The filtering options available on the analysis Dashboards (page 7) are explained in the following table.
Component Description
Period Ending The ending date of the date range. Data collected in the data warehouse during the
date range is included in analyses.
The ending date is not inclusive. For example, if you set the period ending date to July
10 and trailing days to two days, analyses will include data collected on July 8 and July
9.
Trailing Days The number of days included in the date range. Data collected in the data warehouse
during the date range is included in analyses.
Site The Web sites that are considered. Data collected in the data warehouse that is
associated with the sites you select is included in the analyses.
Language The search query languages that are considered. Search queries that are associated
with the languages you select are included in the analyses.
This filter is available on the ATG Search Performance Dashboard (page 8).
Product The product that are considered. Transactional data associated with the product you
select is included in the analyses.
This filter is available on the ATG Product Performance Dashboard (page 8).
4 Dashboards 7
4 Dashboards
Dashboards are a collection of related analyses displayed on one or more pages. You can apply Filtering
Options (page 6) to all the analyses on the dashboard. See information about using dashboards in the
documentation for the Oracle Business Intelligence product (http://www.oracle.com/technetwork/middleware/
bi-enterprise-edition/documentation/bi-ee-087853.html).
ATG Web Commerce Performance Dashboard
The ATG Web Commerce Performance dashboard aggregates data from multiple subject areas. It provides an
overview of the activity associated with your Oracle ATG Web Commerce sites.
You can filter all the pages on the dashboard by individual Web site if your Oracle ATG Web Commerce
application is configured with more than one site. You can also set the period-ending date and number of
trailing days. On the Search page, you can filter analyses by language. See Filtering Options (page 6).
The dashboard includes the pages described in the following table.
Page Description
Sales Displays information about the orders and returns that occurred on your
Web sites. This includes information about the products involved in those
orders and returns and the groups of customers.
Promotions Displays information about the promotional programs that ran on your
Web sites. This includes information about the effect of promotions on
sales revenue and the discounts that were offered.
Traffic Displays information about visits to your Web sites. This includes
information about searches, conversions and registrations. The data on the
traffic page can be filtered by using the Site dashboard prompt.
Search Displays information about the search queries that were submitted at your
Web sites, the time it took to complete the searches, and sales associated
with them. You can filter this page by language.
Contact Center Displays information about activity in your customer service center. This
includes information about individual customer service agents and the
sales and appeasements associated with calls.
8 4 Dashboards
ATG Product Performance Dashboard
The ATG Product Performance dashboard provides information about the orders and returns for individual
products. It includes information about the site visitors and search queries associated with product orders.
When you open the ATG Product Performance dashboard it is filtered by an individual product. You can change
the product filter and you can filter all the pages on the dashboard by individual Web site if your Oracle ATG
Web Commerce application is configured with more than one site. You can also set the period-ending date and
number of trailing days. See Filtering Options (page 6).
The ATG Product Performance dashboard is not divided into separate pages. Because the analyses on the
dashboard require filtering by product, you must open it by clicking a product link on other analyses.
ATG Promotion Performance Dashboard
The ATG Promotion Performance dashboard provides information about the usage and effect on revenue of
individual promotional programs. It includes information about the number of uses, the product units involved,
discount amounts, and which visitor segments used the promotions.
When you open the ATG Promotion Performance dashboard it is filtered by an individual promotion. You can
change the promotion filter and you can filter all the pages on the dashboard by individual Web site if your
Oracle ATG Web Commerce application is configured with more than one site. You can also set the period-
ending date and number of trailing days. See Filtering Options (page 6).
The ATG Promotion Performance dashboard is not divided into separate pages. Because the analyses on the
dashboard require filtering by product, you must open it by clicking a promotion link on other analyses.
ATG Search Performance Dashboard
The ATG Search Performance dashboard provides information about the way that Oracle ATG Web Commerce
Search is used on your Web sites.
You can filter all the pages on the dashboard by language and by individual Web site if your Oracle ATG Web
Commerce application is configured with more than one site. You can also set the period-ending date and
number of trailing days. See Filtering Options (page 6).
Page Description
Search Activity Displays information about the way the search function has been used and
the response time for search queries
Keyword Analysis Displays information about the words used in search queries. Includes
information about frequently used words and words that produce no results.
4 Dashboards 9
Page Description
Search Merchandising Displays information about the relationship between search queries and sales
on your Web sites. This includes information about how often search rules are
used.
10 4 Dashboards
5 Analyses 11
5 Analyses
This section provides information about the individual analyses that are provided with Oracle ATG Web
Commerce. Analyses are reports that include a small set of related information and are grouped together on
dashboards.
The data presented in analyses is controlled by parameters such as the date range and the Web sites that are
included. If you view an analysis in the context of a dashboard, the filtering options for that dashboard affect the
analysis. If you open an analysis directly from the Oracle Business Intelligence presentation catalog, the default
date range applies to it. See Default Date Range (page 5) and Filtering Options (page 6).
See general information about using analyses in the documentation for the Oracle Business Intelligence product
(http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/bi-ee-087853.html).
Site Traffic Analyses
The site traffic analyses provide information about the visitors to your Web sites.
Hourly Traffic (Week/Week)
The Hourly Traffic (Week/Week) analysis provides information about the number of site visits that occur during
each one-hour period of the day. It returns results from a two-week period and compares one week with the
other.
The components of the analysis are explained in the following table.
Component Description
# Visits Compares the number of site visits per hour of day that occurred in each
week
# Visits (Week/Week) Shows the percentage change from the previous week to the more recent
week. The value is calculated as shown below:
(later week value - earlier week value) / earlier week value
12 5 Analyses
Key Conversion Indicators
The Key Conversion Indicators analysis provides information about site visits that include sales.
The components of the analysis are explained in the following table.
Component Description
Conversion Rate The percentage of site visits in which sales occurred
The trend sparkline shows this percentage for each date in the period set by
the period ending date and the number of trailing days.
The following calculation rows show the percentage for the week before the
period ending date, the week before that, and the percent change between
those two weeks.
Gross Revenue per Visit The currency value of the items sold divided by the number of site visits.
See information about the way gross revenue is calculated in Gross
Revenue (page 5).
The trend sparkline shows the average value of sales for each date in the
period set by the period ending date and the number of trailing days.
The following calculation rows show the average value of sales for the
week before the period ending date, the week before that, and the percent
change between those two weeks.
Discounts per Visit The value of promotional discounts that were applied to orders divided by
the number of site visits
The trend sparkline shows the average value of promotional discounts sales
per visit for each date in the period set by the period ending date and the
number of trailing days.
The following calculation rows show the average value of sales per visit
for the week before the period ending date, the week before that, and the
percent change between those two weeks.
Key Traffic Indicators
The Key Traffic Indicators analysis provides information about site visits.
The components of the analysis are explained in the following table.
5 Analyses 13
Component Description
# Visits The number of user sessions that were opened
The trend sparkline shows the number of user sessions opened on each
date in the period set by the period ending date and the number of trailing
days.
The following calculation rows show the number of user sessions opened
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
Avg Page Views The number of Web site pages served divided by the number of user
sessions that were opened
The trend sparkline shows the average number of pages served on each
date in the period set by the period ending date and the number of trailing
days.
The following calculation rows show the average number of pages served
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
Avg Duration (seconds) The length, in seconds, of all user sessions divided by the number of user
sessions
User session duration is the number of seconds between the time a new
Web site user session begins and the time that it ends by timing out after
the last server request.
The trend sparkline shows the average session length in the period set by
the period ending date and the number of trailing days.
The following calculation rows show the average session length during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
# Registrations The number of new, external user accounts created for your Web sites
The trend sparkline shows the number of new, external user accounts
created on each date in the period set by the period ending date and the
number of trailing days.
The following calculation rows show the number of new, external user
accounts created during the week before the period ending date, the week
before that, and the percent change between those two weeks.
14 5 Analyses
Component Description
# Uniquely Identified Visitors The number of individual registered users that visited your Web sites. This
does not include anonymous site visitors.
The trend sparkline shows the number of individual, registered site visitors
on each date in the period set by the period ending date and the number
of trailing days.
The following calculation rows show the number of individual, registered
site visitors during the week before the period ending date, the week
before that, and the percent change between those two weeks.
Site Conversion Analysis (Week/Week)
The Site Conversion Analysis (Week/Week) analysis provides information about the percentage of site visits that
include a purchase. It returns results from a two-week period and compares one week with the other.
The components of the analysis are explained in the following table.
Component Description
Conversion Rate Compares the percentages of site visits that included a purchase in each
week
Conversion Rate (Trailing 7
Day Pct Var)
Shows the percentage change from the previous week to the more recent
week. The value is calculated as shown below:
(later week value - earlier week value) / earlier week value
Weekly Traffic (Week/Week)
The Weekly Traffic (Week/Week) analysis provides information about the number of site visits that occur during
each day of the week. It returns results from a two-week period and compares one week with the other.
The components of the analysis are explained in the following table.
Component Description
# Visits Compares the number of site visits per day of the week that occurred in each
week
# Visits (Week/Week) The percentage change between the number of site visits during the week
before the period ending date and the number of site visits the week before
that
5 Analyses 15
Sales Analyses
The sales analyses provide information about the purchases that are made on your Web sites and other sales
channels.
Age Group Sales Breakdown
The Age Group Sales Breakdown provides the percentages of the total number of items purchased by registered
Web site users in different age groups. Registered users who do not specify an age group are excluded from the
calculations.
By default, this analysis considers data from the past 60 days. If the analysis is part of a dashboard, the period
ending and trailing days settings for the dashboard will override this default.
The components of the analysis are explained in the following table.
Component Description
Units % Compares the number of items purchased by registered Web site users in
different age groups. Registered users who do not specify an age group are
excluded from the calculations.
Channel Sales
The Channel Sales analysis compares information about the sales that occur through different means within
your organization. The channels for sales include your Web sites and your customer service center.
The components of the analysis are explained in the following table.
Component Description
Avg Order Size Compares the average number of items in the orders that were placed
through each channel. The table above the graph provides the average
number of units in the orders for each channel.
Avg Order Value Compares the average value of the orders that were placed through each
channel. The table above the graph provides the average currency value of
the orders for each channel.
Avg Order Discount Compares the average value of the discounts applied to orders in each
channel. The table above the graph provides the average currency value of
discounts applied for each channel.
The discounts included in this calculation do not include appeasements
applied by customer service agents.
% Orders Compares the percentage of total orders that occurred in each channel. The
table above the graph provides the number of orders for each channel.
16 5 Analyses
Component Description
% Units Compares the percentage of the total items that were sold in each channel.
The table provides the number of units for each channel.
% Gross Revenue Compares the percentage of gross revenue that was generated by the sales
in each channel. The table provides the currency value of the gross revenue
for each channel.
See information about the way gross revenue is calculated in Gross
Revenue (page 5).
% Discounts Compares the percentage of the total value of discounts applied to the
orders in each channel. The table provides the currency value of the
discounts applied for each channel.
The discounts included in this calculation do not include appeasements
applied by customer service agents.
Gender Sales Breakdown
The Gender Sales Breakdown provides the percentages of the total number of items in purchases by registered
Web site users of different genders. Registered users who do not specify a gender are excluded from the
calculations.
By default, this analysis considers data from the past 60 days. If the analysis is part of a dashboard, the period
ending and trailing days settings for the dashboard will override this default.
The components of the analysis are explained in the following table.
Component Description
Units % Compares the number of items purchased by registered Web site users of different
genders. Registered users who do not specify a gender are excluded from the
calculations.
Key Product Sales Indicators
The Key Product Sales Indicators analysis provides information about sales of an individual product.
This analysis is not intended to be used without a product filter. If you open it directly from the analysis
catalog, it contains information about sales of all products. Use this analysis on the ATG Product Performance
Dashboard (page 8).
The components of the analysis are explained in the following table.
5 Analyses 17
Component Description
# Orders The number of purchases that were submitted
The line graph shows the number of orders on each date in the period set by
the period ending date and the number of trailing days.
The table below the line graph shows the number of orders during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
Units The number of items in the orders that were submitted
The line graph shows the number of items purchased on each date in the
period set by the period ending date and the number of trailing days.
The table below the line graph shows the number of items purchased
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
Gross Revenue The currency value of the items sold. See information about the way gross
revenue is calculated in Gross Revenue (page 5).
The line graph shows the total value on each date in the period set by the
period ending date and the number of trailing days.
The table below the line graph shows the total value during the week before
the period ending date, the week before that, and the percent change
between those two weeks.
Avg Selling Price The average price of all the items in the orders that were submitted
The line graph shows the average price on each date in the period set by the
period ending date and the number of trailing days.
The table below the line graph shows the average price during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
Key Sales Indicators
The Key Sales Indicators analysis provides information about sales volume and revenue.
The components of the analysis are explained in the following table.
18 5 Analyses
Component Description
# Orders The number of purchases that were submitted
The trend sparkline shows the number of orders on each date in the period
set by the period ending date and the number of trailing days.
The following calculation rows show the number of orders during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
Units The number of items purchased
The trend sparkline shows the number of items purchased on each date in
the period set by the period ending date and the number of trailing days.
The following calculation rows show the number of items purchased during
the week before the period ending date, the week before that, and the
percent change between those two weeks.
Gross Revenue The total currency value of the items sold. See information about the way
gross revenue is calculated in Gross Revenue (page 5).
The trend sparkline shows the value of sales on each date in the period set
by the period ending date and the number of trailing days.
The following calculation rows show the value of sales during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
Avg Order Value The average currency value of the purchases that were submitted. This value
is calculated by dividing the gross revenue by the number of orders.
The trend sparkline shows the average order value on each date in the
period set by the period ending date and the number of trailing days.
The following calculation rows show the average order value during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
Avg Order Size The average number of items in the purchases that were submitted. This
value is calculated by dividing the total number of items sold by the number
of purchase transactions.
The trend sparkline shows the average order size on each date in the period
set by the period ending date and the number of trailing days.
The following calculation rows show the average order size during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
5 Analyses 19
Component Description
Avg Order Discount The average currency value of the promotional discounts applied to
purchases. This value is calculated by dividing the total of all discounts
applied by the number of purchase transactions.
The trend sparkline shows the average order discount on each date in the
period set by the period ending date and the number of trailing days.
The following calculation rows show the average order discount during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
Product Sales Share
The Product Sales Share analysis provides information about the proportion of all sales that are made up by an
individual product.
This analysis is not intended to be used without a product filter. If you open it directly from the analysis
catalog, it contains information about sales of all products. Use this analysis on the ATG Product Performance
Dashboard (page 8).
The components of the analysis are explained in the following table.
Component Description
Product performance table The table at the top of the analysis provides the numeric percentages of
product sales for the period set by the period ending date and the number
of trailing days.
Order Share is the percentage of all purchase transactions that include the
product.
Unit Share is the percentage of all items sold that is made up by the
product.
Gross Revenue Share is the percentage of the value of all items sold that is
made up by the product. See information about the way gross revenue is
calculated in Gross Revenue (page 5).
Order Share The percentage of all purchase transactions that include the product
The line graph shows the percentage on each date in the period set by the
period ending date and the number of trailing days.
Unit Share The percentage of all items sold that is made up by the product
The line graph shows the percentage on each date in the period set by the
period ending date and the number of trailing days.
20 5 Analyses
Component Description
Gross Revenue Share The percentage of the value of all items sold that is made up by the
product. See information about the way gross revenue is calculated in
Gross Revenue (page 5).
The line graph shows the percentage on each date in the period set by the
period ending date and the number of trailing days.
Sales Analysis
The Sales Analysis provides a set of data regarding sales for each date in a period of time that you select.
The analysis does not appear on any of the dashboards. Open it directly from the analysis catalog. Enter the
beginning and end dates of the period you want to include in the report. Select the sites that you want to
include.
The components of the analysis are explained in the following table.
Component Description
# Orders The number of purchase transactions that occurred on each day of the date range
Units The number of items that were purchased on each day of the date range
Gross Revenue The currency value of the sales that occurred on each day of the date range
See information about the way gross revenue is calculated in Gross Revenue (page
5).
Discounts The currency value of the discounts that were applied to purchases on each day of
the date range
Net Revenue The currency value of the sales that occurred on each day of the date range
Net revenue includes revenue components such as tax and shipping. It is
calculated after discounts are applied. See Net Revenue (page 5).
Avg Order Value The average currency value of the purchase transactions that occurred on each day
of the date range
Avg Order Size The average number of items in the purchase transactions that occurred on each
day of the date range
Sales Component Analysis
The Sales Component Analysis provides information about the proportions of gross revenue, tax revenue,
shipping revenue and discounts. These are components of the net revenue. See information about the way
gross and net revenue are calculated in Gross Revenue (page 5) and Net Revenue (page 5).
The components of the analysis are explained in the following table.
5 Analyses 21
Component Description
Sales Component Share The proportions of gross revenue, tax revenue, shipping revenue and
discounts in the net revenue. See information about the way gross and net
revenue are calculated in Gross Revenue (page 5) and Net Revenue (page 5).
The bar graph shows the proportions of revenue components during the
period set by the period ending date and the number of trailing days.
The table below the line graph shows the total currency value of each
component during the period set by the period ending date and the
number of trailing days. It also provides the percentage of net revenue
during that period.
Segment Order Analysis
The Segment Order Analysis compares the purchases made by different user segments, or demographic
divisions.
The components of the analysis are explained in the following table.
Component Description
segment table Sales calculations for each user segment
# Orders is the number of purchase transactions submitted by users in the segment.
% (for # Orders) is the percentage of all purchase transactions that were made by users
in the segment.
Gross Revenue is the total currency value of the items purchased by the users in
the segment. See information about the way gross revenue is calculated in Gross
Revenue (page 5).
% (for Gross Revenue) is the percentage of the total gross revenue that is attributed to
purchases by the users in the segment. See information about the way gross revenue is
calculated in Gross Revenue (page 5).
AOV (Average Order Value) is the average value of the purchase transaction made by
the users in the segment.
bar graph Compares sales calculations for each user segment. Choose one of the calculations in
the Sales Metric menu.
Segment Sales Breakdown
The Segment Sales Breakdown analysis provides the percentages of the total number of items purchased by
registered Web site users in different user segments, or demographic divisions.
The components of the analysis are explained in the following table.
22 5 Analyses
Component Description
Units % Compares the number of items purchased by registered Web site users in
different user segments.
Site Order Analysis (Week/Week)
The Site Order Analysis (Week/Week) compares information about the purchases made at your Web sites. It
returns results from a two-week period and compares one week with the other.
The components of the analysis are explained in the following table.
Component Description
Avg Order Value Compares the average currency value of the purchases made at each Web
site.
Avg Order Value (Prior
Trailing 7 Day Pct Var)
The percentage change in the average value of purchases from the previous
week to the more recent week.
SKU Breakdown
The SKU Breakdown analysis provides information about the sales of individual product Stock Keeping Units
(SKUs). Individual SKUs are a subset of a product. For example, different sizes of a product may have individual
SKUs. Use this analysis on the ATG Product Performance Dashboard (page 8) where it is filtered to show only one
product.
The components of the analysis are explained in the following table.
Component Description
SKU Name The name assigned to the SKU
SKU ID The identifier assigned to the SKU
Units The number of items of the SKU that were sold in the period set by the
period ending date and the number of trailing days
% (for Units) The percent of all items sold that are made up by the SKU
The percentage is calculated based on the item total that is selected by the
analysis. Typically it is restricted by the product and date range filters on the
ATG Product Performance Dashboard (page 8).
Gross Revenue The currency value of the items of the SKU that were sold in the period set
by the period ending date and the number of trailing days. See information
about the way gross revenue is calculated in Gross Revenue (page 5).
5 Analyses 23
Component Description
% (for Gross Revenue) The percent of the value of all item sales that are made up by the SKU.
See information about the way gross revenue is calculated in Gross
Revenue (page 5).
The percentage is calculated based on the gross revenue that is selected by
the analysis. Typically it is restricted by the product and date range filters on
the ATG Product Performance Dashboard (page 8).
Top Product Sales
The Top Product Sales analysis provides information about the sales of individual products.
Note: if there were no sales of a product during the date range, that product is excluded from the Top Product
Sales analysis.
The components of the analysis are explained in the following table.
Component Description
Rank The position of the product when the list of products is sorted according to the number
of orders that include it. This is the default sorting order for the analysis.
Product Name The name assigned to the product
Product ID The identifier assigned to the product
Orders The number of purchase transactions that included the product
% (for Orders) The percent of all purchase transactions that included the product
Gross Revenue The total currency value of the items sales of the product. See information about the
way gross revenue is calculated in Gross Revenue (page 5).
% (for Orders) The percent of the value of all items sales that is made up by the product. See
information about the way gross revenue is calculated in Gross Revenue (page 5).
Promotions Analyses
The promotions analyses provide information about the promotional programs available on your Web sites and
other sales channels.
24 5 Analyses
Age Group Promotional Breakdown
The Age Group Promotional Breakdown analysis provides information about the way that registered Web site
users in different age groups use promotional programs. Registered users who do not specify an age group are
excluded from the calculations.
The components of the analysis are explained in the following table.
Component Description
Uses % Compares the number of times that promotional programs were used by registered
Web site users in different age groups. Users who have not specified an age group are
excluded from the calculation.
Avg Order Discount Per Site
The Avg Order Discount Per Site analysis provides information about the promotional and markdown discounts
that are applied to purchases at your Web sites.
The components of the analysis are explained in the following table.
Component Description
Avg Order Discount The average currency value of the promotional and markdown discounts
applied to purchases at each of your Web sites
The bar graph compares the average values at each site. The table provides
the average values in numeric format.
Discounted Products
The Discounted Products analysis provides information about the promotional discounts that are applied to
individual products. Click a product name link to open the ATG Product Performance Dashboard (page 8).
The components of the analysis are explained in the following table.
Component Description
Product Name The name assigned to the product
Click the link to open the ATG Product Performance Dashboard (page 8).
Product ID The identifier assigned to the product
Units The number of items to which promotional discounts were applied
5 Analyses 25
Component Description
% (for Units) The percent of all promotionally discounted items made up by the product
Markdown The total currency value of the promotional discounts applied to sales of the product
% (for Markdown) The percent of the value of all promotional discounts that were applied to sales of
the product
Revenue The currency value of the sales of the product to which promotional discounts were
applied. The sale value is the Net Revenue (page 5) of the product items.
% (for Revenue) The percent of the revenue attributed to all promotional usage that is made up by
the promotions applied to sales of the product
Gender Promotional Breakdown
The Gender Promotional Breakdown analysis provides information about the way that registered Web site users
of different genders use promotional programs. Registered users who do not specify a gender are excluded from
the calculations.
The components of the analysis are explained in the following table.
Component Description
Uses % Compares the number of times that promotional programs were used by registered
Web site users of different genders. Users who have not specified a gender are excluded
from the calculation.
Key Promotion Indicators
The Key Promotion Indicators analysis provides information about the usage of all promotional programs and
the effect of those promotions on sales and revenue.
The components of the analysis are explained in the following table.
Component Description
# Uses The number of times that promotions were used in purchase transactions
The trend sparkline shows the number of uses on each date in the period
set by the period ending date and the number of trailing days.
The following calculation rows show the number of uses during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
26 5 Analyses
Component Description
Markdown Units The number of items that were purchased using promotions
The trend sparkline shows the number of items on each date in the period
set by the period ending date and the number of trailing days.
The following calculation rows show the number of items during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
Promotional Markdown
Discounts
The currency value of the promotional discounts that were applied to
purchase transactions
The trend sparkline shows the value of the promotions used on each date
in the period set by the period ending date and the number of trailing
days.
The following calculation rows show the value of the promotions used
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
Promotional Revenue Impact The currency value of all the item sales that were purchased
using promotions. See information about Revenue Attributed to
Promotions (page 6).
The trend sparkline shows the value on each date in the period set by the
period ending date and the number of trailing days.
The following calculation rows show the value during the week before
the period ending date, the week before that, and the percent change
between those two weeks.
Avg Markdown Discount The average currency value of purchases in which a promotion was used
This value is calculated by dividing the total currency amount of
promotional markdown discounts by the number of orders.
The trend sparkline shows the average value on each date in the period set
by the period ending date and the number of trailing days.
The following calculation rows show the average value during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
5 Analyses 27
Component Description
Avg Revenue Impact The average currency value of the purchase transactions in which a
promotion was used. See information about Revenue Attributed to
Promotions (page 6).
This value is calculated by dividing the total currency amount of revenue
attributed to promotions by the number of orders.
The trend sparkline shows the average value on each date in the period set
by the period ending date and the number of trailing days.
The following calculation rows show the average value during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
Promotion Summary Analysis
The Promotion Summary Analysis provides information about the usage of individual promotional programs
and the effect of those promotions on sales and revenue
The components of the analysis are explained in the following table.
Component Description
Promotion The name assigned to the promotion
Uses The number of times the promotion was used in purchase transactions
7 Day Var (for Uses) The percentage change between the number of times the promotion was
used during the week before the period ending date and the number of
times the week before that
Discounts The currency value of the discounts that were applied as a part of the
promotion
7 Day Var (for Revenue) The percentage change between the value of the discounts applied as a
part of the promotion during the week before the period ending date and
the value of the discounts the week before that
Revenue The currency value of the sales attributed to the promotion. See Revenue
Attributed to Promotions (page 6).
7 Day Var (for Revenue) The percentage change between the value of the sales attributed to
the promotion during the week before the period ending date and
the value of the sales the week before that. See Revenue Attributed to
Promotions (page 6).
28 5 Analyses
Promotional Revenue Impact
The Promotional Revenue Impact analysis provides information about the value of the sales that are attributed
to promotional programs. See Revenue Attributed to Promotions (page 6).
This analysis appears on the ATG Web Commerce Performance Dashboard (page 7), where it includes all
promotions, and on the ATG Promotion Performance Dashboard (page 8), where it includes only one.
The components of the analysis are explained in the following table.
Component Description
Total Revenue, Promotional
Revenue Impact
Compares the gross revenue to the revenue that is attributed to
promotions. See Gross Revenue (page 5) and Revenue Attributed to
Promotions (page 6).
The line graph shows the currency value of the gross revenue and the
revenue attributed to promotions on each date in the period set by the
period ending date and the number of trailing days.
Promotional Revenue Share The percentage of gross revenue that is made up by revenue attributed
to promotions See Gross Revenue (page 5) and Revenue Attributed to
Promotions (page 6).
The line graph shows the percentage on each date in the period set by the
period ending date and the number of trailing days.
The table below the line graph shows the gross revenue and the total
revenue attributed to promotions in the period set by the period ending
date and the number of trailing days. It also includes the percentage of
gross revenue made up by promotions revenue during that period.
Segment Promotional Breakdown
The Segment Promotional Breakdown analysis provides information about the way that registered Web site
users in different segments, or demographic groups, use promotional programs. Registered users who are not
part of a segment are excluded from the calculations.
The components of the analysis are explained in the following table.
Component Description
Uses % Compares the number of times that promotional programs were used by registered
Web site users in different segments, or demographic groups. Users who are not
part of a segment are excluded from the calculation.
5 Analyses 29
Search Analyses
The search analyses provide information about the way visitors to your Web sites use Oracle ATG Web
Commerce Search.
Key Search Indicators
The Key Search Indicators analysis provides information about the volume of search activity on your Web sites.
The components of the analysis are explained in the following table.
Component Description
# Searches The number of times site visitors entered text search queries
The line graph shows the number of text search queries on each date in the
period set by the period ending date and the number of trailing days.
The table below the line graph shows the number of text search queries during
the week before the period ending date, the week before that, and the percent
change between those two weeks.
Avg Response Time
(milliseconds)
The average time it took the search engine to return the results of search queries.
The time is expressed in milliseconds.
The line graph shows the average number of milliseconds on each date in the
period set by the period ending date and the number of trailing days.
The table below the line graph shows the average number of milliseconds during
the week before the period ending date, the week before that, and the percent
change between those two weeks.
# Searches per Visit The average number of text search queries performed during site visits
The line graph shows the average number of text searches on each date in the
period set by the period ending date and the number of trailing days.
The table below the line graph shows the average number of text searches
during the week before the period ending date, the week before that, and the
percent change between those two weeks.
# Visits with Search The number of Web site visits in which the visitor performed a text search query
The line graph shows the number of visits on each date in the period set by the
period ending date and the number of trailing days.
The table below the line graph shows the number of visits during the week
before the period ending date, the week before that, and the percent change
between those two weeks.
30 5 Analyses
Component Description
# Queries The total number of search queries that were processed by the search engine
The line graph shows the number of search queries on each date in the period set
by the period ending date and the number of trailing days.
The table below the line graph shows the number of search queries during the
week before the period ending date, the week before that, and the percent
change between those two weeks.
# Unique Questions The number of unique text search queries submitted, after the text queries are
normalized by an auto-correction process
The line graph shows the number of unique text search queries on each date in
the period set by the period ending date and the number of trailing days.
The table below the line graph shows the number of unique text search queries
during the week before the period ending date, the week before that, and the
percent change between those two weeks.
Query Type Breakdown
The Query Type Breakdown analysis provides information about the volume of search engine activity. It
compares the numbers of different types of search query.
The components of the analysis are explained in the following table.
Component Description
Type The name assigned to the search query type
Query types include: Unspecified, Simple Search, Browse, Structured Search,
Similar Doc Search, and Category Navigation.
# Queries The number of queries of the type that occurred during the period set by the
period ending date and the number of trailing days
% The percent of all search queries that was made up by queries of the type. This
is calculated based on the queries that occurred in the period set by the period
ending date and the number of trailing days.
Prior Trailing 7 Days The number of queries of the type that occurred between 13 days before the
period ending date and 7 days before the period ending date
Trailing 7 Days The number of queries of the type that occurred between 6 days before the period
ending date and the period ending date
7 Day Var The percentage change between the number of queries of the type that occurred
during the week leading up to the period ending date and the number that
occurred during the week before that
5 Analyses 31
Component Description
Bar graph Compares the percentages that each type of search query makes up of the total
number of search queries
Response Time Analysis
The Response Time Analysis provides information about the performance of your search engine and its
relationship to the number of queries that occur.
The components of the analysis are explained in the following table.
Component Description
Hourly Analysis Compares the average time, in milliseconds, that it took the search engine to return
results during each one-hour period of the day
Compares the average number of search queries that occurred during each one-
hour period of the day
The averages are calculated based on the data from the period set by the period
ending date and the number of trailing days.
Weekly Analysis Compares the average time, in milliseconds, that it took the search engine to return
results during each day of the week
Compares the average number of search queries that occurred during each day of
the week
The averages are calculated based on the data from the period set by the period
ending date and the number of trailing days.
Search Conversion Analysis
The Search Conversion Analysis provides information about the number of purchase transactions that are
associated with search queries. The purchases are associated with search queries if they occur during the same
Web site visit.
The components of the analysis are explained in the following table.
Component Description
Metric The table provides calculations of three metrics: the number of site visits,
the number of site visits that included a search query, and the number of
site visits that include both a search query and a purchase transaction.
Prior Trailing 7 Days The number of visits that occurred between 13 days before the period
ending date and 7 days before the period ending date
32 5 Analyses
Component Description
% (for Prior Trailing 7 Days) The percent of all Web site visits made up by the type of visit listed in the
Metric column. This is calculated based on the visits that occurred between
13 days before the period ending date and 7 days before the period ending
date
Trailing 7 Days The number of visits that occurred between 6 days before the period ending
date and the period ending date
% (Trailing 7 Days) The percent of all Web site visits made up by the type of visit listed in the
Metric column. This is calculated based on the visits that occurred between
6 days before the period ending date and the period ending date
% Change The percentage change between the number of visits during the week
before the period ending date and the number of site visits the week before
that
Bar graph Compares the metrics and calculations that are provided in the table above
the graph. Choose the set of calculations from the menu.
Search Conversion Funnel
The Search Conversion Analysis provides information about the number of purchase transactions that are
associated with search queries. The purchases are associated with search queries if they occur during the same
Web site visit.
The components of the analysis are explained in the following table.
Component Description
Bar graph The graph compares the numbers of three types of Web site visit: the number of
site visits, the number of site visits that included a search query, and the number
of site visits that include both a search query and a purchase transaction. It
presents the percentage of all site visits that are made up by each type.
Table The table provides the number of visits and percentage of all visits for each site
visit type in the bar graph above.
Search Terms Not in the Dictionary
The Search Terms Not in the Dictionary analysis provides information about the number of text search queries
that contain terms that are not in the Oracle ATG Web Commerce Search dictionary.
The components of the analysis are explained in the following table.
5 Analyses 33
Component Description
Line graph Provides the percent of all text search queries that contained terms not in the
dictionary on each date in the period set by the period ending date and the
number of trailing days
Table Lists the terms that were not in the dictionary, the number of times they
appeared in search queries, and the percent of all search queries that contained
them
Search Terms Not in the Indexed Content
The Search Terms Not in the Indexed Content analysis provides information about the number of text search
queries that contain terms that are not in the Oracle ATG Web Commerce Search index.
The components of the analysis are explained in the following table.
Component Description
Line graph Provides the percent of all text search queries that contained terms not in
the index on each date in the period set by the period ending date and the
number of trailing days
Table Lists the terms that were not in the index, the number of times they
appeared in search queries, and the percent of all search queries that
contained them
Search Terms with No Results
The Search Terms with No Results analysis provides information about the search terms that are entered in
queries that return no results.
If a search term is a part of a query that does return results, it is not included in this analysis, even if it would not
have returned any results by itself.
The components of the analysis are explained in the following table.
Component Description
Table Lists the terms that were in search queries that returned no results, the
number of times they appeared in search queries, and the percent of all
search queries that contained them
Searches per Visit by Site
The Searches per Visit by Site analysis provides information about the average number of search queries that are
performed in visits to your Web sites.
34 5 Analyses
The components of the analysis are explained in the following table.
Component Description
# Searches per Visit The average number of text search queries performed during Web site visits
The bar graph compares the average number for each of your Web sites. The
table lists the average numbers.
Searches Resulting in Most Purchases
The Searches Resulting in Most Purchases analysis provides information about the sales associated with terms
that are entered in text search queries.
The components of the analysis are explained in the following table.
Component Description
Search Term The word that was entered in the text search query, after normalization to
correct spelling errors
# Orders The number of purchase transactions that occurred during Web site visits
in which the search term was entered
Units The number of items purchased during Web site visits in which the search
term was entered
Gross Revenue The gross revenue of the sales that occurred during Web site visits in which
the search term was entered
Conversions The percent of all searches that contained the term that resulted in
purchases.
Top Firing Search Configuration Rules
The Top Firing Search Configuration Rules analysis provides information about how frequently Oracle ATG Web
Commerce Search configuration rules are used.
The components of the analysis are explained in the following table.
Component Description
Line graph The percent of all search queries that used a search configuration rule on
each date in the period set by the period ending date and the number of
trailing days
5 Analyses 35
Component Description
Table The name, type, rule text, and total uses of the search configuration rules
that were used during the period set by the period ending date and the
number of trailing days
Top Products associated with Search
The Top Products Associated with Search analysis provides information about product sales that occurred
during Web site visits that also included a search query.
The components of the analysis are explained in the following table.
Component Description
Product Name The name of the product that was purchased. Click the link to open the ATG
Product Performance Dashboard.
# Orders The number of purchase transactions that contained the product and that
also occurred during a Web site visit that included a search query
Gross Revenue The gross revenue of sales of the product that occurred in Web site visits
that included a search query
Top Search Terms
The Top Search Terms analysis provides information about how frequently search terms are entered in text
search queries.
The components of the analysis are explained in the following table.
Component Description
Rank The position of the search term when the list of search terms is sorted
according to the number of text search queries that include it. This is the
default sorting order for the analysis.
Search Term The search term, after normalization to correct spelling
# Searches The number of text search queries that include the search term
% (# Searches) The percent of all text search queries that include the search term
7 Day Variance The percentage change between the number of search queries that
included the search term during the week before the period ending date
and the week before that.
36 5 Analyses
Customer Service Center Analyses
The customer service center analyses provide information about the way your customer service organization
handles contact from your customers.
Agent Summary Analysis
The Agent Summary Analysis provides information about the way customer service agents handle customer
calls.
The components of the analysis are explained in the following table.
Component Description
Organization Selects the group of customer service agents included in the analysis
Last Name The last name of the agent
First Name The first name of the agent
Avg Call Length The average length of the customer contact calls handled by the agent in
seconds
Conversion The percent of the agent’s customer contact calls that resulted in a
purchase
Returns The number of returned items handled by the agent
Avg Refund The average currency value of the refunds handled by the agent
Orders The number of purchase transactions handled by the agent
AOV (Average Order Value) The average currency value of the purchase
transactions handled by the agent
Apsmts (Appeasements) The total currency value of the price adjustments that the
agent made to orders.
Key Call Indicators
The Key Call Indicators analysis provides information about the customer service contacts handled by your
customer service organization.
The components of the analysis are explained in the following table.
5 Analyses 37
Component Description
# Calls The number of customer calls received by your customer service
organization
The trend sparkline shows the number of calls on each date in the period set
by the period ending date and the number of trailing days.
The following calculation rows show the number of calls during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
Avg Call Duration The average amount of time that customer service agents spent during calls
with customers in seconds
The trend sparkline shows the average duration on each date in the period
set by the period ending date and the number of trailing days.
The following calculation rows show the average duration during the week
before the period ending date, the week before that, and the percent
change between those two weeks.
Call Conversion Rate The percent of customer contacts that resulted in purchase transactions
The trend sparkline shows the percent of calls that included purchases on
each date in the period set by the period ending date and the number of
trailing days.
The following calculation rows show the percent of calls that included
purchases during the week before the period ending date, the week before
that, and the percent change between those two weeks.
Gross Revenue per Call The average currency value of the purchases that are associated
with customer service calls. This is calculated by dividing the Gross
Revenue (page 5) of items purchased in the customer service center channel
by the number of customer service calls.
The trend sparkline shows the average gross revenue per call on each date
in the period set by the period ending date and the number of trailing days.
The following calculation rows show the average gross revenue per call
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
Key Service Indicators
The Key Service Indicators analysis provides information about the transactions handled by your customer
service organization.
The components of the analysis are explained in the following table.
38 5 Analyses
Component Description
# Returns The number of times customer service agents processed return
transactions
The trend sparkline shows the number of return transactions on each date
in the period set by the period ending date and the number of trailing
days.
The following calculation rows show the number of return transactions
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
# Exchanges The number of times customer service agents processed exchange
transactions
The trend sparkline shows the number of exchange transactions on each
date in the period set by the period ending date and the number of trailing
days.
The following calculation rows show the number of exchange transactions
during the week before the period ending date, the week before that, and
the percent change between those two weeks.
Returned Units The number of items that were returned
The trend sparkline shows the number of returned items on each date in
the period set by the period ending date and the number of trailing days.
The following calculation rows show the number of returned items during
the week before the period ending date, the week before that, and the
percent change between those two weeks.
Avg Refund Amount The average currency value of refunds made for return transactions
The trend sparkline shows the average refund amount on each date in the
period set by the period ending date and the number of trailing days.
The following calculation rows show the average refund amount during
the week before the period ending date, the week before that, and the
percent change between those two weeks.
Top Product Returns
The Top Product Returns analysis provides information about the return transactions for individual products.
The components of the analysis are explained in the following table.
5 Analyses 39
Component Description
Rank The position of the product when the list of products is sorted according
to the number of returned items. This is the default sorting order for the
analysis.
Product Name The name assigned to the product
Product ID The identifier assigned to the product
Units The number of items of the product that were returned
% (for Units) The percent of all returned items made up by the product
Refund The currency value of the refunds made for returned items of the product
% (for Refund) The percent of the total refund amount made up by the refunds for
returned items of the product
40 5 Analyses