Export - Contacts

Written By Chris Louis (Super Administrator)

Updated at March 22nd, 2021

The Contacts report located in the Export - Sidebar (web application) allows users to create custom report(s) that show the contact information that was entered by reps/users into the Lilypad system for each account. 

NOTE: Distributor rep contact information can also be pulled using this report. However, unlike manually entered Account Contacts, Distributor Rep contacts can either be manually entered or reported by the Distributor through their route files being sent to Lilypad. 


How To Create a Contacts Export

The steps below outline how to use the export builder to customize your Accounts report: 

1 Log into the Lilypad Web App ( https://login.lilypad.co/ ).


2 From the side bar on the left, click on Export.


3 Under the Exports box, select Contacts from the list that populates. 


To the right, under Export Options box, complete the following steps:

4 From the Source dropdown, select either All Accounts or Target Accounts. There are slight differences between these two source types. 

  • All Accounts - report will include all accounts in the Lilypad system
  • Target Account - report will include only accounts on a rep/user's Target List (list of target accounts created by managers for reps/users to hit out in-market). See our  How To - Create a Target List article for more on the Target List creation process.


5 If All Accounts was selected, next steps are to: 

  • Enter a name in the Report Name text box.
  • Select a Distributor(s) (account universe) from the dropdown.
  • Under the Only Contacts Updated section, use the dropdown to select between: Anytime, Last 30 Days, Last 60 Days, Last 90 Days 


6 If Target Account was selected, next steps are to:

  • Under the Which User's List section, use the dropdown to choose which user(s) are included in your report.
  • Use the Target List dropdown to select which specific list you want to pull the report for. 
  • Enter a name in the Report Name text box.
  • Under the Only Contacts Updated section, use the dropdown to select between: Anytime, Last 30 Days, Last 60 Days, Last 90 Days


Under the Premise section, use the dropdown to select between the following three account options: Both, On Premise, or Off Premise.



Under the Contact Type(s) section, use the dropdown to select between the following: 

  • Account - includes the manually entered or uploaded main point of contact for each account in your report
  • Distributor - includes the manually entered or reported distributor rep contact for each account in your report 


Under the File Type section, use the dropdown to select between file optimization preference:

  • Optimize for Excel, Sheets, Numbers - creates a compatible file for Microsoft Excel, Google Sheets, or Apple Numbers.
  • Optimize for CSV - creates a comma-separated values (CSV) file that allows data to be saved in a tabular format. 


10 If Optimize for Excel, Sheets, Numbers was selected, then under the Style section, use the dropdown to choose between the following options: 

  • All in One Sheet
  • Separate each Distributor into its own sheet


11 Under the Send & Frequency section, use the dropdown to select between the following options of how and when you'd like your report sent:

  • Download Now - creates a report that can be opened immediately.
  • Email Now - sends the report as an email attachment immediately.
  • FTP Now - allows you to enter credentials for File Transfer Protocol (FTP) completion to be sent immediately. 
  • Email Once Later - allows you to schedule an email to be sent once.
  • Recurring Email - allows you to schedule an automated email to be sent on a regular basis. 
  • Recurring FTP - allows you to enter credentials for File Transfer Protocol completion and schedule a regular send. 



12 If Email Once Later was selected, next steps are to:

  • Below the dropdown, enter the email(s) into the text box. NOTE: Be sure to separate each email with a comma.
  • Below the email text box, use the calendar icon and numbers text box to enter the date and time you want the report sent to you. NOTE: All times are in the Easter Time Zone.


13 If Recurring Email or Recurring FTP was selected, below the dropdown, enter the email(s) or FTP credentials into the text box.

                


                          or


                




Then, under the Recurrence section, choose from the following: 

  • Next to Repeat, use the dropdown to select the send frequency (Daily, Weekly, Monthly, Quarterly, Hourly). 
    • If Weekly was selected, use the day picker bubbles to select the exact day (Sunday-Saturday) you'd like the report to send.
    • If Monthly or Quarterly was selected, click the calendar icon to select the exact date you'd like the report to send.
  • Next to At, click the textbox to select the exact time the report will be sent.
  • Next to Data Range, use the dropdown to select the time frame (Previous week, Current week, Previous month, Current month, Quarter to Date, Year to Date) you want to pull the report for.



14 Once done, click the green Submit button at the bottom right. This will ensure that the report will either download immediately or automatically run on the selected day/time, depending on which frequency option was chosen. 

Was this article helpful?