im trying to connect social media data to our DW. its pretty stright forward to make the connection, but when connecting to twitter specifically we seem to get tons of tables that are very confusing, and the documentation provided isnt a ton of help. has anyone managed to tame the tables that import from twitter? im trying to get basic metrics, similar to what facebook provides, things like, engagment, impressions, likes, retweets, etc. can anyone provide any guidance as to which tables these would be located in or how this can be achieved? (or let me know the very obvious thing that i am probably missing?)
Please sign in to leave a comment.