Why can I see a sales user under the Modified By column in the Opportunity Settings Page?

Only admins can access the Opportunity Types Configuration page. However there are instances when sales users appear under the Modified By column on the Opportunity settings page –

LeadSquared Opportunity Management

This occurs when the allow auto update setting is enabled for a drop-down field within an Opportunity Type.
With the Allow Auto Update setting enabled, when a sales user enters a new value/option while filling the drop down field (through a form, opportunity import or API call), the opportunity type is modified and the user’s name appears under the Modified By column on the Opportunity Settings page.

LeadSquared Opportunity Management

How to Filter Duplicate Opportunities of an Opportunity Type?

There is no direct way to filter duplicate opportunities of a particular opportunity type through advanced search. However, you can export the opportunities and compare them in the CSV file.

To know more, see Export Opportunities.

Why did the Opportunity Capture API create a Lead but throw an error when creating the Opportunity?

This is the expected behaviour. In the opportunity capture flow, a lead is created first, and then an opportunity is created. So even if opportunity creation fails, a lead is still created.

To know more, see Opportunity Capture API.

Is the Opportunity Origin updated automatically like the Lead Origin Field?

No, the opportunity origin field is not updated automatically. It’s a string field that takes the value sent via the API payload or via CSV import.

For more information, see Opportunity API and Import Opportunities.

Can I update the Created On field of an Opportunity?

Yes. First, reach out to us at support@leadsquared.com to enable this feature. Once enabled, you can use the following API endpoints to updated the Created On opportunity date field –

What is the maximum character length supported for Lead and Activity fields?

The maximum character limit for custom lead fields is 1,000 characters (for ‘Text’ type fields displayed as ‘Text Areas’). However, the Notes system lead field supports 2,000 characters.

For Activity fields of text type, the maximum limit is 200 characters.

For more information, see How to Create a Custom Lead Field and How to Create a Activity Fields.

What are the maximum export limits for Leads, Activities, Opportunities and Tasks?

By default, you can export a maximum of 100,000 (1 lakh) Leads, Activities, Opportunities and Tasks. This limit can be extended to 500,000 (5 lakh). To increase the limit contact us at support@leadsquared.com. Note that increasing this limit may incur additional charges due to the required infrastructure changes.

For more information, see Export your Data From LeadSquared.

What is the maximum number of Leads and Opportunities I can import?

By default, you can import a maximum of 25,000 leads or opportunities at a time. This limit can be increased to 300,000. To increase the limit, contact us at support@leadsquared.com. Note that increasing this limit may incur additional charges due to the required infrastructure changes.

For more information, see How to Import Leads and How to Import Opportunities.

Can I create more than 100 Opportunity or Activity Fields?

No, you cannot create more than 100 Activity or opportunity fields. We suggest creating Custom Field Sets and associating them with Opportunities or Activities if you need more fields.

Setting up Journeys on the Web App

1. Feature Overview

Journeys addresses sales planning and scheduling use cases like Beat Planning or Permanent Journey Planning (PJP) across industries. Sales representatives or teams are often assigned specific geographic areas or customer segments they are responsible for. Beat planning or PJP involves determining the most effective way to cover these areas to maximize sales opportunities. This includes considerations such as the location of potential clients, the density of businesses or customers in a given area, and the travel efficiency of the sales team.

Journeys enables all sales users to create a Plan (Beat Plan, PJP etc.) in just two simple steps by defining the plan duration (i.e. Start Date & End Date) and adding the relevant leads/lead templates. Users can also send plans for approval to their respective managers if required. Once a plan is published or approved, the configured To-Dos will be created against the added leads.

 

2. Prerequisites

 

3. How It Works

Admins must first enable and configure Journeys on the Web application. Once configured, sales users can create plans on the mobile app and submit them for approval to their managers, if required. Once managers approve the plans, they will be reflected on the following pages on the mobile app –

Users can then follow their plans while performing their assigned tasks.

Note: On the web platform, users have access based on their hierarchy. Admin users and Sales managers can view the plans made by all users. Certain sales users also have access to these plans based on their hierarchy. For example, if Sales Users A and B are reporting to Sales User C, C can view the plans of A and B but not anyone else. However, sales users A and B will only be able to view their own plans.

 

4. Journeys Settings

Settings on Journeys can only be configured by Admin users.

  1. From the main menu, navigate to Apps>Journeys and on the bottom left corner of the page, click LeadSquared - journeys settings icon.
  2. On the Settings page, click Journeys.
  3. Configure the following settings and once you’re done, click Confirm.

4.1 General Settings

The look of the map and lead icons on Journeys can be customized. On your LeadSquared Web App, navigate to Apps>Journeys>Settings>General to edit these settings.

  • Map Theme Selection

To customize the Journeys map theme in your LeadSquared Web App, you need to be an Admin, Sales Manager, Sales Group Manager, or Reporting Manager. You can choose from seven pre-designed map color themes, and the selected theme will be applied across all users.

Leadsquared - Journeys Settings

  • Customized Lead Icons

As an admin, you can customize the lead icons displayed in the Journeys feature. Assign distinct shapes and colors to represent different Lead Stages or Lead Lists, making it easy to quickly identify leads within the designated territories of the users.

Leadsquared - Journeys Settings

 

4.2 Journeys Settings

  • Define Default To-Do Task Type

You must first define the default To-Do task type here. Alongside the setting, click the To-Do Task Type dropdown and select the relevant task type. Appointments are not supported as task types on Journeys since they require a specific start and end time which may clash with the other tasks of the day. Once you select a To-Do task type, you can set custom rules and define relevant task types for each lead stage/activity/territory. For example, if Lead A and Lead B are in different lead stages, they will be added to different To-Do task types based on your configuration even if they’re on the same Plan. To set custom rules –

  1. Click Add Custom Rule.
  2. Alongside Primary Lead Field, select the Lead Field you want to add conditions to. Only Mandatory Lead Fields of Dropdown Data Type lead fields will be displayed as options.
  3. Under Conditions, select the relevant value and under To-Do Task Type, select the task type you want to associate with this value.
  4. To add more rules, click Add Custom Rule.
  5. Click Save.
  6. Once you create custom rules-
    1. To delete them, click Delete icon.
    2.  To edit them, click edit.

Note:

  • Plans cannot be published until a To-Do Task type is defined by the Admin.
  • Ensure that the To-Do Task Type chosen here is not restricted for creation under Permission Templates for the Journey users. The task configured here must not be deleted from the platform settings as it may impact the task creation after plan approval.
  • You can add a maximum of 5 custom rules.

LeadSquared - Define Default To-Do Task Type

  • Enable Approvals

In the LeadSquared Web App, by navigating to Apps>Journeys>Settings>Journeys and selecting Templates and Approvals, admins can enable Approvals. If you enable this setting, all the plans created by users will be displayed to their respective managers for approval. Managers can approve or reject these plans. Only the approved plans will be added to the users’ tasks.

Additionally, admins can enable the Auto-Approve Pending Plans setting, which automatically updates plans to Approved status on both the My Plans and My Approvals pages for easy tracking. Auto-approved plans are marked with the “Auto-Approved” status, including the exact date and time of approval. Sales managers and admins can edit these auto-approved plans, with the editor’s name, date, and time of changes clearly displayed in the updated status. Joint Meetings are disabled by default in auto-approved plans to streamline workflow.

Note:

  • Admin users and Sales Managers can approve or reject the plans made by all users. Sales users also have access to these plans based on their hierarchy. For example, if Sales User X is acting as a manager to two other sales users – User Y and User Z, X can approve or reject the plans of users Y and Z, but not anyone else.
  • Approvals is an optional setting.
  • To enable Joint Meetings, you must enable Approvals.
  • Managers can only add leads to a plan if it’s a created using Lead Templates.
  • Changing the user hierarchy after setting up Journeys will result in loss of data.
  • While managers can be allowed to remove leads from plans, they cannot add leads to a plan.
  • Once enabled, Approvals cannot be disabled again.

Leadsquared - Journeys Settings

  • Enable Templates

If you enable this setting, users will be able to create Templates by grouping leads with shared attributes, which can be used to create Plans and Trips. To also allow users to add the same lead to multiple templates, alongside Allow users to add the same lead in more than one template, clickAzure checkbox. Once enabled, Templates cannot be disabled again.

Note: This setting must be enabled to access Lead Templates.
LeadSquared - Enable templates
  • Enable Joint Meetings

When this setting is enabled, users will be able to plan joint meetings with their respective managers/reportees while creating or approving a plan. To define the To-Do Task Type of this joint meeting, click the To-Do Task Type dropdown. Now, select your option.

Note: Approvals must be enabled to use this feature.
LeadSquared - Enable joint meetings

  • Define Quota & Force Minimum Quota

Within the Define Quota settings, administrators can specify the minimum number of leads a sales user must cover in a day. By default, this quota is set to 10 leads per day for all users. This flexible quota can range between 1 to 40 leads daily. Admins have the option to enforce a standard minimum lead requirement across users by enabling the Force Minimum Quota feature. The setting is disabled by default and can only be enabled once a quota is defined. While creating or editing a plan on the LeadSquared Mobile App, users can clearly see the number of leads they have added versus the minimum quota. While submitting a plan, if the users have not met the specified minimum lead quota, the system will block submission and notify the user of the shortcoming. Quotas are managed disregarding days designated as holidays or blocked.

Note: This is an optional setting.
Leadsquared - Minimum Quota Enforcement
Users can view lead chips on planned days to easily track whether their quota is being met. Plans that have met the quota will display a grey lead chip, while plans where the lead quota has not been met will show a red lead chip. The user can add leads appropriately.
Leadsquared - Minimum Quota      Leadsquared - Minimum Quota

  • Day Blocking Configuration

With this setting, you can define and manage a predefined set of reasons that users can select to block their days in a plan, such as for leave, holidays, training or other purposes. You can add a maximum of 10 reasons for day blocking here. You can also associate a To-Do task with the day blocking reason. For example, if you’re blocking a day for a Sales Meeting, you can associate a Sales Meeting task to it. Upon blocking the day, the task will automatically be created against the relevant users. To know more about using this feature, refer to Manage Plans on the Mobile App.

LeadSquared - Day Blocking Configuration

  • Restrict Overlapping Plan Date Ranges

To prevent users from creating plans with date ranges that overlap plans already published, approved, or pending, alongside Restrict Overlapping Plan Date Ranges, click the toggle.

LeadSquared - Restrict overlapping plan dates

4.3 Process Compliance Settings

This feature allows Admins to set a plan submission window, default plan duration and working days for users while creating plans on the LeadSquared Web App. On your LeadSquared Dashboard, navigate to Apps>Journeys>Settings>Journeys to enable these settings.

  • Set Monthly Plan Submission Window – By enabling this setting, the admins can specify a monthly time window during which users can submit their plans. The admins can select the start date and end date from the relevant dropdowns. This will reflect for all users. If this is enabled, any attempt to create a plan outside this window would not be acceptable.
  • Setting Default Plan Duration & Force Duration – Admins can enable Default Plan Duration for users to configure the default number of days in a plan. This can be:
    • Custom –  Selecting a value between 1 to 31 days. For instance, if 10 is entered on March 1st, then the last date of the plan will be March 10th.
    • Current Week – The default End Date would be the upcoming Sunday of the week containing the Start Date. If you select Sunday as the Start Date, the End Date will be the same.
    • Current Month – The default End Date would be the last date of the month. If the selected Start Date is already the month’s last date, it will reflect as both Start and End Date.

When a user logs into the LeadSquared Mobile App and selects a start date, the app automatically displays the end date based on the duration enabled by the admin. The user can change the end date as per their requirement. However, if the Default Plan Duration and Force Duration are enabled, the end date becomes non-editable.

  • Setting Working Days Template – Admins can enable force workday template on the LeadSquared Web App. When a user creates a plan, the app automatically displays the workday template assigned to the user and makes it non-editable. The users can modify the template if the setting is disabled.
Note: This setting is not honored when a user clones or edits a plan, allowing them to make changes to the working days template as needed.
  • Set Lead Frequency Per Plan Admins can set a maximum lead frequency count to restrict how many times the same lead can be added to a lead-based plan from My Plans and My Approvals. Once a lead has been added the maximum number of times allowed (as configured in Journeys Settings), the Add button for that lead will be disabled during the plan creation as well as edit process.
Note: While editing a plan created before the setting was enabled, if a lead has been added more times than the new limit, those entries will be retained. However, the plan cannot be updated until the user manually removes the extra instances to meet the new limit.

Leadsquared - Journeys

4.4 Advanced Settings

On your LeadSquared Web App, navigate to Apps>Journeys>Settings>Advanced.

  • Rename Plans

To rename the Plan entity –

  1. On the Journeys page, click mobile settings icon.
  2. On the left side of the screen, under Settings, select Advanced.
  3. Under Rename Modules, alongside Plans, click edit.
  4. Enter the relevant display name and the plural term for it.
  5. Once you’re done, click Check icon.

LeadSquared - Rename Plans

 

  • User Access Hierarchy

Previously, managers in the higher positions could access all the plans created by all users under them. Now, you can define the hierarchy for accessing Plans, Templates, Trips, Approvals, and Notifications. You can either choose Direct Reporting where you can access only those who directly report to you, or All Accessible Users where you can access all users who are directly or indirectly reporting to you. To toggle between this,

  1. Navigate to Apps>Journeys>Settings>Advanced.
  2. Under User Access Hierarchy, toggle between Direct Reporting or All Accessible Users as required.
  3. Once you make the change, click Confirm on the top-right corner of the page.

Leadsquared - Journeys Settings

 

5. Add Lead Ownership Change Webhook

Create a webhook to update your pre-existing plans and lead templates according to lead ownership changes made on the LeadSquared platform. For example, if user A was assigned 10 leads and someone updates the lead owner of these leads to user B, you can automatically update this information on the platform by creating a webhook.

  1. Navigate to Settings>API and Webhooks>Webhooks and click Create
  2. Enter the following details –
    • Type – Webhook
    • Event – Lead Ownership Change
    • Webhook URL – https://fieldsales-in21.leadsquared.com/api/journey/v1/(EnterOrgId)/lead/owner
      • The orgid included in the URL refers to the organisation ID, which is the same as your LeadSquared Account Number. You can find this ID on the bottom of your screen.
    • Content Type – application/json
    • Execution Delay – 0 Seconds
    • Custom Header Name – Authorization
    • Custom Header Value – 
      • Navigate to Journeys>Settings>Advanced.
      • Alongside Field Sales Token for Automation, click Copy
      • Paste that value under Custom Header Value.
  3. Enter a description for the webhook.
  4. Click Save.

LeadSquared - Lead Owner Change Webhook

 

6. Add Lead Deletion Webhook

Create a webhook to automatically update your pre-existing plans and lead templates when a lead gets deleted on the LeadSquared platform.

  1. Navigate to Settings>API and Webhooks>Webhooks and click Create
  2. Enter the following details –
    • Type – Webhook
    • Event – Lead Delete
    • Webhook URL – https://fieldsales-in21.leadsquared.com/api/journey/v1/(EnterOrgID)/leads?eventType=delete
      • The orgid included in the URL refers to the organisation ID, which is the same as your LeadSquared Account Number. You can find this ID on the bottom of your screen.
    • Content Type – application/json
    • Execution Delay – 0 Seconds
    • Custom Header Name – Authorization
    • Custom Header Value – 
      • Navigate to Journeys>Settings>Advanced.
      • Alongside Field Sales Token for Automation, click Copy
      • Paste that value under Custom Header Value.
  3. Enter a description for the webhook.
  4. Click Save.

LeadSquared - Lead Delete Webhook

 

7. Add Journeys to Mobile App

Once you’re done configuring the Journeys settings, add it to the mobile app’s navigation menu.

  1. On the side panel of the CASA landing page, click Menu builder icon. Then, alongside the menu you want to add Journeys to, click edit.
  2. On the right side of the page, click Side Navigation.
  3. To add Journeys to the mobile app’s navigation bar, under Available Menu Tabs, alongside Journeys, click Add icon.
  4. To rearrange the tabs, drag and drop them in the desired order.
  5. Once you’re done building the menu, click Publish.

LeadSquared - Add Journeys to Mobile Navigation

 

Any Questions?

We’d love to answer your questions or hear your own unique use cases. Feel free to share your experiences in the comments section below.

Manage Plans on Journeys for Web Users

1. Feature Overview

Plans in LeadSquared are structured visit schedules created for sales users to manage their field activities over a specific date range. They help organize which leads a sales user should visit, on which days, and what tasks they need to complete during those visits.

Plans can be created by selecting leads manually or through lead templates (Beats). Admins and Managers approve and reject users’ plans as well as create new plans on the Manage Plans page. Admins can also delete irrelevant plans. Once a plan is published or approved, the configured To-Dos will be created against the added leads. The plan execution can then be tracked by users through My Trips, Tasks, Task Smart Views, etc., on the LeadSquared mobile app.

Note:

  • Only Admins, Sales Managers, Reporting Managers and Sales Group Managers can access Journeys on the Web App. Sales users can access plans on the Mobile App.
  • To know more about Lead Templates, refer to Manage Lead Templates on Web App.

Leadsquared - Journeys

 

2. Prerequisite

 

3. How It Works

Plans help managers organize and monitor field visits for their sales users through a structured workflow:

  • Create a Plan: Admins or managers create plans for users by selecting a date range and adding leads either manually or through lead templates (Beats).
  • Submit or Publish the Plan: The plan can be submitted for approval or published directly (depending on configuration).
  • Review: Admins and managers review submitted plans and either approve or reject them. Rejected plans are sent back to the user for edits.
  • Task Creation: Once a plan is approved or published, the configured To-Dos are automatically created for the assigned leads.
  • Plan Execution: Sales users execute their visits through the LeadSquared mobile app using My Trips, Tasks, and Smart Views.
  • Tracking and Management: Admins and managers can monitor, edit, export, or delete plans from the Manage Plans page when required.

This workflow ensures field visits are planned in advance, properly approved, and easily tracked during execution.

 

4. Create Plans for Users

To create plans for your users –

  1. Navigate to Field Sales Suite>Journeys>Manage Plans.
  2. Click Create. Under Select User, select the user you want to assign this plan to.
  3. Enter the Date Range of the plan and select the relevant working days for the user.
  4. Under Create Plan With, you can choose to create this plan by searching for leads manually or using a pre-existing lead template (Beats). Once you select the relevant option, click Next.

Leadsquared - Journeys

4.1 Create Plans with Lead Templates

  1. Once you land on the Create Template (Beat) Plan page, on the left side, select a Template.
  2. To add the Template to a date on the plan, select the date. On the relevant date, a number denoting the leads already assigned to the user on that particular day (i.e., user’s task load) is displayed. The number mentioned above each date represents the number of tasks assigned. Clicking the number will open a popup with a list view of the tasks.
  3. Repeat this process to add Templates on all the dates added. Any holiday falling within the plan duration will automatically be blocked.
  4. To add a lead to the plan, click the relevant date. Alongside the lead name, click the plus icon.  Once added, you can create a joint meeting for this lead with your user by sliding the Joint Meet toggle. When this setting is enabled, users will be able to plan joint meetings with their respective managers/reportees while creating or approving a plan.
  5. Any holiday falling within the plan duration will automatically be blocked. To delete a plan for the day or add a day block, alongside the date, click Three dots and select the relevant option.
  6. Once you’re done, click Submit for Approval or Publish.

Leadsquared - Journeys

4.2 Create Plans with Leads

  1. On the left side of the page, you can view the dates of the plan. The number mentioned above each date represents the number of tasks assigned. Clicking the number will open a list view of the tasks on the right side of the page.
    On the right side of the page, you can also view all the leads assigned to the selected user.  And you can view the distance between each lead on the map and plan accordingly.
  2. To add a lead to the plan, alongside the lead name, click the plus icon.  Once added, you can create a joint meeting for this lead with your user by sliding the Joint Meet toggle.
    • You can also add leads by drawing on the map. On the bottom of the map, select how you want to draw the area on the map – Freehand, Polygon, or Circle. Once you draw a territory, the leads assigned to the user within that will be added to the selected day’s plan.
  3. To delete a plan for the day or add a day block, alongside the date, click Three dots and select the relevant option.
  4. Once you’re done, click Submit for Approval or Publish.
Note: Only leads with location will be displayed on the map.

Leadsquared - Journeys

 

5. Approve or Reject Plans

As an Admin, Sales Manager, Reporting Manager or Sales Group Manager, you can approve or reject lead-based as well as template-based plans submitted by your users.

  1. In Journeys, on the Manage Plans page, under Pending, you can view all the plans you haven’t approved or rejected yet.
  2. To filter specific plans, click the Filter icon and choose relevant filters.
  3. To view the details of a plan, click on it. The number of leads added on the plan for each day will be visible on the calendar. Click on a day’s lead count to view added leads.
    • To view the lead’s details, click on the lead name. You will now be directed to the Lead Details page on a new tab.
  4. To create a joint meeting for any of the leads, under the relevant lead name, slide the Joint Meet toggle. Then, click Update.
  5. Once you’re done reviewing the plan, click Approve or Reject. If you click Reject, you must write a comment on why you’ve rejected the plan. Approved and rejected plans move from Pending to the All section. In All, view all plans, including Pending, Approved, and Rejected ones. The rejected plans are sent back to the user to edit if they have not expired.

Note: Plans must be approved/rejected on or before their start date. For instance, if a user’s plan begins on February 3rd, the manager must approve it by that date at the latest. If no action is taken by the 3rd, the plan will expire. If Auto-Approval is enabled by the admin in the Journeys settings, the pending plans will be approved automatically on the day of the plan.

Leadsquared - Journeys

 

6. Edit Pending or Approved Plans

Pending or approved plans submitted by your users can be edited to add or remove leads, block a day or revoke a user’s holiday.

Note: You must be an Admin, Sales Manager, Reporting Manager or Sales Group Manager.

6.1 Edit Pending Plans

You can edit plans that are pending for approval to ensure that the user’s plan is optimized.

  1. Navigate to Manage Plans on Journeys.
  2. Select the relevant plan in the Pending status.
  3. Click the Edit icon and you will be redirected to the Edit Plan page.
  4. Here, you can make the relevant changes to the plan and click Update Plan.

Leadsquared - Journeys

6.2 Edit Approved Plans

You can also edit plans that are already approved. This lets you reduce or increase tasks for your user based on their existing plan.

  1. Navigate to Manage Plans on Journeys.
  2. Toggle from Pending to All.
  3. Select the relevant plan in the Approved status.
  4. Click the Edit icon and you will be redirected to the Edit Plan page.
  5. Once you’ve made the relevant edits to the plan, click Update Plan.

Leadsquared - Journeys

 

7. Import Lead-Based Plans for Users

Note: This setting will be visible only if you are an admin.

As an admin, you can bulk upload lead-based plans for your users. To enable this, you must complete a One-Time Setup by selecting a primary unique identifier for each lead (e.g., email, phone number, first name, etc.) to be used when importing plans. A unique lead identifier is a unique piece of information used to distinguish one lead from another in a database. It helps identify existing leads and prevents creating duplicate leads in your account. You can update or change this unique identifier at any time after the initial setup.

  1. Navigate to Field Sales Suite>Journeys>Manage Plans.
  2. Click the Settings gear icon at the bottom-left corner of the page and select Import.
  3. You will see a dropdown under Set Unique Lead Identifier containing all the lead fields that are marked as unique on your LeadSquared account.
  4. From the dropdown, select the relevant option.
  5. Click Confirm.

Leadsquared - Journeys

You will be redirected to the Import Plan page. Before you move forward with your plan import, ensure that you have exported your leads. To learn more, see How to Export Your Leads/Lead Details? . Once the lead details CSV is downloaded, open the file in MS Excel.

Then, to import lead-based plans for users,

  1. On Journeys, select the Start Date and End Date of the plan you are about to create.
  2. Click Download Sample and open the file in MS Excel.
  3. From the previously downloaded lead details CSV file, take the unique identifier of the lead and the email ID of the user you are creating the plan for.
  4. Ensure that –
    • You have not added, removed, modified the column headers in the CSV file or change the file format.
    • The plan dates are formatted as DD/MM/YYYY and fall within the plan duration selected in the Import Plan page.
    • You are adding the correct unique lead identifier against the planned dates and users.
    • The leads are correctly mapped either to the Admin or the user added for generating the plans.
    • The user email IDs are active users in LeadSquared User Management.

5. Once you have saved the file, on the Import Plan page in Journeys, click Browse Files and select the relevant CSV file for import.

Leadsquared - Journeys

To ensure that the plan file has been imported,

  1. Click the Refresh icon alongside History.
  2. If the status says “Successful”, then your plan has been created. If it says “Failed”, this could mean that there is an error in the file.
  3. To understand errors in your plan file and make corrections, click the Download icon and download the report.

Leadsquared - Journeys

The possible errors could be –

Reason Error
Lead not found “Lead does not exist. Please check if the Lead ID is incorrect or the Lead is deleted.”
Multiple errors “Error found in one or more planned dates for this user.”
Date falls outside duration “Planned date is outside the planned duration. Please remove this date from the plan and upload the file again.”
User not found “User does not exist. Please check if the user is inactive or the email is incorrect.”
Users limit surpassed “Total number of unique users exceeded the limit of 100.”
Daily lead limit surpassed “Maximum leads per day exceeded the limit of 40.”

Note:

  • Individual plans will be created for each user based on the provided Start Date and End Date. For example, if 30 user email IDs are added, 30 separate plans will be generated with the specified start and end dates.
  • If no leads are assigned to plan dates within the plan duration or if the dates are omitted in the file, those dates will be left empty.
  • Only 100 Individual Plans can be uploaded via Import at one time.
  • Templates, Joint Meetings, Minimum Quota, Overlapping Date Ranges Restrictions, Day Blocking, Default Plan Duration and Workday Templates are currently not supported in this feature.

 

8. Export Plans

Admins can export plans created by users directly from the LeadSquared web app. They can choose to export plans created by all users or limit the export to specific sales groups or teams. Additionally, admins can filter the export by the date range when the plans were created and by their status.

Note: To learn more about Sales Groups and Teams on LeadSquared, see What is the difference between Sales Groups and Teams?

To export plans –

  1. In Journeys, navigate to Manage Plans and click Export.
  2. On the Export Plans pop-up, select the Users Groups whose plans you want to export. You can choose All Users, Sales Groups, or Teams. If you select Sales Groups or Teams, you can choose multiple options using the multi-select dropdown.
  3. Select the Date Range for the plans. The date range is based on when the plans were created, not the plan start date. You can choose to export the data from the Last 30 Days, This Month, or a Custom date range (Upto 90 days).
  4. Select the relevant Plan Statuses from the multi-select dropdown. The available options include Approved, Auto-Approved, Pending, Not Submitted, Published, and Rejected.
  5. After selecting the required options, click Export. On the Export Request Queued pop-up, click Okay.

Leadsquared - Journeys

8.1 View Export Request and Download CSV

Once your export request is queued –

  1. Navigate to Settings>Request History on Journeys. You can view your Journeys Data Export here.
  2. Click the Download Report icon under Action to download the data as a CSV file.

Leadsquared - Journeys

 

9. Delete Plans

Admins can delete incorrect or irrelevant plans created by users to clean up data when Approvals is enabled or disabled.

9.1 Delete Plans when Approvals is disabled

Admins can permanently delete a submitted plan from Journeys in the web app. When a plan is deleted, all tasks created for the planned leads are also deleted.

To delete a plan –

  1. In Journeys on the web app, select the plan you want to delete.
  2. Click the Delete icon at the top of the plan grid.

In the confirmation popup, click Delete Plan to permanently delete the plan and its associated tasks.

Leadsquared - Journeys

9.2 Delete Plans when Approvals is enabled

In this scenario, Admins can only delete the plans that are rejected. Approved plans cannot be deleted.

Leadsquared - Journeys

 

Any Questions?

We’d love to answer your questions or hear your own unique use cases. Feel free to share your experiences in the comments section below.

If I have more than 1 lakh leads, what order or criteria will they be exported?

Only the first 1 lakh leads will be exported based on the sorted column on the grid.

For more information on lead export, see How to Export Your Leads/Lead Details.

Why can’t I export selected/chosen leads from the Manage Leads grid?

You can’t export selected leads. All leads on the Manage Leads grid are exported in keeping with the export limits.
To export specific leads, instead of selecting them randomly from the grid –

  1. Apply a filter or perform an advanced search or a quick search and then try to export.
  2. Only the results of the quick search, quick filters and advanced search will be exported.

For more information on lead export, see How to Export Your Leads/Lead Details.
To learn about Advanced Search, see How to Use the Advanced Search Feature.

Manage Lead Templates on Web App

1. Feature Overview

Lead Templates are a logical group of leads created based on similar properties like geographical proximity. Users can add these templates to plans instead of adding leads individually for each date in a plan. To know more about Plans, refer to Setting up Journeys on the Web App.

 

2. Prerequisite

  • Users must have the latest version of the LeadSquared mobile app installed on their devices.
  • Users must have Journeys enabled in their account. To enable this feature, reach out to support@leadsquared.com.
  • Users must enable Templates on Journeys settings.

 

3. Create Lead Templates

  1. Navigate to Apps>Journeys. On the left-most side of your screen, click Beats icon.
  2. Click Create.

3.1 Set-up Lead Templates

  1. Under Select User, select the user you want to assign this template to. To display all available leads, uncheck the Show only assigned user’s contacts checkbox.
  2. Under Details, enter the template name and give it a description.
  3. You can pick a colour for this template to distinguish it from the rest.
  4. Click Next.

3.2 Select Contacts

  1. Under All Contacts, alongside the lead you wish to add, click Black add icon.
  2. You can also add leads by drawing on the map. On the bottom of the map, select how you want to draw the area on the map – Freehand , Polygon, or Circle. Once you draw a territory, the leads within that will be added to the template.
  3. To filter the leads, click and choose relevant filters.
  4. To view the leads you’ve added, click the ‘N’ of 10 Added section.
  5. To delete a lead from the template, click Delete icon.
  6. Once you’re done, click Save.
    • If you want to delete the template you’ve worked on before saving it, click Discard.

LeadSquared - Create Beats

 

4. Manage Lead Templates on Web App

  1. Navigate to Apps>Journeys. On the left-most side of your screen, click Beats icon.
  2. On the left side of the page, all saved templates will be displayed.
  3. To filter the templates, click and choose relevant filters.
  4. To view a template’s details, click on the relevant card. All the leads added in that template will now be displayed. To view a lead’s details, click on the lead name.
  5. To reassign this template to a different user, click Reassign. On the Reassign template pop-up, select the user you want to assign it to.
  6. To edit the template, click edit.
  7. To delete the template, click Delete Portal Designer.
    • You can also edit, delete, or reassign templates directly on the template card by clicking Three dots.

LeadSquared - Manage Beats

 

Rename Lead Templates

To rename the Lead Template entity –

  1. On the Journeys page, click mobile settings icon.
  2. On the left side of the screen, under Settings, select Advanced.
  3. Under Rename Modules, alongside Templates, click edit.
  4. Enter the relevant display name and the plural term for it.
  5. Once you’re done, click Check icon.

LeadSquared - Rename Templates

 

Any Questions?

We’d love to answer your questions or hear your own unique use cases. Feel free to share your experiences in the comments section below.

UTC Mail Merge Fields

1. Feature Overview

This article lists the various mail merge fields available in the Universal Telephony Connector (UTC).

 

2. Prerequisites

  • The Universal Telephony Connector is a paid connector, to enable it contact support@leadsquared.com.
  • You must be an Administrator user to access the connector configuration.

 

3. Click2Call Mail Merge Fields

Note: The following click 2 call parameters have been deprecated –

  • @customerNumber
  • @agentNumber
  • @virtualNumber

Refer to the table below for alternatives.

Fields  Description
Virtual Number Fields –
@VirtualNumberWithoutCC Virtual Number/Display Number/Caller ID/DID without country code
@VirtualNumberWithCC Virtual Number/Display Number/Caller ID/DID with country code
@VirtualNumberTag Tag Configured for Virtual Number/Display Number/Caller ID/DID
Entity Fields 
@entityId This parameter is dynamic and gets resolved based on the calling context to either LeadID, OpportunityID, or TicketID.
Opportunity Fields – 

Note: Only the following 3 Opportunity fields are available for Mail-Merge.
@opportunityId Opportunity Id
@opportunityType Opportunity Type
@opportunityTelephonyMappingId Opportunity – Telephony Mapping Id
Activity Fields – 
@{Activity:ActivityEvent_Note, } Activity notes
@{Activity:Status, } Activity status
@{Activity:Owner, } Activity owner
@{Activity:mx_Custom_1, } Custom activity field
@{Activity:mx_Custom_2, } Custom activity field
@{Activity:mx_Custom_3, } Custom activity field
@{Activity:mx_Custom_4, } Custom activity field
@{Activity:mx_Custom_5, } Custom activity field
@{Activity:mx_Custom_6, } Custom activity field
@{Activity:mx_Custom_7, } Custom activity field
@{Activity:mx_Custom_8, } Custom activity field
@{Activity:mx_Custom_9, } Custom activity field
@{Activity:mx_Custom_10, } Custom activity field
 Lead Fields –
@{Lead:FirstName, } Lead’s first name
@{Lead:LastName, } Lead’s last name
@{Lead:EmailAddress, } Lead’s email address
@{Lead:Source, } Lead’s source
@{Lead:Notes, } Notes on the lead
@{Lead:Phone, } Lead’s phone number
@{Lead:Mobile, } Lead’s mobile number
@{Lead:Website, } Lead’s website
@{Lead:Company, } Lead’s company
@{Lead:JobTitle, } Lead’s job title
@{Lead:Score, } Lead’s score
@{Lead:CreatedOn, } Lead creation date
@{Lead:ModifiedOn, } Lead modified date
@{Lead:LeadConversionDate, } Lead conversion date
@{Lead:mx_Street1, } Lead’s address 1
@{Lead:mx_Street2, } Lead’s address 2
@{Lead:mx_City, } Lead’s city
@{Lead:mx_State, } Lead’s state
@{Lead:mx_Country, } Lead’s country
@{Lead:mx_Zip, } Lead’s zip code
@{Lead:OwnerIdName, } Lead owner
@{Lead:OwnerIdEmailAddress, } Lead owner’s email id
@{Lead:CreatedByName, } Lead created by
@{Lead:ModifiedByName, } Lead modified by
@{Lead:SourceCampaign, } Source campaign
@{Lead:SourceContent, } Source content
@{Lead:EngagementScore, } Engagement score
@{Lead:Revenue, } Lead value
@{Lead:TwitterId, } Lead’s Twitter id
@{Lead:FacebookId, } Lead’s Facebook ID
@{Lead:LinkedInId, } Lead’s LinkedIn ID
@{Lead:SkypeId, } Lead’s Skype ID
@{Lead:GTalkId, } Lead’s Google Talk ID
@{Lead:GooglePlusId, } Lead’s Google Plus ID
@{Lead:PhotoUrl, } Photo URL
@{Lead:CurrentOptInStatus, } The current opt-in status
@{Lead:OptInDate, } Lead opt-in date
@{Lead:OptInDetails, } Lead opt-in details
@{Lead:LastOptInEmailSentDate, } The last opt-in email date
@{Lead:LeadAge, } Lead’s age
@leadId Lead Id
@leadPhone Lead Phone number without country code
@PhoneNumberWithCountryCode Lead Phone number with country code
@CountryCode Lead’s country code
@{Lead:ProspectAutoId,} Lead identification number
Account Fields –
@{Account:City , } Account’s city
@{Account:CompanyName , } Account’s company name
@{Account:Country , } Account’s Country
@{Account:Fax , } Account’s fax number
@{Account:Phone , } Account’s phone number
@{Account:State , } Account’s state
@{Account:Street1 , } Account’s street address 1
@{Account:Street2 , } Account’s street address 2
@{Account:TimeZone , } Account’s time zone
@{Account:Website , } Account’s website
@{Account:Zip , } Account’s zip code
@{Account:ShortCode , } Account’s shortcode
@{Account:Plan , } Account’s plan
User Fields – 
@{User:EmailAddress , } Agent’s email address
@{User:FirstName , } Agent’s first name
@{User:FullName , } Agent’s full name
@{User:LastName , } Agent’s last name
@{User:MiddleName , } Agent’s middle name
@{User:AssociatedPhoneNumbers , } Agent’s associated phone numbers
@{User:UserId , } Agent’s user Id
@{User:AccessKey , } Agent’s access key
@AgentNumberWithCC Agent Number with country code
@AgentNumberWithoutCC Agent Number without country code
@agentName User Name
@agentEmail User Email Address
@{User:TeamId,} Team Id
@{User:GroupIds,} Comma-separated IDs of groups that the user belongs to

 

4. Call Disposition Mail Merge Fields

Fields Description
@agentNumber Agent’s number
@customerNumber Customer’s number
@virtualNumber Virtual number
@agentName Agent’s name
@agentId Agent’s ID
@callSessionId Call session ID
@ucid UCID
@campaignId Campaign ID
@notes Call notes
@comments Comments
@date Date
@dispositionValue Configured disposition value
@{User:emailAddress,} Agent’s email address
@{User:FirstName,} Agent’s first name
@{User:FullName,} Agent’s full name
@{User:LastName,} Agent’s last name
@{User:MiddleName,} Agent’s middle name
@{User:AssociatedPhoneNumbers,} Agent’s associated phone number
@{User:UserId,} User Id
@{User:AccessKey,} Agent’s Access Key
@{User:SecretKey,} Agent’s Secret Key

 

5. Agent Panel Mail Merge Fields

Fields Description
@{User:Address,} Agent’s address
@{User:AssociatedPhoneNumbers,} Agent’s associated phone numbers
@{User:AutoUserId,}
@{User:Availability,} Agent’s availability
@{User:AvailabilityStatus,} Agent’s availability status
@{User:CheckinCheckoutHistoryId,} Agent’s check-in check-out history Id
@{User:City,} Agent’s City
@{User:Country,} Agent’s Country
@{User:CreatedBy,} Created By
@{User:CreatedOn,} Created On
@{User:mx_Custom_1,} Custom Agent field 1
@{User:mx_Custom_2,} Custom Agent field 2
@{User:mx_Custom_3,} Custom Agent field 3
@{User:mx_Custom_4,} Custom Agent field 4
@{User:mx_Custom_5,} Custom Agent field 5
@{User:mx_Custom_6,} Custom Agent field 6
@{User:mx_Custom_7,} Custom Agent field 7
@{User:mx_Custom_8,} Custom Agent field 8
@{User:mx_Custom_9,} Custom Agent field 9
@{User:DateFormat,} Date Format
@{User:DateOfBirth,} Agent’s date of birth
@{User:DateOfJoining,} Agent’s date of joining
@{User:DateOfResignation,} Agent’s date of resignation
@{User:DeletionStatusCode,} Deletion status code
@{User:Department,} Agent’s department
@{User:Designation,} Agent’s designation
@{User:EmailAddress,} Agent’s email address
@{User:EmployeeId,} Agent’s employee Id
@{User:FirstName,} Agent’s first name
@{User:mx_Custom_Gender,} Agent’s gender
@{User:HolidayCalendarId,} Agent’s holiday calendar Id
@{User:ImportId,} Agent’s import Id
@{User:IsAdministrator,} Is Agent an administrator
@{User:IsAgencyUser,} Is Agent an agency user
@{User:IsBillingUser,} Is billing user
@{User:IsCheckedIn,} Is Agent checked in
@{User:IsCheckInEnabled,} Is check-in enabled
@{User:IsDefaultOwner,} Is default owner
@{User:IsEmailSender,} Is email sender
@{User:IsEmployee,} Is employee
@{User:IsPhoneCallAgent,} Is phone call agent
@{User:IsSoftPhoneEnabled,} Is the agent’s softphone enabled
@{User:IsWorkingToday,} Is the agent working today
@{User:LastCheckedIpAddress,} Last checked IP address
@{User:LastCheckedOn,} Agent’s last checked on
@{User:LastName,} Agent’s last name
@{User:ManagerUserId,} User ID of agent’s manager
@{User:MiddleName,} Agent’s middle name
@{User:ModifiedBy,} Modified by
@{User:ModifiedOn,} Modified on
@{User:ModifyAllLeadsOfGroup,} Modify all leads of group
@{User:OfficeLocationName,} Agent’s office location
@{User:Team,} Agent’s team
@{User:TemplateNames,} Permission templates
@{User:PhoneMain,} Agent’s main phone
@{User:PhoneMobile,} Agent’s mobile phone
@{User:PhoneOthers,} Agent’s other phone numbers
@{User:PhotoUrl,} Agent’s photo URL
@{User:Role,} Agent’s role
@{User:Groups,} Agent’s group
@{User:SalesRegions,} Agent’s sales regions
@{User:Signature_Html,} Agent’s signature HTML
@{User:Signature_Text,} Agent’s signature text
@{User:Skills,} Agent’s skills
@{User:State,} Agent’s state
@{User:StatusCode,} Agent’s status code
@{User:StatusReason,} Agent’s status reason
@{User:TeamId,} Agent’s team Id
@{User:TelephonyAgentId,} Telephony Agent’s Id
@{User:TimeZone,} Agent’s timezone
@{User:UserID,} Agent’s user ID
@{User:UserType,} Agent’s user type
@{User:ViewAllLeadsOfGroup,} View all leads of group
@{User:WorkDayTemplateId,} Workday template Id
@{User:ZipCode,} Agent’s zip code

 

Any Questions?

Did you find this article helpful? Please let us know any feedback you may have in the comments section below. We’d love to hear from you and help you out!

Manage Access for Email Templates

1. Feature Overview

This feature allows users to restrict access to certain email templates in the application. You can restrict access to specific users, roles, groups, or just yourself. Only the selected users will be able to view these templates on the Email Library. You can manage access on the Email Library or while creating/editing an email template. Once this feature is enabled, an Accessible To column will be added on the Email Library grid to display the number of users who can access that template.

Some of the use cases for this feature are –

  • Data Security – By restricting access, unauthorized personnel can be prevented from viewing or using these templates. This helps in protecting organization’s data and maintain compliance with data privacy regulations.
  • Control Over Branding and Messaging – Access restrictions can help maintain consistency in branding and messaging, preventing unauthorized changes that could harm the company’s image.
  • Enhanced User Experience – With access restrictions, a cleaner and more streamlined user interface can be presented for each user by showing them only the templates relevant to their role.
  • Compliance and Legal Requirements – Access restrictions allow to control who can send emails with certain templates, ensuring compliance with legal requirements and reducing the risk of non-compliance.
Note: Email Templates are accessible to everyone by default.

LeadSquared - Manage email template access

 

2. Prerequisites

  • You must be the creator of the email template or an Admin/Super Admin to manage access for that template.

 

3. Manage Access for Email Templates on Email Library

  1. Navigate to Content>Email Library.
  2. Alongside the relevant Email Template, hover your cursor over LeadSquared - Settings icon and select Manage Access.
  3. On the pop-up window, under Accessible To, click the dropdown and select one of these options –
    • Everyone
    • Only Admins/Only Me
    • Specific User(s)
    • Specific Role(s)
    • Specific Group(s)
  4. To assign access to the relevant entity, select them and click Right Arrow. To remove them from the Assigned Users list, click Left Arrow icon.
  5. Click Save.
Note: The ‘Only Admins’ option will only be displayed to Admin users.

LeadSquared - Manage Access for Email Templates

3.1 View User Access

Once you’re done configuring access to users, you can view the number of users who can access the template under the Accessible To column. Click on the value displayed here to view the entities that have access to this template. Admins/creators of the template can also manage access to the template on this pop-up window.

LeadSquared - Accessible To

 

4. Template Access in Email Editor

Upon clicking the Use Template button in the Email Editor, only the templates accessible to the user will be displayed. In case the logged in user does not have access to any templates, they’ll receive a “No records to display” message.

LeadSquared - Use Template in Email Editor

 

Any Questions?

Did you find this article helpful? Please let us know any feedback you may have in the comments section below. We’d love to hear from you and help you out!

Join Data Sources on SIERA Report Builder

1. Feature Overview

The SIERA Report Builder supports advanced data modeling capabilities through Joins and Sub-Query Joins. These features allow users to combine multiple data sources, apply cross-entity filters, and build complex expressions across nested queries.

  • Use Joins to merge fields across related entities such as Leads, Tasks, Activities, Opportunities, and more.
  • Use Sub-Query Joins to go a step further—filter, aggregate, and group data within independent sub-queries before linking the result to the main report.

This article covers both standard joins and the sub-query join capability, with practical examples and configuration steps.

 

2. Prerequisites

 

3. Join Functionality

SIERA Report Builder allows you to combine data from multiple entities using the Join feature. This is useful for generating consolidated reports across related data sources like Leads, Opportunities, Tasks, Activities, etc.

There are four types of joins available:

  • Left Outer Join: Returns all records from the left entity and matching records from the right.
  • Inner Join: Returns only records that match in both entities.
  • Right Outer Join: Returns all records from the right entity and matching records from the left.
  • Full Outer Join: Returns all records where there’s a match in either entity.

Use-Case

Here are some common use cases for SIERA’s Join feature –

Use Case Tables/Data Sources Join Join Condition Expected Output
Find all closed-won opportunities and their associated accounts.
  • Opportunities (Opportunity ID, Name, Account ID, Status, Amount)
  • Accounts (Account ID, Account Name, Industry)
Inner Join
Opportunities INNER JOIN Accounts ON Opportunities.AccountID = Accounts.AccountID
Lists only won opportunities along with the associated account details.
Show all tasks, even those not assigned to a user.
  • Tasks (Task ID, Title, Due Date, Assigned User ID)
  • Users (User ID, Name, Role)
Left Join
Tasks LEFT JOIN Users ON Tasks.AssignedUserID = Users.UserID
  • Includes all tasks.
  • Tasks without assigned users will have NULL values in the “AssignedUser” column.
Show all contacts, even if they haven’t attended a meeting.
  • Meetings (Meeting ID, Subject, Contact ID, Date)
  • Contacts (Contact ID, Name, Email, Company)
Right Join
Meetings RIGHT JOIN Contacts ON Meetings.RelatedProspectId = Contacts.RelatedProspectId
  • Every contact appears in the report.
  • Contacts who haven’t attended any meetings will have NULL values for meetings.
Get a full view of all invoices and payments, including unpaid invoices and orphaned payments.
  • Invoices (Invoice ID, Customer ID, Amount, Due Date)
  • Payments (Payment ID, Invoice ID, Amount Paid, Payment Date)
Full Outer Join
Invoices FULL OUTER JOIN Payments ON Invoices.RelatedProspectId = Payments.RelatedProspectId
  • Includes all invoices, whether paid or unpaid.
  • Includes all payments, even if they aren’t linked to an invoice.

4. Creating a Join

For example, When you use a Left Outer Join between Leads and Activities, it retrieves all Leads that match a filter (e.g., Created On) but only includes Activities linked to these specific leads:

  1. Click the edit icon icon against Data Source.
  2. Click the Add icon icon.
  3. Select the Join as: Leads Left Outer Join with All Activites.
  4. The On function would be: ProspectID = RelatedProspectID.
    • Here, we are matching the lead ID stored as ProspectID in the Lead Data Source with the lead ID stored as RelatedProspectID in the Activity Data Source. This ensures that activities are correctly associated with their respective leads. For more details on Report Builder Data Sourcesrefer to this article.
  5. Click Save.

Now, you can add the related activity fields to your report.

Note:

  • You can create up to three joins between different entities.
  • Once an entity is joined, you can also utilize its related fields to build custom values, enabling more refined data analysis and reporting.

Report builder data sources

 

5. Data Source Join Fields for Accurate Data Retrieval

This table illustrates the appropriate join fields for different data sources to ensure accurate data retrieval.

Data Source 1 Data Source 2 Join Field for Data Source 1 Join Field for Data Source 2 Comments
Leads Activities/ Custom Activity
ProspectID
RelatedProspectId
Leads Opportunity/ Custom Opportunity
ProspectID
RelatedProspectId
Leads Task/ Custom Task
ProspectID
RelatedEntityId
Leads LandingPage
RelatedLandingPageId
WebContentId
Leads Accounts/ Custom Accounts
RelatedCompanyId
CompanyId
Leads AccountsActivity/ Custom AccountsActivity
RelatedCompanyId
RelatedCompanyId
All Activities/ Custom Activities Opportunity/ Custom Opportunity
OpportunityProspectActivityId
ProspectActivityId
All Activities/ Custom Activities LandingPage
RelatedLandingPageId
WebContentId
All Activities/ Custom Activities Task/ Custom Task
OpportunityProspectActivityId
OpportunityProspectActivityId
If Activity & Task are performed on the Opportunity.
OpportunityRelatedProspectId
OpportunityRelatedProspectId
If Activity & Task are performed on the Lead.
RelatedProspectId
RelatedEntityId
If Opportunity is not enabled.
Opportunity/ Custom Opportunity Task/ Custom Task
ProspectActivityId
OpportunityProspectActivityId
Opportunity/ Custom Opportunity LandingPage
RelatedLandingPageId
WebContentId
Accounts/ Custom Accounts AccountsActivity/ Custom AccountsActivity
CompanyId
RelatedCompanyId

 

6. Sub-Query Joins (Advanced Joins)

Sub-Query Joins allow you to nest an entire query within your main report, enabling you to group, filter, and aggregate data across multiple entities before joining it back to the primary data source. This unlocks advanced reporting use cases that aren’t possible with standard joins—such as applying multi-stage filters, custom expressions, or deep aggregations across related datasets.

 Key capabilities

  • Up to three joins per sub-query.
  • Use filters, aggregations, and custom expressions inside sub-queries.
  • Join a sub-query back to the main report.
  • Use sub-query expressions in the main report (e.g., date differences).
  • Supports pagination to limit data returned from sub-queries.
  • Custom columns are also available in sub-queries.

Use Cases

Here are some use-cases for the Sub-Query feature –

  • Visitor to Customer Analysis: Analyze how many website visitors convert into customers, segmented by source.
  • Time Taken to Win a Customer: Calculate the time difference between lead creation to conversion date.
  • Leads With and Without Activities: Count leads with at least one activity and leads with no activities.

 

7. Rules for Creating a Sub-Query

  • A sub-query can include grouping, which can be used to join with another sub-query or the root query. The grouped field becomes available for use in the next step (if applicable).
  • A sub-query may exclude grouping, allowing it to be used as a NOT IN query.
  • A sub-query can include joins, meaning it can join with one or more tables or other queries.
  • A sub-query can include filters, which may appear in additional filters or as report-level filters based on configuration.
  • A sub-query can include measures, which can be reused in other queries and will become fields in subsequent steps (if applicable).

 

8. Creating a Sub Query Join

Let’s walk through a real example: counting leads with at least one activity and leads with no activities.

Example Use Case: Leads With and Without Activities

Configuration Steps

  1. Edit the Data Source: From the main report builder, click the Edit icon next to your data source.
  2. Create a New Query: Click New Query to define a sub-query. This query will process the necessary joins and aggregations.
  3. Set Up Sub-Query Layers: Create the following sub-queries:
    • Query 2 (Leads Layer): Select the Leads data source.
    • Group by:
      • Owner
      • Prospect ID
    • Query 3 (Activities Layer): Select the All Activities data source.
    • Group by:
      • ActivityId
      • RelatedProspectId
      • ActivityEvent
  4. Query 1 (Join Layer): Join Query 2 (Leads) with Query 3 (Activities).
    • Join Type: Left Join
    • Join Condition: Prospect ID = RelatedProspectID
    • Group Query 1 by:
      • Owner
      • Prospect ID
    • Create Custom Expressions in the Query to count activities
      • Activity Count: CountDistinctIf(`Query 3.ActivityId`, `Query 3.ActivityId` != '')
  5. Click Save.

Creating subquery join

Use Query Output in the Main Builder

In the main custom expression builder, use the following expressions to segment leads:

  • Leads With Activities: CountDistinctIf(`Query 1.Prospect ID`, `Query 1.Activity Count` > 0)
  • Leads Without Activities: CountDistinctIf(`Query 1.Prospect ID`, `Query 1.Activity Count` < 1)

These expressions reference data already grouped and aggregated in the sub-query, making them far more powerful than what is possible using basic joins alone.

show activities for sub query join in expressions

 

Any Questions?

Did you find this article helpful? Please let us know any feedback you may have in the comments section below. We’d love to hear from you and help you out!

Combining Query Results Using Union in Analytics Report Builder

1. Feature Overview

The Union and Union All options in the Analytics Report Builder allow you to combine the results of two or more queries into a single dataset by stacking rows vertically.

Unlike Joins, which merge related tables side-by-side (column-wise), Union combines datasets that share the same structure and appends them together (row-wise).

Union is useful when you want to consolidate similar data from multiple sources into one unified report.

 

2. Prerequisites

 

3. When to Use Union

Use Union when you want to:

  • Merge similar datasets into one report
  • Combine data from parallel entities (e.g., Leads and Activities)
  • Create unified workload or engagement reports
  • Append filtered query results together
  • Avoid relational joins where no direct relationship is required

3.1 Union vs Union All

Option

Behavior

Union

  • Combines datasets and removes duplicate rows.
  • Use Union when you want automatic deduplication.

Union All

  • Combines datasets and retains all rows, including duplicates.
  • Use Union All when every record must be counted (recommended for volume-based reports).

3.2 Important Rules for Using Union

Union can only be applied between queries, not base tables.

Before applying Union, ensure:

  • Both queries return the same number of columns
  • Columns appear in the same order
  • Corresponding columns use compatible data types
  • Business meaning of each column matches across queries

If these conditions are not met, Analytics will show a validation error when saving the report.

 

4. Union Configuration

4.1 Use Case

For example, let’s say you want to combine Lead Source information from:

  • Leads table
  • Activities table

The goal is to create a single dataset that shows all sources (from both Leads and Activities) in one report. This combines Lead Source at the lead level with Traffic Source from activities (for example, form submissions or other interactions), so both the lead’s origin and activity-driven sources are included in one dataset—allowing you to see where the lead originally came from and how the lead interacted later.

Step 1: Create Query 1 (Leads)

  1. Click + New Query
  2. Select Leads as the data source
  3. Add the following rows:
    • Lead Source
    • Prospect ID
  4. Apply required filters, such as Created On (date range)
  5. Save the query

Step 2: Create Query 2 (Activities)

  1. Click + New Query
  2. Select All Activities as the data source
  3. Add the following rows in the same order as Query 1:
    • Traffic Source
    • Related Prospect ID
  4. Apply filters such as:
    • Activity Event
    • Created On (date range)
  5. Save the query

Step 3: Apply Union

  1. In the Data Source section, Under Combine Tables, select Union or Union All
  2. Choose:
    • Query 1 (Leads)
    • Query 2 (Activities)

If both queries follow the validation rules, the union will execute successfully and combine the datasets into a single result.

creating a union in analytics

4.2 Showing Query Filters in the Main Report

You can control query-level filters from the main report page:

  1. Edit the query
  2. Go to Filters
  3. Click the three-dot menu on a filter
  4. Enable Show this filter in the main report page

This allows centralised filtering after union is applied. You

Note: User filters cannot be exposed.

query filters in the main report

 

FAQs

1. Can I use Union directly on tables?

No. Union works only between queries.

2. What happens if column data types do not match?

The report will fail validation and show an error.

3. Which column names appear in the final report?

Column display names are inherited from the left-hand (primary) query.

 

Any Questions?

We’d love to hear your feedback to help improve this article. Feel free to enter your questions or in the comments section below.

Customize Opportunity Details View on Mobile

1. Feature Overview

Based on each Team’s requirements, LeadSquared Admin users can customize the Tabs, Actions, Buttons, and Opportunity V-Card on the Opportunity Details page. To display different Opportunity Details page views for different teams, you can select the –

  • System tabs (Activity History, Tasks, etc.) and Custom Tabs (KYC Documents Collected, Support Tickets, etc.) you want to display to your users
  • Actions your users can perform (Send Email, Call Lead, etc.) from the Opportunity Actions dropdown
  • Quick Action Buttons
  • Opportunity fields you want to display on the Opportunity V-Card
Note: This article deals with Opportunity Details View Customization (ODVC) on the mobile app. To know more about ODVC on the web app, click here.

 

2. Prerequisite

You must have the latest version of the LeadSquared mobile app enabled in your account.

 

3. Opportunity Details View Customization (ODVC)

To customise the opportunity details view (ODVC) on the mobile app –

  1. Navigate to My Account>Settings>Mobile App>Details Customization and click Enable.
  2. Alongside Customize details for, click the dropdown and select Opportunities. Then, select the Opportunity Type. If customization is disabled for that particular Opportunity type, click Enable again.
  3. Enter the name and description of your view.
  4. Select the view to be customized – Tabs or Actions.
  5. Under Available Tabs/Actions, alongside the field you wish to add, click add icon. You can add both system and custom fields. To search for any field, enter the field name under Search Fields.
  6. To preview the customised fields, alongside Selected Tabs, hover your cursor over view on mobile.
  7. Click Save View.
Note: The customized view will be applied on the accounts of all users under the tenant.

LeadSquared - ODVC on mobile

 

Any Questions?

Do you have questions or issues with the content in this article? Let us know in the comments section below. We’ll get back to you asap!

Smart Views FAQs and Troubleshooting

How can I switch back to the old Smart Views UI?

To switch to the old Smart Views UI, click here.

 

Why do I see a malfunction error in Smart Views?

This error occurs when the data fetch API fails. It may occur if any custom lead/opportunity field value in the Smart Views condition has been deleted from the system. To confirm, navigate to Lead Field settings and check if any custom fields added in the Smart Views condition has been deleted. 

LeadSquared - Smart Views Malfunction Error

 

Why does the activity tab I created from admin settings refer a different activity after assignment?

This issue may arise when view permissions for the activity are restricted for the user. Navigate to Permission Templates and check the permissions set for the user. This is applicable to tasks, opportunities, and accounts as well. 

Activity permission template

LeadSquared - View permissions for activity

 

How to Configure the Refresh Interval in Smart Views? Smart View Data Auto-Refresh Not Working Automatically

  • Issue: When a user performs an action on the Smart Views page (e.g., calling a lead or filling a disposition form), the updated data does not automatically reflect in the Smart View. The user must manually refresh the page to see the changes.
  • Solution: LeadSquared supports the auto-refresh of data on Smart Views. However, the auto-refresh interval is configurable and may need adjustment for timely updates. To know more, click here.
    By reducing the refresh interval, the updated data will reflect more frequently without requiring manual refreshes. This resolves issues such as:

    • Smart View data not updating automatically.
    • Need to manually refresh Smart View after actions.

 

Why aren’t the filters configured in Manage Filters applied to LeadSquared’s platform Smart Views while creating an activity tab?

When the Admin configures a Smart Views tab for an activity type, they will be able to add additional filters on the Manage Filters tab. However, the filters added will only be displayed on the new Smart Views UI and Marvin.

 

Why aren’t the filters and columns I added in the old Smart Views UI reflected in the new UI after switching?

When transitioning to the new UI, all data, including tabs, filters, and columns, is initially synchronized. However, subsequent customizations made by the user will not be synced. You’ll need to add filters and columns separately in the new UI.

 

How do I access tab details in the new Smart Views UI?

To know more, click here.

 

Why can’t I reorder columns in the new Smart Views UI by dragging and dropping them?

To reorder columns in the new UI –

  1. Click LeadSquared Service CRM. Then, click Select Columns.
  2. Under Selected Columns, drag and drop the columns to arrange them in your preferred order.

LeadSquared - Rearrange Columns in Smart Views New UI

 

Smart Views tabs are loading very slow, how can this be addressed?

There may be many possible causes for slowness issues on Smart Views, including your internet connection speed, browser settings, issues on the LeadSquared side, etc. However, you can enable the ‘Load inactive tabs in Smart Views’ advanced setting to optimise performance by preloading data for inactive tabs in the background.

Triggers in Lead, Opportunity, Activity and Task Automations

1. Feature Overview

A trigger defines when leads enter your automation.

LeadSquared Automation

Note:

  • Once an automation is triggered 50 times for a lead within a single day, it will automatically terminate. This is done to prevent any potential looping.
  • For information on data posted by each trigger, see Automation Triggers – Data Posted.
  • The User Trigger lets you decide when users, not leads, enter your automation (see Triggers in User Automation).
  • To enable opportunities on your account, please write to support@leadsquared.com.
  • To perform bulk updates through automation, contact your billing team or reach out to support@leadsquared.com.

You can choose any of the following triggers –

 

Category Trigger Example Use Case
Lead Trigger New Lead Triggers the automation when a new lead is created in your LeadSquared account.

  • Send an opt-in email for further email communication.
  • Send the lead a welcome email.
  • Automatically distribute new leads to your users.

Note: You can also trigger the automation on lead import. There’s a Trigger on Import checkbox available in the lead create dialog box.

trigger automation on lead import

Lead Update Triggers an automation when one or more lead fields are updated.

  • Send the lead an email when the lead stage changes from, say, prospect to customer.
  • Send the lead owner an email when the lead’s score increases.
  • Notify the lead owner if a lead’s location changes.
Note: A Lead Update trigger that updates the Owner will not trigger when the lead owner is changed through the distributed lead card. This is done to improve performance and avoid looping.
Lead Added to List Triggers when a lead is added to a list.

  • Add leads with low engagement to a separate list and send them specific nurturing emails.
  • When a lead is added to a ‘Priority’ list, update the lead stage to ‘Customer’.

Note:

  • You can also manually trigger an automation from a static list using the checkbox below.

Automation

  • Once you publish this automation, the ‘Trigger Automation’ option will appear under list actions on the list details page (for the static lists selected in the automation trigger).

trigger automation from list details page

On a Specific Date Triggers on a chosen date.

  • Send emails on special occasions like birthdays, holidays, etc.
  • Set up a customer retention process on renewal dates.
Opportunity Trigger New Opportunity Triggers an automation when a new opportunity is created or added to an existing lead in your account.

  • Send an opt-in email to the lead for further email communication.
  • Automatically distribute new opportunities to your users and/or teams.
Opportunity Update Triggers an automation when one or more opportunity fields are updated or changed.

  • Send the lead an email when the opportunity status changes from, say, open to won.
  • Send the opportunity owner an email when the opportunity stage changes.
On a Specific Date Triggers on a chosen date.

  • Send emails on special occasions like birthdays, holidays, etc.
  • Set up a customer retention process on renewal dates.
Activity Trigger New Activity on Lead Triggers when a lead performs an activity or set of activities.

  • Send a thank you email when a lead submits a form.
  • Automatically add leads to a list if they open a particular email campaign.
  • Send a special offer email to a lead who’s viewed your pricing page.
Activity Update on Lead Triggers when an activity posted on a lead gets updated. This trigger only includes custom and sales activities.

  • When a sales activity is added to a lead, update the lead stage to ‘customer’.
  • When a custom activity (e.g., site visit) status is updated to ‘complete’, send the lead an email.
New Activity on Opportunity Triggers when a lead under an opportunity performs an activity or set of activities.

  • Send a reminder when the lead’s free trial period ends.
  • Schedule communication to be sent once the lead agree’s to a meeting.
Activity Update on Opportunity Triggers when an activity posted on an opportunity gets updated. This trigger only includes custom activities.

  • Send communication for when an appointment is rescheduled.
  • Notify the opportunity owner when an activity is completed.
New Activity on Activity Triggers when an activity is posted on an existing activity.

  • Notify sales users when an activity on activity is posted.
  • Create tasks (like meetings, phone calls, etc.) related to the activity.
  • Change the lead status when an activity on activity is posted.
Task Trigger Task Created on Lead Triggers when a task is created on a lead.

  • Notify users with a personalized email with all the available mail merge fields.
Task Updated on Lead Triggers when a task is updated on a lead.

  • Notify users when the meeting schedule with a lead gets updated.
Task Reminder for Lead Triggers when a task reminder is created.

  • Send emails to users reminding them to collect certain lead details or documents related to the task.
Task Completed on Lead Triggers on the completion of a task.

  • Post an activity once a task is completed. You can then create a follow-up task for a different team. For example, once the sales team has completed a task, post an activity and then create a task for the accounts team.
Task Created on Opportunity Triggers when a task is created on an opportunity.

  • Notify users with a personalized email when an appointment is scheduled with the lead.
Task Updated on Opportunity Triggers when a task is updated on an opportunity.

  • Notify users with a personalized email when a meeting schedule is updated with the lead/opportunity.
Task Completed on Opportunity Triggers on the completion of a task.

  • Post an activity once a task is completed. You can then create a follow-up task for a different team. For example, once the sales team has completed a task, post an activity and then create a task for the accounts team.
Task Reminder for Opportunity Triggers when a task reminder is created.

  • Send emails to users reminding them to collect documents related to the opportunity.
At Regular Intervals At Regular Intervals Triggers at defined recurring intervals

  • If you’re using another third-party system or application, set up and automation to push bulk data (lead, activity, task information, etc.) from Leadsquared at regular intervals.
  • Keep 2 accounts or systems in sync by triggering webhooks or lapps to run at defined intervals.
  • Set up an automation to run every morning and distribute leads based on user availability.
  • Run an automation every day to update a lead field.

 

2. Exit Conditions

After selecting an automation trigger, you can setup exit conditions. Leads will be removed from your automation when these exit conditions are met.

Note: The automation checks to see if the exit conditions are met before executing any action. If they are met, the next action will not be performed on that lead.

For example, let’s say you want to set up an automation that sends nurturing emails to leads to convert them to customers. You can set up an exit condition so that all leads who become customers (Lead Stage = Customer) are removed from the automation and stop receiving the nurturing emails.

Click the Choose conditions(s) to remove lead(s) from this automation link highlighted below.

exit conditions

Next, select the conditions based on which you want leads to exit the automation.

automation exit conditions

 

3. Examples

Example 1: Activity Update on Lead
Here’s an example where the Activity Update on Lead trigger is selected.
The Sales Activity is selected as the Activity Type and Sales Owner is selected as the Activity Field. The automation starts when the sales owner value changes from ‘Any’ to ‘Any’.

For all automation triggers, you can also set up additional conditions to make your automation more versatile. Using this functionality, you can use multiple conditions to trigger your automation.
As an example, say you want to start your automation when a new lead is created but only if the new lead created is from Bengaluru. You can set this up by adding additional conditions to the automation trigger.

 

Example 2: On a Specific Date
Select this trigger to start your automation on a specific date. The specific date can be the ‘created on’ date of your lead or the date of the first landing page submission. This could be used as a condition to send a welcome email when a lead is created/submits on a landing page.

Note: All timings related to date based triggers automatically reflect the user’s time zone and not Coordinated Universal Time (UTC).

Select the lead field as –

  • Created On – This is the date on which a lead is created in your LeadSquared account.
  • First Landing Page Submission Date – This is the date on which the first landing page submission of a lead occurs.
  • Lead Conversion Date – This is the date on which a visitor is converted into a lead in your LeadSquared account.

You can schedule the automation to start when the date condition is satisfied. You can also specify the time you want to trigger the automation at. You can also use Repeat Annually to trigger the automation on the same day every year.

Note: Additional Conditions can also be provided to check the leads entering into the automation.

 

Example 3: Lead Update

lead update

As an example, Lead Update is the starting point of this automation. When the Lead City changes, after a Wait condition of one day, an email is sent to the lead with the details of the location. If the Lead opens the Email, another \email is sent to the Lead with more details. If the email is not opened after one day, a notification is sent to the lead owner to contact the Lead.

 

Example 4: New Activity on Lead

new activity on lead

New Activity on Lead is the starting point of this automation. When a lead satisfies the Met in Tradeshow activity, a Wait condition of one day is provided. After one day, if the activity of the lead is Inbound Phone Call Activity, an email is sent to the lead with the product details. If not, the lead owner is notified with the lead name and lead phone number to follow-up.

 

Example 5: Lead Added to List

added to a list

When a Lead is added to a Starred Lead list, the Lead Stage is changed to Premium User. Once the Lead Stage is updated, an email is sent to the lead with the benefits of being a premium user of your product.

 

Example 6: At Regular Intervals

This automation is set up to post the activity data of certain leads to another application.

cron example

It triggers for leads at 9 a.m. every day and pushes any activity that has been posted on leads the previous day.

cron job

 

Any Questions?

Did you find this article helpful? Please let us know any feedback you may have in the comments section below. We’d love to hear from you and help you out!

Automation – Feature Guide

The Automation feature lets you automate your entire workflow using an intuitive and easy to use visual designer. It’s a powerful way to push your leads to conversion! Just set it up once and watch your leads trickle down the sales funnel with minimal manual effort.

Here are some examples of what you can achieve through automation –

  • Send automated campaigns to leads and follow up based on their behaviour.
  • Nurture leads with the right messages depending on their engagement.
  • Automatically distribute leads to users/groups based on location, interests, products, etc.
  • Automatically check-in/check-out your users, create tasks and alerts based on their availability and send them automated messages on special occasions.
  • Use Lapps and webhooks to pull/push data and automate processes you perform in third-party applications.
  • And lots more…

 

Automation Types

You can set up different types of automations based on the automation trigger you select –

Automation Type Description
Account Lets you automate workflows around your B2B relationships and activities.
Lead Lets you automate your lead conversion workflow through engagement, nurturing, sales management, etc.
Opportunity Lets you automate your opportunity capture workflow through engagement, nurturing, sales management, etc.
Activity Lets you automate workflows when activities are posted or updated against accounts, leads or opportunities.
Tasks Lets you automate workflows when tasks are posted or updated against accounts, leads or opportunities.
User Lets you automate the workflow of your users and lead distribution through check-in/check-out functionality. work day and hour availability, holiday/leave management, etc.
At Regular Intervals Lets you trigger automated workflows at specified intervals.

If you’re new to the automation feature, we recommend you go through this article first.

Automation Type Articles
Account Automation
Lead, Opportunity, Activity, and Task Automations
User Automation
Automation Audit Report
See who changed what and when, as well as previous versions of your automations.
Note: Once an automation is triggered 50 times for a lead within a single day, it will automatically terminate. This is done to prevent any potential looping.

 

Automation Basics

Automations have three key components –

  • Triggers
    The starting point of your automation. When a new lead is created for instance.
  • Conditions
    An if/else or wait until condition that is usually followed by an action. Wait until a lead opens an email for example.
  • Actions
    An action to perform once a condition is met, such as adding a lead to a list or sending an email once a condition is met.

Automation Basics

 

Navigation

From your main menu, navigate to Workflow>Automation.

automation navigation

From this page, you can –

  • Create new automations.
  • Filter existing automations by Type, Status, Modified By and Modified On.
  • Use the SettingsSettings iconicon alongside an existing automation to Publish, Edit, Rename, Clone or Delete the automation.

 

Unplishing Automation

When unpublishing an Automation, you have two options to choose from:

  • Immediate  Unpublish the automation right away, stopping all leads currently in the workflow.
  • Delayed – Unpublish after all leads in the workflow are processed, but no new leads will enter.

unpublishing automations

Delayed automations will appear as Unpublished* and cannot be deleted until all leads are processed. Alternatively, you can convert it to an Immediate unpublish to delete it.

Note: After twelve months, all Delayed unpublish automations will automatically convert to Immediate unpublish.

deleting unpublished automations

 

Automation Reports

 

Any Questions?

Do you have a workflow you would love to automate? Let us know in the comments. We’re happy to help!

Why do I see a malfunction error in Smart Views?

This error occurs when the data fetch API fails. It may occur if any field or value in the smart views condition has been deleted from the system.

How do I access tab details in the new Smart Views UI?

In the new UI, tab details have been relocated.

  • To view the tab details, alongside the tab name, click LeadSquared - Info icon.
  • You can also delete or edit the tab details on the Tab info pop-up.

LeadSquared - Tab Info in Smart Views New UI