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

Remove unspecified's from correlation reports

Avatar

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

806 likes

Total Posts

188 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

806 likes

Total Posts

188 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adierl
Level 10

17-02-2010

When a correlation is used and there are not always values for all elements of the correlation, you have to deal with "Unspecified" in the report. While it might make sense for some reports (did not find anyone to far) it destroys reporting of many others. The totals is wrong as well as the chart is useless since Unspecified makes >90% in most cases.

 

E.g. if you have a variable to store a business unit (prop1) and have a 5 item-correlation (prop1, pages, downloads, exits, keywords)

The breakdown to see all exits for a single BU, will count all (page+download+keywords)-instances as "Unspecified".

 

 

corr_unspecifieds.png

 

No standard user can understand "Unspecified" here.

 

Or even easier, if you have a correlation Pages<->Keywords, you will see any PageViews without a keyword as "Unspecified". Makes sense?

4 Comments

Avatar

Avatar
Validate 1
Level 7
RobertBlakeley
Level 7

Likes

200 likes

Total Posts

95 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 7
RobertBlakeley
Level 7

Likes

200 likes

Total Posts

95 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
RobertBlakeley
Level 7

21-02-2010

But we use this value for debugging.

Avatar

Avatar
Boost 5
Level 3
pfg51073
Level 3

Likes

40 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
pfg51073
Level 3

Likes

40 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
pfg51073
Level 3

10-03-2010

Make it an option, then.  I agree with this post.  I'm constantly creating custom reports that filter out the "Unspecified" values in these reports (which also messes up the totals), or having to explain to people looking at the correlated reports that 90% of the usage is "Unspecified" because that particular property isn't relevant in the case they're looking at.

Avatar

Avatar
Boost 5
Level 4
xptr99210
Level 4

Likes

40 likes

Total Posts

29 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
xptr99210
Level 4

Likes

40 likes

Total Posts

29 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
xptr99210
Level 4

26-05-2010

well, the filter does not even work anymore...I think it died after the last release.  It was nice but as pointed out above the total is still wrong.

Avatar

Avatar
Boost 5
Level 3
pfg51073
Level 3

Likes

40 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
pfg51073
Level 3

Likes

40 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
pfg51073
Level 3

01-09-2010

Yes, I noticed that, too.  So, no filtering and I'm back to having to explain the meaning of "unspecified" to everyone.