Export - Accounts

Written By Chris Louis (Super Administrator)

Updated at March 22nd, 2021

The Accounts report located in the Export - Sidebar (web application) allows users to create custom report(s) that show the entire account universe that's being reported to Lilypad for a particular distributor(s). 


How To Create an Accounts 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 Accounts 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, Target Accounts, or Territory. There are slight differences between these three 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.
  • Territory - report will include only accounts in a rep/user's Territory (custom areas within a distributor's footprint created by managers for individual users/reps). See our How To - Create A Territory article for more on the Territory 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.


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

  • Under the Which User's List section, use the Select Teams and Select Users dropdowns to choose which 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.


7 If Territory was selected, next steps are to:

  • Under the Which User's List section, use the Select Teams and Select Users dropdowns to choose which are included in your report.
  • Enter a name in the Report Name text box.
  • Select a Distributor(s) (account universe) from the dropdown.


8 Next, use the Account Activity dropdown to choose between the following options: 

  • All Accounts - report will include all accounts regardless of if an Activity, Task, or Placement was completed at that account.
  • Only Accounts With Activity - report will include only accounts where an Activity, Task, or Placement was completed.
  • Only Accounts Without Activity - report will include only accounts where no Activity, Task, or Placement was completed. 


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


10 Under the Type section, use the dropdown to select between the following account options: Both, Independent, or Chain 


11 Under the Buy/Non-Buy section, use the dropdown to select between the following accounts sales options: Both, Buying, Non-Buying


12 Next, use the Best Day to Visit and Distributor Order Day dropdowns to include accounts with those particular Attributes (customizable account characteristics) in your report. 

    NOTE: Attributes are created by organization admins and entered into the Lilypad system by reps/users while out in market. 

    See our How To - Create A New Attribute article for more on the creation process. 


13 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. 
  • Optimize for JSON - creates a file that stores simple data structures and objects in JavaScript Object Notation (JSON) format


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

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


15 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. 


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

  • Under the Report Range section, click the calendar icon to select the time frame you want to pull the report for.
  • Next, 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 Eastern Time Zone.


17 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.


18 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?