As a small hotel owner or manager, your goal is to maximize the revenue from every available room. To truly achieve this, understanding and utilizing your hotel’s historical data is key. This is where Amiqa comes in – our AI-powered dynamic pricing solution is designed to help small hotels like yours compete effectively and boost profitability. To provide you with tailored recommendations, we need to analyze your real reservation history.
What’s in this article?
- Why Your Data Matters (and How Amiqa Uses It)
- What Data Does Amiqa Need? The Four Essential Variables
- Where to Find Your Historical Reservations Report
- How to Prepare Your File for Amiqa (The Crucial Step!)
- How to Upload Your Report to Amiqa
- What Happens After Submitting Your Data?
- Frequently Asked Questions (FAQs)
Why Your Data Matters (and How Amiqa Uses It)
Your historical reservation data is the secret ingredient for accurate and personalized pricing recommendations. It allows Amiqa’s powerful machine-learning model to understand the unique rhythm of your hotel and market, revealing crucial insights such as:
- Seasonal booking patterns specific to your property.
- Which room types that consistently perform best.
- The optimal price points you’ve achieved across different times of the year.
The cleaner and more complete your data, the more precise and effective our dynamic pricing recommendations will be.
Your Data is Safe with Amiqa: We understand the importance of your data’s privacy and security. We only require four specific, non-personal variables from your historical reservation data. We do not need any guest personal information, email addresses, booking channels, or payment methods.
What Data Does Amiqa Need? The Four Essential Variables
To generate dynamic pricing recommendations, Amiqa requires only four key variables from your reservation history:
| Variable | Description | Also Known As |
| Check-in Date | Guest’s arrival date | Arrival Date |
| Check-out Date | Guest’s departure date | Departure Date |
| Sold Price | Total booking value confirmed | Net Revenue, Booking Value, Sold Price |
| Room Name / Type | Name or category of the room booked | Room Name, Room Type, Room Category |
Where to Find Your Historical Reservations Report
Before you begin, decide which system you’ll use to export your data. All systems offer a way to export past booking data, regardless of the platform name. You can typically find this information in your:
- Channel Manager
- Property Management System (PMS)
- Invoicing or Billing System
Look for reports named similarly to:
- Check-ins (Arrivals)
- Check-outs (Departures)
- Booking Production
- Revenue History
- Invoice Report (Billing Report)
Key Selection Criteria: Ensure the report you choose includes stay dates (check-in/out), sold price, and room name/type.
How to Prepare Your File for Amiqa (The Crucial Step!)
This is where you make sure your data is perfectly ready for our model.
- Download Your Report: Export the report from your chosen system, ideally in .CSV or .XLSX format.
- Open the File: Open the downloaded .CSV or .XLSX file in a spreadsheet program (e.g., Microsoft Excel, Google Sheets, Apple Numbers).
- Identify and Keep Only the Four Essential Columns:
- Check that it includes exactly the four required variables.
- Keep only these four columns: “Check-in Date”, “Check-out Date”, “Sold Price”, and “Room Name / Type”. (Remember to use the “Also Known As” guide above if your column names differ ).
- Delete ALL other columns. This is very important; extra data can cause issues with our model.
- Review Data Format (Optional but Recommended):
- Dates: Ensure your “Check-in Date” and “Check-out Date” columns are in a consistent date format (e.g., YYYY-MM-DD or MM/DD/YYYY). Most spreadsheet programs handle this automatically, but a quick check helps.
- Sold Price: Ensure this column contains only numerical values.
- Save the Cleaned File: Save your modified file as a new version (e.g., “Amiqa_Cleaned_Report.csv” or “.xlsx”).
The final file must contain only the four essential variables.
How to Upload Your Report to Amiqa
Once your cleaned report is ready:
- Through the Amiqa Dashboard:
- Register & Log In: Register at https://app.amiqa.io/signup (if you haven’t already) and log into your account.
- Upload: Use the simple ‘Upload Data’ feature to upload your cleaned report directly into your Amiqa dashboard.
- (Alternative: Email Upload) Alternatively, you can contact us via email to customer@amiqa.io and let us know you would like us to guide you through the process.
What Happens After Submitting Your Data?
After we receive your report:
- We validate the data quality.
- Your historical data will be fed into our machine-learning model.
- We will generate your personalized dynamic pricing recommendations within a few days.
You’ll then be ready to optimize your revenue immediately!
Frequently Asked Questions (FAQs)
What if I cannot find the exact column names (e.g., “Check-in Date”)?
Look for equivalents! Common alternatives include: “Arrival Date” for Check-in Date; “Net Revenue” for Sold Price.
What if I don’t know how to clean the file, or I’m unsure?
No problem! Contact us via email to customer@amiqa.io. We’re here to help!
Can I leave extra data/columns in the file?
No. Please keep only the four essential variables. Extra data can complicate the process for our model.
Is my data safe with Amiqa?
Absolutely. We comply with all data protection regulations. Your data’s privacy and security are paramount.
Thank you for trusting Amiqa! With your data, your knowledge, and Amiqa’s technology, optimizing your hotel’s profitability has never been easier.
Ready to see the difference dynamic pricing can make? Let’s talk, and get a free analysis of your current pricing strategy.