LeadSquared Data Access – Summary(Clone DB)

LeadSquared Data Access – Summary(Clone DB)

  • LeadSquared provides read-only views and tables for analytics.

  • Lead and Activity data are in Prospect_Base, ProspectActivity_Base, and their extension tables (joined by ProspectId / ProspectActivityId).

  • Other lead tables exist but are not needed for analytics.

  • Recommended approach: create a data pipeline, pull incremental data, and load it into your data warehouse.

  • User_Base is not allowed in CloneDB. This is the expected behavior. User tables can not be accessed due to sensitive data.


    • Related Articles

    • Lead Activity Summary | Data retrieval concern | User reports

      Issue reported: A user who is the manager of a particular sales group is expecting to receive all lead data of his/her sales group members as per the report subscription. The user has subscribed to the "Lead Activity Summary" user report. Report ...

    • Data fetch issue | Activity based reports

      Issue reported: The "Activities by User (Historical)" report does not fetch the complete data of all the activities selected using the "Activity Type(s)" dropdown. Solution/ Findings: This is the default behaviour of the system wherein: 1. If there ...

    • Unable to open Leadsquared mobile application on MAC/iOS

      Issue: When trying to open the Leadsquared mobile application in MAC/iOS, the user may encounter an error: "Device not supported" Root Cause: The error is seen if the user's device has been manipulated/rooted for unknown reasons. Since this is a ...

    • Support Access User – Starred Leads Restriction

      Support Access User – Starred Leads Restriction Support Access Users in LeadSquared are restricted from marking leads as starred and cannot view the ‘Starred Leads’ list under the Lists section. This restriction is enforced across all UI versions ...

    • How to reset Leadsquared Password

      You can set the password by following the below steps Go to the login page https://login.leadsquared.com/ Click on the "Forgot Password" and enter your Leadsquared login id. You will receive a reset email link in your email inbox or spam folder. ...