Are you interested in viewing the total revenue generated in a specific year? Perhaps you're searching for the overall fees or subscription costs that were paid. Or maybe you're curious about the number of miles you've tracked? If that's the case, you'll be delighted to know that our Data exports contain a wealth of information for you to explore!
How to Find Your Data Exports
To access your Data Exports page, follow the steps provided below. Once you reach the page, you can choose the specific export from which you want to retrieve information.
If the option is not visible to you, may not have the necessary permissions. In this case, we recommend reaching out to your company administrator to enable the financial permission under the teams setting.
Click on the drop-down menu in the top right of your dashboard.
Select "Data Exports."
Click the blue link below the export you would like to view.
 💡Quick tip: Click on the video above to expand it in another window. |
Please access the drop-down menus below to locate information on each of our available exports.
Inspection Data
Inspection Data
We highly recommend utilizing the Inspection Data Export for the most comprehensive information. This export includes all inspection details, contact details, addresses, services, fees, and more. Simply click on one of the available years to access this valuable data or take advantage of the custom export option mentioned below.
If you are an Advanced user, you can create custom data exports for your search to be more refined. Check out this article for more details.
Custom Export
The "Custom" option under the Inspection Data Export, offers a custom option that allows you to tailor your data export to your specific needs. You can easily filter by inspector and even include or exclude specific services, cities, states, or zip codes.
Export Example
Charges
Charges
The "Charges" export function enables you to access a comprehensive breakdown of all fees that have been incurred for each year. This includes the name of the service, date of inspection, and address.
This export does include deleted inspections and canceled inspections
Export Example
Payments and Fees
Payments and Fees
Welcome to our "Payments and Fees" export feature! It's designed to make your life easier by providing you with a comprehensive view of all your received payments and processing fees. You'll have access to important details such as the date, inspection address, amount, payment type, fee, and more.
The payments and fees spreadsheet does not automatically output totals for fees. You’ll need to use the AutoSum function in Excel to calculate fee totals
Export Example
Unpaid/ Unsigned Inspections
Unpaid/ Unsigned Inspections
The export for "Unpaid/ Unsigned Inspections" allows you to view inspections that have not yet been paid for or signed.
Please be advised that any pending ACH (bank transfers) payments will be designated as unpaid in the export until the payment has been settled.
Once you open the export, you can modify the date range by either manually entering a specific date in the "Start Date" and "End Date" calendar options or selecting from pre-set options like past week to next week, past 2 weeks to next 2 weeks, or past 30 days to next 30 days. Then, you can personalize the report by choosing to show both unpaid and unsigned, only unpaid, or just unsigned. After making those adjustments, hit the "Run Report" to update the results.
At the present moment, this export is not capable of being exported, but can only be viewed.
Export Example
Mileage Export
Mileage Export
Are you in need of a convenient way to track your mileage? Perhaps you require a mileage report for tax purposes or reimbursement? Our "Mileage Export" feature is here to help! With just a few clicks, you can easily view all the miles you've driven in a year.
If Spectora Advanced and Inspection Events are enabled, the mileage will be tracked for events as long as the inspection event is associated with an inspection.
Within the export, it will have the company's total mileage count. At the bottom of the export, you will see tabs for each inspector on your account. Within each of the inspector tabs, you can see the total mileage for that inspection as well as details from each address for the mileage data.
How Mileage is Tracked
The milage calculates from your "Starting address for driving directions" > inspection A > inspection B > back to "Starting address for driving directions"
You can edit the "Starting address for driving directions" by going to Settings > Dashboard Settings > updating the address in the field "Starting address for driving directions."
Export Example
Subscription Fees
Subscription Fees
The "Subscription Fees" export will provide details on when the payment for a subscription was applied, the total amount including tax, a description of the service, the last four digits of the card used to pay, if any credits were used, and the transaction ID.
Export Example
Agent Export
Agent Export
The export option for "Agents" enables you to see a list of all your agents, along with the total number of inspections they have participated in and the date of their most recent inspection.
This export does not include any deleted inspections.
Export Example
External Scheduling Data
External Scheduling Data
The "External Scheduling Data" Export is a document containing information about external inspection schedules. This export includes "UTM Codes," which are the codes that appear at the end of a URL when a specific campaign is run. These UTM codes can be used in Google Analytics or other marketing and web analytics services to track website traffic and user engagement.
This tracking must be conducted externally, as our software does not offer tracking capabilities. We solely provide the necessary codes.
Export Example
FAQ
How can I view these exports if I don't have Excel?
If you do not have Microsoft Excel, you can use Google Sheets for free with a Google account!
If you have any questions or feedback, write into our chat bubble or email support@spectora.com!
