How to Prepare Data for ColdEmailingJet

by

Before you start a cold email campaign, it’s crucial to prepare and import your data into ColdEmailingJet’s local database. This ensures efficient data management and streamlines the sending process. Below is a step-by-step guide on how to prepare the required data, including sender accounts, contact lists, mail content, proxies, attachments, and links.

Update 20241210： first create a Account group from Account menu, then create a new camp , select the account groupd created , then prepare the data

Update 20250302: for csv import, make sure the file is in utf8 encoding, and first col is ’email’, sorry for mistake make before

1. Importing Sender Accounts

ColdEmailingJet supports sender account data in .txt and .csv formats. For .csv files, the first line must contain headers, and no special characters are allowed in custom field names.

  • CSV Format: A CSV file for sender accounts must include the following fields:
    • email (required): The email address of the sender.
    • pwd (required): The sender’s password.
    • Optional CSV Fields:
    • SMTP_host: The SMTP host for the sender account.
    • smtp_port: The SMTP port for the sender account.
    • proxy: Binds a proxy to the sender account.
    • from2: If provided, this value appears in the “From” field of the email body.
    • Other custom fields can be added as needed, but they should not contain spaces or special characters. Example Usage in Email Body:
      You can reference these fields in the email body using tags like {sender.username}, {sender.customized_field}
    • If a CSV file is missing a username, ColdEmailingJet will also auto-generate it
  • TXT Format: Each line should represent a new account, with fields in the format mailaddr:pwd:smtp-host:smtp-port. ColdEmailingJet will auto-generate a username for each email in TXT files. .

2. Importing Contact Lists

Contact lists can be stored as .txt or .csv files.

  • CSV Format: The CSV file must contain a email field. Additional custom fields are allowed and can be referenced in the email body, such as {email.mail_addr} or {email.customized_field}.
  • TXT Format: For TXT files, each line should contain an email address. ColdEmailingJet can auto-generate fields like {email.username} based on the email address, though accuracy may vary. You can use {email.email} for the email address in TXT files.

Custom Fields in CSV: avoid spaces or special characters. For example, if your CSV file includes a Phone field, reference it as {email.Phone} in the email body.

3. Preparing Mail Content

Mail content should be stored in text or HTML files (.txt, .htm, .html). ColdEmailingJet reads the content and formats it according to the following guidelines:

  • Text Files: The first line in a .txt file is used as the email subject.
  • HTML Files: The title tag is used as the email subject. You can also use spin text for dynamic content. For example:
  Hello {world|everyone|friends}, welcome to {Python|programming|coding}!

You can also load data from a file directtly: {{ilespin.subject}, then mailer will try to open the file named “subject.txt” under mail.data/file.spin

4. Configuring Proxies

Proxies can be set up in text files (.txt).

ColdEmailingJet supports only IPv4 proxies with the following formats:

  • Proxy Format: type://usr:pwd@ip(or domain):port
  • Examples:
  http://wm3r8j984xdd:fxopyuijat9wz9@82.52.14.139:3023
  socks5://82.52.14.139:3023  # No username/password
  proxydomain.com:3023        # HTTP protocol assumed

5. Attaching Files

To add attachments, save the files you wish to attach in a folder. ColdEmailingJet will randomly select a file from this folder to include in each email. Supported file formats include images and PDFs.

6. Adding Link Files

Links can be stored in text files (.txt). Each link should be on a new line, and you can reference it in the email body using {link} if links are set up in campaign settings.

Enabling Tracking Tags

To monitor your email performance, you can include tracking tags:

  • Open Tracking: {track_open_link} insert img tage with trackdata
  • Click Tracking: {track_click_link} inserts link+#trackdata.