Visits
Returns recent visit activity data, such as website visits or CRM record access logs.
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the visit record. |
| PageVisited | String | Name of the web page that was visited. |
| VisitedBy_Id | String | Unique identifier of the visitor. |
| VisitedBy_FirstName | String | First name of the visitor. |
| VisitedBy_LastName | String | Last name of the visitor. |
| IPAddress | String | IP address from which the visit originated. |
| TimeSpent(Minutes) | String | Duration of the visit in minutes. |
| Referrer | String | URL or domain that referred the visitor to the site. |
| VisitedPageURL | String | URL of the specific page that was visited. |
| CreatedBy_Id | String | Identifier of the user or system that created the visit record. |
| ModifiedBy_Id | String | Identifier of the user or system that last modified the visit record. |
| ModifiedBy_FirstName | String | First name of the user or system that last modified the visit. |
| ModifiedBy_LastName | String | Last name of the user or system that last modified the visit. |
| CreatedTime | Datetime | Date and time when the visit record was created. |
| ModifiedTime | Datetime | Date and time when the visit record was last modified. |
| AttendedBy | String | User who attended or responded to the visit. |
| UserDetails | String | Details about the user associated with the visit. |
| Browser | String | Browser used during the visit. |
| TimeVisited | Datetime | Exact date and time when the visit occurred. |
| VisitorType | String | Category of visitor, such as new or returning. |
| Revenue | Decimal | Revenue amount attributed to this visit. |
| NumberofPages | Int | Number of pages viewed during the visit. |
| PortalName | String | Name of the portal used during the visit. |
| SearchKeyword | String | Keyword entered by the visitor in a search engine. |
| SearchEngine | String | Name of the search engine used before the visit. |
| OperatingSystem | String | Operating system of the visitor's device. |
| Gclid | String | Google Click Identifier associated with the visit. |
| Keyword | String | Search or campaign keyword associated with the visit. |
| ClickType | String | Type of ad click that led to the visit. |
| Devicetype | String | Type of device used during the visit, such as mobile or desktop. |
| AdNetwork | String | Advertising network associated with the visit. |
| SearchPartnerNetwork | String | Search partner network responsible for the visit. |
| AdCampaignName | String | Name of the advertising campaign linked to the visit. |
| AdGroupName | String | Name of the ad group responsible for the visit. |
| Ad | String | Specific ad that led to the visit. |
| AdClickDate | Date | Date and time when the ad was clicked. |
| VisitSource | String | Source channel that brought the visitor, such as direct, organic, or paid. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String | Fields used to identify duplicate records during upsert. Only one field is allowed for bulk upserts. |
| CustomViewId | Long | Identifier for a custom view used to filter the record. Applies when the useCOQL parameter is set to false. |