Business owners and managers can download their business's data from Reports > Data export. Each section is one CSV file with every record from the first one to today, not only recent ones. Staff who are not owners or managers cannot open the page or download a file.
Download a section#
- Select the business whose data you need.
- Go to Admin > Reports and open Data export.
- Select Download CSV on the section you need.
The file is built while it downloads, so a large section can take a minute. The button reads Downloading… until the file is ready. If the download stops partway, the page tells you instead of giving you a short file. Download it again.
Your business can download one file at a time, up to 20 an hour and 60 a day. That covers every section with room to spare. If you reach a limit, the page says how long to wait.
What each section holds#
- Customers: each customer, guest and lead with their contact details, date of birth, language and marketing choices, each customer's recorded choices about phone messages from your business, the notes your business wrote about them, the tags your business put on them (one Tag row each), the family links between customers, and every email unsubscribe from your campaigns with its date, campaign and reason. A lead shows where it stands in Lead stage:
not_invited,invitedorerror. An address that unsubscribed twice has two Email unsubscribe rows. The unsubscribe rows also need View marketing; without it the file leaves them out. - Bookings and attendance: every class and appointment booking with its status (cancelled and no-show included), attendance, check-in time and notes, and every entry at a door or turnstile, by customers and staff.
- Credits and passes: every class pack and pass a customer holds or held, with credits remaining, when it was bought, when it starts and when it expires.
- Memberships: every membership with its status, price and next billing date, its freezes, the people who share it, the contracts assigned to customers and staff, and the program plans customers enrolled in.
- Account balances: every customer account with its balance, limit and name, and every entry that changed it. A negative balance is what the customer owes.
- Waiver signatures: every waiver and legal document a customer signed, with who signed, when and which version.
- Payments and refunds: every payment with its date, customer, product, class, method, amount, fees, tax and note, the amounts as in the Payments report (a payment refunded in full also has a refund row), every payment that did not complete with its status and the amount tried, every refund, full or partial, and every correction of an amount that was never taken, with its date, amount and reason. A payment that failed, was canceled or is still processing shows not completed in Entry and the amount tried in Attempted amount. A refund shows its amount in Refunded amount and a correction in Corrected amount. All three sit apart from the payment amounts, so adding up payments counts none of them. A refund Stripe failed whose amount went to the customer's account shows the date in Repaid to wallet on. Created and Updated show when the payment was made and last changed, Class and Class starts the class it was for, Note the note on it, Stripe checkout session and Stripe payment intent the ids Stripe holds for it (Reference shows just one), and Recorded amount what a sale was recorded at, before any correction of an amount never taken.
- Gift card history: every gift card sold or issued, with its code, balance, recipient and expiry, and every purchase and redemption on it. A card shows its Template, who bought it in Purchaser email, who claimed it in Claimed by email, and, in Recipient emailed on, when the recipient was sent the card.
- Waitlist, referrals, coupons and reviews: every waitlist request, referral, coupon or promo code use, and review with its reply.
- Classes and schedule: every class with its instructors, location, room, capacity and the passes that cover it, the recurring schedules, and every class time, past or future, cancelled ones included, with its instructor, location and capacity.
- Services: every service with its length, people, price links, locations, providers and resources, and the hours each is available.
- Products and prices: every pass, membership, service product, physical product and gift card you sell with its prices and price versions, what each includes and covers, where and when it can be used, who may book a service, its stock levels and categories, its discounts, promo codes and coupons, and every program plan with its classes and prices. Discounts and promo codes need View marketing. Coupons need View marketing, View customers and View payments. Without them, the file leaves them out.
- Locations and resources: every location with its address, time zone and opening hours, and every room, court, chair or other resource with its type, capacity and location.
- Staff and teachers: everyone on staff with their name, email, phone and roles, and every instructor and provider with their bio and whether they are active. An invitation that has not been accepted yet is not in the file.
Read the files#
- Every file names a customer by Customer ID. Match rows across files on that column.
- The sections about what you set up name each class, class time, product, location, resource, instructor and staff member by an ID column such as Class ID, Product ID or Teacher ID. Match rows across files on those columns. Prices are in the main unit of the currency: 59 is 59 euro.
- In Products and prices, a Coverage line says what a pass or membership pays for and who may book a service: Gives is
includedormay_book, and amay_bookline shows its Advance days and Max future bookings. Coverage limit rows list every limit, and Product rule rows hold the days, times and locations a pass or membership can be used at. - A section with more than one kind of record starts with a Record type column. Filter on it to see one kind.
- Times are in UTC. Amounts are in the currency named beside them.
- Phone message choices are the ones recorded, with when, where and under which notice version. They do not say whether a message can be sent today: a later STOP reply or another choice can change that. A news and offers choice that was carried over from the old global switches reads carried over, not consent; the customer was never asked.
- Text that starts with
=,+,-or@gets a leading apostrophe, so a spreadsheet never runs it as a formula.
The files do not include who on your staff wrote a note, recorded an entry or made an account entry, card details, signature images and signed documents, pictures, or staff pay settings, payslips, bank details and sign-in details.
Downloads from other pages#
The Customers, Gift Cards, Payments and Unsubscribes pages have no download of their own. Each links to Reports from the line under its title on a larger screen, for owners and managers:
- Customers and Unsubscribes open Data export. The Customers section holds every customer, guest and lead, and every email unsubscribe, not only the latest of each address.
- Gift Cards opens Data export, where Gift card history holds every gift card and what happened on it.
- Payments opens the Payments report, which exports the selected month. Payments and refunds in Data export holds every payment from the first one.
A download does not apply a search or filter from the page you came from.
What exports are for#
For one person's bookings, purchases, or class passes, open their customer record. A download holds the whole business, not a search result. Decide who needs the file before sharing it.
What not to export#
Avoid using an exported file for:
- Sharing customer lists broadly
- Sending data to personal accounts
- Keeping permanent copies of sensitive customer information
- Working around role permissions
Do not use a business customer list as a substitute for a customer's own account data request. Ask your Naayya contact if you are unsure how to handle that request.
Protect exported files#
After downloading a file:
- Keep the file in a secure location
- Do not leave it on shared computers
- Avoid forwarding it by email unless that is approved for your business
- Delete it when the work is done
- Be careful with spreadsheets that sync to personal cloud storage
Troubleshooting#
Export is empty#
Confirm that you selected the correct business. A section with no records downloads a file with only its header row. For Customers, check Admin > Customers > All to see whether it has people. An older CSV may be empty because it was exported before records were added.
Export fails#
Try again from Reports > Data export. The download stops if Naayya cannot collect every record. If it still fails, contact support@naayya.com with the business name and the time you tried; do not send customer data in the message.
Customer data looks stale#
An existing file is a snapshot. Check the current record in Admin, then download a new CSV if you need the latest data.