How to export your Revue newsletter data

This week Twitter's newsletter platform Revue announced they would be shutting down on January 18, 2023. If you have a Revue newsletter, you can export all your data with just a few clicks. 

Twitter acquired Revue in January 2021, as a way to "jumpstart their efforts" to support long-form writers. With the takeover of Twitter by Elon Musk at the end of October, many employees were laid off, and a number of features have been removed. It was expected Revue would be on the chopping block, so this does not come as a surprise. 

Note that if you have a paid newsletter, you should wait until December 19 to export your data to be sure it includes paid subscribers. 

Export your Revue Newsletter Data

Your Revue export includes: 

• Your list of email subscribers as a .csv file
• Email address
• First name and last name
• Date subscriber was added
• Your newsletter issues, including content and metadata
• issues.csv file: issue ID, description, date and time issue was sent, subject line and preheader
• items.json file: title, issue ID, item type (tweet, link, text, header, video or image), URL (if a link), description, order (placement in issue), image URL
  NOTE: the archive does not include uploaded images, just links to the images (which will break after Revue shuts down)
  Also note that the items.json file is not really human-readable. 
• Your newsletter issue statistics
• number of dropped emails
• number of delivered emails
• number of deferred emails
• number of bounced emails
• number of opened emails 
• number of clicks on links
• number of times a member reported an issue as spam
• number of members unsubscribed when the newsletter was sent
• number of emails processed to be sent
• number of subscribers when the issue was sent
• number of times a member reposted the issue
• number of up and down votes

Click to enlarge

Create a Revue data archive: 

1. Sign in to Revue (www.getrevue.co)

2. On the top banner that says We're shutting Revue down click Learn More

Or open the shutdown page directly at www.getrevue.co/app/offboard

3. Click the Export my data button

You will see a notice that says: 

Your data is being exported. We'll send you a link to your export once it’s ready.

This is a pretty fast process. My data with 68 newsletter issues was ready within 15 minutes.

Download your Revue data: 

When your data is ready, you will receive an email from Revue. 

The email has a link to download your data. This link only remains valid for 7 days, so download your data as soon as possible.

 

1. Open your email from Revue with the subject line Your data export is ready

2. Click the Download export button. 

If that does not work, you can copy and paste the full URL from the email into your browser's address bar.

This downloads a .zip file onto your computer's desktop.  My file was about 304k. 

The .csv files can be imported into Google Sheets or your favorite spreadsheet editor.

Where can your Revue newsletter data be imported?

There are several platforms that let you import Revue newsletter data: 

Ghost is an "all-in-one" platform designed for creators, writers and news media, that lets you create a website and paid newsletters. It's $9 per month for up to 500 subscribers. Instructions for migrating from Revue.

beehiiv is a popular newsletter platform that lets you monetize with paid subscriptions. It has a free tier.  Instructions for migrating from Revue. 

Loops is a new platform designed for email marketing for SaaS startups. While there is currently a waitlist, current Revue users can sign up immediately.

Note that Substack has a Revue newsletter import tool (substack.com/revue) that does not require exporting your data first.