Data Feed: What does a value of 0 mean in the Browser.tsv lookup? | Community
Skip to main content
S
ShaunAu1
June 16, 2023
Solved

Data Feed: What does a value of 0 mean in the Browser.tsv lookup?

  • June 16, 2023
  • 2 replies
  • 1316 views

For the most part, values are as expected and I can find a matching Browser. However, some rows in my data feed are tagged as 0. Does that mean this value was missing from that hit and Excel is simply inserting a 0? (I know Excel does some strange things such as with the Event_List that do not appear when pulled into a SQL database).

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by leocwlau

You may try to look at the "user_agent" for those lines with 0 on "browser" and see if there is a valid "user_agent" for Adobe to determine the browser.

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 16, 2023

I don't have a browser.tsv file handy in front of me... is the file small enough to open in something like Notepad++ or Text Editor? Something that doesn't like to "auto-convert" data?

S
ShaunAu1Author
June 16, 2023

The browser.tsv file is surprisingly large but I used a findstr looking for 0 and it doesn't bring back any rows. However, if would be the data file I'd need to attempt to open to find out if Excel is adding the 0's and I don't think that would work in Notepad. The client is supposed to be setting up a SQL space for me with a week's worth of data, and it will be easier to see if 0's actually return in the data feed or not. Right now, I'm treating them as NULL values.

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 16, 2023

Well I was thinking Notepad++ not just Notepad.... Notepad++ is a really good tool with lots of plugins to support things like format JSON, CSV Query, it supports regex find and replace... 

 

But, yeah, if the file is huge it may still be a problem to sort through... 

leocwlau
Community Advisor and Adobe Champion
leocwlauCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
June 20, 2023

You may try to look at the "user_agent" for those lines with 0 on "browser" and see if there is a valid "user_agent" for Adobe to determine the browser.

S
ShaunAu1Author
June 20, 2023

Ok, I will try that approach.

Terms & ConditionsAccessibility statement

Loading footer...