Creating a Custom Pardot Campaign Influence Model: Lessons Learned

Sometimes the standard Campaign Influence models that come with Marketing Cloud Account Engagement (Pardot) just don’t quite fit what you are looking to measure. We recently went through the exercise of creating a Custom Model, and it wasn’t quite as straightforward as we would have liked it to be. 

To save you some ramp-up time we’ve decided to share some of the things we learned. Here they are!

Lessons Learned the Hard Way while Creating a Custom Pardot Campaign Influence Model

We went ahead and created a custom Pardot Campaign Influence model and took excellent notes so you can reap all the benefits. 

Here’s what you should know before you start your own custom Pardot Campaign Influence Model project.

Simplify your Custom Model, then nail it down

There’s a lot of calculations needed in Campaign Influence, and the last thing you want to do is build this a few times as you discover exactly what you are looking for. 

Spend some time with the business and really think about which touches you really want to measure and if having them measured will drive meaningful business value. Can you explain it in 20 seconds or less? No? Your model might be too complex.

You have 2 options for integrating your Model

The simple example Salesforce provides as part of its documentation is to have a Trigger on the CampaignInfluence object, which allows you to create your records when Salesforce creates theirs.  This example is okay for demonstrative purposes, and it avoids a lot of the complexities. 

The example also works okay if the Model that you are “watching out for” creates and deletes CampaignInfluence records at the same time you need to. Though for us, often we discovered that we wanted our Model to recalculate, but it never did. This is because the default model didn’t need recalculating so no new records were created/edited. As a result, ours never had the chance to run. 

One way around this is to watch out for the b2bmaEvenDistributionModel as it has the most chance of adding/removing records, and firing off your trigger.

Another thing to consider (if you are relying on another model’s calculation to trigger your custom one) is that Salesforce doesn’t properly batch influence calculation. We learned this when turning off the Even Distribution Model and turning it back on hoping it would trigger calculation on all Opportunities. We ended up having our own Batch APEX class run to initially populate data for our new model.

If you need a little more control, you would need to introduce triggers on various objects (such as CampaignMember, OpportunityContactRole, Opportunity) looking for the events that would have an impact on your Model and cause it to recalculate. You might find luck here using Platform Events to separate the triggering event from all the processing that the Model might need, especially important as Opportunities often already have a lot of custom automations hanging around them.

Campaign Influence code runs as a special User

Salesforce’s CampaignInfluence records are created by a Special Salesforce User “Salesforce Administrator” which you can’t pick when setting up debug logs. You can find this User’s ID by looking at the CreatedById field of any of the CampaignInfluence records in your org.

Setting up a Debug log for this user is a bit more involved than normal, and needs you to manually create a TraceFlag entry referencing the special User as well as the Id of DebugLevel. We used https://workbench.developerforce.com ‘s REST explorer to create the record, and we used the SFDC_DevConsole DebugLevel allowing us to use the DeveloperConsole to check out the logs as we were testing.  A bit of setup for each debugging session, but worth it.

Break your code into debuggable chunks

We ran into a few different challenges as we were putting this together, and we found having our code broken up really sped up our debugging process. Each chunk of code had debug statements giving us an idea of the overall state / progress, which made it easy to quickly diagnose where things might be going awry.

While we aren’t yet ready to share a precise recipe, we can at least give you the ingredients we used!

  1. Build a list of Opportunity IDs of the Opportunities that need to be calculated
  2. Get all Opportunity details (including Opportunity Contact Roles)
  3. Get all needed CampaignMember records
  4. Calculate the “winning” CampaignMember records for each Opportunity
  5. Calculate the CampaignInfluence records needed from the “winning” CampaignMember records
  6. Insert final results

Plan for custom Campaign Influence Model success

Creating a Custom Campaign Influence Model is not for the faint of heart. It takes quite a bit of planning and work to put together even the simplest of Models (which might be why there’s so little out there when we tried googling for examples). 

If you are looking to take this on, hopefully these tips save you a bit of frustration and colorful language. If it still looks daunting and you need some help, we would love to have a chat!

Further Reading

Original article: Creating a Custom Pardot Campaign Influence Model: Lessons Learned

©2022 The Spot. All Rights Reserved.

The post Creating a Custom Pardot Campaign Influence Model: Lessons Learned appeared first on The Spot.

By |2022-10-19T18:44:00+00:00October 19th, 2022|Categories: Analytics & Reporting, Pro Tips, revive, Strategy|

How to Choose a Salesforce Marketing Reporting Tool

Not sure which Salesforce marketing reporting tool is the best for showing the results of your campaigns? 

With so many to choose from between Salesforce CRM, Marketing Cloud Account Engagement (Pardot), and CRM Analytics, it can be difficult to nail down what reporting tool is the best fit for you. 

While all the tools described here (to some extent) can be used to meet each criteria, some do it better than others. 

Questions to determine which Salesforce marketing reporting tool is best for your team’s goals 

We’ll help you narrow it down with some simple questions and a review of what each tool excels at! Hint: They all contain the letter “A”!

Question 1: What are you “asking” of the data?

While there are many uses for data, breaking down what you want into categories can help you create specific and purpose driven reporting content. 

What that content is meant to inspire is the million dollar question. So… “What do you want your data to do for you?”

I Need Operational Data!

This type of reporting is really ideal for managing day to day metrics. The key here is that these are used to keep a pulse on the health and activities that keep your business running day to day. 

  • How many deals were open, closed, won or lost?
  • How many tasks were completed?
  • What is overdue? Or due today?
  • Who are my best performing Salespeople?

Best Fit: Salesforce

Why? Salesforce reports excel at showing data in a way that tells you what’s going on right now. Built-in report types give you easy access to history data and other commonly used data. 

Need a quick list or visual to get the point across that is specific to a specific business metric? It’s easy to do (assuming you have the data in place). Another cool feature is that your reports and dashboards can be tailored to run as the person opening them, making them a custom fit and focussed.

I Need Trending Data and Patterns, preferably in visuals!

  • How fast are we closing sales?
  • How is the pipeline looking for Q2 Compared to Q1? What had the most impact?
  • Which activities lead to sales?
  • How are my KPI’s Performing to goal
  • What are my leading or lagging indicators?

Best Fit: CRM Analytics

Why? Of all the tools this is the one that allows you to do “gymnastics” with your data and connect lots of things together. It also has much more robust visualization options, allowing you to connect and visualize data more easily. 

Built-in apps provide “purpose” driven dashboards and insights based on best practices. You can have many filters and even specify which dashboard items interact with which filter! 

While you can do some trend analysis in Salesforce, CRMA brings it to the next level. To top it off, if you have the right license, predictive analytics are within your reach.

I Need Marketing Asset Intelligence!

  • What is the health of my campaigns?
  • I need to create list reports to segment and manage prospects!
  • What marketing activities are leading to increased engagement?
  • What activities are occurring? Or have occurred?
  • How is my nurture program performing?

Best Fit: Pardot Reporting

Why?: Pardot is purpose built to surface marketing metrics and streamline prospect management. Reports on common metrics (click through, open-rate, bounce rate opt out etc.) are available. While more limited in the sense of customization, these are critical metrics for every marketing department and company and help you keep a pulse on the health of your assets.

Other considerations for selecting a Salesforce marketing reporting tool

Who is your audience?

This one is really all about functional role and (ahem) attention span. Think about the following questions to determine how audience affects which Salesforce marketing reporting tool to use:

  • How much time does the audience for the report have time to absorb the information? Does it come from multiple sources? 
  • Are they open to navigating many reports? 
  • How many filters are needed on the front end? 

If your audience does not use your reports, then all the platforms are equally terrible. Always consider useability and make sure you consider hidden costs when comparing value.

Leadership Team (C-Suite) 
  • These stakeholders tend to want a 5,000-foot strategic view that can be visually absorbed quickly and without too much explanation or time. For this group, CRM Analytics is a good fit since its strength lies in optimizing connected datasets in a visual way.
Operational Managers
  • This group often wants to look at the high-level metrics, but also be able to dig into the records and data when a pattern or interesting number stands out. For these stakeholders, Salesforce reporting can be the best choice. 
Marketing staff, Designers, Marketing Managers (admins, marketing staff etc)
  • As the lifeblood of marketing, these stakeholders need quick and easy access to see who is a best fit for nurture programs, check scoring and grading status and see what assets are performing best. Pardot reporting provides this view and the data that’s needed day to day.
Analytics Staff
  • When you need ALL the data and want to know all the things, a deeper tool is needed. CRM Analytics allows the high-level and low-level data and allows the ability to create unlimited customized datasets to use for reporting. Additionally with licensing upgrades, the power of Einstein predictions can be unleashed. Fun fact, this data can be written back to Salesforce with the Salesforce Data connector, adding even more potential uses (teaser for a future blog 😉).

What resources do you have available for reporting and analytics?

Ok, so this one is kind of a trick question. No one ever has enough time or money… But it does matter. Having the right resources to develop your brilliant report or having the time to consume report content is critical. 

How can you get the most out of each platform if you are strapped for resources? Any of the choices requires expertise and time to master customization or modification. But many “no effort” solutions also exist out there. 

Also, while tools like CRM Analytics are pricier, consider the time to create 10 reports in Salesforce to get the same information and the limitations around connecting objects. Additionally, consider the pitfalls around manual reporting (Excel gathering) and the potential data and time issues that can occur. Consider all the costs of NOT having a single version of the truth. 

How can I stretch my time and budget around Salesforce analytics? 

Here are resources that might help.

Salesforce: Check out the app exchange for many free useful examples and fully functioning Dashboards. Everything from adoption metrics to quality check dashboards can be had at the click of a button … and many are free. 

CRM Analytics: This one is license specific, but you don’t need a data scientist to install apps such as B2BMA analytics (included for many Pardot  versions – more information here).

Pardot: Sometimes less is more! This documentation around all reports Pardot will get you pointed in the right direction!

Which Salesforce marketing reporting tool is best? It depends…

So in conclusion, while each reporting platform has its strengths and weaknesses, the strongest is the one that presents the right content, to the right audience at the right time. 

We hope the information in this post helps you to nail down which tool is right for your unique situation. 

Still not sure? Drop us a line and we’ll see how we can help you.

Original article: How to Choose a Salesforce Marketing Reporting Tool

©2022 The Spot. All Rights Reserved.

The post How to Choose a Salesforce Marketing Reporting Tool appeared first on The Spot.

By |2022-10-10T18:27:00+00:00October 10th, 2022|Categories: Analytics & Reporting, Pro Tips, revive, Strategy|

Pardot Scoring & Grading Lab

As inbound marketing efforts continue to grow across industries, marketers are having to come up with new ways to qualify the best of these new leads. Once they’ve been qualified by marketing, the next challenge is making sure the sales team gets the lead at the right time in their journey to capitalize on their interest. 

With Marketing Cloud Account Engagement (Pardot) you can use prospect scoring and grading together to surface the most relevant leads. Combined with the automation tools built into the platform, you can save time by automatically qualifying leads and routing them to the appropriate sales person or team. 

In this blog, we’ll discuss how these two systems work together and the best ways to automate your approach.

Pardot Prospect Grading

Prospect grading takes place once you have set up your company’s ideal customer profile (ICP) and have a set of factors to evaluate a new prospect on. The best ICP’s are made up of quantifiable data, like number of employees, industry, job title and location. 

Once you have determined your criteria, you can provide the information to Pardot, and the system will automatically apply a letter grade (A-F) to prospects as new data is collected. 

To learn more about setting this up, check out Pardot Grading 101

For now, let’s take a look at some of the common criteria that marketers use to grade their prospects:

 

  • Location – If your organization uses geography to prioritize leads, you can adjust a prospect grade based on what location they provide.
  • Industry – Market and sell only to the industries that your business is targeting.
  • Job Title – Be sure you’re reaching the influencers and decision makers at an organization.
  • Company Size – Be Goldilocks and only reach out to the companies that are just right for you.

     

Try it out for yourself!

Not sure how prospect grading works in the real world? Here’s a chance for you to see how this functionality might work in your own organization.

Tell Us About Your Ideal Lead:

What sized companies do you target?



What industry do you typically target?



What department do you sell to?



Who are you typically targeting?





Joe is new inbound lead

D+

Pardot Prospect Scoring

You can use the Pardot prospect score in conjunction with the prospect grade to make sure only the best leads are being passed on to the sales team as qualified. Lead scores are a numerical value that can help you determine how interested a prospect is in working with your company. 

With prospect scoring, you assign points to the actions you decide are the most important. These points are totaled up and displayed as the prospect score and helps you determine how engaged a prospect has been with your marketing materials.

Let’s take a look at some of the actions you could use to influence a prospect score:

  • Page Views – Increase a prospect score with every page visit on your website.
  • Form Submission/Landing Page Success – Add points if a prospect fills out an important form on your website or landing page.
  • File Access – Adjust a score based on a prospect downloading an important file. 
  • Email Clicks – Good interaction with your email content may be an important indicator of how interested a prospect is in your offerings.

Let’s see it in action

I mentioned earlier that using prospect scoring and grading together can help to only qualify the best leads and send them to the sales team. Using these two tools can give you a better understanding of the prospects you’re working with and how to market to them appropriately. 

Check out each of the leads below to learn more about how their score and grade impact marketing efforts.

Roy

Roy is a great fit for your product or service, but either hasn’t had time to do any research, or doesn’t know that your product exists yet. This lack of activity is why he has a high grade, but a low score.

Recommended Action: Call him or place him on a nurturing campaign.

Ryan

Ryan is a student interested in an internship with your company. All of his activity on your site (like browsing your careers page) has given him a great score, but since he is not going to purchase, he receives a low grade.

Recommended Action: Do not assign Ryan to a sales rep.

Katie

Katie is enthusiastic about your company, but may not be the best fit for your product. This gives her a decent score, but moderate grade.

Recommended Action: Nurture Katie with a drip campaign to conserve resources.

Renee

Renee is a great lead who has been working with your sales team for a while. She has done her research, has a lot of interest in your product, and fits your ideal profile. This gives her a great grade and terrific score.

Recommended Action: Send Renee pricing and bottom-of-funnel resources.

Better Together: Pardot Prospect Scoring and Grading

Prospect scoring and grading can work fine separately, but I think they work best when used together as seen in the example above. 

With automation rules, you’re able to tell Pardot to send prospects to the appropriate sales representative and add them to lists or engagement studio programs when they reach the right combination of score and grade. This helps to ensure only the best leads are being sent to the sales team, and that you’re sending the right information to the right prospects at their stage of the buying cycle.

Don’t be afraid to subtract points or letter grades for bad matches, either! You can use page actions to subtract points from a prospects score if they (for example) visit your careers page. You’re also able to set up grading to lower a prospects letter grade if they’re the exact opposite of your ideal customer profile. 

Let me know in the comments if you’ve got more questions about these two tools, or reach out to us for help with your own prospect scoring and grading strategy.

Original article: Pardot Scoring & Grading Lab

©2022 The Spot. All Rights Reserved.

The post Pardot Scoring & Grading Lab appeared first on The Spot.

By |2022-09-29T14:30:58+00:00September 29th, 2022|Categories: Marketing Automations, Pro Tips, revive, Strategy|

Connected Salesforce + Pardot Campaigns: How They Rock Our World

Salesforce and Pardot connected campaigns bridge two distinct campaign reporting functions into one powerful feature. 

Prior to 2019, Salesforce and Pardot campaigns were independent of each other. But with the introduction of connected campaigns the two entities joined forces. And with that, the humble marketer’s life is made easier. 

The Difference Between Salesforce and Pardot Campaigns

Before we jump in, let’s do a quick 101 refresh on the difference between Salesforce campaigns and Pardot campaigns.

The Skinny on Pardot Campaigns

Pardot campaigns refer to the first touch interaction that could be tracked. It answers the question: “What brought this person to us?”

For example, let’s say someone visits your How to Be Good At Stuff webinar page. They didn’t sign up, came back 30 days later, and converted to a lead by downloading your I’m Awesome at Stuff whitepaper. Their campaign would be set to the How to Be Good At Stuff webinar, since that was the first initiative that brought them to you.

Pardot campaigns are one-to-one. That means each person has ONE source campaign. And every asset created in Pardot has to be tied to one campaign as well.

This gives you useful reporting data on the number of leads sourced by your campaigns and how these convert into closed-won opportunities downstream in the pipeline.

How Salesforce Campaigns are Different

Salesforce campaigns are more… how normal people think about campaigns. Campaigns are marketing initiatives, and each contact or lead can belong to multiple campaigns.

Tracking this in Salesforce is hugely impactful. If you leverage Salesforce campaigns to record who you touch with your marketing efforts, then you’re laying the foundation to be able to show all of the marketing touchpoints that led to a sale on each of your opportunities:

Opportunity Dashboard

And at the campaign level, you can see the total volume of opportunities that were influenced by your marketing activities.

Salesforce Campaign dashboard

Marketers have been talking about revenue attribution for the last decade. But for most organizations, this stops with “talk.” We all like the idea of being able to link marketing campaigns to hard revenue numbers, but our disparate systems and measurements make that incredibly hard to deliver.

Campaign influence reporting finally makes revenue attribution doable for a typical marketing team — all with tools native to the platform. This comes together in first touch, last touch, or any other custom attribution models your team needs to analyze the impact of its marketing spend.

Campaign performance dashboard

How to Set Up Connected Campaigns in your Pardot Org 

The good news is that connected campaigns are automatically activated for Pardot orgs setup after 2019. But, there are a few settings we’ll want to take a look at to make sure everything is functioning.

 The magic is in the Pardot connector!

Connected campaign settings are managed by the connector that bridges Salesforce and Pardot. 

In Pardot Lightning…

  1. Click on Pardot Settings
  2. Connectors (on left menu)
  3. Click the settings cog under Actions on the right for the Salesforce connector
  4. Select Edit Settings

On this screen, you’ll notice the campaign that is being used to connect contacts that come from Salesforce into Pardot. They will be marked with this “first touch” campaign when they sync from Salesforce. If you do NOT have a campaign here, you should create a campaign in Salesforce, something generic like “Salesforce Contacts,” and select it here. 

Question: I created the campaign in Salesforce and it doesn’t appear in this picklist?

This is pretty common. There are three reasons why the campaign would not appear, here are some troubleshooting steps…

  1. When setting up the campaign in Salesforce you must check the box to make the campaign “Active.”
  2. Be patient! It can sometimes take 5-10 minutes for the campaign to appear in Pardot. You may need to refresh the connector settings page to see it appear.
  3. As a last resort, delete the campaign you created in Salesforce and create a new campaign. You might be shocked at how often this solves the problem.
Connector Settings

Let’s Look at Campaign Settings

Once you have the connector settings worked out, click on the Campaigns tab at the top.

Pardot Settings, campaign tab

Let’s take a closer look at the setting options.

  • First, ensure the check box for “Enable Connected Campaigns and Engagement History” is checked. This should already be checked by default, which turns on all the wonderful connected campaign magic. 
  • Enable Campaign Member Sync should also be checked to ensure that when you add people to your campaign in Salesforce or Pardot they stay in sync. Note: If you add people to a campaign in Pardot but they do not exist as Contact or Lead records in Salesforce, you will not see them in Salesforce under that particular campaign. 
  • Use Salesforce to manage all campaigns should be checked allowing you to create and manage campaigns in one place — Salesforce! No more duplicating efforts in Pardot.
  • Limit Campaign Creation by Date – this handy feature gives you the ability to limit what campaigns sync to Pardot. If your Salesforce org has been around for a while, it undoubtedly has campaigns that were created and you may not wish to clutter Pardot with old campaigns. You can select a cut-off date here!
  • Show unconnected campaigns in Pardot Campaigns tab is good to check if you wish to see what campaigns in Pardot are not connected to Salesforce. As the subtext under the box states: Unconnected campaigns are always shown unless Manage Campaigns in Salesforce is enabled.
  • Finally, Campaign record types enabled for connection. This will say “Master Record Type” by default if you only have one Salesforce campaign record type. But some orgs are fancy and have multiple record types for different parts of the business. If this is the case, you can select which record types should sync to Pardot.

Once Connected Campaigns are flowing here’s what you’ll notice

  • All new campaigns will be created in Salesforce — you can not create campaigns in Pardot.
  • Every time you add a new active campaign to Salesforce, it’s automatically available in Pardot.
  • You can add campaign members in Pardot through automation rules or completion actions. As long as they are assigned to a user, they will sync to Salesforce and show up as members of that campaign in Salesforce. 

PRO TIP: If you have a campaign set up for a weekly or monthly newsletter, add a completion action to your signup form. This ensures that when a prospect fills out the form, they are automatically added to that campaign.

These campaign fields will also be updated by Salesforce and pushed to Pardot:

  • Name
  • Cost
  • Created By
  • Updated By
  • Updated At

Now for the Really Exciting Stuff: Show Engagement History on the Campaign in Salesforce & Report On It

To add another layer of awesomeness to this, Connected Campaigns allows you to also enable Engagement History on Salesforce campaigns.

What this means is that on Salesforce campaigns that are connected to Pardot campaigns, you can pass engagement metrics from:

  • List emails
  • Forms
  • Form handlers
  • Links & custom redirects

When you turn on Engagement History, new custom objects called ListEmail, MarketingForm, and MarketingLink are created and populated with data from corresponding Pardot records. These records DO count against your org’s data storage limits. 

Important: these custom objects do need to be added to your Campaign page layout! Here are detailed instructions to do this.

Benefits of Enabling Engagement History

Enabling Engagement History lets you add KPIs for these assets to the Campaign Page Layout:

Engagement History

And even better, it lets you get at this data in Salesforce reports & dashboards:

campaign report

My heart literally flutters with anticipation of the power this is going to bring to marketers on the platform.

 A few general FYIs on what you need to make Engagement History work:

  • Connected campaigns set up (duh)
  • Prospects syncing with a Salesforce lead or contact, and added to the connected campaign
  • The prospect must be assigned to a user, group, or queue in Salesforce (a requirement for it to sync to Salesforce in the first place)
  • To access Engagement History data, users need the Sales User or CRM User standard permission set and field-level security access to the engagement history fields.

Ready to Roll with Salesforce and Pardot Connected Campaigns?

Once you experience connected campaigns, there’s no going back. (Literally and figuratively. Once it’s on, it can’t be turned off.)

To make this magic happen, you will need your Salesforce admin on board, since a lot of the configuration changes take place inside Sales Cloud. 

Do you utilize the power of connected campaigns? What’s your experience been? We’re dying to know — please share with fellow readers in the comments!

Original article: Connected Salesforce + Pardot Campaigns: How They Rock Our World

©2022 The Spot. All Rights Reserved.

The post Connected Salesforce + Pardot Campaigns: How They Rock Our World appeared first on The Spot.

By |2022-09-19T14:37:00+00:00September 19th, 2022|Categories: Analytics & Reporting, Data Management, Pro Tips, revive|

Salesforce Native Reporting: Get More From Your Data

Salesforce has robust native reporting capabilities that come out of the box. But what happens when you need more? What CAN you do? 

This Salesforce native reporting overview will make you a custom operational reporting superstar. That’s because it highlights the ways you can leverage custom objects and use joins in your reporting. 

The good news is, once you know what’s possible, the world of Salesforce reporting is much easier to navigate.

Where to Start: Create a Lookup Relationship on a Custom Object

We’re going to start by going through the process of creating a lookup relationship on a Salesforce custom object.

Why start here? In short, all Salesforce reporting is based on relationships between objects. 

Let’s say you have a custom object where you store all of your team’s required compliance paperwork. You want to report on which opportunities need which paperwork within that custom object. 

While you can create a custom report type for your custom object, there is no link between Opportunities and your custom object. 

The good news is that you can create one! 

Example: Creating a relationship between custom object and Opportunity

Here’s an example that we can use as we move through our reporting exploration. Specifically, these are the steps to create a relationship between a custom object and an Opportunity in Salesforce:

  1. Open the custom object. In this case, I have created a custom object called “Compliance Documents.”
  2. Select Fields & Relationships.
  3. Select “New” to create a new field.
  4. Select “Lookup Relationship.”
  1. Select “Opportunity” as the Related to. This will create the relationship between Opportunity and the custom object, making them “linked” for reporting and other related purposes.
  2. If you want the relationship to be consistent and there should be a value selected, make sure to select “Always require a value in order to save the record.” Also make sure that “Add this field to existing custom report types that contain this entity” is checked.
  3. Click through the next few screens to verify permissions, Related list label and select what layouts to the new field to.

With these steps, you can now add the custom object in a report type AND the related list will appear for the Opportunity. So easy, right?

Exploring Salesforce Custom Report Types

So, now that we have linked our custom object with a lookup relationship, let’s get ready to report!

Use the following example to inspire your use of native Salesforce reporting capabilities.

Use Case Example: Set up a custom report type 

You want to be able to see what type of compliance reports have been completed (and what opportunities do NOT have documents) for your Opportunities. To accomplish this, we will set up a custom report type. 

  1. Go to Setup and select “Report Types.”
  2. Click “New Custom Report Type.”
  3. Select the Primary object (see tip below for more information).
  4. In our case, we will use Opportunities as our base object. We are interested in both Opportunities that have documents AND those that don’t. So, we’re calling it “Opportunities with or without Compliance Documents.”
  1. Now we can select the related objects. In this case, we want to see Compliance Documents. 

Because our custom objects were created to support Activity creation, and Activity creation links to the Assignment object, we can add all these to maximize our report.

NOTE: We are selecting “A” Records may or may not have “B” records so we can see how many of our total Opportunities have records. If we selected Each “A” record must have at least one “B” Record, we would ONLY see these records and not be able to compare (which will be handy in our report).

  1. Save your changes.

Tip: What is the Primary Object?

The primary object is the “base” Object for your report. You can select a custom or standard object. To decide which to select, consider what fields you want and whether they are connected as you select these. 

Remember that all reporting starts with relationships between objects. One tool that can help you “see” the relationships in Salesforce is the Schema Builder in setup, which is where you can select your objects and get a visualization of how they are connected. 

Good news for us, Salesforce report types makes this easy by only allowing you to select objects that are related and have lookup relationships. If you don’t see a child object, it’s because there isn’t a defined relationship. 

Add Lookup Fields in Salesforce Custom Report

So, great news! You have connected your custom object to a standard object and created a new report type. But what other data can we add from here? 

Let’s see what we can add using the “edit layout” section of the Report Type.

  1. Click on “Edit Layout”
  2. On the left, you can dropdown the list under “view” to see the objects in your report type.
  1. Use the “Add fields related via lookup” to see what you can add to your report from other related objects.
  1. You can see all the objects that have a relevant relationship to “opportunity” in this window. Clicking on the object name allows you to select fields to add to your report.

    In the example above, I am adding Account Name and Account Number. You can change the view to show any of the objects in the custom report type to select related fields. You can see which fields were added by lookup easily since they have a magnifying glass next to them in the layout window.

NOTE: Watch out for duplicate fields. For example, if I select the ID for Account using the related lookup, I will end up with two almost identically named fields when creating reports, which could be confusing. Not all lookup fields contain data. If a field is not required in a related object field, you may not get any additional data (just empty fields)

  1. You can add sections, add and remove fields and do many other fun things in this window, but we’ll move on to creating our report with our shiny new report type! (more information on working layouts here.) For our use case, we are ready to move on.

Creating a Report Using Your Custom Report Type

Finally all your work will come together in an amazing report! Let’s jump in!

  1. Go to Reports
  2. Click on “New Report”
  3. Be sure to select “all” to search for our New Custom Report type
  1. On the right, you can quickly see what reports have been created with this report type and what objects are included. Click on “Start Report”. You can add whatever fields you need.

Using Cross Filters to Filter Records Based on Related Objects

Now that I have a report in progress, what else can I do to use other objects with it? One example of this is a cross filter. 

A cross filter allows you to filter your report type based on a related object. For example, If I have a report type based on opportunities, I can use a cross join to limit the results to opportunities that have related campaign influence records (without actually having to include the Campaign Influence object in the custom report type).

  1. Click on “Filters”
  2. Select the drop down next to filters and select New Cross Filter
  3. Select Opportunities as the “show me” and Campaign Influence as the limiter

    NOTE: You can use “With” or Without” as the criteria to return records.

TIP: Check out the Sercante Campaign Influence Starter Pack for more information.

Using Joined Reports in Salesforce to Enrich Your Data

Joined Reports in Salesforce are a little tricky to understand but can be VERY practical. Here’s how the feature works.

Consider the following use case. You want to be able to show Products on Opportunities related to those with compliance documents. Your custom report type does not have Product information. 

No worries at all! If there are related fields between the two report types, you can join them together in blocks.

Here’s how to do that:

  1. Click on “Report” at the top left of your report window.
  2. Click on “Joined Report,” and click apply.
  1. Click on Add Block.
  2. Select the Opportunities with Products block.
  1. Use the lookup window under “Group Across Blocks” to pick the field you want to group on. This will create a connection on a common field. 

In this case OpportunityID is most appropriate since I want to see detail for each opportunity. You can now see the fields I selected from my Custom Report type and fields I selected from the Opportunities with Products report.

NOTE: Once you create a Joined Report, you also need to manage filters for each one separately under the filter area. 

Now you can see how the Joined Report enriches your data! We can see if any Opportunities with or without documents have products linked.

So what happens now?

In our little summary we have reviewed the ways in which you can show data in Salesforce reports through Lookup relationships on objects for the following:

  • Custom reports types
  • Lookups on Custom report Types
  • Joined Report
  • Cross filters

The wonderful world of Salesforce Reporting is constantly changing and improving with every release. Knowing what you can do to bring your data together is the key to creating meaningful, actionable reports. 

I hope this summary helps in your understanding of what’s available and related use cases.

Looking for information about Salesforce native reporting?

Salesforce has a wonderful help section with videos and how tos that can help you on your journey. And remember, you can always reach out to the team at Sercante if you have any questions. 

Tell us what you’re going to build using Salesforce native reporting capabilities in the comments section.

Original article: Salesforce Native Reporting: Get More From Your Data

©2022 The Spot. All Rights Reserved.

The post Salesforce Native Reporting: Get More From Your Data appeared first on The Spot.

By |2022-09-16T14:21:00+00:00September 16th, 2022|Categories: Analytics & Reporting, Data Management, Pro Tips, revive|

Automation Facelift: Migrate Workflow Rules and Process Builder to Salesforce Flow

With Salesforce moving to Flow as its go to low-code automation tool, and Workflow Rules and Process Builder planned for retirement, it’s a good idea to migrate your existing automations to Flow. Here are best practices to get started on this process BEFORE you begin migrating.

Reviewing Your Current Automation Stack

Depending on how old your org is, it may have a lot of legacy configurations from old or obsolete business processes that don’t mean anything for your organization today. Do you really need to bring all of that technical debt along in your migration process? Or would you rather have an opportunity for a fresh start with your automations?

Before jumping in and migrating all of your current automations, this is a good opportunity to develop a migration strategy so that the changes being made now will meet the current and future needs of your organization. 

Develop a Salesforce Flow Migration Strategy

STEP 1: Audit your current workflow rules and process builders

First, inventory your list of workflow rules and process builders and perform an analysis. Here is a template you can use for your audit (click File > Make a copy).

When looking at your current automation, consider the following questions:

  • Which automations are active?
  • What automations are still relevant?
  • How many automations are there per object?
  • How complex is each automation?
  • Can any automations be combined?
  • Which automations make updates to the same record that triggered it?

STEP 2: Decide Which Automations to Migrate

After completing the audit, you will have a better idea of the automations in your org, which are still relevant and need to be migrated, and which can be decommissioned. 

This is also a great time to decide on which you will consolidate. Candidates for consolidation are:

  • Automations on the same object with the same trigger criteria. For example if you have 3 workflow rules that trigger from a Lead Status change, these may be a good candidate for combining into a single flow.
  • Automations that include field updates on the triggering record.
  • Automations that have similar components that could be combined into a subflow that’s called from each flow.

STEP 3: Prioritize Your Migration Plan

As you assess the automations in your org, you will become aware of those that are critical vs nice to have, and which can be combined into a single well performing flow. Use this understanding to prioritize the workflow rules and process builders you want to tackle first.

STEP 4: Get Familiar with Salesforce Flow

If you’re not familiar with Flow, and the types of flows available, this should be your next step before jumping in, to help make informed decisions about your flow strategy.

There are many resources available to help you get started.

You can check out my recent blog post for more information and links to a few great resources. Or this one from Mike Morris that outlines a process to manage Salesforce campaign activation with Flow.

STEP 5: Decide on a Flow Strategy

Ok so you know what workflow rules and processes need to be migrated and which to tackle first. So how are you going to actually migrate them? 

Salesforce Migrate to Flow Tool
  • Salesforce provides a Migrate to Flow Tool to help with the process of migrating current Workflow Rules and Process Builder to flow.
    • Support for migrating Workflow Rules is generally available as of Summer ’22.
    • Support for migrating Process Builder is coming and estimated early 2023.
  • The tool is very easy to use and does pretty much all of the lift in the migration process, creating the flow with start criteria and each action, and even makes it easy for you to deactivate the old and active the new.
  • One consideration is that the current version of the tool will migrate each workflow rule into its own flow. So if you have 20 workflow rules and use the tool to migrate you will end up with 20 flows. Will this work for your org?
Third-Party Migration Tools
  • The UnofficialSF site has a tool called ConvertToFlow v2 that can be used to convert Workflow Rules and Process Builder. I personally have not used it but it has been recommended in the community.
Building Flows Manually

If you have identified automations that can be combined, or are migrating process builders, you will no doubt build some flows. Before clicking that New Flow button, decide on:

  • Will this be a ‘Before Save’ vs ‘After Save’ record-triggered Flow?
    • Will the flow make an update on the same record that triggered the flow? If yes then a Before Save flow may be the best fit for better performance.
    • Will this flow be invoking an action or creating/updating related records? Then you will want to create an After Save flow.
  • Is there an existing flow with the same entry conditions? Can it be updated to include the logic you are currently migrating?
  • Is there an existing flow that has the same components involved? Can those components be converted into a subflow to be used in each of the flows?

Step 5: Build your Flow(s)!

Now that you have completed all of this awesome prep work, you are ready to roll up your sleeves and get building!

Questions about using Salesforce Flow? 

Let us know how you’re using Salesforce Flow in the comments section, or reach out to us with any questions.

We’re here to help!

Original article: Automation Facelift: Migrate Workflow Rules and Process Builder to Salesforce Flow

©2022 The Spot. All Rights Reserved.

The post Automation Facelift: Migrate Workflow Rules and Process Builder to Salesforce Flow appeared first on The Spot.

By |2022-08-06T00:16:00+00:00August 6th, 2022|Categories: Marketing Automations, Pro Tips, revive, Strategy|

Three Interaction Studio Features Marketers Should Look Out For

This blog delves into the value that Salesforce Marketing Cloud Interaction Studio provides to marketers (B2B and B2C). We’ll discuss Interaction Studio and its key capabilities with a focus on identity stitching and machine-learning-based recommendations.  

In addition, we’ll talk about the integration capabilities with Salesforce products including the three Marketing Cloud tools that could benefit marketers, which are Open-time email, Journey Builder, and Automation Studio.

Interaction Studio Use Case Example

An example of a use case with Interaction Studio is when customers view a product in-store, browse through the web, download a mobile app to use a voucher, make a purchase, and talk to a sales representative after a few days, multiple touchpoints and delivering a consistent experience is needed. 

That’s where Interaction Studio comes in, unifying the customer experience with its features.

Web

Based on the user’s interaction with the website (e.g. what content they read, or what products view, how much time they are on a particular page), a personalized banner based on on-site behavior and backend preference is enabled. 

Instead of a static banner on the homepage, Interaction Studio activates a dynamic banner in conjunction with the user’s behavior and data.

Email

A personalized email is uniquely catered based not only on aspects such as name, or city but with micro nuances such as user behavior. 

Omni-channel

Interaction with a user happens on a specific channel, but reaching out happens on another channel. What we’re looking at here is adding a user on a journey or a nurture campaign when they sign up from a form on the website.

Common Thread between Interaction Studio use cases

Each of the three use cases is unique in its own features but a common thread to all of them is personalization

Interaction Studio puts web tracking cookies on your website to listen for all the data that comes.

Top 3 Features of Interaction Studio

Today, in this world where we have interactions happening across multiple channels, it’s really important that all your sales, service, and marketing departments talk in the same language. That can be a huge challenge at times. 

Interaction Studio is related back to contextual data such as a product catalog or a content catalog. It can bridge the two resulting in a unified view of a customer. From the data of the customer, you can make a centralized decision leading to an orchestrated delivery across all touchpoints. 

Open-Time Email

Delivers personalized content and product recommendations at the time an email is opened by the recipient, which is rendered in true real-time, utilizing the most current information of every user in your subscriber list. 

The solution is designed to work with any email or marketing provider. 

Journey Builder

Based on API. Interaction Studio listens through web, mobile, API, and data feeds, constantly gathering data about visitors, then updates existing segments in real-time. Use these segments to add customers to Journey Builder within moments of data changing.

Automation Studio

Import or export segments between IS and SFMC. Export segments from IS to SFMC/Pardot using IS SFTP — one time or nightly. 

Use Automation Studio to import data into SFMC DE. Import data into IS — Marketing Cloud data extensions are extracted using Interaction Studio SFTP as a destination in Automation Studio.

Ultimate goal

As we learned, Interaction Studio unifies multiple touchpoints of user behavior from viewing a product through a website all the way to talking to a sales representative after a purchase. From these features, it all comes down to a better understanding of the customer’s needs, making it the best experience for them as possible. 

Learn more from the original content of Deboleena Bhattacharyya here. Or, check out more MarDreamin videos here

Original article: Three Interaction Studio Features Marketers Should Look Out For

©2022 The Spot. All Rights Reserved.

The post Three Interaction Studio Features Marketers Should Look Out For appeared first on The Spot.

By |2022-07-24T01:40:00+00:00July 24th, 2022|Categories: Emails & Forms, Marketing Automations, Pro Tips, revive|

Demystifying Pardot B2B Marketing Analytics Plus

With Pardot B2B Marketing Analytics Plus, you are able to bring external data, use an intuitive and customizable dashboard, activate Discovery Stories, and take advantage of Einstein Prediction Builder.

Difference between B2BMA and B2BMA+

B2BMA B2BMA+
B2B Marketing Analytics app External connectors
Pardot and CRM data Pardot, CRM and Import data
B2B Marketing Analytics app
Marketing Campaign Intelligence App
ABM App
Discovery Stories
Einstein Prediction Builder
More data

Extracting Data

A case scenario is that there is a lack of visibility into usage as the data sits in an external system, getting it through that B2BMA. Extracting and bringing data is easy with the proper steps taken in B2B analytics. 

Remember that:

  • Dashboards are only as good are your data
  • Data is clean
  • Quality data everywhere
  • Joining in an effective way
  • What questions are you answering?

Customizing Dashboards

A use case example would be that you are missing key usage data from an ABM Dashboard, so you’ll add an additional lens from it. The first thing to do to edit a dashboard is to clone it. Connect it to the right data sources. Drag and drop as easily as you can. 

Remember:

  • Always copy the dashboard before editing
  • Think first about user experience 
    • Who will be using this dashboard?
    • What data will they be looking for?
  • What questions are we answering?
  • Charts were not created equal

Discovery Stories

An example of this use case is how prospects engage with your content and how can you actually improve it? Common questions that Discovery Stories can help with are how are your downloads doing? Or Are there engagements in downloading e-books or whitepapers? Options and suggestions from Discovery Stories will be given in a decision and strategy point of view for the future.

You can identify changes that are predicted to improve. Always remember to:

  • Not neglect combinations
  • Select relevant fields

Einstein Prediction Builder

An example of a case scenario would be a high percentage of leads were being marked unqualified and we didn’t know why so running tests from this capability will prevent this and identify some root causes.

Always remember:

  • Output is boolean or a number
  • What data matters? (e.g. not phone numbers)
  • Don’t include past leads that have already been unqualified

Takeaways

Pardot B2B Marketing Analytics Plus can give you a lot of advantages when it comes to data and being strategic in making decisions from it. There are plenty of capabilities that B2BMA+ offers including bringing external data easily to the dashboard, customization, Discovery Stories, and Einstein Prediction Builder. 

To learn more, click to watch the original video from Jess Pyne here.

Check out more MarDreamin’ videos

Further Reading

Original article: Demystifying Pardot B2B Marketing Analytics Plus

©2022 The Spot. All Rights Reserved.

The post Demystifying Pardot B2B Marketing Analytics Plus appeared first on The Spot.

By |2022-07-12T19:57:00+00:00July 12th, 2022|Categories: Analytics & Reporting, Data Management, Pro Tips, revive|

7 Marketing Cloud Security Tips for a Hybrid Work Environment

You can keep your free snacks and ping pong tables. If we’ve learned one thing from the pandemic, it would be that employees really want the ability to work remotely — at least part of the time. While organizations have become more accepting of this new reality, IT departments are facing security challenges.  

In this post, we’re looking at Salesforce Marketing Cloud security best practices for hybrid and remote work environments. We’ll review some of the security settings in Marketing Cloud that will allow your remote employees to work safely and take some of the stress off of your IT team.

Marketing Cloud security for remote and hybrid work models

Since the onset of the pandemic, the number of remote workers has grown exponentially and the hybrid work model is becoming the new norm. A 2021 Mckinsey & Company survey found that 52% of workers prefer a more flexible working model moving forward. And listening to those wishes is helping many employers to avoid the effects of the Great Resignation at their companies.

Luckily, Marketing Cloud is built with security in mind and it can be configured to allow your employees to work securely — wherever they may be. 

Let’s take a look at some ways you can protect your data in addition to using multi-factor authentication (MFA).

Security Tip #1: Limit the Data in Salesforce Marketing Cloud

Salesforce Marketing Cloud is not a data warehouse. So don’t treat it like one. 

When bringing data into SFMC, ask yourself how it will be used for segmentation. If data will not be used for segmentation, don’t import or sync it over. Data like credit card numbers should NEVER be stored in Marketing Cloud.

Special attention also needs to be applied when handling Personally Identifiable Information (PII). The Department of Homeland Security defines PII as:

As any information that permits the identity of an individual to be directly or indirectly inferred, including any information that is linked or linkable to that individual, regardless of whether the individual is a U.S. citizen, lawful permanent resident, visitor to the U.S., or employee or contractor to the Department.

Linked PII is information that can be used by itself to identify an individual (ex. Social Security number) and linkable PII is information that can be used in combination with other information to identify an individual. Depending on the type of data in your account and the industries you serve, additional security measures like data at rest encryption, field level encryption and tokenized sending might be necessary.

Security Tip #2: Control Access with Marketing Cloud Business Units

Even before creating users, I like to see how organizations are structured. If your organization operates in several regions, all users might not need access to all the data. The best way to secure data is to not grant access to it in the first place!

This is where business units come in. Business units in Marketing Cloud allow you to control access to information by creating a hierarchical structure. They also allow you to control branding elements including email display name, email reply address, and physical mailing address at the business unit level. You can even control the settings to allow unsubscribe at the business unit level or the enterprise.

Business units don’t have to be limited to geography. Your hierarchy can be built based on your unique needs. Building a hierarchy based on products is a great use case.

Note: Business Units are available in Enterprise and Enterprise 2.0 accounts.


Security Tip #3: Provide Users with the Correct Access Based on Need

Now that we’ve established our hierarchy and determined where users should be included, the next question is access level. Let’s start by talking about the differences between roles and permissions.

  • Permissions are micro-level security.
  • Roles are macro-level security.
    • They are a collection of permissions.

Permissions in Marketing Cloud are very granular. For this reason, the good folks at Salesforce have included default roles within Marketing Cloud based on common needs/scenarios (similar concept to the default user roles in Pardot). These are divided into Marketing Cloud and Email Studio Roles. I would highly recommend using these roles and limiting the creation of custom roles.

Marketing Cloud Role Description
Marketing Cloud Administrator This role assigns Marketing Cloud roles to users and manages channels, apps, and tools.
Marketing Cloud Viewer This role views cross-channel marketing activity results in Marketing Cloud.
Marketing Cloud Channel Manager This role creates and executes cross-channel interactive marketing campaigns and administers specific channels like Email Studio.
Marketing Cloud Security Administrator This role maintains security settings and manages user activity and alerts.
Marketing Cloud Content Editor/Publisher This role creates and delivers messages through applicable channel apps.
Email Studio Role Description
Administrator Access to all Email Studio functions including Setup, email creating, and creating data extensions.
Content Creator Access to all content, shared folders, and tracking in Email Studio, but no access to data or administrative features.
Data Manager Access to everything in Email Studio except email content
Analyst Access to tracking features in Email Studio.

Marketing Cloud Roles and Permissions

When assigning roles to users, you should always start with the lowest level that permits the individual to do their job. I’m always amazed when I log into an account for the first time and see all users have the Marketing Cloud Administrator and Administrator roles assigned. There’s simply no reason for this. I generally like to have two admins in an organization. It’s always good to have a backup in the event of an emergency!

It’s also worth noting that SFMC defaults to the most restrictive value when multiple roles are assigned to a user. For example, if a user was assigned the Content Creator, Marketing Cloud Channel Manager, and the Marketing Cloud Viewer roles, they would not be able to send an email. This is due to the fact that the Marketing Cloud Viewer is the most restrictive of the three roles and does not permit email sending.

It’s very possible that the same user will have access to multiple business units, but perform different functions in each. That’s perfectly fine and SFMC has you covered. Roles can be assigned at the business unit level so the same user could have admin access in one and view only in another. This is very handy and should be utilized if users don’t need full access to all the BUs that they are part of.

Security Tip #4: Follow Login and Password Best Practices

Marketing Cloud allows admins to set security policies very easily within the Security Setting under setup. However, I’m really surprised by how often I see accounts where the standard Salesforce recommendations are not followed. Take a minute to audit your account to ensure that they comply with the recommended account settings from Salesforce included below.

Field Recommended Setting
Session Timeout 20 minutes
Login Expires After Inactivity 90 days or less
Invalid Logins Before Lockout 3
Count Invalid Logins Across Sessions Yes
Minimum Username Length 8 characters
Minimum Password Length 8 characters or more
Enforce Password History 8 passwords remembered
User Passwords Expire In 90 days
Send Password Change Confirmation Email Enable
Enable Audit Logging Data Collection Enable

Security Tip #5: Limit Logins by IP Address

The Restrict Logins by IP Address (IP Allowlisting) setting allows you to define a list of IP addresses that can access your account.

This feature is optional and is set to Off by default, but can quickly be activated under Setup > Security Setting > Username and Logins. When activating, you’ll have the option to log non-allowed IP addresses and permit access or log non-allowed IP addresses and block access. Don’t forget to add IP addresses to your allowlist under Setup > Security > Login IP Allowlist if you choose to use this feature. 


Security Tip #6: Limit Exports

Ask yourself this simple question…

Does this user need to extract data from SFMC to do their job?

If the answer is “no,” then don’t allow them to export. It’s that easy!

Data extracts are a security risk that I see in most accounts. While data in the hands of a user can be risky, the real concern is data sitting on a computer that is not properly secured. Once the data leaves SFMC, all bets are off. This is a huge risk with remote workers. Let’s mitigate this risk by limiting exports.

Data can be exported from SFMC using Data Extract activities in Automation Studio, from tracking in Email Studio, and from reports in Analytics Studio. While some reports can be viewed onscreen or downloaded as PDFs, email and file transfer locations are the primary ways that data is exported. 

Email Export 

Your data is sent from SFMC via email. This is pretty scary, but can be controlled with Export Email Allowlists. The email allowlist includes individual email addresses or domains that are authorized to receive email exports from your account.

Export Email Allowlists must be activated in your SFMC account by first selecting the Enforce Export Allowlist in Security Setting. You will then need to specify the individual email addresses and domains that are authorized to receive email exports within your Export Email Allowlist (Setup > Security > Export Email Allowlist).

File Transfer Locations 

Marketing Cloud also makes use of file transfer locations to import and export data. The most common location is the Enhanced FTP Account, but you can also add additional locations under Setup > Administration > Data Management > File Locations.

To access data from the Enhanced FTP Site, users must login. Access to the data can be controlled by limiting users and not sharing login credentials. Marketing Cloud allows up to 10 FTP users per MID, allocate them wisely! Users can be granted Read Only or Full access.

Security Tip #7: Automate and Review Audit Trails

Audit Trails in Marketing Cloud can be used to track account access and activity. Reports can be automated through Automation Studio or through REST API extracts.

Before audit trails can be exported, the following actions must be taken to enable them in your account.

  • Enable Audit Trail Data Collection under Setup > Security > Security Settings
  • Assign the Marketing Cloud Security Administrator role to the user who will be extracting the data

Once these requirements are met, automations can be created in Automation Studio to extract the access and activity logs. Salesforce recommends that audit trail data be retrieved periodically based on a rolling window.

There are a couple of things to keep in mind when creating your automations.

  • You must create a Data Extract activity and select the desired extract type (Audit Trail Access Log or Audit Trail Activity Log).
  • Data is extracted to the Marketing Cloud Safehouse, so a File Transfer activity is needed to securely transfer files to the FTP location of your choice.

The automation is pretty simple and will look like this when complete.

The Basic Audit Trails are a great place to start. They are included in your account and have a 30-day retention period. Advanced Audit Trails, which can be purchased for an additional fee, extend the retention period to 60-days and include additional data related to Email Studio, CloudPages, MobileConnect, and more. Learn more about Basic and Advanced Audit Trails. 

Take Action to Secure your Marketing Cloud account

This post includes some recommendations to help secure your Marketing Cloud account with the rise in remote workers. However, it is not inclusive of all the security capabilities of SFMC. 

For more information, check out the following Trailhead modules or post your questions in the comments section. We’re here to help you succeed with Marketing Cloud! You can contact us with any questions.

Original article: 7 Marketing Cloud Security Tips for a Hybrid Work Environment

©2022 The Spot. All Rights Reserved.

The post 7 Marketing Cloud Security Tips for a Hybrid Work Environment appeared first on The Spot.

By |2022-06-28T20:44:08+00:00June 28th, 2022|Categories: Data Management, Privacy & Compliance, Pro Tips, revive, Strategy|

Using Pardot B2BMA as a Data Audit Tool

In this blog, we will talk about data completeness, data hygiene, and data completeness KPIs to get you to have a better understanding and practice with Pardot B2BMA as an audit tool.

Data completeness

We’ll keep this straight to the point. You aren’t able to make great decisions if you don’t have good data. What is complete data? Are the fields being completely filled out? It’s actually about data you don’t know, what you need to know, and the diversity of sources you’re getting your data from.

How do you know if your data is complete?

Can you make decisions based on the data you have? Are you able to answer business questions or goals based on the data? Complete data does not necessarily mean asking every single question but only asking what you need.

 It’s best to make it targeted data. Knowing where it started, where it’s going, and what’s in the data are great practices to help you.

Data Hygiene

How do we control our data? We’ll start by getting the data we only need. Asking questions that would not be helpful to the goals can be avoided. 

  • Avoid open text boxes for categories like fields on cities/states/country as it will be very difficult to put them together categorically.
  • Be aware of convenience sampling. It is important to guide questions in a certain direction. Are we looking to find the things that we don’t already know yet? 
  • Monitor sources. Where does your data come from and how complete are those sources? Knowing who your population is and getting a proper sample from them is key.

Data completeness KPIs

What is your most actionable data? If you can only know 5 things about each of the people you’re getting information from, what would be the 5 most important information you want to get from them? 

Make prioritizations

Determine what your priorities are. Is it Industry, Geolocation, or Title? 

  • Identify non-actionable data. Are you collecting things because of everybody else? 
  • Determine categories of data to enrich. If you’re looking towards 5 different things that are important to you and you value, categorize them. 
  • Prioritize data enrichment activities. You can’t fix everything all at once. Having a good plan for determining which is the most critical data and how to clean them up will help you do a better job on forms and getting the data cleaner into Pardot. 
  • Measure your progress. It’s better to start a baseline and monitor insights as to what movement you have shown.

Conclusion

There are three critical aspects that can help us use Pardot B2BMA as an Data Audit Tool including data completeness, data hygiene, and data completeness KPIs, all of which are important to making important business decisions and achieving their goals.

Check out the full original video by Dominique Beaudin here. Or, click here to learn about this year’s MarDreamin’ conference. 

Further reading:

Original article: Using Pardot B2BMA as a Data Audit Tool

©2022 The Spot. All Rights Reserved.

The post Using Pardot B2BMA as a Data Audit Tool appeared first on The Spot.

By |2022-06-24T01:21:00+00:00June 24th, 2022|Categories: Analytics & Reporting, Data Management, Pro Tips, revive|