I Know A Girl
Enterprise
Business Travel & Consortia  ·  Annual Engagement

The RFP Architect™

Required Reports & Pull Guide

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.

01  ·  Start Here

How this works

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.

Where to upload
Property Setup, then the Input Readiness panel. Each report has its own upload button and its own Instructions link.
What formats
Agency360 exports are XLSX. Production reports are Excel preferred, PDF accepted. The prior-year workbook is Excel or PDF.
When it unlocks
Once every required report is in (or Why-Noted) and IKAG confirms the pre-analysis review, the AI modules unlock.
Before you start
  • Pull every Agency360 report for the Trailing 12 Months date range, ending August 31, 2026.
  • Your trailing-twelve-month and year-to-date Lighthouse production reports must end on August 31, 2026, the same date as your Agency360 pulls. This is what makes the year-over-year math line up. The full-year 2025 report is a fixed calendar year.
  • Excel is preferred everywhere. PDF is accepted for the production reports and the prior-year workbook.
  • Do not rename files to match a required name. Upload what the tool exports. The suggested names in this guide are only to keep you organized.
  • If a report genuinely does not apply to your property, record a Why Not on that report instead of leaving it blank. IKAG reviews every Why Not before analysis.
IKAG Insight

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.

02  ·  The List

The reports at a glance

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
1OverviewAgency360XLSXRequired
2Performance Trends - Month ViewAgency360XLSXRequired
3Booking PatternsAgency360XLSXRequired
4Agency Targeting - Rank By OpportunityAgency360XLSXRequired
5Agency Targeting - Rank By CS RevenueAgency360XLSXRequired
6Agency Targeting - Rank By Market RevenueAgency360XLSXRequired
7Agency Targeting - Rank By Subscriber RevenueAgency360XLSXRequired
8Corporate Performance - Subscriber RevenueAgency360XLSXRequired
9Corporate Performance - Comp Set RevenueAgency360XLSXRequired
10Corporate Performance - Market RevenueAgency360XLSXRequired
11Trailing 12 Months ProductionLighthouse BIXLSX / PDFRequired
12Year-to-Date ProductionLighthouse BIXLSX / PDFRequired
13Full-Year 2025 ProductionLighthouse BIXLSX / PDFRequired
14Comp Set Rate ShopShop tool or manualXLSX / PDFRequired
15Manual Grunt WorkCompiled by propertyXLSXRequired
16Prior-Year Roadmap / Pricing WorkbookLast year's deliverableXLSX / PDFReturning

Returning: required for properties in their second year of the engagement onward. New properties can skip report 16.

03  ·  Pull Instructions

Section A  ·  Agency360

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.

Agency360
Overview
In the portal:  Agency360  ›  Overview
  1. Set Date Range to Trailing 12 Months, ending August 31, 2026, then click Apply.
  2. Click Customize Metrics, choose All Metrics (check the box), and click Apply in the popup.
  3. Click the Export arrow.
Save the file as
Overview
Also do this
Upload this same file into The Listing Architect as well.
Agency360
Performance Trends, Month View
In the portal:  Agency360  ›  Performance Trends
  1. Set Date Range to Trailing 12 Months, ending August 31, 2026, then click Apply.
  2. Switch the view to MONTH.
  3. Click the Export arrow.
Save the file as
Performance Trends Month View
Agency360
Booking Patterns
In the portal:  Agency360  ›  Booking Patterns
  1. Set Date Range to Trailing 12 Months, ending August 31, 2026, then click Apply.
  2. Turn on "Include DOW Analysis."
  3. Click the Export arrow.
Save the file as
Booking Patterns
Extended-stay properties
Scroll down to Length of Stay and click "Extended Stay" before exporting.
Agency360  ·  Four exports from one tab
Agency Targeting
In the portal:  Agency360  ›  Agency Targeting
Set up once
  1. Set Date Range to Trailing 12 Months, ending August 31, 2026, then click Apply.
  2. Choose 25 to 100 accounts (whatever the tool allows).
Then export four times, changing only Rank By each time
Set Rank By toSave the file as
OpportunityAgencyTargeting- Opportunity
CS RevenueAgencyTargeting- by CS Revenue
Market RevenueAgencyTargeting- by Market Revenue
Subscriber RevenueAgencyTargeting- by Subscriber Revenue
Stay on this tab
Keep every other setting the same. Only the Rank By selection changes between the four exports. Click the Export arrow after each change.
Agency360  ·  Three exports from one tab
Corporate Performance
In the portal:  Agency360  ›  Corporate Performance
Set up once
  1. Set Date Range to Trailing 12 Months, ending August 31, 2026, then click Apply.
  2. Choose 25 to 100 accounts (whatever the tool allows).
Then export three times, changing only Rank By each time
Set Rank By toSave the file as
Subscriber RevenueCorporate Performance- by Subscriber Revenue
CS (Comp Set) RevenueCorporate Performance- by Comp Set Revenue
Market RevenueCorporate Performance- by Market Revenue
Stay on this tab
Keep every other setting the same. Only the Rank By selection changes between the three exports. Click the Export arrow after each change.

Section B  ·  Lighthouse BI

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.

Lighthouse BI
Trailing 12 Months Production
Source:  Lighthouse BI  ›  Accounts
  1. Choose the date range: Trailing 12 Months, ending August 31, 2026.
  2. Go to Lighthouse BI.
  3. In the drop-down menu, choose Accounts.
  4. In the Filters, set Market Segments to Consortia, Corporate and Government.
  5. Click Apply. It sits in the same row and is not highlighted, so it is easy to miss.
  6. Export the report.

Format:  Excel preferred. PDF accepted.

Save the file as
Trailing 12 Months Production
Lighthouse BI
Year-to-Date Production
Source:  Lighthouse BI  ›  Accounts
  1. Choose the date range: Year-to-Date, ending August 31, 2026.
  2. Go to Lighthouse BI.
  3. In the drop-down menu, choose Accounts.
  4. In the Filters, set Market Segments to Consortia, Corporate and Government.
  5. Click Apply. It sits in the same row and is not highlighted, so it is easy to miss.
  6. Export the report.

Format:  Excel preferred. PDF accepted.

Save the file as
YTD Production
Lighthouse BI
Full-Year 2025 Production
Source:  Lighthouse BI  ›  Accounts
  1. Choose the date range: 2025 Full Year (January 1 to December 31, 2025).
  2. Go to Lighthouse BI.
  3. In the drop-down menu, choose Accounts.
  4. In the Filters, set Market Segments to Consortia, Corporate and Government.
  5. Click Apply. It sits in the same row and is not highlighted, so it is easy to miss.
  6. Export the report.

Format:  Excel preferred. PDF accepted.

Save the file as
Full-Year 2025 Production

Section C  ·  Comp Set Rate Shops

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.

Rate-shop tool or manual
Comp Set Rate Shop
Acceptable sources:  a HIS (Hotel Information Service, hisreports.com) export, a comparable rate-shopping tool, or a manual Excel rate shop completed by the property.
Choose whichever fits your property
If youThen
Use a rate-shop toolExport your Corporate Negotiated Rate Shop from HIS (hisreports.com), or the equivalent from a comparable tool.
Shop by handComplete a rate shop across your full comp set in Excel.

Format:  Excel preferred. PDF accepted.

Save the file as
Comp Set Rate Shop
Keep it consistent
Shop the same competitive set you use across the rest of your reporting.

Section D  ·  Manual Grunt Work

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.

Compiled by property
For each top & target account
Compile:  the two items below, per account.
  1. Top Hotel's RN, ADR & Revenue. The account's top-producing hotel, with its room nights, average daily rate, and revenue.
  2. DOW & LOS data by account (day-of-week and length-of-stay production for each account). For DOW, flag the days that carry the heaviest produced volume.

Format:  Excel.

Save the file as
Top & Target Account Detail
Reading the DOW
The heaviest-volume days tell you whether the account is worth its value, or whether it is displacing higher-value revenue on days you would already fill.
IKAG Insight

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.

Section E  ·  Prior Year

Returning properties add one more file. New properties can skip this section.

Last year's deliverable  ·  Returning properties only
Prior-Year Roadmap / Pricing Workbook
Source:  Your previous-year IKAG deliverable
  1. Upload your previous-year roadmap or pricing workbook.
  2. Have it completed with final negotiated rates, filled in as much as possible.

The prior-year roadmap must have finalized pricing to be of value.

Format:  Excel or PDF.

Save the file as
Prior Year Roadmap | Pricing Workbook
When it is required
Returning properties, year two of the engagement onward. New properties can skip report 16.
HVMG properties
If you are already working within a spreadsheet, you may upload your completed 2027 pricing workbook here instead of the prior-year roadmap.
One last thing

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.