Set up Automatic Nightly Lead Exports


Administrative permission is required to access the ZiftONE Settings. For more information, contact your supplier's point of contact.


Setup the nightly lead export email to automatically send identified recipients an email notifying them that the CSV file with a list of leads for the day that includes the lead/opportunity information that is available in My Downloads. The leads that are included are those that have exceeded the lead-score threshold and have had some sort of marketing activity on the previous day. The email notification is sent each night. Logged-in users can access the report under My Downloads.

The CSV file will include these three things:

  • The standard lead contact information like email address, first name, last name, company, and phone number.
  • Any custom lead fields such as the product of interest.
  • A list of the marketing events for that lead in JSON format. This includes the type, date/time, and description of the event.

Here is an example of the JSON formatted string for marketing events:

[{"Type":"Email Open","Description":"Email 'EP-ADSD-NA-Nurture1-Dynamic' was opened. Click <a href='' target='_blank'>here<\/a> to view the email.","Date":"6/6/12 6:05 PM"},{"Type":"Website View","Description":"Viewed website '<a href='' target='_blank'><\/a>'.","Date":"4... 6:09 PM"},{"Type":"Website View","Description":"Viewed website '<a href='' target='_blank'><\/a>'.","Date":"4... 6:09 PM"},{"Type":"Email Open","Description":"Email 'Eloqua Lead Campaign' was opened. Click <a href='' target='_blank'>here<\/a> to view the email.","Date":"4/16/12 5:21 PM"}]

This list can be easily imported into your CRM using its standard lead or data import capabilities.

Set up Your Nightly Email Export

  1. On the ZiftONE home page, click the drop-down arrow beside your name and select Settings.
  2. From ZiftONE > Settings, click CRM Settings.
  3. Click Add New CRM Integration.
  4. Select Nightly Lead Export from the drop-down.
  5. Click Edit Settings.
  6. Complete the settings.
    1. Under Users to Send File, enter the email addresses that will receive the email notifying them that they can pick up the report in My Downloads.
    2. Enter the minimum lead-score threshold.
    3. Select either Lead Distribution, Marketing Automation or both under Usage Profile.
      • Learn more about the Usage Profile at Settings: How to Set Up a Usage Profile for a CRM.
      • Note for the Lead Distribution usage profile within Nightly Lead Export Email CRM— Distributed Leads must be accepted (or the partner must have Auto-Accept enabled) before being added to the Nightly Lead Export Email CRM.
  7. Click Save at the bottom of the screen.
  8. Verify the integration is set to On to complete the integration process.
Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.