Loading
Feature degradation | Gmail Email delivery failureRead More
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Purchases Filters

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Purchases Filters

            Here are some examples of common purchases use cases.

            Delayed Product Sales Orders

            This filter finds individuals who made a purchase and have an order status of delayed.

            Example
            Example
            • Sales Order | Count | At Least | 1
            • Sales Order Status | Is Equal To | Delayed

            Delayed Product Sales Orders Filter

            Find Combined Purchases and Order Number

            This filter looks for individuals who made purchases with a combined total greater than $1,000, their order numbers contained MARCH, and they self-identified their phone's contact point as based in New York City.

            Example
            Example
            • Sales Order | Count | At Least | 1
            • Order Number | Contains | MARCH
            • AND
            • Grand Total Amount | Is Greater Than | 1000

              AND

            • Contact Point Phone | Count | At Least | 1
            • City Name | Is Equal To | New York City

            Find Combined Purchases and Order Number Filter

            Combined Purchases and Order Start Date

            This filter finds individuals who made a combined purchase greater than $1,000, have an order start date in March, and a contact point city equal to New York City.

            Example
            Example
            • Sales Order | Count | At Least | 1
            • Grand Total Amount | Is Greater Than | 1000
            • AND
            • Order Start Date | Month Of Year | March

              AND

            • Contact Point Phone | Count | At Least | 1
            • City Name | Is Equal To | New York City

            Combined Purchases and Order Start Date Filter

            Gender, Sales Order, and Location

            This filter finds males who spent more than $300 and have a location of New York or Boston.

            Example
            Example
            • Sales Order | Sum | Grand Total Amount | Is Greater Than | 300
            • Grand Total Amount | Is Greater Than | 300

              AND

            • Contact Point Phone | Count | At Least | 1
            • City Name | Is In | New York, Boston

              AND

            • Gender | Is Equal To | Male

            Gender Sales Order and Location Filter

            Alternative Example
            Alternative Example
            • Sales Order | Sum | Grand Total Amount | Is Greater Than | 300
            • Grand Total Amount | Is Greater Than | 300

              AND

            • Contact Point Phone | Count | At Least | 1
            • City Name | Is In | New York
            • OR
            • City Name | Is Equal To | Boston

              AND

            • Gender | Is Equal To | Male

            Order Number, Sales Store, and Subject Line Engagement in the Last 3 Days

            This filter looks for customers who made a purchase in store number 1283, their order number contained 2020, and they clicked or opened an email with a subject line of NYC In Store Factory Refurbished Sale.

            Example
            Example
            • Sales Order | Count | At Least | 1
            • Sales Store | Begins With | 1283
            • AND
            • Order Number | Contains | 2020
            • AND
            • Order Start Date | Last Number Of Days | 3

              AND

            • Email Engagement | Count | At Least | 1
            • Engagement Channel Action | Is In | Click, Open
            • AND
            • Subject Line Text | Is Equal To | NYC In Store Factory Refurbished Sales
            • AND
            • Engagement Date Time | Last Number Of Days | 3

            Order Number Sales Store and Subject Line Engagement Filter

            Purchases in the Last 30 Days by Gender

            This filter finds individuals who aren’t male and made an order start date within the last 30 days.

            Example
            Example
            • Sales Order | Count | At Least | 1
            • Order Start Date | Last Number Of Days | 30

              AND

            • Gender | Is Not Equal To | Male

            Purchase by Gender Filter

            Previous Purchase but Not in the Last 30 Days by Gender

            This filter finds individuals who aren’t male and made a purchase more than 90 days ago but not in the last 30 days.

            Example
            Example
            • Sales Order | Count | Is Equal To | 0
            • Order Start Date | Last Number Of Days | 30

              AND

            • Sales Order | Count | At Least | 1
            • Order Start Date | Greater Than Number Of Days | 90

              AND

            • Gender | Is Not Equal To | Male

            Purchase a Product in the Last 30 Days

            This filter looks for customers who purchased at least two non-black hiking boots in the same order in the last 30 days.

            Example
            Example
            • Sales Order Product | Count | At least | 2
            • Product Name | Is Equal to | Hiking Boots
            • AND
            • Product Description | Is Not Equal To | Black
            • AND
            • Order Start Date | Last Number of Days | 30

            Purchased a Product by Month

            This filter looks for customers who purchased hiking boots or tents in May.

            Example
            Example
            • Sales Order Product | Count | At least | 1
            • Product Name | Is In | Hiking Boots, Tents
            • AND
            • Order Start Date | Month Of Year | May

            Purchased a Product but Not Another Product

            This filter looks for customers who purchased kayaks but no safety vests within a certain time frame.

            Example
            Example
            • Sales Order Product | Count | At least l 1
            • Product Name | Is Equal To | Kayaks
            • AND
            • Order Start Date | Is Between | 2020-05-01 AND 2020-06-01

              AND

            • Sales Order Product | Count | Is Equal To | 0
            • Product Name | Is Equal To | Safety Vests
            • AND
            • Order Start Date | Is Between | 2020-05-01 AND 2020-06-01

            See Also

             
            Loading
            Salesforce Help | Article