Every property in the engagement provides the same set of reports. They ground every AI module in the portal, from your business case to your account targeting. This guide names each report, tells you exactly where it lives, and walks the pull step by step.
You will find these reports in the portal under Property Setup, in the Input Readiness panel. Upload each report there. Builds stay locked until every required report is uploaded, or carries a Why Not, and IKAG confirms the pre-analysis review. Filenames do not need to match exactly. The portal accepts a report once its data is present.
Matching end dates across every report is what makes the analysis trustworthy. When the Agency360 window and the Lighthouse production window line up, the portal compares like for like, and the account targeting holds up when it reaches a brand or an RFP system. The few minutes spent pulling these correctly is what makes the output defensible.
Fifteen inputs are required for every property, plus the prior-year workbook for returning properties. Names below match the labels you will see in the Input Readiness panel, so you can tick them off directly.
| # | Report | Pulled from | Format | Required |
|---|---|---|---|---|
| 1 | Overview | Agency360 | XLSX | Required |
| 2 | Performance Trends - Month View | Agency360 | XLSX | Required |
| 3 | Booking Patterns | Agency360 | XLSX | Required |
| 4 | Agency Targeting - Rank By Opportunity | Agency360 | XLSX | Required |
| 5 | Agency Targeting - Rank By CS Revenue | Agency360 | XLSX | Required |
| 6 | Agency Targeting - Rank By Market Revenue | Agency360 | XLSX | Required |
| 7 | Agency Targeting - Rank By Subscriber Revenue | Agency360 | XLSX | Required |
| 8 | Corporate Performance - Subscriber Revenue | Agency360 | XLSX | Required |
| 9 | Corporate Performance - Comp Set Revenue | Agency360 | XLSX | Required |
| 10 | Corporate Performance - Market Revenue | Agency360 | XLSX | Required |
| 11 | Trailing 12 Months Production | Lighthouse BI | XLSX / PDF | Required |
| 12 | Year-to-Date Production | Lighthouse BI | XLSX / PDF | Required |
| 13 | Full-Year 2025 Production | Lighthouse BI | XLSX / PDF | Required |
| 14 | Comp Set Rate Shop | Shop tool or manual | XLSX / PDF | Required |
| 15 | Manual Grunt Work | Compiled by property | XLSX | Required |
| 16 | Prior-Year Roadmap / Pricing Workbook | Last year's deliverable | XLSX / PDF | Returning |
Returning: required for properties in their second year of the engagement onward. New properties can skip report 16.
Ten reports come from Agency360. The four Agency Targeting exports and the three Corporate Performance exports each come from a single tab. You set the tab up once, then export several times, changing only the Rank By selection between exports.
| Set Rank By to | Save the file as |
|---|---|
| Opportunity | AgencyTargeting- Opportunity |
| CS Revenue | AgencyTargeting- by CS Revenue |
| Market Revenue | AgencyTargeting- by Market Revenue |
| Subscriber Revenue | AgencyTargeting- by Subscriber Revenue |
| Set Rank By to | Save the file as |
|---|---|
| Subscriber Revenue | Corporate Performance- by Subscriber Revenue |
| CS (Comp Set) Revenue | Corporate Performance- by Comp Set Revenue |
| Market Revenue | Corporate Performance- by Market Revenue |
Three production reports come from Lighthouse BI. You pull from the same place three times, changing only the date range. The trailing-twelve-month and year-to-date pulls end August 31, 2026, the same date as your Agency360 pulls in Section A. The full-year 2025 pull is a fixed calendar year.
Format: Excel preferred. PDF accepted.
Format: Excel preferred. PDF accepted.
Format: Excel preferred. PDF accepted.
A rate shop of your competitive set, so the analysis can see where your rates sit against the comps. The source is flexible. An export from a rate-shopping tool and a rate shop you build by hand in Excel are both fine.
| If you | Then |
|---|---|
| Use a rate-shop tool | Export your Corporate Negotiated Rate Shop from HIS (hisreports.com), or the equivalent from a comparable tool. |
| Shop by hand | Complete a rate shop across your full comp set in Excel. |
Format: Excel preferred. PDF accepted.
This is the hands-on part. For each account on your top account list and your target account list, pull the following together yourself, using the same trailing-twelve-month window as your Agency360 pulls in Section A.
Format: Excel.
This account-level detail is the heaviest lift and the highest value. It is what lets the analysis name the accounts to defend and the accounts to chase, with the numbers to back it up. Do it for every account on your top list and your target list.
Returning properties add one more file. New properties can skip this section.
The prior-year roadmap must have finalized pricing to be of value.
Format: Excel or PDF.
The portal will not run a build until the data is in, and that gate is deliberate. Every business case, demand brief, and opportunity map is only as sharp as the reports behind it. Pull these once, correctly, and the rest of the engagement runs on solid ground.
Questions on any report? Reach IKAG at jacque@iknowagirlenterprise.com.
This guide and the RFP Architect™ process it describes are the confidential and proprietary property of I Know A Girl Enterprise. It is provided to a single property for use in that property's RFP Architect engagement only, and may not be copied, reproduced, distributed, used at any other property, or disclosed beyond the specific hotel to which it was provided, without the prior written consent of I Know A Girl Enterprise.
Data you provide is handled in confidence and used to deliver your engagement. I Know A Girl Enterprise may also use this data in de-identified and aggregated form for research, benchmarking, and industry studies, in a manner that does not identify any individual property, account, or negotiated rate. Ownership of the underlying property data remains with the property and its ownership group, subject to the terms of any third-party data providers.
This notice is provided under and subject to the engagement agreement between I Know A Girl Enterprise and the recipient. That agreement governs, and this notice does not limit or replace it.
© 2026 I Know A Girl Enterprise. All rights reserved.