This article shows you, how you can integrate return information.


Preface

Return information can be tracked via an e-commerce parameter. The matching is done based on an order ID, that is transmitted to Mapp. Usually, it is transmitted every day automatically, which value per order number was returned.


Step 1: Setting up the e-commerce parameter

Prior to the upload a custom parameter has to be set up for tracking the return value.
This can be done at Mapp Q3 > Configuration > Custom Parameters > E-Commerce Parameter > Create New Custom Parameter. Use the following setup:

In order to allow them to be added as metric to your analyses, the returns are set up as Datatype "Figure".


Step 2: Import of return information

Usually, the import of the return information is done automatically via data feed or JSON.

In this example, we show the import via Excel. This is often done as a first step in order to understand and check the working principle.

  1. Data Export

    in order to have the correct import format, we first export the order numbers and the parameter.
    For doing so click on "Import and Export" in the configuration layer of the e-commerce parameter and then on "Export".

    Please note: The function "Import and Export" is only available after the parameter was saved and is available in Mapp Intelligence. Perhaps this could take some minutes.

  2. Data Import

    You have to insert the order IDs, that were returned, in the column "Order ID". The value of each returned order has to be inserted into the parameter column.
    Example: A customer orders 2 products for 100 Euros each. The total order value was 200 Euros. One product was returned, therefore the return value is 100 Euro.

    Save the file and upload it again via the import tab.

    Please note, that it can take some time (usually 60 minutes) for the import to be processed.

    Documentations about the data import via data feed or JSON can be found in the Developer section.


Step 3: Analysis

The imported return data can be used in the analyses in Mapp Intelligence.

2 metrics are available:

  • Return Value

    includes the monetary value, that was returned. Therefore, it is the counterpart to "Order Value".

  • Qty Return Value

    shows the number of times returns happened. Therefore, it is the counterpart to "Qty Orders".

The date and time of the order are assigned to both metrics.

A simple analysis could look like this:

Further interesting metrics can be set up individually as a custom formula (Custom Figure > Custom Formula > New Custom Formula):

  • Return Value %

    shows what percentage of the order value was returned.


  • Qty Returns %

    shows what percentage of the orders were returned.



  • Order Value after Returns

    shows the order value minus the return value.

These metrics are often used in campaign analyses: