Property Tour Request Logs
This dataset logs detailed records of property tour requests, capturing buyer and agent information, property details, request and assignment timestamps, and tour outcomes. It enables real estate teams to optimize agent assignments, monitor buyer engagement, and analyze the effectiveness of property tours for improved sales and operational efficiency.
Sample rows
preview · 8 of 60 rows · all 24 columns| tour_request_idstring | lead_sourcestring | property_statestring | property_idstring | property_street_addressstring | property_citystring | property_postal_codestring | property_countrystring | request_datetimedatetime | requested_tour_datetimedatetime | buyer_idstring | buyer_first_namestring | buyer_last_namestring | buyer_emailstring | buyer_phonestring | agent_idstring | agent_first_namestring | agent_last_namestring | agent_emailstring | assignment_datetimedatetime | tour_statusstring | tour_completion_datetimedatetime | cancellation_reasonstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRQ20240601001 | website | CO | PROP3001 | 123 Maple Ave | Denver | 80209 | USA | 2024-06-01T09:13:00 | 2024-06-03T14:00:00 | BUY1001 | Emily | Nguyen | emily.nguyen@ | 720-555-1283 | AGT5005 | Troy | Bennett | troy.bennett@ | 2024-06-01T10:00:00 | scheduled | blank | blank | Buyer prefers late afternoon slots. |
| TRQ20240601002 | mobile app | CO | PROP3002 | 3412 Spruce St | Aurora | 80012 | USA | 2024-06-01T10:34:00 | 2024-06-04T11:45:00 | BUY1002 | Carlos | Mendez | carlos.mendez@ | 303-555-1632 | AGT5002 | Sarah | Fletcher | sarah.fletcher@ | 2024-06-01T11:10:00 | scheduled | blank | blank | Requested to tour with partner. |
| TRQ20240601003 | referral | CO | PROP3003 | 2180 Oak Lane | Boulder | 80302 | USA | 2024-06-01T11:20:00 | 2024-06-07T16:00:00 | BUY1003 | Priya | Patel | priya.patel@ | 720-555-3411 | AGT5005 | Troy | Bennett | troy.bennett@ | 2024-06-01T12:00:00 | completed | 2024-06-07T16:45:00 | blank | blank |
| TRQ20240601004 | third-party portal | CO | PROP3001 | 123 Maple Ave | Denver | 80209 | USA | 2024-06-01T12:45:00 | 2024-06-05T15:30:00 | BUY1004 | Lucas | Martinez | l.martinez@ | 720-555-7777 | blank | blank | blank | blank | blank | requested | blank | blank | First-time homebuyer. |
| TRQ20240601005 | website | CO | PROP3004 | 456 Pine St | Fort Collins | 80524 | USA | 2024-06-01T13:00:00 | 2024-06-09T10:00:00 | BUY1005 | Mia | Kim | miakim@ | 970-555-3456 | AGT5003 | Morgan | Reed | morgan.reed@ | 2024-06-01T13:25:00 | scheduled | blank | blank | blank |
| TRQ20240601006 | referral | CO | PROP3005 | 890 Willow Rd | Littleton | 80120 | USA | 2024-06-01T13:42:00 | 2024-06-10T13:30:00 | BUY1006 | David | Hernandez | dhernandez@ | 303-555-9988 | blank | blank | blank | blank | blank | requested | blank | blank | Prefers homes with large backyards. |
| TRQ20240601007 | mobile app | CO | PROP3002 | 3412 Spruce St | Aurora | 80012 | USA | 2024-06-01T14:11:00 | 2024-06-06T09:30:00 | BUY1007 | Sophia | King | sophia.king@ | 720-555-4444 | AGT5002 | Sarah | Fletcher | sarah.fletcher@ | 2024-06-01T14:45:00 | completed | 2024-06-06T10:05:00 | blank | blank |
| TRQ20240601008 | third-party portal | CO | PROP3006 | 1777 Birch Dr | Greeley | 80631 | USA | 2024-06-01T15:00:00 | 2024-06-12T12:30:00 | BUY1008 | Alex | Johnson | alex.johnson@ | 970-555-1122 | blank | blank | blank | blank | blank | requested | blank | blank | blank |
| TRQ20240601009 | website | CO | PROP3003 | 2180 Oak Lane | Boulder | 80302 | USA | 2024-06-01T15:30:00 | 2024-06-13T10:15:00 | BUY1009 | Ava | Williams | ava.williams@ | 720-555-6666 | AGT5001 | Jessica | Anderson | jessica.anderson@ | 2024-06-01T16:00:00 | scheduled | blank | blank | Interested in solar panels. |
| TRQ20240601010 | referral | CO | PROP3004 | 456 Pine St | Fort Collins | 80524 | USA | 2024-06-01T16:18:00 | 2024-06-14T17:00:00 | BUY1010 | Ethan | Smith | ethan.smith@ | blank | AGT5003 | Morgan | Reed | morgan.reed@ | 2024-06-01T16:55:00 | completed | 2024-06-14T17:45:00 | blank | Buyer prefers evening tours. |
| TRQ20240601011 | mobile app | CO | PROP3005 | 890 Willow Rd | Littleton | 80120 | USA | 2024-06-01T17:12:00 | 2024-06-16T13:00:00 | BUY1011 | Mohamed | Ali | m.ali@ | 303-555-5555 | blank | blank | blank | blank | blank | requested | blank | blank | Has a tight schedule. |
| TRQ20240601012 | website | CO | PROP3006 | 1777 Birch Dr | Greeley | 80631 | USA | 2024-06-01T18:00:00 | 2024-06-17T09:30:00 | BUY1012 | Isabella | Garcia | isabella.garcia@ | 970-555-1313 | AGT5004 | Daniel | Harris | daniel.harris@ | 2024-06-01T18:30:00 | scheduled | blank | blank | Interested in new builds. |
| TRQ20240601013 | referral | CO | PROP3007 | 1020 Cedar Ct | Loveland | 80538 | USA | 2024-06-01T18:45:00 | 2024-06-20T12:00:00 | BUY1013 | Liam | Lee | liamlee@ | 970-555-8884 | AGT5006 | Ashley | Nguyen | ashley.nguyen@ | 2024-06-01T19:00:00 | no-show | blank | blank | No response after confirmation. |
| TRQ20240601014 | website | CO | PROP3001 | 123 Maple Ave | Denver | 80209 | USA | 2024-06-01T19:30:00 | 2024-06-21T15:00:00 | BUY1014 | Chloe | Stewart | chloe.stewart@ | 720-555-3322 | blank | blank | blank | blank | blank | requested | blank | blank | Requesting virtual tour option. |
| TRQ20240601015 | third-party portal | CO | PROP3008 | 501 Cherry St | Lakewood | 80226 | USA | 2024-06-01T20:10:00 | 2024-06-23T10:30:00 | BUY1015 | Noah | Miller | noah.miller@ | 720-555-1199 | AGT5001 | Jessica | Anderson | jessica.anderson@ | 2024-06-01T20:30:00 | canceled | blank | Buyer unavailable due to travel. | Reschedule requested. |
| TRQ20240601016 | mobile app | CO | PROP3009 | 15 Aspen Way | Longmont | 80501 | USA | 2024-06-02T09:12:00 | 2024-06-24T14:00:00 | BUY1016 | James | Chen | james.chen@ | blank | AGT5004 | Daniel | Harris | daniel.harris@ | 2024-06-02T09:30:00 | scheduled | blank | blank | blank |
| TRQ20240601017 | website | CO | PROP3010 | 102 Golden Gate Dr | Arvada | 80004 | USA | 2024-06-02T10:41:00 | 2024-06-25T11:00:00 | BUY1017 | Benjamin | Moore | benjamin.moore@ | 720-555-2121 | blank | blank | blank | blank | blank | requested | blank | blank | Interested in open house schedule. |
| TRQ20240601018 | referral | CO | PROP3007 | 1020 Cedar Ct | Loveland | 80538 | USA | 2024-06-02T11:10:00 | 2024-06-26T13:30:00 | BUY1018 | Ella | Thompson | ella.thompson@ | 970-555-7766 | AGT5006 | Ashley | Nguyen | ashley.nguyen@ | 2024-06-02T12:00:00 | completed | 2024-06-26T14:20:00 | blank | Has small children, prefers safe neighborhoods. |
| TRQ20240601019 | website | CO | PROP3008 | 501 Cherry St | Lakewood | 80226 | USA | 2024-06-02T12:33:00 | 2024-06-27T16:00:00 | BUY1019 | Grace | Baker | gbaker@ | 720-555-9988 | AGT5001 | Jessica | Anderson | jessica.anderson@ | 2024-06-02T13:10:00 | scheduled | blank | blank | Looking for investment property. |
| TRQ20240601020 | third-party portal | CO | PROP3009 | 15 Aspen Way | Longmont | 80501 | USA | 2024-06-02T13:15:00 | 2024-06-28T15:00:00 | BUY1020 | Sebastian | Murphy | sebastian.murphy@ | 720-555-6543 | blank | blank | blank | blank | blank | requested | blank | blank | Requesting info on HOA fees. |
What the 60 rows show
from the 60-row sample- string 20
- datetime 4
Columns
24 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
tour_request_id | string | Unique identifier for each property tour requestunique | TRQ20240601001 |
property_id | string | Unique identifier for the property being toured | PROP3001 |
property_street_address | string | Street address of the property | 123 Maple Ave |
property_city | string | City where the property is located | Denver |
property_state | string | State or province where the property is located | CO |
property_postal_code | string | Postal or ZIP code of the property | 80209 |
property_country | string | Country where the property is located | USA |
buyer_id | string | Unique identifier for the potential buyer requesting the tour | BUY1001 |
buyer_first_name | string | First name of the potential buyer | Emily |
buyer_last_name | string | Last name of the potential buyer | Nguyen |
buyer_email | string | Email address of the potential buyer | emily.nguyen@ |
buyer_phone | string | Phone number of the potential buyeroptional | 720-555-1283 |
agent_id | string | Unique identifier for the assigned real estate agentoptional | AGT5005 |
agent_first_name | string | First name of the assigned agentoptional | Troy |
agent_last_name | string | Last name of the assigned agentoptional | Bennett |
agent_email | string | Email address of the assigned agentoptional | evan.ramos@ |
tour_status | string | Current status of the tour request (e.g., requested, scheduled, completed, canceled, no-show)requested · scheduled · completed · canceled · no-show | scheduled |
cancellation_reason | string | Reason for cancellation if the tour was canceledoptional | Buyer unavailable due to … |
notes | string | Additional notes or comments related to the tour requestoptional | First-time homebuyer. |
lead_source | string | Source from which the tour request originated (e.g., website, mobile app, referral, third-party portal)4 sources · optional | website |
| Dates and times 4 columns | |||
request_datetime | datetime | Date and time when the tour request was submitted | 2024-06-01T09:13:00 |
requested_tour_datetime | datetime | Preferred date and time for the property tour as requested by the potential buyer | 2024-06-03T14:00:00 |
assignment_datetime | datetime | Date and time when the agent was assigned to the tour requestoptional | 2024-06-01T10:00:00 |
tour_completion_datetime | datetime | Date and time when the tour was completed (if applicable)optional | 2024-06-07T16:45:00 |
Use it for
A real estate dashboard
A breakdown of property_
state. Excel, Power BI or Tableau. What pattern can you find in 60 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 60 rows.
- Tour requests60TRQ20240601001websiteTRQ20240601002mobile a…TRQ20240601003referral
A software demo
Believable tour requests with property_
id, property_ street_ address and property_ city to fill a screen in front of a buyer.
blueprint · property-tour-request-logs
Behind this dataset
Same schema. As many rows as you need.
These 60 rows came out of a blueprint — 24 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Log each tour request per property
- Record customer and agent details
- Timestamp requests and scheduled tours
- Flag same-day requests
- Exclude cancelled tours from analysis
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- property-tour-request-logs