Salesforce Reporting

Learn all about Reporting in eComm's instance of Salesforce, primarily to create audiences for communications sent via Marketing Cloud. Before diving into eComm data, it's crucial to have a basic understanding of the Salesforce Reporting interface. After, find templates of common populations to clone (below) with the option of further customizing and familiarize yourself with eComm's data dictionary to better understand the 500+ data points that can be leveraged.

Data Dictionary Entity Relationship Diagram

 

 

APPLY YOURSELF

Those tasked with creating audiences can apply the entire process by cloning the eComm specialist Training Plan. After reading the instructions below, navigate to the Reports & Data Extensions tab to practice creating a variety of Reports (populate Column C) while following along with the examples in the video below.

ROW 3 | 13:55, ROW 5 | 19:02, ROW 6 | 23:27, ROW 12 | 25:47, ROW 17 | 30:27

Templates

Affiliates

Alumni

Campaigns

Employees

Students

Grow into a Reporting Expert

Recorded Sessions

REPORTING ACCURACY TIPS

  • Confirming an accurate audience Report is crucial to getting your message to the right people. There are some methods to verify your work to avoid an incorrect Report.

 

  • Different Report Types can give the same result but with a different approach. For example, if you are reporting on contacts who are in a Campaign you could:
    • Use the Campaigns with Contacts Report Type and use Campaign ID in the criteria. That way you can drag in the Campaign Name column to confirm the Report criteria is as desired. 
    • Use the Contacts & Accounts Report Type and use Campaign History as a cross-filter to add Campaign ID in the criteria. In this case, you cannot pull in the Campaign Name column used in the cross-filter, making confirming accuracy more difficult.
  • Not sure what Report Type to use?
    • Start with the templates above OR
    • Select your Report Type, remembering that the available columns will be dependent on the Report Type objects

 

OPTIMIZE REPORTS

  • Large Reports can take a long time to run and can even result in a failed send. To avoid this, it's best to optimize Reports. When a Report is simplified, a very large population can still be sent successfully. If a send fails, there are steps to remedy it.
  • By limiting the number of records returned, adding a filter can significantly speed up reports.
    • Because they limit the amount of data returned by reports, you'd think filters would always make reports run faster. However because each record must be evaluated against each report filter, filters with complex logic can slow down reports. Apart from the performance-slowing filters described in this guide, adding a filter to return fewer records is a surefire way to speed up a sluggish report.
  • Filter with EQUALS instead of CONTAINS
    • When you set a filter with CONTAINS the report executes many steps to return data, which slows down the report. EQUALS executes in fewer steps, resulting in a faster report.
  • Filter with NOT EQUAL TO instead of DOES NOT CONTAIN
    • When you set a filter with DOES NOT CONTAIN the report executes many steps to return data, which slows down the report. NOT EQUAL TO executes in fewer steps, resulting in a faster report.
  • Don't filter by row-level formulas
    • Filtering by a row-level formula slows down reports. If you have a slow-running report that filters by row-level formulas, speed it up by removing the row-level formula filters.
  • Remove unnecessary columns
    • Much like returning lots of records can slow down a report, returning many columns can slow down a report. Many report types add a dozen or more columns to a report when it’s created. Removing columns you don't need speeds up the report.
  • Avoid using the filter 'Contact ID' to include a few people in a larger Report
    • For example, if you have a Report of students it seems convenient to include a few people from your office in the Report based on their Contact ID. These Reports should be separate, one for students and a second for those in your office you need to be aware of delivery. 

null

Field Editing Enabled

'Field Editing' within a Salesforce Report became available in early 2023 but has little use for eComm specialists. While technically you can click Field Editing Enabled and then edit cells in the Report by selecting the pencil icon, it will likely be overwritten (since 99% of our data is coming from a source system). The ONLY relevant use-case for eComm specialists might be updating data for Standard Contacts that they uploaded.

null

TEST YOURSELF eComm specialists and other audience creators - regardless of their previous experience - are highly encouraged to complete an extensive quiz to ensure a deep understanding of Campaigns / Campaign Members / Apsona annually. Please set aside 30-60 min. to complete the quiz of 35+ questions, many being open-ended. Do not miss the opportunity to review correct responses after submitting your answers to see how they match up for self-correction.