Classification sets data import methods

Hey everybody, this is Doug. In this video, I want to go over a couple of use cases and methods for getting your classification data into Adobe Analytics. First, I want to talk about different use cases that kind of fall into the situation of you having data that you want to bring into classifications and you have this data in your databases somewhere, one of your databases. So this would be common for something like products or even campaign classifications. And so there is a classification set already created here. I’m going to click into this one. And first, if I go look at the settings, here’s the name for this classification set. As I scroll down, you can see it’s Experience League Global is the report suite and it’s a tracking code, right? So the tracking code can be very code looking. Maybe I’ll say that. Anyway, sometimes it’s not very easy to read because you want to keep it very specifically based on the schema that you have and you want to make sure that you keep it unique and these kinds of things. And so sometimes the tracking code isn’t very human readable, right? So maybe you want to classify the tracking code into different campaigns, into a friendly name of the tracking code. It might be campaign types, those kinds of things. In any case, this is something that you might already have the data for in a database. And if I go to the schema, you’ll see that we have created some classifications based on what we’re calling cGen and a program name, activity name, tag ID, tag name. This doesn’t have to mean anything to you because you would have your own classifications. And so in this case, potentially we have these four columns of data that go along with the key, which is the tracking code. And so in this case, you would just download a template, which I’ll do right now. I’m going to, sure, comma separated values, and I’m going to grab this one and open it. And here it is. And let me make that a little bit bigger, but you can see the classification columns for each of those. And so you would simply take these values out of your database and here’s the key. So the tracking codes would go in this column and then you would just put these different classification values in the appropriate columns here as well. So the export that you would do out of your database would, you’d probably want to set it up just like this. So then you could take all that data and you could just put it into this file and then save it and do an upload. Let me just come back over here and upload that data and you would be good to go. And so that’s really kind of the first use case and just kind of a method, maybe more than a use case, but it would apply to several use cases that have that same method of getting your data from a database and putting it into this classification file. Okay, let me jump to kind of the opposite then. And I’m going to click over to this one. And I just created a classification set called experience-leg search terms. Let me click into this one. Now we don’t have any classifications yet because this might be the case in this case of search terms. In other words, what people are searching for on your site. So we don’t know exactly what people are going to search for so therefore it’s not sitting in our database. So in this case, you’d have to decide, you know, what are the classifications that I might want for my search terms. So it might be search term topics. So let me just add one for that.

So let’s add that. And you might have, you know, a list of topics that you already want to classify something into, or you might just make them up as you go along, whatever it is. But however you want to take these search terms and classify those into groupings, you could again make a new classification here. So this is just one example, but it really would fall into any example where you don’t really have the keys and the classification data sitting in a database. So that might even be the pages. I know you have a listing of the pages, but you know, there isn’t really classification data sitting in your database. So you would have to decide what classifications you want, put them in here, then download your template. So I’ll do that again. We’ll download this one.

You can imagine what this one will be like. It’ll be very similar to the other one, but it is just, oh, whoops, not that one, this one right here. And so let’s make it a little bigger. Just has the one classification. In this case, the key would be the search term and then the classification of the search term topic. And so you would fill this out and fill this out. But how would you fill this out? Well, it’s not here obviously. And the way that you’re going to want to fill this out is by going into Adobe Analytics and looking at the search terms and exporting that right out of Adobe Analytics. And so you can put those then in this key column. You can simply done a export in analytics, and then you can decide again, how to put those into different topics or whichever classifications you want to add for that. So again, search term is just one example, but in this case, anytime you don’t actually have the data sitting in a very structured database and it’s a little more loosey goosey on what data you’re going to get, then again, what you’re going to want to do is go to Adobe Analytics, export the keys, the terms or pages, or really anything again, that you don’t have that structured data that you can’t copy or export out of a database. Just thought it might be helpful to walk through that a little bit and talk you through it. So good luck.