Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Remove unspecified's from correlation reports

Avatar

Level 10

2/17/10

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

Level 3

3/10/10

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

Level 4

5/26/10

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.