Configure advanced reports in BI

With Business Intelligence (BI), you can create detailed, near real-time reports by selecting measures to report and dimensions that group and filter data results. BI analyzes large quantities of information, which can be drilled down to an increasingly granular level.

You can use BI reports to determine, for example:

• How much revenue you made last month
• If your email promotion is working
• Which MVT candidate is performing better
• Average cart value this week compared to last week

Configuring a report is highly flexible and customizable. This enables you to get results that meet your organization business needs. For example, you can build reports based on different markets and regions. You can break the information down by type of customer and their location, browser, language, IP address, and more. You can then use this information for optimizing your business.

In BI, you can also use and access reports which are pre-defined.

Additionally, you can:

• bookmark the reports you configure and easily access them for future use either in BI or in our web admin tool.
• export the reports.

Configure a report in BI

1. Select what to report

1. In the Available Measures section, select:
   

   • Most Common tab for the most commonly used measures.
   • All tab for a list of all possible measures.

2. Select a measure. For the descriptions of all measures, click the blue help button to the right of each measure.

3. Drag and drop the measure to the Selected Measures section on the left. The measure displays with a drop-down list below it.

4. In the drop-down list, select the type of payment status which you want to base the report on.

Option	Description
All	The report displays all payment status types.
Expected subscriptions	The report displays subscriptions and revenue expected for the future. These are calculated up to one year in advance under the assumption that there will be no subscription cancellations.
*Paid (Aggregated)	The report displays paid orders in aggregate, which includes revenue mins all returns for that period.
*Paid (Only Refunds)	The report displays refunds, which are payments initiated by Cleverbridge or the software provider back to the customer.
*Paid (Only Returns)	The report displays returns, which are refunds plus chargebacks. In other words, returns include all reverse transactions. Chargebacks are initiated by customers who don't recognize a charge on their credit cards or when a charge comes from a fraudulent order. The customer's payment provider issues a chargeback.
*Paid (Only Revenue)	The report displays revenue from all paid orders regardless of later events, such as refunds or chargebacks. If an order was refunded at a later date, it's still included in the period as if the order had the status Paid.
Quotes	The report displays quotes.
Unpaid	The report displays unpaid orders, including quotes.

5. If needed, add more measures or remove any of the measures by clicking the red x to the right.

Example

In the Most Common tab, you select **Sales Revenue (Client). Any report generated with this measure will be a sales revenue report. In the drop-down list, you select **Paid (Aggregated). The report will display paid orders that include refunds, returns, and revenue.

2. Select how to report

Select how to report the measures with one or more dimensions. To run the report, you must select at least one dimension in the Dimension Group section.

1. Customize the report view. In the Dimension Group section, there are two options:
   • X-axis, which is a horizontal axis of the report (when in chart form) typically used for item selection.
   • Y-axis, which is a vertical axis of the report (when in chart form) acting as the secondary axis.

Example

You selected *Sales Revenue (Client) as the measure and Time as the dimension for the x-axis. The report displays the sales revenue numbers on the y-axis and the time increments, such as months, on the x-axis.

2. Decide how to filter the report, which is a way to include or exclude only a subset of returned data. You can select a filter in the Dimension Filter section.

3. In the Available Dimensions section, select either the Most Common tab for the most commonly used dimensions or All - for the list of all possible dimensions.

4. Select a dimension. For descriptions of all dimensions, click the blue help button to the right of each dimension.

5. Drag and drop the dimension to the X-axis, Y-axis, or Dimension Filter sections on the left. The dimension displays with more selectable options.

6. If needed, further refine the dimension by selecting additional options or remove a dimension by clicking the red x to the right.

tip

One of the most commonly used dimensions is Time, because that is how you select or change the length of time covered by the report, or how the returned data is grouped, such as by month, day, or hour.

3. Run a report

To run or refresh a report, click the green button in the top right corner of the screen or press F5.

note

There are limitless possibilities of how you can configure a BI report. This procedure provides general guidelines.

Additional report settings

If needed, you can configure additional report settings that determine how the reports and data are calculated. For example, you can set the exchange rate time, currency, and time zone. To do this, in the Global Header, click Additional Settings. A window with the options displays.

note

These settings are reset to default when you close and reopen BI. If you want to save the customized settings, best practice is to save reports with those settings as bookmarks.
If you wish to have custom defaults for all users in your company, contact Client Experience.

Measures settings

In the Measures tab, select from the available options:

Option	Description
Exchange rate time	Select from which time perspective the data should be displayed when there is a currency conversion. The exchange rate is captured once per day. Purchase — The exchange rate is taken from the time of the purchase. Now (default) — The exchange rate is taken from the current time (the time the report is run). Warning: With the Now option, the data for previous days will change, depending on the day you run the report, due to daily exchange rate fluctuations. Payments to clients and affiliates happen between the first and the fifth business day of each month. The exchange rate time used for clearing is based on the day of the payment. However, in BI, this information should only be used as a snapshot and not for accounting purposes.
Currency	Select which currency to display reports for. The default currency is taken from the Default base currency field in Commerce Assistant (CA) Account Setup.
Revenue settings	Select how to display revenue: Gross — Total amount of revenue, including tax. Net (default) — Net amount of revenue, excluding tax. This option will typically be the most useful for you. Only tax — Only tax, which is the difference between net and gross.

Time settings

In the Time tab, select from the following options:

Option	Description
Purchase reference time	Select the time reference the report displays data for: Purchase submitted — The time the order was placed, regardless of when it was paid or refunded. Financial transaction (default) — The time the financial transaction, such as a payment or refund, took place. This option will typically be the most useful to you. This option can also give you a better snapshot of your clearing information. Example: You selected Financial transaction. On Monday, a customer places an order. On Tuesday, this order is paid. The report displays the data for Tuesday, which is the day of the financial transaction.
Time zone	Select the time zone the report displays data for.
Week type	Select whether the report is based on the following week types: ISO (default) — The report is based on the International Organization for Standardization (ISO) week, which begins on Monday. The week always has seven days, even in cases where a week spans two different years. In the event a week spans two different years, the week is placed in the year that has more days in that week. Example: Three days of the week fall in Year 1. Four days of the week fall in Year 2. The week counts for Year 2. US — The report is based on the United States (US) week, which begins on Sunday. There is partial week numbering when a week spans two different years, which means there are always 53 weeks in a year. The partial weeks can make some calculations inaccurate at the end of December or beginning of January. Example: Three days of the week fall in Year 1. Four days of the week fall in Year 2. The week is split between Year 1 and Year 2.
Customer contact reference time	For customer contact reports, select the time reference the report displays data for: Customer contact time (default) — The report displays data based on the time the customer contacted Cleverbridge or you for support. Purchase time — The report displays data based on the time the order was placed.

Miscellaneous settings

In the Miscellaneous Settings tab, select how to display data for test orders:

• No tests (default) — The report displays no test orders.
• Only tests — The report displays only test orders.
• All — The report displays both test and regular reports.

View and work with report results

Display type

You can select a display type for the report in the top left corner of the results pane. The options are as follows:

• Area (only available for the Time dimension)
• Bar
• Doughnut
• Line (only available for the Time dimension)
• Pie
• Scatter
• Table
• World map (only available for one measure and up to two dimensions, one of which must be the Country dimension)

Display options

There are various report display options on the top of the results pane which vary according to the display type (area, bar, and so on). Click the button to turn on the following options:

Option	Description
Animate	Creates an animation effect when the report changes because of a refresh, a change of display type, and so on.
Point Labels	Displays labels on the data, such as percentages on the pie chart.
Show Zero	Starts the data points with 0. Otherwise, the data points start with the lowest rounded data point closest to the lowest number in the report. Example: Show Zero is not selected. You run a report for sales revenue by language and select the Bar display type. The language with the lowest revenue is $25,175. The data points in the report begin with $20,000.
Legend...	Offers various positions for displaying the legend.
Export	Offers various options for exporting and opening the report.
Cross Table	Displays the data in a matrix, showing the interrelation between the two axes. This is only available for one measure and two dimensions.

Tooltips with data

Hover the mouse pointer over the data, such as a bar in a bar chart, for a tooltip that displays information about the data.

Drill down to more specific data

You can drill down through data layers to get more specific data in BI.

Double-click

Double-click to further drill down in the same report. This works for the following dimensions, which have a hierarchical structure:

• Browser, with versions
• Country, with states
• Customer Contact Reason, with detailed reasons
• MVT campaigns, with candidates in a campaign
• Operating System, with version
• Parameter (for X-Parameter revenue tracking), with the hierarchy for the selected parameter tree
• Payment Types, with subtypes

Example

You run a report for sales revenue by browser and select the Bar display type. You double-click the bar for Google Chrome. The report refreshes and displays all versions of Google Chrome.

Highlight a section of the report

If you are running the report with the Time dimension, you can highlight a section of the report to open a more detailed report below it. The report below displays the next level of detail, such as from year to month, or from month to day, and so on. To do this:

1. In the results pane, select the Bar report option type.
2. Click on a bar. A red line displays.
3. To display more data for only that bar, release the mouse click. A second report with detailed data displays below.
4. To display more data for a wider time period, drag the cursor over more bars in the report and release the mouse click. A second report with detailed data displays below.
5. To further refine results:
   • Hover the mouse pointer over the left or right edge of the highlighted section and drag the highlighting to a new position.
   • Hover the mouse pointer over the highlighted section and right-click. While holding the click, drag the entire highlighted section to a new position.
   • To further refine the results:
     • Hover over the left or right edge of the highlighted section and drag the highlighting to a new position.
     • Hover over the highlighted section and right-click. While holding the click, drag the entire highlighted section to a new position.

Example

You run a report for sales revenue by the last year, grouped by month, and select the Bar display type. You highlight two bars of the report that represent two months: January and February. A detailed report displays below the report with data for each day of the highlighted two months.

Context menu

Right-click the report results to view a menu with options to select a subset of data, such as All Countries or Top Languages. When selected, the report refreshes to display the data by that subset.

Example

You run a report for sales revenue. You right-click the report results and select Browsers. The report refreshes and now displays revenue by browser type.

Did you find this doc useful?