SmartCRM: Report Builder Fields

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.