Skip to main content

Report Export

The Report Export API allows you to fetch structured reporting data from ShowMojo in either JSON or CSV format. Reports are available by name and can be exported via authenticated POST requests.

Named Reports​

Use the following report names when calling endpoints:

Report Display NameEndpoint Report NameNotes
Detailed Listing Datadetailed_listing_data
Detailed Prospect Datadetailed_prospect_dataDate range limited to 1 week
Digital Accessdigital_access
High-Level Metricshigh_level_metrics
Listing and Showing Metricslisting_and_showing_metrics
Prospect Showing Dataprospect_showing_data
Listing Performancelisting_performanceDoes not support date filtering
Resident Informationresident_information

For custom reports, use the special endpoints listed below.

Response format​

  • JSON endpoints return { "response": { "status": "success", "data": [ ... ] } }. data holds one object per row, keyed by the column names below. high_level_metrics is the exception: each row is a two-element array, ["<metric>", <value>].
  • CSV endpoints return the same rows as text/csv. The header row holds the column names in sentence case, so listing_uid becomes Listing uid. Columns whose name already contains spaces are used as they are.
  • Errors return { "response": { "status": "error", "errors": "<message>" } } with a 4xx status. An invalid or revoked token returns 401 with an empty body.

Columns by report​

Some columns appear only when a feature is enabled on the account; those are listed under Also.

detailed_listing_data​

address, unit, city, state, zip, rent, bedrooms, full_bathrooms, partial_bathrooms, square_feet, access_device, market_status, last_on_market, days_on_market, short_url, imported_from, team_members, listing_code, listing_uid

Also: account_name first, for master accounts; listing_type and property_name; appfolio_id; renters_warehouse_id.

detailed_prospect_data​

created_at, name, email, phone, showtime, address, unit, listing_uid, showing_was_scheduled, showing_method, no_show, current_status, canceled_by, lead_source, referrer_url, source_email_autoreply, source_showmojo_phone, team_member, notes, comments, showing_uid, listing_code

Also: account_name first, for master accounts; listing_type and property_name; calendar_name; document_request_outcomes and documents_submitted.

digital_access​

Serial number, Access date, Access code, Listing, Pulled by, Pulled for, Distributed by ShowMojo

Accounts on MojoLock digital access get Serial number, Access date, Access code, Device Name instead.

high_level_metrics​

One [metric, value] row per metric: Total incoming phone calls, Total incoming text inquiries, Total incoming email inquiries, Total inquiries from the web, Total new leads, Total new showings, Total prospect-confirmed showings, Total no-shows avoided with auto-cancel, Total feedback surveys completed, Total prospects notified about new on-market listings, Total prospects notified about rent reductions, Total showings auto-canceled due to off-market listings. The CSV header is Metrics,Result.

listing_and_showing_metrics​

listing_address_and_unit, listing_uid, timestamp, entry_type, referrer, listing_code

Also: account_name first, for master accounts.

prospect_showing_data​

name, showtime, showing_address_and_unit, listing_uid, phone, email, status, no_show, listing_code

Also: account_name first, for master accounts.

listing_performance​

Listing address, Actual showings, Scheduled showings, Leads, Market time, Showing agent, Feedback count, Boost, Attendance score, Presentability score, Rent score, Showing score, Will apply score, Listing code

resident_information​

listing, first_name, last_name, cell_phone, email, lease_start, lease_end, resident_access