Loading
Feature degradation | Gmail Email delivery failureRead More
Einstein and Analytics in Marketing Cloud Engagement
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
            Click Rate Builder Calculation Example

            You are here:

            1. Salesforce Help
            2. Docs
            3. Engagement: Einstein and Analytics

            Click Rate Builder Calculation Example

            Use this example to see how data is pulled from connected data extensions (regions) and engagement data (sends, bounces, and clicks).

            Required Editions

            Available in: Intelligence Reports Advanced
            Region Sends Bounces Clicks
            EMEA 100 5 50
            AMER 150 15 65
            APAC 90 10 20

            Builder Calculations

            Logic

            Delivered = Sends - Bounces

            Formula 

            [email__sends_[engagement__data]] - [email_bounces_[engagement_data]]

            Logic

            Click Rate = Clicks/(Sends - Bounces)

            Formula 

            [email_unique_clicks_[engagement_data]] / ([email_sends_[engagement_data]] - [email_bounces_[engagement__data]])

            Query Results

            The builder calculations produce these query results.

            Region Delivered Click Rate
            EMEA 95 0.52
            AMER 135 0.48
            APAC 80 0.25
             
            Loading
            Salesforce Help | Article