Power BI Connector for Zoho CRM

Build 25.0.9454

Visits

Shows recent visit activity, such as website visits tracked via Zoho CRM's SalesIQ integration.

Columns

Name Type Description
Id [KEY] String A unique identifier (Id) for the visit.
PageVisited String The name of the page that was visited.
VisitedBy_Id String The Id of the visitor who made the visit.
VisitedBy_FirstName String The first name of the visitor who made the visit.
VisitedBy_LastName String The last name of the visitor who made the visit.
IPAddress String The IP address from which the visit originated.
TimeSpent(Minutes) String The total time spent on the visit, measured in minutes.
Referrer String The URL of the website that referred the visitor.
VisitedPageURL String The URL of the page that was visited.
CreatedBy_Id String The Id of the user or system that recorded the visit.
ModifiedBy_Id String The Id of the user or system that last modified the visit record.
ModifiedBy_FirstName String The first name of the user who last modified the visit record.
ModifiedBy_LastName String The last name of the user who last modified the visit record.
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 name of the user who attended the visit.
UserDetails String Details about the user associated with the visit.
Browser String The browser used during the visit.
TimeVisited Datetime The date and time when the visit occurred.
VisitorType String The type of visitor, such as new or returning.
Revenue Decimal The revenue generated from this visit.
NumberofPages Int The total number of pages visited during the session.
PortalName String The name of the portal through which the visit was made.
SearchKeyword String The search keyword that led to the visit.
SearchEngine String The search engine used to find the visited page.
OperatingSystem String The operating system used by the visitor.
Gclid String The Google Click Identifier (GCLID) associated with the visit.
Keyword String The keyword used in the search that resulted in the visit.
ClickType String The type of click that initiated the visit.
Devicetype String The type of device used by the visitor.
AdNetwork String The ad network that served the advertisement.
SearchPartnerNetwork String The search partner network involved in the visit.
AdCampaignName String The name of the advertising campaign.
AdGroupName String The name of the advertising group.
Ad String The specific advertisement clicked on for the visit.
AdClickDate Date The date when the advertisement was clicked.
VisitSource String The source of the visit, such as direct, organic, or paid.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
DuplicateCheckFields String The field or fields used to identify duplicate records during an upsert operation.
CustomViewId Long The custom view Id used to filter this record. Works only when the useCOQL parameter is set to false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454