The Export module allows accessing the data that is stored in Antavo’s database. Backoffice administrators can generate reports to get an overall view of the data of customers, coupons, or stores – among others – tailored to their current needs. When creating the export file, the module configuration interface provides options to add data fields and apply filters.
...
From
The ‘From’ value is automatically populated from the ID of the field selected and cannot be modified.To
The name of the field in the column header of the export file.Default
This value will be added to data cells where the field value of the individual entity is empty.Replace values
You can decide to overwrite certain data values that are stored in the database with a new value in the export file (eg. replace all ‘female’ values in the Gender customer field with ‘ladies' or replace ‘14’ values in the Age customer field with ‘underage’).
Use the ‘Value to replace’ and ‘New value’ fields to define which value should be replaced and the target value added to the export.
To map more than one value, click the ‘Add new field’ button.Aggregation
This mandatory setting is available if the ‘Aggregation’ option has been enabled in the previous step.
Please note that computed fields cannot be aggregated. If you’re unsure if the field is a computed field, check the editor interface of the field (Events, Customers) or consult the Antavo Service Desk.
Use the dropdown field to select one of the available aggregation methods:Group
At least one field has to be marked as ‘group’, which defines the field that will serve as the base of aggregation (eg. if the customer ID is added, the data in the export will be aggregated per each individual customer).Count
Use this option to retrieve the number of individual entries in the report.
Please note that this This method counts the number of entries, not the fields. If more than
Please make sure you add only one field is marked as ‘count’, the same count value will be produced in the report. with ‘count’ aggregation option.Sum
Use this option to retrieve the accumulated number of all numeric values of the data fields.Average
Use this option to retrieve the average value calculated from all the values of the items in the report.Min
Use this option to retrieve the lowest value of all the attribute values in the report.Max
Use this option to retrieve the highest value of all the attributes value in the report.
...