Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Data Warehouse Sort by Feature for Metrics

Avatar

Avatar
Boost 5
Level 2
Linda58
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Shape 1
Give Back
View profile

Avatar
Boost 5
Level 2
Linda58
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Shape 1
Give Back
View profile
Linda58
Level 2

28-07-2021

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

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

992 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

992 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile
Andrey_Osadchuk
Community Advisor

29-07-2021

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

Avatar
Boost 5
Level 2
Linda58
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Shape 1
Give Back
View profile

Avatar
Boost 5
Level 2
Linda58
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Shape 1
Give Back
View profile
Linda58
Level 2

29-07-2021

@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

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

992 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

992 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile
Andrey_Osadchuk
Community Advisor

29-07-2021

@Linda58 , another option is to use the legacy Reports UI where it's possible to export up to 50k rows https://experienceleague.adobe.com/docs/analytics/analyze/reports-analytics/scheduling.html?lang=en

 

Best wishes,
Andrey Osadchuk | Inspect Launch Implementation, Automate Classifications & Data Sources, Essential Bookmarks

Avatar

Avatar
Boost 5
Level 2
Linda58
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Shape 1
Give Back
View profile

Avatar
Boost 5
Level 2
Linda58
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Shape 1
Give Back
View profile
Linda58
Level 2

29-07-2021

@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.