Database Reference
In-Depth Information
Second panel - Users Replying to @user
The following screenshot shows counts for
Impressions
,
Followers
,
Tweets
, and
Tweet
Text
for
@user
:
Counts for Impressions, Followers, Tweets, and Tweet Text for @user
The code for creating this panel is as follows:
index=twitter justinbieber in_reply_to_screen_name=justinbieber
| fields entities.user_mentions{}.screen_name user.followers_count text
user.screen_name
| rename entities.user_mentions{}.screen_name as mentions | mvexpand mentions
| search mentions=justinbieber
| stats sum(user.followers_count) as Impressions max(user.followers_count) as Follow-
ers count as Tweets values(text) as "Tweet Text" by user.screen_name
| sort 20 -Impressions
This panel looks at the top 20
user.screen_names
that tweeted
@justinbieber
during this time period, and then lists the sum of the followers who saw each tweet (re-
named
Impressions
) as well as the number of followers. (Notice that user
MyDream-
isDrew1
tweeted twice, so the impressions are double the size of the Followers.)