Lead Activities Report

Field Name Data Type Limits Description
Id Integer Max value 2147483627 This is an internal serial number assigned for each activity.
activity_created_at DateTime with zone (eg- 2019-01-08 22:12:05 -0800) N/A Date and time this activity was created, in format of local time of server timezone (PST - 08:00 / PDT - 07:00)
access String/Varchar Max 255 Characters Type of record
Value Description
Controlled_showing renter viewing record created by Visitor Access Code on Manager Portal
self_registered_scheduling renter registered online and indicated that they plan to view the target property
self_registered_viewing actual renter viewing record. a renter may view a property without prior scheduling
callcenter_showing renter viewing facilitated by rently
callcenter_scheduling when call center scheduled a showing
Status when a status field is updated in lead detail page
agent_assign when a lead is assign to an agent
waitlist_alert when a lead receives alert of property back on market
prelease_signup when a lead signs up a prelease property wait list
agent_scheduling when a lead scheduled a showing with agent
agent_viewing when a lead receives a showing with agent
custom_prescreening_ban when a lead banned by prescreening questions
property_apply when a lead applies a property
email when inquiry received from email
failed_viewing when renter not satisfy showing requirements, like phone verification, ID verification or there was issue issuing a code
location_safe_signup when a prospect who has zero location credit and is idology authenticated schedules a future self showing
open_house_scheduling when an open house showing is scheduled
open_house_viewing when an open house showing is happened
callcenter_guest_card when leads created from call center
otv_safe_signup when a prospect who has zero location credit and is not idology authenticated schedules a future self showing
safe_signup when there is a safe mode sign up
voicemail when a prospect calls the properties phone line and leaves a voicemail message
viewing_abandoned When a renter not a match for the property(but still allow to do showing)
self_registered_viewing_abandoned When a renter started viewing but abandoned tour before getting an access code
property_id Integer Max value 2147483627 Rently internal property ID.  Same Id as property export.
Name String/Varchar Max 255 Characters Name that is entered in when prospects are registered
Phone Integer 10 digits Phone number used for registration
Email String/Varchar Max 255 Characters Email that is entered during registration
agent_name String/Varchar Max 255 Characters Agent name is here if this is an agent assigned viewing or scheduling
credit_card 0 0 Is the credit card on file: True or false
lead_id Integer Max value 2147483627 unique ID for lead
lead_created_date DateTime with zone (eg- 2019-01-08 22:12:05 -0800) N/A The date this lead was first entered into Rently system, in format of local time of server timezone (PST - 08:00 / PDT - 07:00)
lead_status String/Varchar Max 255 Characters Status field on lead detail page
account String/Varchar Max 255 Characters Market name. Useful if when you are viewing report for multiple tabs.
source String/Varchar Max 255 Characters The channel that initiated the auto showing. Sources could be PC or smartphone or qrcode
total_viewings Integer Max value 2147483627 Per prospect, how many propertied they have gained access to for this account
address String/Varchar Max 255 Characters address of the property if it is a viewing activity
tag String/Varchar Max 255 Characters Property CRM Tag
rating Integer 0 renter rating on the viewing (1 to 5 points), if a view survey is completed
feedback String/Varchar Max 255 Characters renter feedback on the viewing, if a view survey is completed
pcode String/Varchar Max 255 Characters Property pcode used in Yardi system.
is_viewing Boolean True/False Whether the activity is a visit to a property or not.
account_id String/Varchar Max 255 Characters Account id to which property belongs to.
time_zone String/Varchar Max 255 Characters Time zone of the property
ip_address String/Varchar Max 255 Characters The public IP address of the prospect is granted a viewing code for a self viewing. This field is only populated for "self_registered_viewing" and "failed_viewing" access types
showing_status String/Varchar Max 255 Characters Abandoned (When tour abandoned before access code granted)/Successful (When tour success with granted access code)/Unsuccessful (When tour failed with granted access code)
utm_source String/Varchar Max 255 Characters UTM tracking source