get_guest_card_inquiries_report
Generate a filtered guest card inquiries report to analyze lead activity by properties, sources, statuses, and date range.
Instructions
Returns guest card inquiries report for the given filters. IMPORTANT: All ID parameters (properties_ids, property_groups_ids, portfolios_ids, owners_ids) must be numeric strings (e.g. '123'), NOT names. Use respective directory reports first to lookup IDs by name if needed.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| property_visibility | No | Filter properties by visibility status. Defaults to "active" | active |
| properties | No | Filter results based on properties, groups, portfolios, or owners | |
| guest_card_sources | No | Filter by guest card sources. Defaults to ["all"] | |
| guest_card_statuses | No | Filter by guest card statuses. Defaults to ["all"] | |
| guest_card_lead_types | No | Filter by guest card lead types. Defaults to ["all"] | |
| assigned_user | No | Filter by assigned user. Defaults to "All" | All |
| assigned_user_visibility | No | Filter assigned users by visibility. Defaults to "active" | active |
| guest_card_status | No | Filter by guest card status. Defaults to "open" | open |
| filter_date_range_by | No | Which date field to use for filtering. Defaults to "inquiry" | inquiry |
| received_on_from | Yes | Start date for the reporting period (YYYY-MM-DD). Required. | |
| received_on_to | Yes | End date for the reporting period (YYYY-MM-DD). Required. | |
| columns | No | Array of specific columns to include in the report. Valid columns: name, email_address, phone_number, received, last_activity_date, last_activity_type, latest_interest_date, latest_interest_source, status, move_in_preference, max_rent, bed_bath_preference, pet_preference, monthly_income, credit_score, lead_type, source, property, unit, assigned_user, assigned_user_id, guest_card_id, guest_card_uuid, inquiry_id, occupancy_id, property_id, unit_id, notes, tenant_id, rental_application_id, rental_application_group_id, applicants, inquiry_type, total_interests_received, interests_received_in_range, showings, interest_to_showing_scheduled, showing_to_application_received, application_received_to_decision, application_submission_to_lease_signed, inquiry_to_lease_signed, inactive_reason, crm. If not specified, all columns are returned. |