topic Twitter metrics in QVsource in QlikView

Twitter metrics in QVsource

Anonymous — Tue, 13 Oct 2015 14:56:08 GMT

Can I find individual tweet favorites, retweets,replies using QVSource?

Re: Twitter metrics in QVsource

chrisbrain — Wed, 14 Oct 2015 08:29:56 GMT

Do you mean you would like to input a Tweet ID and get the count of the favorites, retweets and replies?

If so, the TweetLookup table will give you the favourite and Retweet count. e.g. for this:

https://twitter.com/MSNBC/status/654148404738703360

You also get these columns in other tables which return Tweets (e.g. the Search tables).

I do not think you will get the reply count like this, to do this you would have to gather all the Tweets you were interested in (e.g. using the Search table) and then use some script to check the in_reply_to_status_id field for all Tweets and count them up.

Re: Twitter metrics in QVsource

Anonymous — Fri, 16 Oct 2015 14:42:23 GMT

Thanks Chris.I have one more Question, Since twitter data is about 15 pages /1 week data; can we have storage internally? Did anyone did this?? i feel like it is not only insert, insert update?Please guide me pn this

Re: Twitter metrics in QVsource

chrisbrain — Sat, 17 Oct 2015 07:16:18 GMT

‌Yes, you can store and accumulate your data into QVD files which is a standard Qlik file format.