Loading
Salesforce now sends email only from verified domains. Read More
Integrate and Analyze Marketing Data with Marketing Cloud Intelligence
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 Using the Query Builder

            You are here:

            1. Salesforce Help
            2. Docs
            3. Marketing Cloud Intelligence

            Create a Query Using the Query Builder

            Use the Query Builder to create the query without having to manually create the query in SQL. All you have to do is select the dimensions and measurements and then a query is created automatically. You can convert a query from the query builder into SQL and use it as a regular SQL query. For example, you can save or export the converted query.

            Required Editions

            User Permissions Needed
            To create a Granular Data Center query: Admin
            Note
            Note If you want to pull data from different tables in the Granular Data Center, first define the fusions between the dimensions on the Granular Data ERD tab.
            1. From the Connect & Mix tab, select Granular Data Center, and then Query Granular Data.
            2. Click Create New Query.
              create_query_builder
            3. Select Query Builder and then click Create.
              query_builder
            4. Click the plus sign next to the entity that you want to add (1). For example, add a dimension. A list of all the dimensions that exist in the Granular Data Center appears.
            5. Select the dimensions for the query.
            6. Repeat the same steps to add measurements. After you add measurements, you can change the dates for which you’re applying the query (2). The date is the past 30 days.
            7. To add a filter, click the plus sign in the Filter column (3). For example, if you want to only query a specific campaign.
            8. Click Run (4). The query results appear at the bottom of the page.
            9. To convert the query builder to SQL, click Create SQL Version at the top of the dialog.
              A new tab opens with the SQL, allowing you to edit the code if necessary.
              Note
              Note The converted SQL query isn’t saved automatically. If you want to save the query click Save. For more information, see Create a Query Using SQL.
             
            Loading
            Salesforce Help | Article