You are here:
Fields Available on Salesforce Knowledge Reports
The fields you can use in a knowledge report depend on the type of information you are reporting on.
Required Editions
| User Permissions Needed | |
|---|---|
| To create or update custom report types: | Manage Custom Report Types |
| To create a public reports folder: | Manage Public Reports |
Important Where possible, we changed noninclusive terms to align with our
company value of Equality. We maintained certain terms to avoid any effect on customer
implementations.
The following tables list the available fields by primary object for Salesforce Knowledge reports.
Fields Available on Article types (Knowledge in Salesforce Classic) Reports
The Article Type primary object allows you to add a secondary object of the article type version.
| Field | Description |
|---|---|
| Archived By | User who archived the article. |
| Archived Date | Date the article was archived. |
| Article Number | Unique number automatically assigned to the article. |
| Article Type ID | The ID associated with the article type. |
| Case Association Count | Number of cases attached to the article. |
| Created By | User who created the article. |
| Created Date | Date the current article version was created. If the article has been published more than one time, Created Date is the latest draft date. To create reports that use the original article creation date, first create a Custom Report Type that joins the Knowledge Article (__ka) and Knowledge Article Version (__kav) objects for a given article type to allow for use of the created date on the record in the Knowledge Article object, rather than the one for the Knowledge Article Version record. |
| Custom fields | Any custom fields created on the article types. Add the article type's version as a secondary object to access any custom fields for the article type. |
| First Published Date | Date the article was originally published. |
| Knowledge Article Version | The article's version number. |
| Last Modified By | User who changed the article most recently. |
| Last Modified Date | Date the article was last changed. The last modified date of a draft article is the time the draft was saved. The last modified date of a published article is time the article was most recently published. |
| Last Published Date | Date the article was last published. |
| Next Review Date | The date when the article must next be reviewed for accuracy. |
| Primary Language | The original language of the article. |
Note Currently you can’t use Knowledge Article Version and
Last Modified Date in the same report.
| Field | Description |
|---|---|
| Archived By | User who archived the article. |
| Article Type | The article type associated with the article. |
| Created By | User who created the article. |
| Created Date | Date the current article version was created. If the article has been published more than one time, Created Date is the latest draft date. To create reports that use the original article creation date, first create a Custom Report Type that joins the Knowledge Article (__ka) and Knowledge Article Version (__kav) objects for a given article type to allow for use of the created date on the record in the Knowledge Article object, rather than the one for the Knowledge Article Version record. |
| Custom fields | Any custom fields created on the article types. Add the article type's version as a secondary object to access any custom fields for the article type. File fields aren't supported for reports and report types with Knowledge. |
| Is Latest Version | Indicates if the article is the most recent version. |
| Is Primary Language | Indicates that the article is not a translation, but the original article. |
| Knowledge Article Version ID | Unique ID automatically assigned to the article translation. |
| Language | The article's language. |
| Last Modified By | User who changed the article most recently. |
| Last Modified Date | Date the article was last changed. The last modified date of a draft article is the time the draft was saved. The last modified date of a published article is time the article was most recently published. |
| Out of Date | Indicates that the primary article has been updated since this translation was published. |
| Publication Status | Indicates whether the article or translation is in progress (draft), published, or archived. |
| Summary | Description of the article provided by the author. |
| Title | The article's title. |
| Translation Completed Date | Date the translation was completed. |
| Translation Exported Date | Date the article was exported for translation. |
| Translation Imported Date | Date the translation was imported. |
| URL Name | Text used as hyperlink for the article. |
| Validation Status | Indicates if the article is valid or not. |
| Version Number | The version number of the article. |
| Visible in Customer | Indicates that the article is published in the Customer Portal. |
| Visible in Internal App | Indicates that the article is published in the internal app (Articles tab). |
| Visible in Partner | Indicates that the article is published in the partner portal. |
| Visible in Public Knowledge Base | Indicates that the article is published in the public knowledge base. |
Fields Available on Knowledge Articles Reports
Fields Available on Knowledge Article Searches Reports
Fields Available on Knowledge Article Versions Reports
Fields Available on Knowledge Article Views Reports
You can add up to six of these eight fields.
| Field | Description |
|---|---|
| Channel | The channel that’s applicable to the article. Possible values are All Channels, Internal App, Customer, Partner, and Public Knowledge Base. |
| Count | The number of article views applicable to the duration shown (day, month, year). |
| Cumulative Count | The total number of article views for the history of the record. |
| Date | Last date on which an article view took place for the record. All rows represent a date, channel, and role combination. |
| Duration | The time period the search count is applied to. Possible values are Daily, Monthly, and Yearly. For example, a record where the Count is 70 and the Duration is Monthly indicates that 70 searches took place over the past month. Totals are aggregated daily for the current month, monthly from the past full month through the past full year, and yearly beyond that. |
| Related Role | Name of the role that applies to the record. |
| Score | The article's average view rating. Scores take into account a half-life calculation. Every 15 days, if an article has not been viewed its average rating moves up or down. This calculation ensures that over time, older or outdated articles don't maintain artificially high or low ratings compared to newer, more frequently viewed articles. |
| Total Views | Number of times a published article has been viewed. |
Fields Available on Knowledge Article Votes Reports
| Field | Description |
|---|---|
| Channel | The channel that’s applicable to the article. Possible values are All Channels, Internal App, Customer, Partner, and Public Knowledge Base. |
| Count | The number of article votes applicable to the duration shown (day, month, year). |
| Cumulative Count | The total number of article votes for the history of the record. |
| Date | Last date on which an article vote took place for the record. All rows represent a date, channel, and role combination. |
| Duration | The time period the search count is applied to. Possible values are Daily, Monthly, and Yearly. For example, a record where the Count is 70 and the Duration is Monthly indicates that 70 searches took place over the past month. Totals are aggregated daily for the current month, monthly from the past full month through the past full year, and yearly beyond that. |
| Related Role | Name of the role that applies to the record. |
Fields Available on Knowledge Keyword Search Reports
Knowledge Keyword Search reports are designed for use with the Salesforce Knowledge in Salesforce Classic data model. These reports include searches from the Knowledge One widget.
Fields Available on Knowledge Search Activity Reports
| Field | Description |
|---|---|
| Average Click Rank | The order in which the article appeared in search results when results are sorted by relevance and when readers clicked it from the list of results. |
| Channel | The channel that’s applicable to the article. Possible values are All Channels, Internal App, Customer, Partner, and Public Knowledge Base. |
| Clicked Article Title | The title of the clicked article taken when the search results are sorted by relevance by the reader. |
| Duration | The time period the search count is applied to. Possible values are Daily, Monthly, and Yearly. For example, a record where the Count is 70 and the Duration is Monthly indicates that 70 searches took place over the past month. Totals are aggregated daily for the current month, monthly from the past full month through the past full year, and yearly beyond that. Activity totals are collected nightly and aren’t in real time. |
| Language | The language filter that’s applied to the reader’s search. |
| Number of Results | The number of search results that were returned for the search term. If Duration is also included, this value is aggregated based on the time period specified. |
| Number of Searches | The number of searches for the duration that’s shown (day, month, or year). |
| Number of Users | The number of individual users who clicked the article. |
| Search Date | The date of the search. |
| Search Term | The first 100 characters of the search term that was used to search published articles in the knowledge base. |
Did this article solve your issue?
Let us know so we can improve!
