Rankings in Adobe Analytics

In this article, we will explain how to upload data to categorize it into different variables in Analytics, which can be used in most custom dimensions.

Once the dimension contains data, you have a new dimension to use in reports and perform deeper analysis with more segmented data. For example, we can classify product IDs based on product name, product type, color, or size.

There are different ways to classify data:

• Classification sets: (Components -> Classification sets) You can create and manage classifications and their rules in a single interface.
• Classification rules: (Admin -> Classification rule builder) You can create rules to assign a specific dimension element to a classification element, for example, using regular expressions.
• Classification importer: (Admin -> Classification importer) You can export a spreadsheet template with dimension elements in each row, where columns correspond to each classification of a dimension.

In this article, we will focus on the last method of classifying data, which is typically used when all the dimension elements are known and no constant updates are required.

In this case, the data we import must have a specific format. Adobe offers the opportunity to download a data template with this format, where we can add the new data we want to classify and then import the file using an FTP. However, we can also import a file containing the data created by a text editor, respecting tabulation for rows, which represent each dimension element we want to classify, and columns, which represent each classification of a dimension.

But in order to classify the data, we need to first create the different classifications for each dimension we want to segment. To do this, we need to go to Admin -> Report Suites -> Edit Settings, where we can define the hierarchical trees for each dimension.

Adobe allows us to modify or delete a data upload if we made a mistake in a dimension in a classification. To modify a data upload, all we need to do is re-upload the row with the dimension element where the error occurred in a new data file, and it will automatically be corrected in Adobe. If we want to delete a classification, we have two options: If we want to delete just one dimension in an element, we write empty in the column we want to delete, and if we want to delete an entire row, we write deletekey in the last column of the row we want to remove.

I hope this is useful and that you can apply it in your daily work.