Wow! Even Ubi are quite close to sony.........
I do think its the hardware that gave its extra boost.

Not in a positive way. If you go to the link you can clearly see that they aknowledge that most of Ubisoft attention seems to be made up of criticism. They even linked a Jim Sterling tweet. Is gold trust me.

Yes, which goes a long way to show us social media statistics have marginal real world value.  The PS4 still beat the Xbox One easily over the course of the year.

My guess is that people are mentioning Xbox because Microsoft pushes "Xbox" really hard as a brand, and because of the hardware and system announcements, but that doesn't seem to correlate into sales.

As for games, Fallout 4 completely dominated mentions last E3, by an even greater margin than Zelda.

That's why this doesn't mean a lot.  When people are mentioning God of War or Spiderman, they don't really need to mention Playstation, too.  

It means the combining all the Sony games Beats All of the Nintendo games.

Microsoft (Games and console) > Sony (Games, PSVR) > Nintendo (Mostly Pokemon and Zelda) 

But Zelda Alone beats all of the games in its individual form. 

Are you sure the stadistics are the problem or is it E3 dwindling relevance? Does the casual Call of Duty crowd even care about E3? Is the PS4 really the system where most of the core gamer audience is and not just the mainstream choice? There are many ways in which these studies can be seen, but they are always only a small part of a bigger picture. It doesn't tell the entire story but they still can tell an integral part of it. They are not definitive, but is wrong to dismiss their importance.

What is shown is what happened during the few days of E3. Nothing more.

This

Zelda? By that much. Wow. Also MS? The show wasn't even that strong. Personally I found this E3 bland. Even though Sony showed more games it was pretty damn meh.

Your statistics are not showing... 

After Sea of Thieves I am going to have a trouble getting that amusement ride out of my head... Also, I liked MS more cinematic presentation and the fact that all their games are close to release... 

What is shown is the way a particular company has decided to group and correlate raw data, which is then twirled around in different ways by people who want different things out  of it.  If I say, "wow, omg, God of War is the best game I've ever seen," that would be just as meaningful to Sony as, "this Playstation conference is pretty good."  However, here people are looking at one metric--conference mentions--and deciding a "winner".  Who won what, though?  What conclusions are you reaching with this data?  That mention of a PS4 game might just have sold a PS4 console while the conference mention went nowhere.

Unless it's correlated with real world results, what can be learn?  Have we learned anything from last year's data?  One firm had Xbox completely dominating Twitter last year, what can we conclude from that?

If data is meaningful we have to know in what way before it's useful.