Import Listing and Stats

Learn how to track and monitor imports

Overview

After configuring, mapping, and setting the frequency for the import, select Import to view the Import Listing page. This page shows a list of all imports created for the data warehouse database and can also be accessed from Settings > Partners > Import Center > Filter by partner.

📘
Private Beta
SnowFlake is a private beta release. Contact your Customer Success Manager for access. (@Parth)

The Import Listing page will display the following:

Header	Description
Nickname	The unique name given to each import. This helps easily identify and differentiate between different database imports.
Partner	The partner integration (for example, Snowflake) used for the import.
Status	The current state of the import Running Scheduled Paused Draft Stopped
Import Type	Indicates whether the import is for user profile data or event data.
Frequency	Displays the frequency of the data import (for example, Repeat Intervals, Custom Schedule, or Manually Trigger).
Health	Indicates the health of the import: 100% (Green): All data has been processed without issues. 50% - 99.99% (Yellow): Some errors in data processing. 50% (Red): Less than half of the data processed, check data selection and mapping.
Last Run	Shows the date and time when the import was last triggered.
Created On	Displays the date when the import was created.
Created By	Shows the user who created the import.

The listing page can also be filtered based on the following criteria:

Filter Option	Description
Partner Name	Filter imports by the name of the partner (for example, Snowflake) used for the integration.
Sync Type	Filter by Event Data or User Profile Data to view imports of a specific type of data.
Status	Filter by the status of the import: Running Scheduled Paused Draft Stopped
Frequency	Filter by the frequency of the import: Repeat Intervals Custom Schedule Manually Trigger
Created On	Filter by the instance (Created, Triggered, etc.) and select the date using the calendar widget to display results for a specific timeframe.
Created By	Filter by the user who created the import by selecting a user from the drop-down. This helps you view imports created by specific users.

Apply these filters by selecting relevant checkboxes to refine the import listings based on your requirements.

Stats

Stats provides a detailed overview of data imports, including their status, success rate, and any errors encountered during the process. These stats help track the health of each import, ensuring data integrity and identifying any failed records that need attention. The stats table includes key metrics such as Total Records, Successful Syncs, Failed Syncs, and the overall health percentage of the import.

To access Stats, go to Settings > Partners > Import Center > Edit selected import > Stats.

Label	Description
Date & Time	The timestamp when the import process was initiated.
Imported On	The date when the import was successfully recorded in the data warehouse.
Health	Indicates the health of the import: 100% (Green): All data has been processed without issues. 50% - 99.99% (Yellow): Some errors in data processing. 50% (Red): Less than half of the data processed, check data selection and mapping.
Total Records	The total number of records included in the import.
Successful Syncs	The number of records that were successfully imported into the data warehouse without errors.
Failed Syncs	The number of records that encountered errors and failed to import during the import process.

To review detailed import records and their processing status, follow these steps to navigate the Stats Table and access specific entry details in the right pane.

On the Stats Table, click on a specific import entry to view its detailed information in the right pane. The right pane will display individual entries from the selected import, including relevant details.

For User Profile Data, the right pane will show:
- Result: If the result is Success, it indicates that the user profile data has been successfully imported; if Failed, it means the user profile data has not been successfully imported.
- CleverTap ID: Unique identifier for the user profile.
For Event Data, the right pane will show:
- Result: If the result is Success, it indicates that the event data has been successfully imported; if Failed, it means the event data has not been successfully imported.
- Clevertap ID: Unique identifier associated with the event.
- Event Name: Name of the event processed in the import.

By following these steps, you can effectively track import performance, identify any errors, and ensure the accuracy and integrity of the imported data within the data warehouse.

Updated 19 days ago