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. |