Metrics: "Engagement by account" section

[amindadgar]

We want to compute the analytics of "engagement by account" section. Basically, what it is, is explained as below

• [x] High quality and low amount: people who (reply | quote | mention) AND (less than 3 interactions of any kind). so this could be 1 replies and 1 mention, or 2 mentions
• [x] High quality and high engagement: people who (reply | quote |mention) AND (min 3 interactions of any kind). so this could be 2 replies and 1 mention, or 3 mentions
• [x] Low quality and low amount: people who (like | retweet) AND (less than 3 interactions of any kind). so this could be 1 replies and 1 mention, or 2 mentions.
• [x] Low quality and high engagement: people who (like | retweet) AND (min 3 interactions of any kind). so this could be 2 replies and 1 mention, or 3 mentions

[amindadgar]

The analytics seem to be able to be done using pure cypher queries in back-end. Here's the queries for each and we could do more filtering them in backend codes.

We will count each person's interactions with people and return the counts

1. Reply count of each user

   MATCH (t:Tweet {authorId: '{userId}'})<-[r:REPLIED]-(m:Tweet)
   WHERE m.authorId <> t.authorId AND r.createdAt >= {Epoch7daysAgo}
   RETURN m.authorId AS user, COUNT(*) as reply_count

2. Quote count of each user

   MATCH (t:Tweet {authorId: '{userId}'})<-[r:QUOTED]-(m:Tweet)
   WHERE m.authorId <> t.authorId AND r.createdAt >= {Epoch7daysAgo}
   RETURN m.authorId AS user, COUNT(*) as quote_count

3. Mention count of each user

   MATCH (a:TwitterAccount {userId: '{userId}'})<-[r:MENTIONED]-(t:Tweet)
   WHERE a.userId <> t.authorId AND r.createdAt >= {Epoch7daysAgo}
   RETURN t.authorId AS user, COUNT (*) as mention_count

4. Retweet count of each user

   MATCH (t:Tweet {authorId: '{userId}'})<-[r:RETWEETED]-(m:Tweet)
   WHERE t.authorId <> m.authorId AND r.createdAt >= {Epoch7daysAgo}
   RETURN m.authorId AS user, COUNT (*) as retweet_count

5. Likes count of each user

   MATCH (t:Tweet {authorId: '{userId}'}) <-[:LIKED]- (a:TwitterAccount)
   WHERE a.userId <> t.authorId
   RETURN a.userId, COUNT(*) as likes_count

Note 2: The {userId} is related to the main userId which they connected to our system. Note 3: The {Epoch7daysAgo} is representative of 7 days ago timestamp.