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

SOLVED

Zeroes Appearing in Row Results in Free Form Table

JohnRog
Level 2
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
jeff_bloomer
Correct answer by
Level 8
Level 8

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

View solution in original post

10 Replies
jeff_bloomer
Level 8
Level 8

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

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

 

 

PratheepArunRaj
Moderator
Moderator

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

jeff_bloomer
Correct answer by
Level 8
Level 8

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

View solution in original post

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

jeff_bloomer
Level 8
Level 8

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_belliston-Adobe
Community Manager
Community Manager
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?