Create Sales Analytics Using the Wizard
It’s time to jump in and create the app. In the Analytics Apps Basics Trailhead module, you did that using the fast Basic creation option. This time, you do it again with the Custom option, which means you get to try out the built-in configuration wizard.
As you work, keep in mind the rules of using the wizard you read in the Analytics Apps Basics module. Your goal: To get Laura a working version of Sales Analytics so she has quick access to KPIs showing her team’s quarterly results.
Start by taking a sec to look at what you created in the Analytics Apps Basics module.
Log in to the org you set up in Analytics Apps Basics and click the App Launcher (). Then click the Analytics Studio tile.
Open My First Analytics App. If you don’t see it right away, click the Browse tab at the top of the screen to get to your app. Get the app’s dashboards in a single view by clicking the Dashboards tab at the top of the app window. You now have all the dashboards in a scrollable window—a handy way to look at them, right?
Remember one of the rules of using the wizard: “Use it to fine-tune your analytics experience.” Put another way, that means there are many aspects of dashboards you can’t change. For example, open the Executive Overview – Pipeline Performance dashboard. You can be sure that will catch the CEO’s attention, right?
Don't worry if your dashboards look a bit different from the examples here and elsewhere in the Sales Analytics trail. The basic elements of the dashboards should be the same even though the data may differ.
The wizard doesn’t let you change the top part of this dashboard. In fact, many Sales Analytics elements can’t be changed by the wizard selections. Remember: We’ve prebuilt Sales Analytics and all the other Analytics apps to make analytics easy, right out of the box, with little effort on your part.
That said, some things are under your control through the wizard. Let’s have a look at an example.
What You Can Change With the Wizard: An Example
Have a look the Sales Performance dashboard, one of the dashboards for the sales ops team. Laura can use it to help her and the team understand which customers might be good candidates for upsell or cross-sell to help make quota. Here’s what the top of it looks like:
Now have a look at the wizard.
- In Analytics Studio, click Create in the upper right and select App.
- Select Sales Analytics and click Continue.
- Select My First Analytics App, click Continue. That opens a screen that lets you add objects to your app. We’ll come back to that in a minute; for now click Looks good, next.
Have a look at the first two questions, which ask how you want to segment customers. The Sales Performance dashboard uses those answers to determine what goes in some of the filters across the top. Here are the wizard questions (on the left) and the dashboard filters (on the right).
See how Account Type and Industry in the wizard end up as filters in the dashboard? The other filters across the top can also be changed by the wizard, as can some filters in other dashboards. To see details about how to control dashboards with wizard selections, see the Sales Analytics Dashboard guide listed in the resources section at the end of this unit.
Close the wizard by clicking the X in the upper right corner.
This time, you use the Custom option to vary the default settings and use the wizard. To keep it simple, we’re only going to change a couple of settings. You’ll get a feel for how the wizard works and how to use it in your own org. And you’ll see that your answers to the wizard questions really do matter!
- Go to your Developer Edition org and open Analytics Studio.
- Click Create and select App.
- In the “Choose an app template” window, select Sales Analytics and click Continue.
- Select Create a brand new app. Click Continue. This starts a compatibility check to see if your org meets minimum requirements for creating the app and to look at the data in your org. It should pass with flying colors, since we’ve prepopulated your the special Developer Edition org with the right data. After this runs, click Looks good, next.
- Select Custom and click Looks good, next.
- This brings you to a page that lets you add objects to your app with Products and Cases preselected. When Service Analytics runs the compatibility check, it looks for the objects you see on this page. We’ve included Products and Cases in your special Developer Edition org, but not the other objects (which are greyed back here). You can deselect them by clicking the object, but let’s leave them—you know that DTC uses data about products to measure results. And it sounds great to see customer service data with your sales data. So leave them as is and click Looks good, next. In your own org, you can add other objects to your app here, but we only want Products and Cases for our example app.
- You see the first page of the wizard. Go to the first question, about the first field to use to segment customers. It has Account Type—but you’re going to try something a little different: You know that Laura usually likes grouping customers according to the segment. So look for Segment in the answers to the first question and select that. Leave Industry in the second question, like this.
- Click Looks good, next, and move on to questions about the Opportunities object. Open the list of answers to each question one at a time and scroll through them. You should be able to tell that very few of the choices would work. For example, the first question asks about total amount of the opportunity, and the default selection is Amount. The other possibilities—Expected Amount, Probability, and Quantity—clearly aren’t right. That’s an important wizard rule in action: that only some answers make sense.
- On that page, go to the question about the field that indicates an opportunity is new business. Right now, the answer is Opportunity Type. But you’re feeling confident and want to try something different, so select Opportunity Source.
- Click Looks good, next a few more times to move through the rest of the wizard. As you do that, keep your eye out for one question you should know about: “How would you like to control data visibility in Sales Analytics?” Your answer controls data security in your app. Choosing the default lets Laura and other users view the data they own as well as the data owned by the people who work for them. In other words, it uses the standard Salesforce Role Hierarchy for data security. Leave that as is for now, but if you ever need to change data security for a particular app, this is the place to start. You can learn more about Salesforce Role Hierarchy in the document listed in the Resources section at the end of this unit.
- When you get to the Name your app dialog, type in Analytics for Sales Managers and click Create.
- From Analytics Studio, go to the app picker at upper right and select Trailhead Data Manager. You may have to scroll down to find it.
- Select the Trailhead Data Manager link below Items. Then select Trailhead Data Manager on the next page.
- On the Trailhead Data Manager home page, click Refresh DTC Data.
- If your data is up-to-date, click the Download Trailhead Dataflow circle.
- From the dropdown menu, select Analytics_for_Sales_Managers. If you don’t see your app in the menu, you need to wait until the app creation process has finished.
- Click the Download Dataflow for Analytics_for_Sales_Managers_for_Trailhead button. The file is saved in your Downloads directory. It should be called Analytics_for_Sales_Managers_for_Trailhead.json.
- Go back to Analytics Studio by selecting it from the app picker.
- Click the gear icon in the upper right, and select Data Manager. (This is the Analytics Data Manager, not to be confused with the Trailhead Data Manager.) From the menu in the upper left, select Dataflow View.
- Scroll to Analytics for Sales Managers. Open the menu on the far right opposite the app name and select Upload.
- Click Select a file, navigate to the file you just saved in Downloads (Analytics for Sales Managers_forTrailhead.Json), and select it.
- Click Open, click the Upload button, and then click Done.
- Finally, open the menu on the far right next to the app name again, and select Start.
- From the menu in the upper left, select Dataflow View. You can see the status of the dataflow to the right of your app name at the top of the list of jobs. Click the refresh button a few times until the status changes from Running to Successful.
Wait a few minutes for the dataflow to run again. To be sure it’s finished, refresh your browser, select Dataflow View in the menu at the upper left and click the plus sign next to Analytics for Sales Managers. If you see Running at the top of the Status field, it’s not done yet. Once that changes to Successful, you’re ready to move on.
Go back to Analytics by clicking the gear icon at upper right and selecting Analytics Studio. Click Browse All, and open Analytics for Sales Managers. Now go to the Sales Performance dashboard to see what you did.
The first version had Account Type and Industry filters at the far left. The second has Segment and Industry filters instead.
Just to see how the dashboard works, open the Segment filter to look at a list of DTC’s various market segments. Choose SMB and click Update. Now you can look at just accounts in the small-medium business segment. To go back to the dashboard in its original state, click the reset button above the dashboard.
Now go to the My First Analytics app and open the Sales Performance dashboard. Open the Account Type filter, which lets you select only from between Customer and Partner.
It’s a subtle, but important change. Laura can now filter all the performance dashboards exactly the way she wants—looking at all the data according to segments.
Previously, filters gave Laura a choice between looking at customers or partners, that is customer types, and she wanted to see a breakdown of customers. The new Segment filter shows sources of business broken down according to DTC’s market segments—exactly what she wants. Nice!
Now, let’s look for the results of the other change you made: Selecting Opportunity Source instead of Opportunity Type. Look at the filters along the left side of the dashboard, below the filters you just looked at. The second filter is called Opportunity Source.Go back to My First Analytics App and open the Sales Performance dashboard. The filter in the same location is called Opportunity Type. You can see the same change to all the other performance dashboards (by geography, by source, and so on), and other dashboards, too. One small change made a difference, right?
We deliberately made this simple, to help you get Laura what she wants fast. Likely, when you use the wizard to create your own app, it will take a little more thought and effort. But you get the idea: the wizard guides you through the process and tries to eliminate as much complexity as possible.
- In Analytics Studio, click the Apps tab to see all your apps.
- Open My First Analytics App.
- Select the arrow in the upper right, and click Delete
- Confirm that you want to delete the app.
- Repeat this for all other apps you might have created, except Analytics for Sales Managers. You want to have a clean org with only one app before you move to the next unit.
But for now, you’re happy, and Laura and the CEO should be ecstatic! It’s time to switch from coffee to champagne!
But wait! Just as you pop the cork on your champagne, your bubble bursts. You decide to check dashboards that show how the sales team is doing against its quota. You go to the apps tab in Analytics Studio, find your app, and open the Company Overview dashboard. But...
You can see the forecast, but you can’t see how your team’s doing against its quota! Oh no! You forgot that you store and track data about the sales team’s quotas in a tool outside Salesforce. Never fear: You’ll learn how to import the data into Sales Analytics in the next unit.
Thinking back to not so long ago, you remember how long it used to take to get all this data, and the form it used to take—a boring-looking set of reports. But now that you have Sales Analytics, Laura and the CEO can quickly get all DTC’s KPIs in one place and look at everything in snappy, interactive dashboards. And you got there with just a few quick runs through the wizard.
Of course, you’ve only done that with a few dashboards. But you can see just how fast and how intuitive the process can be, as long as you take a step-by-step approach and remember a few key rules when using the configuration wizard.