Skip to main content
Gainsight Inc.

Create a Report of Customers Without Open or No CTAs

This tutorial explains how to create a report to determine which customers do not have any open CTAs or no CTAs. First, you will create a custom numeric field named “Count of CTAs” on the CustomerInfo object. Then, you will create rule to determine the count of open CTAs, and map it with the custom field. And finally, you will create a report on the CustomerInfo object with a specific filter to determine the customers without CTAs.

Create a Custom Numeric Field

To create a custom numeric field:

  1. Navigate to the Custom Info Object page in Salesforce.
  2. Click New to create a new field.

3. Select the data type as Number and click Next.

4. Enter the field label as Count of CTA and field name as Count_of_CTA. Click Next.

  1. Select the required security settings and click Next.
  2. Click Save.

Create a Rule to Determine the Count of Open and No CTAs

To create a rule to determine the count of open and no CTAs:

  1. Navigate to Administration > Rules Engine.
  2. Click + RULE.
  3. Select the rule type as Bionic.
  4. Select Account in Rule Type and enter the required rule name as “Count of open CTAs”.

  1. Click NEXT.

Create First Dataset

To create the first Dataset:

  1. Click DATASET TASK. Enter the required task name and output dataset name as Fetch from Call to Action.
  2. Select the source object as Call to Action.
  3. Select the Account, Account Name, and Count of Call to Action Name fields in the Show section.
  4. Apply the ‘Status = New’ filter, or as per your requirement.

  1. Click SAVE.

Create Second Dataset

To create the second Dataset:

  1. Click + TASK > Dataset in the Setup Rule screen.
  2. Enter the required task name and output dataset name as Fetch from Account.
  3. Select the source object as Account.
  4. Select the Account Name and Account ID fields in the Show section.

Rule1.png

  1. Click SAVE.

Merge Task to create single output 

To create a merge task:

  1. Click + TASK > Merge in the Setup Rule screen.

Rule2.png

  1. Enter Task Name (here it is Load to Customers), Task Description (Optional), and Output Dataset Name (here it is Load to Customers).
  2. Select the following options in the Criteria section, for the available fields as used in this example:
  • Merge: Fetch from Call To Action
  • With: Fetch from Account
  • Select Join Type: Retain all records from both dataset

Rule7.png

  1. Click MERGE ON FIELD. This adds the following fields (entered/selected data is for this use case):
  • Select Source: id
  • Select Target: Account  id

Note: Ensure that Output Field Labels should be unique in the Show Fields section.

Rule99.gif

  1. Click SAVE

Perform Action

To setup an action on the rule:

  1. Navigate to Setup Action.
  2. Click + ACTION and select Merge task.
  3. Select the Action type as Load to Customers.
  4. Map the newly created custom field with the COUNT of Call To Action Name and run the rule.

Rule4 - Copy.png

  1. Click RUN NOW

Note: Ensure that you uncheck the Test Run checkbox before clicking the RUN button.

Rule10.png

Create the Report

To create the report:

  1. Navigate to Administration > Analytics > Report Builder.
  2. Click + REPORT.
  3. Select the data source as Customer Info.
  4. In the Show me section, select the Account Name and Count of CTA fields.
  5. Click RUN.

Rule9.png

  • Was this article helpful?