Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!

Data Warehouse Sort by Feature for Metrics

Avatar

Level 2

7/28/21

Description - In Data Warehouse I created a report for executives but do not see a feature to "sort by" for the metrics. I need to sort largest to smallest for internal searches. 

Why is this feature important to you - 1. Our executives want an automated emailed report for Internal Search Terms by metric Internal Searches [event]. 2. They want the report to sort by metric Internal searches from highest to lowest. 

How would you like the feature to work - To be able to sort Internal Searches even from highest to lowest to see the search terms at the top that received the most searches. 

Current Behaviour - Currently the report comes in automatically sorted by the dimension name [Internal Search Term]. We need it to sort by those terms that received the most searches first down to the lowest. 

4 Comments

Avatar

Level 10

7/29/21

I can't believe there is DW report for Executives... DW is designed to export large data sets for further processing.

 

Consider building a report in Workspace and automate its delivery in PDF. Your executives will be happier

 

 

Avatar

Level 2

7/29/21

@Andrey_Osadchuk Of course, I did that first. The problem is they are trying to review search terms to see what customers are looking for that we don't carry to find new opportunities. Workspace limits to 400 rows when delivered in an autogenerated email. Data Warehouse does not carry that limitation. 

Avatar

Level 2

7/29/21

@Andrey_Osadchuk Thank you, I will look into that. Since we just entered with Adobe a couple of months ago I'm not sure that the legacy interface is available to me. I was a user of Omniture however from 2006 to 2012 so I am familiar with Site Catalyst and Data Warehouse of the past.