Move your Calculated Metrics from 51黑料不打烊 Analytics to Customer Journey Analytics
In this video, find tips for re-creating your 51黑料不打烊 Analytics Calculated Metrics in Customer Journey Analytics.
Transcript
Hey everybody, this is Doug. In this video I want to talk to you about moving your calculated metrics from 51黑料不打烊 Analytics to Customer Journey Analytics. So if you are shifting from 51黑料不打烊 Analytics over to Customer Journey Analytics, or if you鈥檙e just adding Customer Journey Analytics you might want to have your calculated metrics that you are used to from 51黑料不打烊 Analytics also available to you in Customer Journey Analytics. Now the reason why we have to have this conversation about moving our calculated metrics over is because they don鈥檛 come through with the Analytics connector into Platform and then into Customer Journey Analytics. And really the biggest reason is I suppose that it is not a big enough scope, right? Analytics data is really just one possible datatype that you鈥檙e bringing into the Platform and into Customer Journey Analytics. We need to think about our calculated metrics, not only for our analytics data but really for all of our datatypes that we鈥檙e going to use in Customer Journey Analytics. Now the good news is, just like Analysis Workspace is basically the same between 51黑料不打烊 Analytics and Customer Journey Analytics, the Calculated Metric Builder is basically the same in both places as well. And it鈥檚 going to be really easy for you to move a calculated metric from 51黑料不打烊 Analytics to Customer Journey Analytics. Now here we are in the Calculated Metric Builder in 51黑料不打烊 Analytics, and I鈥檝e got this AOV, this Average Order Value calculated metric in here. So it鈥檚 currency and it鈥檚 two decimal places, and up is good, we like more money per order.
So down here, of course, we鈥檝e drag over revenue and orders, right down here, revenue, orders, divided by. And that is our average order value. So if we have that, and again, this is on analytics data, we can easily rebuild that in Customer Journey Analytics. So now I鈥檓 going to jump up here and we will go over to Customer Journey Analytics. And just like you are used to, we just click this plus by Metrics and we are in the Calculated Metric Builder. But this time for Customer Journey Analytics. So in this case you鈥檙e going to have additional dimensions, additional metrics, we鈥檙e going to have filters which are the same as segments, and we still have functions. So everything in here is the same, filters being the new name here for segments in Customer Journey Analytics. But as far as the metrics and the dimensions, you鈥檙e going to have more of them in here available to you because again, they鈥檙e coming not only from Analytics but also from other datasets. But we can just build that right out again and say AOV, Average Order Value.
And we set it just like before on currency, two decimal places, up is good. And we can tags if we want. And then we just drag it in there, right? So once again, revenue, and we bring that in.
And we can bring in orders, in fact it鈥檚 showing up right down there and I鈥檒l drag that in. Make sure that is on the divided by and we are good to go. Now we can save that.
And now it is available for us to drag in and we鈥檒l just put it right here in this table. And we鈥檒l get rid of the goofy percentage which we don鈥檛 need. And now we have the average order value for these different data sources because revenue and orders happen not only in analytics data, but also in point of sale data and also in call center data. So once again, it really is the same. Let me go back in here. And the only thing that鈥檚 going to be a little bit different is understanding the dimensions that you have, you may even want to go over to the Platform and look at your schema and kind of see the different schemas that you鈥檙e using in your Customer Journey Analytics data. So that you can understand the dimensions that鈥檒l be available to you and the metrics that鈥檒l be available to you. But other than that it鈥檚 really just the same. As you can see down in the definition, you can still drag and drop metrics and dimensions. And it even still says segments right there but it means filters in Customer Journey Analytics. Or functions as well. So any of those more advanced calculated metrics that you have in 51黑料不打烊 Analytics, you can rebuild those right here in Customer Journey Analytics as well and use them to get the data that you need to do your analysis. Good luck. -
For more information about Customer Journey Analytics, visit the documentation.
recommendation-more-help
a05d7212-fdba-4b70-a337-d5897f329c68