Zeroes Appearing in Row Results in Free Form Table

[JohnRog]

I keep getting these "0" value rows in my free form table. I have tried creating a segment that excludes visits or page views if they are not "greater than zero". Has anyone ever had this issue? Is this possibly related to our implementation of Adobe Analytics? I have already tried adding the page view or visits metric exclusion in my segment, but it is not working (i.e. page view is greater than 0).

[jeff_bloomer]

Hi @JohnRog,

An output in your data the way you describe it would likely not have to do with the implementation itself.  Are you observing these zeroes at the base levels of your report or in breakouts?
Being a visual person, if you could just provide couple of visuals of what you're encountering, it would be very helpful, even if you have to blur out some headings to protect your data.

Thanks!

[JohnRog]

I am seeing the zero in the break out or rows.

[JohnRog]

BTW how do I attach an image to my questions?

[jeff_bloomer]

@JohnRog,

When you are initially creating a question or if you EDIT a comment, you should see the camera icon, which allows you to insert images.  You can also copy and paste an image directly into a question, just like I have done here:

Clicking on the pasted image should then give you handles to further control the properties of the image and go from there.  

However, please make sure to edit any fields on your side that would need to be obfuscated to protect the privacy of your company's data.

[PratheepArunRaj]

Dear John,

If you use metrics like Exit Rate, Bounce Rate, Entry Rate etc., you will see the values with '0' because these metrics are common to visits and thus will not apply to individual line items.

Thank You, Pratheep Arun Raj B | Xerago | Terryn Winter Analytics

[PratheepArunRaj]

Thank You, Pratheep Arun Raj B | Xerago | Terryn Winter Analytics

[jeff_bloomer · Accepted solution]

@JohnRog 

Meanwhile, I know I've blurred out a lot here, but hopefully this gets the point across, because it has to do with how segmentation and specific variables behave, particularly when you break down variables.  The first variable is a navigation variable, and I am breaking it down by a success dimension, and then I'm showing the Unique Visitors in one column and the success metric for the first eVar in the second column and the breakdown evar's metric is in the THIRD column.  You'll notice I have ZEROES in the second column, which is perfectly fine, but I would have to explain that to someone who does not normally use Adobe Analytics.

For the sake of argument, let's say for All unique visitors who come to the website, I want to see all navigation clicks who are first clicking specific navigation sections on the top of the site, but then how many people sign up for the newsletter through a specific interface?
Make sense?

[JohnRog]

What about when all the columns are zero? I even excluded entries that were less than 1. I would post an image but don't know how. LOL

[JohnRog]

I think what's going on is that my editorial tool bar is not showing. I wonder if my company's browser is blocking it. Otherwise I would share and image.  Looks like its working now...

[jeff_bloomer]

Here's the thing about "0."  Sometimes the value that's being displayed as zero may be a value that is actually less than zero, but it's not being displayed because it's being rounded UP.
However, I also see Bounce Rate as one of your Success Metrics, and like @PratheepArunRaj said, that's why you're seeing zero results as well.

[jantzen_b]

Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?