Tracking the retweets of any Tweet

Learn how to track retweets of any Twitter account

Intro

Ellen DeGeneres’ photos of the 2014 Oscars, portraying a bunch of Hollywood superstars, marked a record and still is in the top 5 most quoted tweets of all times, with 3+ million retweets.

While likes on social media make anyone feel warm, sharing is the real powerhouse. Thanks to its compounding effect, Retweeting is a super powerful tool to promote your product and quickly boost your brand awareness.

In this short guide, we’ll walk you through all the steps to build a report to track any Tweet’s retweets, all in a spreadsheet.

Here is a sneak peek of what you will get:

retweets tracker

Twitter engagement glossary

Before getting started, let's briefly go through some definitions. As a business, Twitter offers its community a broad range of actions to engage with your social media activity:

  • Follow. Following an account puts it on your feed and allows you to get updated when it posts new content.
  • Like. Use it to show appreciation or endorsement of specific posts.
  • Retweet. Use it to re-share some content to your follower base, ignite discussions, and support a cause.
  • Reply. Through reply, you can directly add a personal comment below any Tweet.
  • Share. Use it to share the link to a specific Tweet with anyone outside Twitter.

Based on these actions, some relevant metrics are computed:

  • Impressions. The total number of times a Tweet is displayed in the timeline or search results.
  • Engagement. The sum of all interactions a tweet has triggered (mainly likes and retweets, but also replies, expansions, hashtags clicks,...) defines the so-called engagement of a tweet.
  • Engagement rate. All engagements divided by the impressions of a Tweet. It represents a measure of how reactive your follower base is.
  • Link clickthrough. The total number of times a link in a Tweets has been clicked.

Let's go

First of all, use our template at the following link Retweets tracker and save it in one of your workspace's folders.

This template allows you to have a quick list of any retweets of a Tweet, thus helping you to monitor your or your competitor's engagement activity.

Let's reverse-engineer it together.

First of all, you need to enable the data connection and connect your Twitter account to Rows. Click on the top modal and then follow the instructions. The typical Twitter Auth page will open: enter your Twitter handle and password, and authorize Rows to retrieve your data.

Now you are back on the spreadsheet, ready to set it up. In cell B1 of the Search table, past the link of the Tweet your want to track

Screenshot 2022-09-05 at 10.37.11

In cell B3, our SEARCH_RETWEETS_TWITTER() function uses the tweet_url as unique parameter to retrieve retweets' data.

B3 is a data cell. In Rows, a data cell stores more than a string or a number, the typical content of standard spreadsheets' cells. In this specific case, it data about the retweets of the picked Tweet. Moreover, cell B4 displays its count, thanks to the following PARSE() function:

1                =PARSE(B3,"[0].['retweet_count']")
PARSE() is used anytime you need to read and extract a single datapoint from a data cell in [JSON format](https://rows.com/docs/parsing-data-manually), such as B3. It uses as a first argument the data cell in B3 and, as a second one, the path to spot the desired element.

Rows offers a friendly way to obtain it. Click on the ... icon in data cell B3 and choose View data. A panel on the right-end side will open, allowing you to navigate the data structure.

The highest level displayed represents the list of Retweets. Click on any element and hit COPY to the right of the metric retweets_count.

Screenshot 2022-09-05 at 11.03.28

The function is now copied on your clipboard, and all you need to do is to paste it into a cell, let's say B2.

The "Retweets" table is designed to show insights about anyone who retweeted the picked Tweet. It is built using our 'Create a table' function: let's have a closer look at it together. Click on the ... icon in data cell B4 and choose Create a table. A panel will open on the right-end side. Here you can pick the table headers, i.e. the metrics you want to display as columns in the output table and the table destination, here cell A1 of the 'Retweets' table.

The current table includes the following data:

  • Date. The timestamp of the retweet.
  • Username. The username of the user that retweeted our post
  • Text. The text of the retweet, which may contain a comment above the shared Tweet or not
  • Location. Where the user who retweeted is based
  • Description. Its description, as displayed on its profile
  • Followers. Its number of followers
  • Likes. The total number of likes it gave
  • Verified. A parameter, TRUE/FALSE, that indicates whether the account is verified or not

You can always modify the metrics, columns' order, and name by clicking on the ... in the last column header of the table.

Due to specific constraints of Twitter APIs, only a limited number of retweets are fetched.

You might also like