Twitter metrics in QVsource

[Anonymous]

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

[chrisbrain · Accepted solution]

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.

[Anonymous]

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

[chrisbrain]

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