User Tools

Site Tools


export_campaign_data

Introduction: Exporting data into groups or files

In the LUCY there's a navigation item called export within the campaign overview page. The menu that opens allows you to export any campaign-related data:

You can either export ALL data that gets monitored in LUCY or only specific data:

Export into CSV

:!: Reports in the CSV format are generated using the separator specified in the Advanced Settings section. The default separator is a tabulation. Please consider this when opening CSV files - in some versions of Excel you may need to manually specify the type of separator when opening the file.

  • Export recipients to CSV (1): allows to export recipients to a CSV file (can be opened in excel) based on different criteria

  • Export benchmarks (4): This will export the main statistics (scenario name, number of messages_sent, mails_opened, clicks & succeeded) to a CSV. If you want to export ALL data, please use "Export recipients to CSV" and select "ALL".
  • Export collected data to CSV (5): export the data collected (any submitted data or file uploads from malware simulations) in the campaign to a CSV

Export Collumns

The following table contains the list of all export columns with description and the value type specification.

Collumn name Description Value Type
name Name of the recipient Text
email Email of the recipient Text
phone Phone number of the recipient Numeral
gender Gender of the recipient Male / Female
link Unique link of the recipient Text
lure_submitted_at Time of lure email submission Timestamp
mail_submitted_at Time of email submission Timestamp
clicked Recipient clicked the link in the email Yes / No
clicked_at Time recipient clicked the link in the email Timestamp
succeeded Success action triggered for the recipient Yes / No
succeeded_at Time when success action was triggered Timestamp
trained Recipient has completed the training Yes / No
trained_at Time when recipient has completed the training Timestamp
reported Recipient has reported the message via LUCY Report Plugin Yes / No
reported_at Time when recipient has reported the message Timestamp
domain Domain used in the campaign's scenario Text
scenario Name of the scenario on the campaign Text
staff_type Info about recipient's staff category Text
location Info about recipient's location Text
division Info about recipient's department Text
comment Additional optional comment about the recipient Text
os Operational System of the workstation that submitted first click Text
ip IP of the workstation that submitted first click Numeral
proxy_ip IP of the proxy Numeral
browser Browser of the workstation that submitted first click Text
plugins Plugins detected on the workstation that submitted first click Text
country Country based on IP County Code
success_rate How many times a recipient was successfully attacked, depending on the Success Action Numeral
click_rate How many times a recipient clicked the attack link Numeral
scenario_time Amount of time the victim has spent on the phishing link page Numeral
awareness_time Amount of time the victim has spent on the awareness link page Numeral
email_subject Subject of the sent email Text
first_click_after_delivery Time value in seconds between mail_submitted_at and succeeded_at Numeral
first_report_after_delivery Time value in seconds between mail_submitted_at and reported_at Numeral
reminder_click_submitted_at Time when recipient clicked the reminder link Timestamp
reminder_training_start_submitted_at Time when the recipient started the training provided by reminder Timestamp
reminder_training_finish_submitted_at Time when the recipient finished the training provided by reminder Timestamp
downloaded_files File-based attack downloaded files by the recipient Text
collected_data The data that has been submitted by the recipient on the landing page Text
out_of_office_at Time of Out of Office autorespond Timestamp
bounced_at Time of the Bounced response Timestamp
responded_at Time of the incoming response to the email Timestamp
certificate_received Recipient has received a certificate Yes / No
training_with_quiz_passed Recipient has passed a training with Quiz mode enabled Yes / No
training_with_quiz_passed_at Time when recipient has passed a training with Quiz mode enabled Timestamp
training_noquiz_finished Recipient has finished a training without Quiz Yes / No
training_noquiz_finished_at Time when recipient has finished a training without Quiz Timestamp
security-level Level of awareness security Numeral
answers_count_0 Quiz answers count Numeral
answers_percent_0 Quiz answers percentage (based on total number of questions) Percentage
correct_answers_count_0 Number of correct quiz answers Numeral
correct_answers_percent_0 Correct answers percentage (based on total number of questions) Percentage
wrong_answers_count_0 Number of wrong quiz answers Numeral
wrong_answers_percent_0 Wrong answers percentage (based on total number of questions) Percentage
quiz_time_spent_0 Time spent for quiz Minutes / Seconds
training_succeeded_0 Recipient has completed the training with Extended method of tracking the end of the quiz Yes / No
training_succeeded_at_0 Time when recipient has completed the training with Extended method of tracking the end of the quiz Timestamp

Export into groups

  • Export recipients to groups (2): this feature allows you to create new groups. Once you click the export button LUCY will create a new group within the recipients navigation tab that contains the according users. Those groups can then be used for further specific campaigns
  • Export recipients within submitted time range to a new group (3): using this function you can export recipients in a new group using a specific time range

Alternative: Export via API

Beside manual exports, you can use also our API to fetch all data. More details here

Export Logins

All collected data can be exported. Go to statistics/collected data and then click "export:

Automated Export

The export process can be also automated by using the feature "Automated Export" which can be found in the left navigation bar of the campaign's overview page:

The automated export can be configured by the following options:

  • Export Target: multiple data type exports can be selected, each representing a separate data export
  • Export Frequency: determines how frequently the export should be created (Dayly, Weekly, Monthly, Yearly)
  • Export Time: at what time the export should be generated
  • Export Days: days of week or month: 1-7 for weekly, 1-31 for monthly. Days of year: 1-12 (month numbers); 1-31 (days of month) for yearly. Example for weekly: 1,3,5,7. Example for monthly: 1, 15, 25. Example for yearly: 1,3,5,7; 1,15.
  • Export Type: file format XML or CSV.

The following example on the screenshot shows the configuration of the full data weekly report done each Friday at 15:00 in CSV format.

The generated automated exports can be found in this menu section:
Support > Exports

export_campaign_data.txt · Last modified: 2022/03/05 17:49 by lucysecurity