There are 12 exports available in Briq. You can find these exports in Briq.app > reports > exports.
Click on create export and select the filter options on the slide-in to refine. After this it can be downloaded as a .csv file.
You can use the following filter options:
Some (financial) programs work with data in UTC. Most exports will be most useful in the local time zone.
- Date range
The date range is the selector where the date range is chosen applicable to the export. There are presets and a custom date selector.
A .csv is a file with data that is interrupted to display different cells. You can select whether the interruption is a comma “ , ” or a semicolon “ ; ”.
What exports are available and what can you do with them?
Payments provides an overview of all payments for bookings with an execution date in the selected period.
Customers export provides an overview of all customers who have booked in a specific period. This also includes their personal data. This can be used for customer tracking or marketing purposes. Note: Always respect the GDPR laws and regulations.
Product sales (filtered on BookingDateTime)
Product sales provides an overview of the total number of products sold in the selected time period. This also shows the total sales value of the products and whether they have been booked online or offline. It also states in how many bookings the product occurs. For instance, this can be used to determine the average upsell value per booking.
Deal sales (filtered on BookingDateTime)
Deal sales provides an overview of the total number of deals sold in a selected period. This also shows the total sales value of the products and whether they have been booked online or offline.
Bookings (filtered on VisitDateLocal)
Bookings provides information about the current status of all bookings in the system for the selected time period. If something changes in a booking tomorrow, the export tomorrow can be different from today. The export provides information at a general level; it says nothing about the products contained within the booking.
Booking mutations describe all changes that have been made on a particular booking. It concerns the changes at a general level. There is therefore no information about the products and deals inside a booking.
Booking products (filtered on BookingDateTime)
Booking products provides information about the products and deals contained inside a booking. The same booking number can therefore occur on several lines in the export, because several products and / or deals can be part of the same booking.
Booking product mutations
Booking products mutations shows all changes on the product level within a booking within the selected time period. It does not describe the general changes to the booking as in the Booking mutations export.
Products is an export of all products that are currently configured in the Briq application. Filtering for a specific time is not necessary as it is a snapshot of the current state of the database.
Deals is an export of all deals that are currently configured in the Briq application. Filtering for a specific time is not necessary as it is a snapshot of the current state of the database.
Discount vouchers (filtered on DateOfRedeeming)
Discount vouchers export contains information on all redeemed vouchers in the selected time. This also shows the origin, the voucher code and the corresponding payment.
Capacity (filtered on Date)
Capacity provides an overview of the capacity of the resources in the selected time period. Each line in the export shows a specific time slot. This provides insight into the occupancy rate. Note: This export can become long if you request the export for a long period.