The following steps will help you to check how many tweets in your dataset have been deleted from Twitter, which could have been done by a user or the platform.
Step 1: Install a free text editor that supports regular expressions such as Nodepad++
Step 2: Download your dataset from Netlytic as an Excel or CSV file and open it in Excel
Step 3: Copy the column called โguidโ from the Excel file into a new text file in Nodepad++
Step 4: in Nodepad++
- delete the first row with โguidโ
- using the Search & Replace function, find โhttps://twitter.com/โ (no quotes) and replace it with an empty character โโ (no quotes)
- using the Search & Replace function, find โ/statusesโ (no quotes) and replace it with an empty character โโ (no quotes)
- using the Search & Replace function in the regexp mode (check the appropriate check box), find the following regular expression ^[^\n\t\r\/]+\/ and replace it with an empty character โโ (no quotes):
Step 4: in Nodepad++, save it as a new text file (letโs call it โids.txtโ; this file will include a list of unique tweet ids.
Step 5: Install a free Hydrator app
Step 6: in Hydrator:
- Link your Twitter account to Hydrator (under Settings)
- Open the “ids.txt” file in Hydrator by adding it as a new dataset.
- Click the “Add Dataset” button
Step 7: Continue in Hydrator:
- Run the collector by clicking the “Start” button.
- Once ready, save the dataset by clicking on the “CSV” button. The resulting file will include all original tweets/retweets (minus those that have been deleted either by the users or the platform). A side benefit of this process is that the original dataset is now enriched with additional metadata elements that have not been originally collected by Netlytic (such as the number of times a tweet has been retweeted).
Step 8: Once the recollection process is complete, click on the green bar to see how many tweets have been deleted from your original dataset. For example, in the sample dataset 4% of tweets have been deleted.
PS. To check if a tweet was deleted by its creator or by the platform, try the following python script: https://github.com/DocNow/twarc/blob/master/utils/deletes.py