Edit metrics across requests in Report Builder edit-metrics-across-requests-in-report-builder

Transcript

Hi, this is Jen Lasser with Adobe Analytics Product Management. In this video I’m going to show you how to edit multiple metrics at once across a set of data requests in Report Builder. So let’s say you have a dashboard that you’ve built and you’ve got to the end you’ve built up this this great view for your business users and then you realize you want to change one of the metrics that you’ve used throughout a set of requests to something else. For example we have Visits kind of layered throughout different views here and we want to change that to Unique Visitors. So with the fall release we’ve introduced the ability to edit metrics across requests all at once. So let me walk you through how to do that. Let’s say you have a set of requests in here that have Visits included in them and even some that don’t. So there’s two ways you can edit multiple metrics: you can highlight all of the requests and even some that don’t. If you want to just Select All, the first way is you can right click Edit Requests. So we’ve had the option to edit across a set of requests Report Suites, Segments and Date Ranges and Granularity or groups of any of those options to date. So those are things we currently offer. The new feature that we’re adding is the ability to now edit the metric. So if you select Edit Metric, you’ll get a pop up model here and there’s three actions that you can take. You can either Add a Metric, Replace a Metric or Remove a Metric. So first demonstrate replacing a metric to go along with the use case here of wanting to switch from Visits to Unique Visitors. So the first option you have to click is what you want to replace. It’s going to take a unique list of all the metrics that have been selected in the requests, so Visits is what we want to replace. And you can do a one to one replace. So what do you want to put in instead of Visits, and we want to do Unique Visitors.

We require that it is a one to one replace because we’re going to swap in this new metric in the exact same spot that Visits was before. So we’ll go ahead and click OK. So clicking OK will render all of the data requests in offline mode, meaning they’re just place holders for now. To run those requests, you just simply need to right click and click Refresh and click OK. So while those run, notice that the request for Products, the one that’s got the zeros in it, it hasn’t changed, it still shows orders. That’s because we will skip over any requests that don’t have the metric that you wanted to to swap out.

So let this just finish here.

So now notice that all of the requests have Unique Visitors in them instead of Visits. And if we go back to our dashboard tab, you’ll see that everything was inherited here as well. Unique Visitors here, in our Devices and in our pie charts as well. So that’s one way you can edit metrics across multiple requests, you can also do two other actions which are Add and Remove. So let’s say we wanted to add another metric to our device type table here as well as this device table as well.

So we can Edit Multiple and go here for metrics.

So when you do add metrics you’ll see a little note, this is just letting you know that when you add metrics you could impact the footprint that a data request takes up. So in the case of this table here it may run into the table on the right. And in case of the table on the right it may overwrite the formula we have here as well. So I’m going to just do this one just as an example and let’s say we want to add Bounces to this request. So notice now that this request is taking up one more additional column, so that’s something to think about as you add in metrics, always make sure to add in the proper spacing between the requests before you go ahead and bring in more metrics.

The last way that you can edit metrics is to Remove. So if you want to take out metrics across a set of requests you can simply come in here, again will list out all the metrics that are available to remove, we’ll click Bounces and we’ll click Ok. Now we’re back to where we started. So right click menu is one way to edit multiple metrics you also have the option to go to Add-ins, Manage.

From the Manage window if you Select All. And choose Edit Multiple you also have the options available to you in here as well. So we will group the requests and the lists based on what you’re trying to edit. So let’s say you try to edit the granularity. We’ll go ahead and group them up based on the granularity they have today. And then you just simply have to go edit each group individually since each one has different starting parameters. The same goes for the new metric option when you select Metric here, we’ll group them up by the metrics that they have within them and then you’ll just simply need to go and select each group and make the changes that you’d like. So I hope you guys find this new Edit Metric feature helpful and it saves you a lot of time.