Loading
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
            Create a Query with a Data Extension

            You are here:

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

            Create a Query with a Data Extension

            Create a query with data extensions to view your engagement data with your data extension data. For example, view total clicks per region.

            Required Editions

            Available in: Intelligence Reports Advanced
            User Permissions Needed
            To Create a Query: Create & Edit

            To query the data extension you can use SQL or the Query Builder. If you’re using SQL, you can create complex use cases. If you’re using the Query Builder and you want to query both engagement data and extension data in the same query, you must make sure you created a join before creating the query.

            In this example, you can see how to query engagement data and data extension data using the Query Builder.

            1. On the Queries tab, click Create New Query.
            2. Name your query.
            3. Select Builder, and click Create.
            4. Build your query.
              For example, create a query to view total clicks per region. In this example, the dimension is Location (taken from the data extension) and the measurement is email_sends (taken from the engagement data).
              data_extensio_query
            5. If you’re using SQL, here’s an example of a join that produces the same results. 
              select data_extension.Region, sum(data_extension.email_unique_clicks) 
from engagement_data left join data_extension on engagement_data.subscriber_id = data_extension.ID 
group by data_extension.Region
            6. To run the query, click Run
             
            Loading
            Salesforce Help | Article