Our support has moved to: here

Exporting Lead data as a CSV

Exporting Leads

Spectate allows users to export Lead data to a CSV file (comma-separated value) so that it may be imported into an external system or used to generate a spreadsheet.

To export Leads:

  1. Go to Track > Leads
  2. Click the "Export to CSV" icon (page with paper clip) above and the right of the Leads datatable

Exported Lead Columns

The CSV includes the following data for Leads:

  • Id - Unique identifier of the lead. Can be used to read or update the Lead using our REST API
  • Campaign - The Campaign in which the Lead originated - e.g. Social Media, Website
  • Salutation - Salutation for the Lead - e.g. Mr., Ms., Mrs.
  • First Name - First name of the Lead
  • Last Name - Last name of the Lead
  • Email - Email address of the Lead
  • Password -
  • Company - Company that the Lead belongs to. Would be filled in by the Lead themselves in a form.
  • Website - The website of the organization that the Lead works for
  • Job Title - The job title of the Lead
  • Department - The organizational department that the Lead works in (Support, Marketing, IT, Sales, Operations, etc)
  • Country - The country that Lead works in
  • Address One - The primary address of the Lead
  • Address Two - The secondary address of the Lead
  • City - The city that Lead works in
  • State - The state that Lead works in
  • Territory - The territory that Lead is responsible for
  • Zip - The zip code in which that Lead works
  • Phone - The Lead's phone number
  • Fax - The Lead's fax number
  • Source - The traffic source from which the Lead found the user's website via (Direct Traffic, Organic Search, Email Marketing, Social Media, Paid Search, etc)
  • Annual Revenue - The annual revenue of Lead's company/organization
  • Employees - The number of employees that work for the Lead's company/organization
  • Industry - The industry that the Lead works in
  • Years In Business - The number of years that the Lead's organization has been in business
  • Comments - Additional comments offered by the Lead
  • Notes - Additional notes offered by the Lead
  • Score - The numeric score associated with the Lead that the user sets up
  • Grade - The letter grade associated with the Lead
  • Last Activity At - The last time the lead was tracked by Spectate
  • Recent Interaction -
  • Crm Lead Fid -
  • Crm Contact Fid -
  • Crm Owner Fid -
  • Crm Account Fid -
  • Crm Opportunity Fid -
  • Crm Opportunity Created At -
  • Crm Opportunity Updated At -
  • Crm Opportunity Value -
  • Crm Opportunity Status -
  • Crm Last Sync -
  • Crm Is Sale Won -
  • Crm Url -
  • Is Do Not Email -
  • Is Do Not Call -
  • Opted Out -
  • Is Reviewed -
  • Is Starred -
  • Created At -
  • Updated At -
  • Page Views Count -
  • Twitter Username -
  • Imported Prospect -
  • Exported Prospect -
  • On Aws Blacklist -
  • Has Bounced Email -
  • Has Invalid Email -
  • Has Spam Report -
  • User -
  • Crm -
  • Crm Object Type -
  • Connector -
  • Source Type -