Skip to main content
SmartRecruiters

SmartCRM: Report Builder Fields

 

Here's a list of all fields that are available as columns in the Report Builder to SmartCRM customers. Each section lists the fields available to each entity. 

Community

Field name Type Description
Community ID ID Unique identifier of the community.
Community Name Text Name of the community.
Community Creation Date Date Date when the community was created.
Community Status Text Status of the community.
Brand org field value Text Value of the default Brands Org field.
Country org field value Text Value of the default Country Org field.
Department org field value Text Value of the default Department Org field.
Sourcers Text An aggregated list of Sourcers by name on the sourcing team of a community.
Participants Text An aggregated list of Participants by name on the sourcing team of a community.
Community Creator ID ID Unique identifier of the community creator.
Community Creator First and Last Name Text First and last name of the community creator.
Community Creator Email Text The email address of the community creator.
Community Status Last Change Date Date Date when the community's status was last updated.
Community Status: CLOSED Date Date Date when the community was last moved to CLOSED.
Community Status: OPEN Date Date Date when the community was last moved to OPEN.

Community Application

By community application, we refer to all the prospect information related to a specific community they are part of.

Field name Type Description
Community Application ID ID Unique identifier of community application.
Community Application Status Text The current state of the community application.
Community application last update date Date Date when the application was last updated
Community Application URL Text URL link to the community application.
Community Application Creation Date Date Date when community application was created.
Campaign subscription status Boolean Boolean value, set to FALSE if the community application has unsubscribed from campaigns, set to TRUE otherwise.
Community application state: Added Date Date Date when community application was last moved to Added.
Community application state: Contacted Date Date Date when community application was last moved to Contacted.
Community application state: Responded Date Date Date when community application was last moved to Responded.
Community application state: Interested Date Date Date when community application was last moved to Interested.
Community application state: Not Interested Date Date Date when community application was last moved to Not Interested.
Community application state: Not Selected Date Date Date when community application was last moved to Not Selected.
Community application state: Transferred Date Date Date when community application was last moved to Transferred.
Time in community application state: Added Number Total number days a community application was in state: Added.
Time in community application state: Contacted Number Total number days a community application was in state: Contacted.
Time in community application state: Responded Number Total number days a community application was in state: Responded.
Time in community application state: Interested Number Total number days a community application was in state: Interested.
Reason of Not Interested Status Text Selected reason of Not Interested status of the community application.
Reason of Not Selected Status Text Selected reason of Not Selected status of the community application.
 
Community application removal date Date Date when community application was removed and status changed to Transferred.
Community application status before NOT_INTERESTED Date The status of the application before it was NOT_INTERESTED.
Community application status before NOT_SELECTED Date The status of the application before it was NOT_SELECTED.
Is Community Application Deleted? Boolean Boolean value set, to TRUE if the community application has been deleted, FALSE otherwise.
Community Application Deletion Reason Text The origin of the community application deletion.

Community Application Source

Field name Type Description
Community Application Source Text Source of the community application.
Community Application Source Type Text Source type of the community application.
Community Application Source Subtype Text Source sub-type of the community application.
Is Custom Community Application Source Boolean Boolean value set to TRUE if the source is custom, or FALSE if it is a default souce.
Community Application Source Referrer ID ID Unique identifier of the referrer.
Community Application Source Referrer Email Text Email of the referrer.
Community Application Source Referrer First and Last Name Text First and last name of the referrer.

Campaign

Field name Type Description
Campaign ID ID Unique identifier for the campaign.
Campaign Name Text Name of the campaign.
Campaign Creation Date Date Date when campaign was created.
Campaign Status Text Current state of the campaign.
Campaign Language Text Language selected for the campaign.
Campaign Status Change Date Date Date when campaign's status was last changed.
Campaign status: Draft Date Date when campaign status was last changed to Draft.
Campaign status: Scheduled Date Date when campaign status was last changed to Scheduled.
Campaign status: Launched Date Date when campaign status was last changed to Launched.
Campaign status: Ended Date Date when campaign status was last changed to Ended.
Campaign status: Cancelled Date Date when campaign status was last changed to Cancelled.

Campaign Message

Field name Type Description
Campaign Message ID ID Unique identifier for the campaign message.
Campaign Message Name Text Name of the campaign message.
Campaign Message Creation Date Date Date when campaign message was created.
Campaign Message Style Text Message style: Branded vs Simple.

Campaign Message Email

Data fields of the Campaign Message Email entity are available only if Campaign or Campaign Message is selected as the reporting area.

Field name Type Description
Total Sent Number Total number of sent email messages.
Total Delivered Number Total number of delivered email messages.
Total Opened Number Total number of opened email messages.
Total Clicked Number Total number of clicked email messages.
Total Replied Number Total number of replied email messages.
Total Bounced Number Total number of bounced email messages.
Total Marked As Spam Number Total number of email messages that were marked as spam.

 Community Application Screening Question Answer

Field name Type Description
Community Application Screening Question ID ID Unique identifier of the community screening question.
Community Application Screening Question Title Text Short title of the community application screening question.
Community Application Screening Question Text Text Long text of the community application screening question.
Community Application Screening Question Answer Text Answer to the community application screening question.
Community Application Screening question Answer: [Question Name] Text Community Application Answer to the screening question.
Is Community Application Screening Question Answered: [Question Name] Boolean Boolean value set to TRUE if the community application screening question has been answered, set to FALSE otherwise.