Get Twitter Impressions and Total engagements

[darogael]

Hello,

Is there a way I can capture Impressions and total engagements of a tweet from Twitter? I don't see that option available in Flow and upon investigation I confirmed it is unavailable in the Twitter- Connectors. Currently, the only way I see that available is to manually export the analytics from Twitter. However, I've seen folks on Twitter regularly updating Power BI reports of tweets related to an event which contains impressions and engagements regularly so it seems they are automating it somehow.

So far I have been successfully at capturing information from twitter via Flow and saving it in my Azure SQL database, however, I'm still looking for adding the impressions and engagements.

I searched around for a while and did come across these two articles. They are close but not exactly what I am looking for.

1. Stream Analytics and Power BI: A real-time analytics dashboard for streaming data
2. Get started using Azure Stream Analytics: Real-time fraud detection

I'm hoping someone can point me in the right direction.

Thanks in advance!

[Anonymous]

@darogael,

How about you connect to the Power BI template in Power BI Desktop? Based on the following blog, you are able to get data about 
impressions and engagements.

https://blogs.msdn.microsoft.com/samlester/2016/07/06/create-your-personalized-twitter-analytics-das...

Regards,
Lydia

[darogael]

Thanks Lydia.

That's the manual process I have been currently following. I'm looking at automating this somehow using Flow or Logic Apps. 

[Anonymous]

@darogael,

You can use Power BI REST API to push data from Twitter into a dataset, then create a real-time dashboard following the guide in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-real-time-streaming/ .

There is also a similar thread for your reference.
http://community.powerbi.com/t5/Developer/collecting-live-twitter-data/td-p/235059


Regards,

[darogael · Accepted solution]

Thanks guys, but I was able to get the impressions and engagements created based on the same formulas Twitter uses. I'm good for now.

[sergioe]

Can you tell us how? Thanks!