Import event feature allows you to import events from a CSV file into your MoEngage account. This feature supports several uses, such as:
Historical Data Import- As a marketer, you can import historical event data into MoEngage to analyze your customers’ past behaviour and trends.
Event Data Migration- During a platform migration, you can import events through CSV to ensure a smooth transition of historical event data, ensuring continuity in analysis and campaign management.
Batch Upload- Importing events through CSV allows users to upload a large volume of events in a single batch, saving time and effort. This is useful when updating or populating a large number of events in the MoEngage platform.
Enter the following details related to the source and format of the CSV file in Step 1.
A CSV file can only upload one event at a time, so it is impossible to use one CSV file to upload multiple events.
Import name- Enter a name for your import.
Select event- Select the event you want to upload using the CSV file. If the event you are searching for is not listed in the drop-down, click Create new event from the drop-down.
On the Create new event dialog box, enter the Event name and click Create.
Select file- You can either drag and drop a CSV file or upload a CSV file from the computer. You can also Download a sample file to view a sample event file that clearly explains the data format expected in the CSV File. Note that CSV files less than 150 MB are supported.
When you upload an event CSV file, the column represents the event attributes.
File preview- Click the Preview file to preview the CSV file you uploaded. You can preview the first five rows of the event CSV file.
This is a mandatory mapping that should be performed. Under the Attribute name, you can view the event attributes of Moengage, such as User Identifier and Event time. These attributes should be mandatorily mapped to the events attributes column in the CSV file listed under Map Column. You can select the column names of the uploaded CSV file from the drop-down menu under the Map column.While mapping the Event time, make sure to select the date, time format and time zone.
After successfully mapping the mandatory fields mentioned above, you need to map the remaining events attribute columns in the CSV file to the event attributes of MoEngage.The event attributes columns of the CSV file are listed under the Column name, and this is to be mapped to the event attributes of MoEngage under the Map column to attribute.Perform the following steps to map columns:
You can either select the event attributes of MoEngage from the Select attribute drop-down or click Create new attribute, if the attribute is not listed in the drop-down.
On the Create new attribute dialog box, enter the Attribute name, Data type and click Create.
Select the Data type of each attribute while mapping.
Select the Skip columnif you want to skip any columns from mapping. Note that the mandatory fields already mapped are disabled under Map Columns.
After the event data is imported to MoEngage, you can send the import status to 10 email ids. Select the Email id from the drop down to which you want to send the status and click Next.
If your file contains empty values then these would still be imported into MoEngage. In this case, we will create/update event attribute where the value would be empty.
Simple arrays are supported. Nested and Associated arrays are not supported.
The supported delimiter in the CSV is ”|”.
The supported data types are array double (numeric) and array string. You can select these data types in the list under the Map column to attribute column of the Map columns section while executing Step 2: Import configuration and action.\
All the elements in the array have to be homogenous, which means they must be either double or string. If they are not homogenous, MoEngage tries to typecast (transform) the element and then store the data. Following is the example of an array in a CSV field: [1|2|3]
Array Typecasting: If an array has elements [“1” | 2 | “abc”] of multiple datatypes and the defined datatype is Array Double, then the final array ingested in MoEngage is [ 1, 2 ]. In this case, “abc” was a string that cannot be transformed into Double and hence not ingested into MoEngage in the final array. For more information on typecasting in MoEngage, refer here.
Attribute Type list and other complex types (JSON, dictionaries, etc.).
Newline character formats other than “\n” - .The only newline character currently supported for the .csv files is “\n”. Other formats like “Ctrl+M” or “\r” are not supported.
If your file contains less than 5 rows, then you may face errors during file import. Make sure to add some dummy rows to import in this case.
