A template is a combination of facts, dimensions, and/or KPIs. Standard templates are created from facts, and dimensions where as a custom dimension is a combination of KPIs and dimensions.  Standard templates consist of raw data where as custom templates can have summarized data. For example, Standard templates consist of columns such as points issued, total visits, purchases and so on at the customer level, i.e., basically the columns which are summarized.  However, if you need these values for a specific duration, you need custom templates.

To create a custom template, see Creating Custom Templates.

There are over 20 different standard templates categorized as Fact, Dimension and Fraud as mentioned below:
Fact

  • Customer Merge Event Log
  • Points Expiry Reminder
  • Transaction
  • Registration Event Log
  • Footfall
  • Call Tasks
  • Messages
  • Issue Trackers
  • Return Transactions
  • Slab Change Log
  • Profiles
  • Contacted
  • Responders
  • Points
  • Coupons
  • Members
  • baseFactTemplate

Dimension

  • item - Inventory
  • event_zone_till - Stores
  • campaign - Campaign
  • campaign_group - Audience Group
  • event_user - Users

Fraud (Currently, there are no templates in this category)

  • initial_fraud_template

To select a template, do the following:

  1. In Export Templates, click Add/Remove Templates. You can also create a new template using the Create Export Template option if required

  1. Check the templates that you want to add to the export job and click Select. You can select multiple templates at a time.

For standard templates, you will see the default measures selected and for custom templates you will see the selected KPIs count. All the dimensions that are applicable for the KPIs or measures along with the applicable dimensions. You can modify the template to select only required dimension values and apply filters to the existing data if required. Data of each template is saved in a separate directory in the destination path

  1. To add filters and select dimensions that you want to download, click Modify

As you see, by default all dimensions are selected as shown above.

  • Filter down data (): Filter down the export data to get only the information that is required. You can filter the data by filter dimensions and audience list
  • Update the destination path of the current template data: You can use to modify the path of the current template's data on the FTP location 
  • Order field names () : This icon lets you reorder the field names as you would like to see in the exported file. To do so, hold the field icon and drag it to the required position
  • Deselect KPIs (KPIs): By default, all the existing KPIs of the template are selected. You can uncheck all the KPIs that are not required
  • Deselect Dimensions (Dimensions): By default, all the existing dimension of the template are selected. You can uncheck all the dimensions that are not required

Note: The data that will be exported will have the columns KPI1, KPI2, ..., Dimension1.KPI1, Dimension2.KPI1, Dimension1.KPI2, Dimension2.KPI2, ...

  1. Continue to Step 3 of 3 to modify the template
Note: In a template, custom fields will not be selected by default