Apart from the standard reports that are available by default, EI allows you to create three types of custom reports.

  • Normal Reports: General report that you can create using normal charts.
  • Migration Reports: Special reports used to track the migration of users from one slab or segment to another slab or segment. You can use only migration charts to create migration reports.
  • External Reports: Add reports that are created outside EI.

Create Normal & Migration Report

To create a custom report, do the following.

  1. Login to the EI web application.
  2. On the home page, click Create Report.

  1. In Report name, specify a name for the report.
  2. Choose the type of the report Normal or Migration in the drop-down next to Report Name.
  3. Choose the report category in the next drop-down box - Sales, Customer, Loyalty, CRM, Product, or Migration.
  4. Click + Add/Remove Charts.

You will see a pop-up screen that prompts you to select charts

  1. Search for the required chart using the search box.  If you do not remember the chart name, you can also get charts by KPIs and Dimensions using the respective boxes.
  1. Click Add of the respective chart that you want to add

  1. Click Remove to deselect a chart if not required.
  2. Close the pop-up screen. You will see the charts added to the report
  3. Choose the duration of the filter, check the Compare filter to compare data with that of a previous duration, and click Apply. To know more about date filter and comparison with a previous duration, see Filter by Date Range & Compare with Previous Period.

  1. Click Save to complete creating the report. You can see it in the respective category in All Reports.

You need to publish it manually, as explained below, if you want other users of your organization to access the report. Else, only you (creator) can access the report.

  1. In All Reports, click the report that you want to publish. Use the Search box and filters to find the report quickly
  2. Click the More Options icon > Publish.

You will see a success message if the report is published successfully.

Create External Report

External reports are reports that are created on a different tool or platform other than EI. You can configure external reports so that you can view it on EI without the need to switch between different tools for your reports. For example, an org might use a third-party reporting tool if the org data is not available on EI.

However, you can only view external reports that are added for the org and drill down data through filters and dimensions.

External reports have org level access.

To add an external report on EI, follow these steps.

  1. On the EI home page, click Create Report.
  2. In Report Name, specify a name for the external report.
  3. In Type, choose External.
  4. In Category, choose the report category - Sales, Loyalty, Customer, Product, CRM, Leads, or Custom Reports.

  1. In Description, enter a short description for the report.
  2. Click Next.

  1. In Report URL, enter the URL of the external report without parameters.
  2. In Query Params, enter the parameters of the report URL as key-value pairs. In Key name enter the parameter name, and in value is choose the respective value. Click the icon to add more parameters.
    1. userId: To add user id as the query parameter to the report URL.
    2. ouId: To add Org Unit ID as the query parameter to the report URL.
    3. orgId: To add Org ID as the query parameter to the report URL.
  3. Check Authorization if authorization is required to view the report.
    1. Basic Auth: Provide username and password of the third party tool on which the report is available. The same authentication will be used for any user that views the report.
    2. Capillary Auth: Uses EI credentials. It uses the authentication of the user that views the report.
  4. Click Preview to view the report before creating.
  5. Click Create.