Custom Data Export

Generate an export with just the data you need - and save the settings for future use!

Josh Koontz avatar
Written by Josh Koontz
Updated over a week ago

We've just added a new export option!

Now you can export your data and just include the specific data that you want making it easier than ever to understand your business.

Note: This feature requires Advanced being On

Get Started

In the new Reporting section of Spectora you will find a new tab labeled Custom Export

From this screen you can now build out your own custom exports using any of the data points in the selector and then filter (if you choose too) to further tailor you export to your needs.

Click on + Add Custom Export to create a new export

In the window that pops up start by selecting what data you want to be in your export

  • You can choose individual items or everything in a section by clicking Select All

  • There are a few items that when selected will generate more than one column in your export;

    • Service Fee Breakdown will include a column for each of your services (including add-ons) with the cells filled out per row with the associated dollar amount.

    • Payment Amount will include a column for each of your Payment Types with the cells filled out per row with the associated dollar amount.

    • Client, Buyer's Agent and Seller's Agent Address will include separate columns for the individual components of the address

    • Client, Buyer's Agent and Seller's Agent Phone will include separate columns for Work (Office), Mobile, Home (Clients only) and Fax (Agents only) phone numbers

  • The Custom Fields selectors are based on what you have setup in Custom Scheduling Fields here in Settings

  • Click on Next or Filter to move on to the next step of customization OR just click Run Export to generate the .csv file without filtering

image

Once on the Filter step you may adjust what data will actually make it into your export using the following filters

  • Date Range - Default is Last Month

  • Status - Default is to not include Deleted, Archived or Cancelled but include data from Confirmed or not, Paid or not and Published or not

  • Inspectors - No selection here means all Inspectors will be included. You may choose multiples by starting to type the name and selecting the inspector.

  • Services - No selection here means all Services will be included.

Click on Next or Save Export to move on to the next step OR just click Run Export to generate the .csv file without saving the setup for future use.

image

From the last step Save Export you have the option to save your settings for this export and name it something meaningful. You can even add a description. Finally click on Save & Run Export

image

Once you have saved exports you will see them on the main Custom Export page and can simply Run, Edit or Delete them. These Exports are not user specific so anyone with Financial Data permissions will be able to see, create and run them!

As always, reach out to the bubble if you need any help!

Did this answer your question?