Prompt Chain: Generate Your Weekly Performance Report in 5 Steps

What This Builds

A five-step prompt chain that takes your raw weekly data (rooms cleaned, re-cleans, complaints, absences) and produces five useful outputs in sequence: a data summary, a staff performance breakdown, coaching notes for anyone needing follow-up, a formal GM report, and a team recognition message. Each step's output feeds the next step — you run them in order and end up with everything you need for the week in about 5 minutes.

Prerequisites

• Comfortable using ChatGPT with Custom Instructions (Level 3)
• A way to track basic weekly data (rooms per attendant, re-cleans) — even a paper tally sheet works
• Cost: Free (ChatGPT basic) / $20/mo (ChatGPT Plus for faster responses and longer context)
• Time to build: 1 hour the first week to set up the chain; 5 minutes per week after

The Concept

A prompt chain is like an assembly line. Instead of one big complicated request, you break the work into stages — each stage builds on what the previous stage produced. It's like a relay race where each runner hands off the baton to the next. The output of Step 1 becomes the input of Step 2, and so on. By the end of the chain, you have five professional documents that would have taken you 2+ hours to write manually.

Build It Step by Step

Part 1: Set up your weekly data tracking sheet

Before running the chain, you need input data. Use a simple paper sheet or Google Sheet with these columns for each staff member:

Fill in the number of rooms cleaned each day. Mark absences. Tally re-cleans (rooms that had to be done again) and any guest complaints linked to a specific staff member.

Total it up at the end of each week. This takes 10 minutes if you're tracking as you go; 20 minutes if you're filling it in from memory at week end.

Part 2: Save the 5-step prompt chain

In your phone's Notes app (or a Google Doc), save these five prompts. You'll run them in order each week.

STEP 1 — Data Summary

Here is my housekeeping team's data for the week of [DATE]:

[Paste your weekly table here — staff name, rooms per day, re-cleans, complaints, absences]

Total rooms serviced: [X]
Team size (active this week): [X]

Summarize this data clearly: total output, overall re-clean rate (%), average rooms per attendant per day, and anything that stands out as a pattern.

STEP 2 — Staff Performance Breakdown

Using the data summary above, give me a brief performance ranking for each staff member. For each person, note:
- Their average rooms per shift
- Their re-clean count and what it might indicate
- Whether they were present and reliable this week
- One sentence: "Strong week," "Solid," "Needs coaching," or "Concerning pattern"

Keep it factual, not harsh.

STEP 3 — Coaching Notes

For any staff member you flagged as "Needs coaching" or "Concerning pattern," write me:
- A 2-3 sentence description of the specific performance issue
- One concrete, achievable improvement goal for next week
- One thing I should say in a brief coaching conversation (supportive but direct)

Format as individual entries per staff member.

STEP 4 — GM Weekly Report

Using everything above, write a one-page weekly housekeeping department report for my General Manager. Format:

Subject: Housekeeping Weekly Update — Week of [DATE]

Sections:
1. Summary (3-4 sentences: output, re-clean rate, any notable issues or wins)
2. Staffing (attendance, any coverage issues)
3. Guest Experience Impact (any complaints or compliments tied to housekeeping)
4. Action Items for Next Week (coaching, training, supply needs, maintenance follow-up)

Professional tone. Under 300 words.

STEP 5 — Team Recognition Message

Based on the performance data, write a brief recognition message I can post in our team WhatsApp group or print for the bulletin board.

Include:
- An overall positive note about the team's output this week
- A specific shoutout for the top performer (use the name and what they did)
- One motivating note about next week

Keep it warm, short (under 100 words), and appropriate for a diverse team — not everyone is a native English speaker.

Part 3: Run the chain each week

On Friday afternoon (or the last day of your reporting week):

1. Open ChatGPT
2. Start a NEW conversation (so you're starting fresh each week)
3. Run Step 1 — paste your data, copy the output
4. Run Step 2 — paste directly in the same conversation ("Now do Step 2...")
5. Continue through Step 5 in the same conversation

ChatGPT remembers everything from earlier in the same conversation, so each step builds on the previous one without you having to re-explain the data.

The whole chain takes about 5 minutes to run. You end up with: a data summary, individual staff notes, coaching prep, a GM report, and a team message.

Real Example: End of Week Run

Input data:

• 8 staff active this week
• 412 rooms serviced
• 18 re-cleans (4.4% rate)
• 2 guest complaints (both Room 308 on Tuesday and Thursday)
• 1 absence (Maria, Wednesday, covered by overtime)
• Top performer: Jose — 72 rooms, 0 re-cleans

After running the 5-step chain, you have:

1. Data summary: "412 rooms serviced, 4.4% re-clean rate (industry benchmark ~3-5%), avg 9.2 rooms/attendant/day. Anomaly: Room 308 had re-clean issues on two separate days — possible recurring maintenance issue rather than staff error."

2. Staff breakdown: Jose = Strong week. Room 308 pattern flagged. Etc.

3. Coaching note: "For the Room 308 re-cleans — before coaching the attendant, check if maintenance has addressed the underlying bathroom issue. If so, coach on thoroughness. If not, escalate to maintenance."

4. GM report: Professional 250-word weekly update ready to email.

5. Team message: "Great work this week team — 412 rooms, strong scores. Special shoutout to Jose for a perfect week. Next week is holiday weekend — let's bring our best."

Total time: 5 minutes in ChatGPT + 10 minutes reviewing and adjusting = 15 minutes vs. 90+ minutes writing manually.

What to Do When It Breaks

• Step 2 produces vague results → Go back to Step 1 and add more specific data (exact rooms per day per person, not just weekly totals)
• The GM report is too long → Add "Keep it under 200 words" to Step 4
• Staff names feel too exposed → Use initials (J.R., M.L.) instead of full names in your data input
• ChatGPT loses context halfway through → If the conversation gets very long, you may need to re-paste the Step 1 summary at the start of Step 4 as a reminder

Variations

• Simpler version: Just run Steps 1 and 4 — data summary and GM report. Two steps, still a huge time saver.
• Extended version: Add a Step 6 that formats the coaching notes as an email draft for each person who needs follow-up.

What to Do Next

• This week: Run Steps 1 and 4 only with last week's data — prove it works before building the full chain habit
• This month: Run all 5 steps for two full weeks, then evaluate whether the team recognition message actually impacts morale
• Advanced: Connect to Google Sheets (using the technique from the Level 2 guide) so your weekly data automatically populates — eliminate the manual data-entry step entirely

Advanced guide for Housekeeping Supervisor professionals. These techniques use more sophisticated AI features that may require paid subscriptions.