Visits
Shows recent visit activity, such as website or portal visits tracked through Zoho CRM integrations.
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the visit. |
| PageVisited | String | The title or name of the page that was visited. |
| VisitedBy_Id | String | The unique Id of the visitor who accessed the page. |
| VisitedBy_FirstName | String | The first name of the visitor. |
| VisitedBy_LastName | String | The last name of the visitor. |
| IPAddress | String | The IP address from which the page was accessed. |
| TimeSpent(Minutes) | String | The amount of time, in minutes, that the visitor spent on the page. |
| Referrer | String | The referring page or source from which the visitor came. |
| VisitedPageURL | String | The full URL of the page that was visited. |
| CreatedBy_Id | String | The Id of the system object that created the visit entry. |
| ModifiedBy_Id | String | The Id of the system object that last modified the visit entry. |
| ModifiedBy_FirstName | String | The first name of the entity that modified the visit entry. |
| ModifiedBy_LastName | String | The last name of the entity that modified the visit entry. |
| CreatedTime | Datetime | The date and time when the visit record was created. |
| ModifiedTime | Datetime | The date and time when the visit record was last modified. |
| AttendedBy | String | The person or representative who attended to the visit. |
| UserDetails | String | Information about the user involved in the visit. |
| Browser | String | The web browser used during the visit. |
| TimeVisited | Datetime | The date and time the visit occurred. |
| VisitorType | String | The classification of the visitor, such as new or returning. |
| Revenue | Decimal | The amount of revenue attributed to the visit, if any. |
| NumberofPages | Int | The total number of pages viewed during the visit. |
| PortalName | String | The name of the portal through which the visit was made. |
| SearchKeyword | String | The keyword entered by the visitor in a search engine prior to the visit. |
| SearchEngine | String | The search engine used by the visitor. |
| OperatingSystem | String | The operating system of the visitor's device. |
| Gclid | String | The Google Click Identifier used for tracking advertising campaigns. |
| Keyword | String | The keyword associated with the visit for search or advertising tracking. |
| ClickType | String | The type of click action recorded during the visit. |
| Devicetype | String | The type of device used for the visit, such as desktop, tablet, or mobile. |
| AdNetwork | String | The advertising network through which the ad was served. |
| SearchPartnerNetwork | String | The search partner network associated with the visit. |
| AdCampaignName | String | The name of the advertising campaign that generated the visit. |
| AdGroupName | String | The name of the ad group associated with the visit. |
| Ad | String | The specific advertisement that was clicked to initiate the visit. |
| AdClickDate | Date | The date on which the advertisement was clicked by the visitor. |
| VisitSource | String | The origin or source that led to the visit, such as direct, referral, or ad. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String | The fields used to check for duplicate records when performing an upsert. The REST API allows multiple fields, while the BULK API allows only one. |
| CustomViewId | Long | The custom view Id used to filter this record. Applies only when the useCOQL parameter is set to false. |