In this video, we’ll walk through the basics of creating Calculated Metrics in Customer Journey Analytics.
Hey everybody, this is Doug. In this video, I want to give you an introduction to Calculated Metrics in Customer Journey Analytics. Now, if you are familiar with Calculated Metrics from Adobe Analytics, regular Adobe Analytics, then it is really the same in Customer Journey Analytics, with just a few little things to remember, and I’ll get to that in a minute. So let’s talk about what Calculated Metrics are. Well, here I have a table with my data sources, and I’ve got the people metric, which is basically the same as visitors, and of course, I can add additional metrics. So maybe I’ll add the orders metric, grab that and bring it over here and just add it to this table, drop it in there, and now I can see the number of orders during this timeframe per data source, as well as people. And you can see of course, that the orders are being fulfilled in Analytics and in Point of Sale, or at this store, and also at the Call Center, and those are the three data sources that have any orders in them. But maybe I’d like to know the orders per person or per people here. And I don’t have a brain that will do that math on the fly, so we can actually create a calculated metric to drop into this table so that my brain doesn’t have to explode trying to do that math on the fly. So we’ll go to metrics, and we click on this plus to do a new calculated metric, and we give it a title and maybe it’s just Orders per Person, and we could give it a description, but we don’t have to. We have the format, what do we want this format in, time, decimal, percent, currency, et cetera? Definitely want decimal, and I’m going to put two decimal places because we might have some very small numbers. We can show upward trend as good, green, and that’s good, the higher number of orders per person, the better, so up is good. We can also add some tags if we have a bunch of Calculated Metrics and we want to be able to add some metadata to them.
And basically, I’m going to go down here to the definition and start dragging things over. Now, you can see you can drag and drop the metrics, which we’re going to do, but you can also drag and drop dimensions, and segments, and functions in here. And I’m not going to do that in this introduction, but we’ll talk about that in other videos. So for now, we can even just take our cue from the title, which is Orders per Person, and so we’ll just drag in orders, and we’ll drag in our people right below it. And by default, it is doing the divided by, so that’s per, and that’s exactly what I need. So this one was super easy to create. And now when I save that, it will become available to me. And you’ll be able to see by this little icon, that it’s a calculated metric, and that it was built by me, or by a user, not by Adobe. You have other metrics here that are out-of-the-box, and so they have the little Adobe symbol here. So now I can take my orders per person, and drag that over, and I can add that here, I’ll just add on the front of that, and that’ll do my calculation and show me those numbers. And it’s showing me the percentage of the total and doesn’t really make sense on this kind of a calculated metric, so I’m going to go up here to this column, click on this gear, and deselect percent, I don’t need that. And so I come back here and now I just have my numbers, that makes a lot more sense. And I can see in this demo data, that the store data, I’m getting a lot more orders per person than in analytics, online, or in my call center, people calling up to order stuff. So that gives me really great data and again, it makes it so that I don’t have to do math in my brain on the fly, so that’s really good. That’s your Calculated Metrics, and just a couple things to remember, you are working with all of your data here. So if you have multiple data sources coming in, you’ll want to know if certain metrics are specific to one data source, or to multiple data sources. We can see here that the orders metric is coming from three different data sources, and our people metric is coming from all these different data sources. And so that’s really important to know, especially if I were going to do this for the entire data view and not per data source, I would get totals for all of my data, but I would need to know that yeah, that’s really coming from the analytics data, store data, and the call center data. So it’s very important to know your schema and which metrics are available to you from the different data sources that you are analyzing here in Customer Journey Analytics. Good luck. -
For more information about Customer Journey Analytics, visit the documentation.