✕
Skip to content
Article
Data Cloud Breaks $1B ARR Milestone in Q1 FY26: What...
Article
SF Ben Salesforce Admin Survey Results 2025: Download Now!
Article
Salesforce Summer ‘25 Release: Everything You Need to Know Before...
Article
Salesforce Announces 6% Pricing Increase and Unlimited Agentforce Licenses
Article
Data Cloud Breaks $1B ARR Milestone in Q1 FY26: What...
Article
SF Ben Salesforce Admin Survey Results 2025: Download Now!
Article
Salesforce Summer ‘25 Release: Everything You Need to Know Before...
Article
Salesforce Announces 6% Pricing Increase and Unlimited Agentforce Licenses
Article
Data Cloud Breaks $1B ARR Milestone in Q1 FY26: What...
Salesforce Ben
  • Events
  • Career
  • AppAssessor
  • Salesforce News
  • Articles by Role
    • Admins
    • DevOps
    • Developers
    • Marketers
    • Consultants
    • Architects
    • Business Analysts
  • Where to Start
  • Salesforce Certification List
  • How to Get Certified
  • Free Salesforce Practice Exams
    • Admin Practice Exam
    • Platform App Builder Practice Exam
    • Platform Developer 1 Practice Exam
  • How to Get a Job in Salesforce

Find us on:

Salesforce Ben
  • Events
  • Career
  • AppAssessor
  • Salesforce News
  • Articles by Role

      Articles by role:

    • Admins
    • DevOps
    • Developers
    • Marketers
    • Consultants
    • Architects
    • Business Analysts
    • Featured

      The Great Salesforce Job Market Reset

      By Sasha Semjonova

      December 09, 2024
      How to Avoid Bad Salesforce Partners: The Three-Question Test

      By Jon Cline

      January 08, 2025
  • Newsletter
  • user
    • Courses Login
  • Events
  • Career
  • AppAssessor
  • Salesforce News
  • Articles by Role

      Articles by role:

    • Admins
    • DevOps
    • Developers
    • Marketers
    • Consultants
    • Architects
    • Business Analysts
    • Featured

      The Great Salesforce Job Market Reset

      By Sasha Semjonova

      December 09, 2024
      How to Avoid Bad Salesforce Partners: The Three-Question Test

      By Jon Cline

      January 08, 2025

What’s trending

Bret Taylor vs. Marc Benioff: The Agent War We Should Have Seen Coming
Salesforce Announces Agentforce 3.0: Command Center, MCP, and Apps
Salesforce Announces 6% Pricing Increase and Unlimited Agentforce Licenses
SF Ben Salesforce Admin Survey Results 2025: Download Now!
Salesforce Marketing Cloud Next (vs. MCE, MCAE, MCG, MCA)

UPCOMING EVENTS

SouthEast Dreamin’

26
Jun

Atlanta, GA

Community

Portugal Dreamin’

27
Jun

Porto, Portugal

Community

How to Build Future Ready Approval Processes in Salesforce Flow

01
Jul

Virtual

SF Ben Webinar

Buckeye Dreamin’ 2025

07
Jul

Columbus, OH

Community

Architecture Insights for the Salesforce Ecosystem

08
Jul

Virtual

SF Ben Webinar
See more
Share
Marketers / Account Engagement (Pardot) / Analytics

Create and Join Datasets In B2B Marketing Analytics

By Jennifer Contino

October 14, 2022

B2B Marketing Analytics (B2BMA) datasets are a collection of source data that the B2B Marketing Analytics app formats and optimizes for your interactive exploration.

B2BMA comes out of the box with datasets and dashboards, providing you with a solid foundation. However, we may want to tell a bigger story, to expand on this information and bring in more data from Salesforce, Pardot (Account Engagement), or even a third-party app. Or, you may have received requests from your colleagues who want to see specific information. 

B2BMA allows you to create more datasets using the data manager. Let’s see how it’s done.

READ MORE: Guide to B2B Marketing Analytics (B2BMA)

B2BMA Data Sources: Bring Data Into B2B Marketing Analytics

There are three ways you can bring data into B2BMA.

  1. Create and upload a CSV file.
  2. Create a dataset from Salesforce. Data is “packaged up” into datasets and sent into CRM Analytics through dataflows.
  3. Connect to data in supported applications, data warehouses, and database services (this option may require additional permissions).

Tip: Before you create a Salesforce Dataset ensure your data is clean and complete. Bring in only the data you need. Remember to use a clear naming convention so you’ll be able to identify the datasets.

Create Datasets in B2B Marketing Analytics

For this example, we’ll create a new Salesforce dataset for campaigns.

1. Navigate to Datasets. Browse → All Items → Datasets.

2. Click Create → Dataset.

3. Click Salesforce Data for the default Salesforce dataflow.

4. Select Custom Object → Name your dataset → Add to default dataflow.

5. Name your dataset, and choose whether or not you’d like to add it to an existing dataflow or add to a new dataflow.

6. Select the Salesforce object you’d like to pull data from.

7. Select the + sign next to the Campaign object to add your fields. Select each field you’ll need for your dataset. Once you’re done selecting your fields, click next.

8. Select the app for your dataset. Click create dataset if you’re ready to create. If you want to edit more fields, click edit dataflow.

Your dataset is now in the queue to be created. To check the progress, go to the data monitor.

Join Datasets in B2B Marketing Analytics (Recipes)

You can group and combine data, or import data into your instance and combine it with the out-of-the-box data. Also, you can combine the out-of-the-box and custom datasets to choose only the fields you need.

For this example, we’ll use the newly created dataset for Salesforce campaigns and join it with the email template dataset. If you are looking for the click-through rate on a specific campaign, this would be a great use case to merge these datasets.

Email Template Dataset + Salesforce Campaign Dataset = Campaign CTR report.

1. Navigate to Setup → Data Manager → Dataflows & Recipes. Click Create Recipes.

2. Chose the base dataset. For this example, I’ll select “Pardot Email Templates”.

3. Name your new recipe → Click Next.

4. Click the ad data icon. Chose the dataset you’d like to combine with the base dataset. Make sure there is a field in common to match the data. For this example, I’ll select “Salesforce Campaigns”.

5. The Recipe builder will automatically suggest the field to match the datasets. Verify the field makes sense. An email address is a great example to use as a match.

6. Select the fields you need from your dataset → Then click “Done”.

7. Verify you have the form fields you need → Then click “Create Dataset”.

8. Chose the App location you want to save the dataset to.

9. Do you want it to run periodically (i.e. it will update the data when you tell it to).

When you go back to your datasets, you’ll see your new dataset available.

Summary

Thanks to B2BMA and its point-and-click interface, you’ve learned how to create and join datasets to create new visuals. Without clean and consistent data that feeds our visualizations, we wouldn’t be able to tell our story. So be sure that the data you are bringing in, is reliable, clean, and consistent.

B2BMA is included in specific packages if you don’t have it reach out to your account executive. For help in getting started, reach out to us here, for a complimentary consult, we’d love to help!

The Author

Jennifer Contino

Jennifer is a marketing automation consultant, who specializes in demand generation, at RoyCon Technologies.

More like this:

Marketers

Salesforce Marketing Cloud Next (vs. MCE, MCAE, MCG, MCA)

By Lucy Mazalon

June 16, 2025
Marketers

8 Takeaways from Salesforce Connections ’25

By Lucy Mazalon

June 16, 2025
Marketers

Calculate Credit Consumption With Digital Wallet in Marketing Cloud Next

By Lucy Mazalon

June 12, 2025

Leave a Reply Cancel reply

Newsletter:

    By signing up you agree to our Terms of Use and Privacy Policy.

    Find us on:

    Salesforce Ben

    Salesforce Ben
    Third Floor Library Building
    Sun Street
    Tewkesbury
    Gloucestershire
    United Kingdom
    GL20 5NX

    • Where to Start
    • Salesforce Certification List
    • How to Get Certified
    • Free Salesforce Practice Exams
      • Admin Practice Exam
      • Platform App Builder Practice Exam
      • Platform Developer 1 Practice Exam
    • How to Get a Job in Salesforce
    • Events
    • Career
    • AppAssessor
    • Salesforce News
    • Articles by Role
    • Admins
    • DevOps
    • Developers
    • Marketers
    • Consultants
    • Architects
    • Business Analysts
    • About Us
    • Contact Us
    • Write For Us
    • Influencer Program
    • Advertise With Us
    • Pledge 1%
    • Privacy Policy
    • Change Cookie Preferences
    • Log in to Courses

    © 2014-2025 SalesforceBen.com