Spotler Help CentreCRM IntegrationsSalesforceSalesforce GatorMail User GuidesHow to create reports on GatorMail results within Salesforce

How to create reports on GatorMail results within Salesforce

GatorMail results can be used in order to target people for future campaigns.  This article shows you the steps required to filter a report based on GatorMail results

Create the Salesforce Report

Create the Salesforce Report
  1. Go to the 'Reports' tab
  2. Click 'New Report'

Select a CommuniGator Report Type

Select a CommuniGator Report Type
  1. Open 'Other Reports'
  2. Choose the report type you would to use (this decides which query fields are available to you).
  3. Click 'Create'

Building your report in the report layout screen

Building your report in the report layout screen
  1. You can drag fields from this area to the right, in order to see the data for those column headings
  2. This shows you the report data based on the heading and filters used
  3. You add filters here in order to retrieve results

Adding a report filter

Adding a report filter
  1. Select 'Add'
  2. Select 'Field Filter'

Apply report filter settings

Apply report filter settings
  1. From the dropdown list, select the field you would like to query on plus your operator and query.  The above example is to select all actions where the campaign name is equal to GatprMay News.
  2. Press 'OK'

Repeat adding filters until your parameters are set.

Running the report

Running the report

With parameters set, click 'Run Report'

Adding the report to a salesforce campaign

Adding the report to a salesforce campaign

Now the report has been run, you can add the results to a Salesforce campaign.

  1. Click 'Add to Campaign'

Associate the report with your campaign.

Associate the report with your campaign.
  1. Click the search button
  2. Type your campaign name search and select 'go'
  3. click on the correct campaign you would like to add members to
  4. Click 'Add to Campaign'.