Data Extract

Configure the export of raw transactional and fixed data from the reporting database. Users can extract data from standard sources such as call attempts at specified times and for selected Campaign groups or campaigns.

Go to Menu > Reports > Data Extraction. The page displays the following information:

• Name – Specifies the name of the data extraction configuration.

• Description – Provides additional context or details about the configuration.

• File Name – Defines the name of the output file that will be generated by the report.

• Activate – Indicates whether the data extraction configuration is currently active and running.

• Job History – Opens a popup that displays the history of data extraction jobs with the following information:

  • It displays the time zone selected for the data extract report. Date and time in the report are based on this selected time zone.

  • Report Start Time – Displays when the data extraction process starts.

  • Report End Time – Displays when the data extraction process ends.

  • Scheduled Time – Shows the time the report is scheduled to be generated.

  • Status – Indicates the current status of the report (for example, Processing, Completed, or Failed).

  • Records – Shows the number of records included in the generated report.

  • Action – Provides a download button to download the report file. This appears only when the report status is Completed.

  • Search Option – Allows users to search and filter the job history list to quickly find specific entries.

• Action – Allows the user to edit or delete the data extraction configuration.

Storage Destination

Storage destination screen allows the user to store the data extraction file.

1. Go to Reports > Storage Destination. By default, the Shared Drive is selected and below fields are populated.

2. Select the Storage Type from Shared Drive, S3, and Google Cloud Storage.

3. If you select S3 storage, then perform the following:

   1. Enter the S3 Path that stores your extraction data. This is the absolute path on the Amazon S3 bucket where you intend storing the extraction data. Example, bucket:\DE\.

   2. Select the Is Role based Authentication checkbox, if required.

   3. Enter the AWS Region End Point. This is the region that your AWS S3 bucket is located in.

   4. Enter the AWS Access Key. This is the key to access your AWS S3 bucket. Access Keys are used to sign the requests you send to Amazon S3. AWS validates this key and allows access. You use access keys to sign API requests that you make to AWS.

   5. Enter the KMS Encryption if you want the data to be encrypted using AWS' KMS encryption.

   6. Enter the AWS Secret Key. This is the secret key (like the password) for the AWS Access Key entered above. The combination of an access key ID and a secret access key is required for authentication.

   7. Enter the Server Side Encryption. This is the encrypt/decrypt key, defining that the purged data is encrypted using the AWS' Key Management System (KMS) encryption.

   8. Enter the KMS Key. This is the key to decrypt the data on S3 bucket.

   9. Enter the Archive Path that stores your archived data. Example, bucket:\DE\archive\.

      Note:

      When giving the path, do not include any slash/backslash at the beginning. For example, if you require your data to be archived in the LCMArchive folder of the machine having IP address 172.20.3.74 and the Path as LCMArchive. If you are using a subfolder under LCMArchive, specify the correct path - LCMArchive\PurgeData.

   10. Click Save.

4. If you select Shared Drive storage, then perform the following:

   1. Enter the IP/Host Name of the device that stores your archived data.

   2. Enter the User ID and the Password of the user to accesses the drive to store the data. This should be a combination of domain and username. Example, <domain>\User ID.

   3. Enter the Extraction Path of the shared drive where your data is to be extracted.

   4. Enter the Archive Path of the shared drive where your data is to be archived.

      Note:

      When adding a path, do not include any slash or backslash at the beginning. Example, if you require your data to be archived in the LCMArchive folder of the machine having IP address 172.xx.x.xx and the Path as LCMArchive. If you are using a subfolder under LCMArchive, specify the correct path - LCMArchive\PurgeData.

   5. Click Save.

5. If you select Google Cloud storage, then perform the following:

   1. Enter the Data Extraction Path field of Google Cloud Storage that stores your extraction data. This is the absolute path on the Google Cloud Platform where you intend storing the extraction data.

   2. Enter the Account Type. This is the account type used to access the Google Cloud Storage. Use service_account as the default account type.

   3. Enter the Private Key of the Google Account to access the Google Cloud Storage to place the archived data.

   4. Enter the Client Email of the Google Cloud Platform client account used to access the Google Cloud Storage.

   5. Enter the Archive Path of Google Cloud Storage where the application stores the archived data.

6. Click Save.

   Note:

   Do not use any special characters as part of the file names such as /, \, :, *, ?, <, <, and |.

Edit Data Extract

1. Select the Data Extract and click Edit under Action.

2. Update the parameters and click Save.

3. Enable Activate switch to activate data extraction process.

4. To delete Data Extract, click Delete under Action. Click Ok on the confirmation pop up.

Fields

Notes:

• The report is extracted from beginning of the day to the scheduled time configured and the file is placed at the configured storage location.

• When you extract this report a second time, the file containing the first data extraction is moved to the Archive Path configured. The latest extraction is placed in the configured storage location.

• When you extract this report a third time, the file containing the second iteration is moved to the Archive Path configured, and the first iteration file is deleted. The third iteration data is placed in the configured storage location.

• All the above three conditions apply only when Campaign Specific File Creation and Append Date Time switch are OFF.

Data Extraction Fields

Data Extract service enables the user to download data from standard data sources such as call attempts and Agent activities from selected platform at specified times and for selected campaign groups/campaigns.

Transaction Field Details

The following tables list down the extracted fields and their details:

• Call Activity

• Agent Activity

• Global Upload

• List Upload

• Scrub List Info

• Audit Log

• Audit Trail

• Anonymous Inbound SMS

• SMS Inbound Session

• SMS Outbound Session

• SMS Delivery Status

• Upload Error

• Global Upload Error

• API Upload Error

• Non-Call Activity

• Contact Business Data

• List Info

• Upload History

• Call Trace

Master Field Details

The following tables list down the extracted fields and their details:

• Agents

• Campaign Filter Groups

• Outcomes

• Campaign Groups

• Channels

• Categories

• Campaign

• Modes

• Users

• Campaign Business Fields

• Contact Status

• Dial Plan Details

• Profile

The table contains the following columns:

• Source Table: The table name on the application/reporting database that is the data source.

• Column Name: The field name of the extracted data.

• Display Name: The field name as displayed on the UI.

• Data Type: The data type for the field.

• Description: The description for the field.

• Platform: The dialer platform that the data is extracted for.