Skip to main content

Create custom reports

Download data at any time with the help of custom reports

Updated over 2 weeks ago

Create a report

Administrators can create custom reports (in CSV file format) with such data as:

  • Users

  • Companies

  • Subscriptions

  • Transactions

  • Invoices

  • Invoice items

  • Bookings

  • Event attendees

  • Shop orders

  • Benefit applications

  • Visitors

  • Support tickets

To download a custom report in Spacebring, go to the Analytics > locate Create report the top right and choose the report type.

Types of reports

Report type

Subtypes (Filters)

Usage

Users

  • Members

  • Nonmembers

Collects all users' contact and billing information, their subscription details, and users' company names.

Companies

  • Members

  • Nonmembers

Retrieves a list of companies created in the location with their subscription and billing details.

Subscriptions

  • By status

Lists users' and companies' subscriptions with details on their start and end dates, renewal dates, total price, and the included credits and day passes.

Transactions

  • Credits

  • Money

  • Per company

  • All users and companies

  • By start and end dates

  • By status

Collects a complete list of transactions initiated with their ID, date, description, amount, status, memo (to transactions for externally paid invoices), contact information of the users related to the transaction, transaction's discounted amount (if paid with money), links to receipts PDFs, and many more.

Invoices

  • By the invoice issuance date

  • By the invoice creation date

  • By status

Offers the total amount of the invoices issued, their numbers, memo (if added), tax breakdown, links to invoices PDFs, and users' and companies' information.

Invoice items

  • By the invoice issuance date

  • By the invoice creation date

  • By status

Breaks down all invoice items from users' and companies' invoices that describe what has been included in the invoice, the price for them with taxes, and the discounted amount.

Bookings

  • By the booking create date

  • By the booking start date

  • By type: Room, Dedicated Desk, Hot Desk, Office, Parking lot

  • By the specific resource

Retrieves bookings with data on their resource type, price, owner, and creator details, payment type, etc.

Event attendees

  • By the event joining time

  • By the specific event

Lists all event attendees who purchased tickets for a specific or any event within the selected time range with their contact details, event title, and information on ticket payment.

Orders

  • By the order creation time

  • By the specific product

Provides a list of the orders made on the Shop page with data about purchased products, options, prices, and user contact details.

Benefit applications

  • By the benefit application creation time

  • By the specific benefit

Lists applications made on the Benefits page for a specific or any benefit within the selected time range with application comment, benefits, and user contact details.

Visitors

  • Visits

  • Contacts

  • By the visit or contact registration time

Offers a list of visits and contacts registered with their dates, visitor, contact, and host contact information.

Support tickets

  • By the ticket creation time

Tracks support tickets created with the initial user's question, ticket type, status, creation date, and information of requested and assignee.

Notes

  • The "Subscriptions" report includes all active subscriptions, as well as those that were canceled or ended after November 29, 2024, when this report was introduced in the app. It also includes some data on canceled and ended subscriptions from a few months preceding its release. However, please note that comprehensive historical data will be captured and available in this report only for subscriptions canceled or ended after November 29, 2024.

FAQ

How can I export the list of users from the app?

To download a list of your users along with their contact details, email addresses, and subscription information, generate the "Users" report type on the Analytics page > Create report. You can choose to download a report that includes only your members, only nonmembers, or both groups of users by using the "Members" and "Nonmembers" switches on the report creation page.

How can I export the list of all members with an active subscription?

To download a list of all your members with an active personal or company subscription, generate the "Users" (enable the "Members" subtype) and "Companies" report types on the Analytics page > Create report > filter them by the "Subscription Start Date" column to identify which members currently have an active subscription.

How can I check the average spend per customer?

You can easily calculate the average spend per customer (including both your members and non-members) using this step-by-step guide:

  1. Create a "Transactions" report with the necessary period. Select the "Paid" status to get only paid transactions result. Open the report in Google Sheet or Excel.

  2. Add all income from both members and nonmembers. You can use the formula =SUM() to calculate all the rows of the "Amount" column.

  3. Count all distinct individuals who made a purchase during that period by using the formula =COUNTUNIQUE(A:A).

  4. Divide the total revenue by the number of unique customers.

How can I calculate the rooms' occupancy in % during work hours?

To calculate the rooms' occupancy in % during work hours, you can follow this guide:

  1. Download the "Bookings" report (filtered for rooms, desired period).

  2. Open it in Excel or Google Sheets > filter and sum the booking durations. This gives you "Total booked hours".

  3. Determine "Total available hours" for your rooms (Number of rooms x Work hours/day x Working days in period).

  4. Divide "Total booked hours" by "Total available hours" and multiply by 100.

This method provides the percentage of time your rooms were booked specifically during your operational work hours.

You can also view overall usage statistics on the Analytics > Rooms page, where the number of bookings and revenue are displayed.

How can I get a report for invoices and payments made for a particular client?

To generate a report for invoices and payments made for a particular client, follow these steps:

  1. Download the "Invoices" report for a summary of all invoices, including their status, amounts, and links to PDF copies.

  2. Open it in Excel or Google Sheet and filter it by company or user.

  3. Download the "Transactions" report for a list of all payments, including receipts and payment details.

  4. Open it in Excel or Google Sheet and filter it by company or user.

You can also view and download individual invoices and receipts directly from the client’s profile under Customers > user/company profile > Billing > Invoices or Transactions. This allows you to access or print specific documents as needed.

Did this answer your question?