Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Zeroes Appearing in Row Results in Free Form Table

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

jeff_bloomer_0-1620925802710.png

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?

Jeff Bloomer

View solution in original post

10 Replies

Avatar

Community Advisor

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!

Jeff Bloomer

Avatar

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

Avatar

Community Advisor

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

jeff_bloomer_0-1620924596959.png

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

jeff_bloomer_2-1620924782430.png

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.

 

 

Jeff Bloomer

Avatar

Community Advisor

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

Avatar

Correct answer by
Community Advisor

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

jeff_bloomer_0-1620925802710.png

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?

Jeff Bloomer

Avatar

Level 2
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

Avatar

Level 2

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

free-form-tbl-zeroes.jpg

Avatar

Community Advisor

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.

Jeff Bloomer

Avatar

Level 10
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?