Need access to your data outside of Meltwater to create a report? Whether you're using Tableau to mine content for patterns or you're relying on an offline process for building earned media reports, we help you export data from Meltwater. Below we'll cover multiple ways to export content-related data via the content stream actions and from a dashboard widget.
Check out the simple steps below:
Export from the Content Stream
Within Explore or Monitor, load the articles you'd like to export
Via the tick box, select the results. If you have used the 'tick all' option and have more than 25 results in your list, please note the alert with a prompt to 'Select all'.
From the quick toolbar, select the Export icon
An Excel report will then be emailed to the address you used to log into the platform
Alternatively, when your download is ready you'll receive an alert icon at the top right of your page.
Select Alerts and use the download button
The maximum size results available to export are 20K results at a time to an excel file, and up to 500 results as a PDF. In order to support large-size reports (>10MB) we do not attach the report, but you will be able to download the report from the cloud by clicking the download link in the email, or via alerts.
If your total results exceed 20K, you have two options for exporting. Click the download button, prior to selecting any results via the tick boxes, to display these options.
Export the first 20K results
Export a randomized sample of 20K results
Export the first 20K Results
This option will download the first 20K results available. Results are ordered based on your sort type and sort order. You can change your sort type and order by clicking the three lines beside the download button, and selecting your preferred options.
Export a randomized sample of 20K results
This option will export a randomized 20K sample from your total results. Some things to note about random sampling.
How the data is randomized: Each result is randomly assigned a number between 0 and 1. Selection is then based on the percentage of results to include in the export, totaling 20K. For example, for 200K results, each result randomly assigned a number between 0 and 0.1 will be included, so that 20K results are returned.
There are no special considerations used when randomly selecting results. All results are weighted equally.
Sampling will be evenly distributed across the selected time range. For example, if your results total is 200K for a 10 day period, your export would include 2K results per day.
Each random sample export will return different results than the last. For example, if you export a random sample 3 times, you would have 3 different data sets.
Export from a Dashboard Widget
Hover over the widget and select the blue arrow to load a larger view
Select the Export button on the top right
You can export the widget as a PDF, Image, Excel (Raw Data) or Excel (Analytics)
Take a look at the image below for a quick run-through:
The processing time of your request will depend on the amount of data requested. You should receive an email with a link to download the report within minutes of your request. Check your spam folder, if necessary.
Export from the Meltwater API
If you would like to automate your exports, or export larger volumes of data, you can do both via the Meltwater API. For more information on how to access and use the Meltwater API, please review this article.
Exporting on a MAC without Excel troubleshooting
When exporting data, after a few minutes you will receive an email with a link provided to download its content. If your Safari browser is trying to open the file within the browser rather than downloading the file, please follow the below steps:
Right-click (or control-click) the 'Download Report' link in the email and go to 'Save Link As...' and save the file to a location convenient for quick and easy access (Downloads folder or Desktop folder, for example)
Copy the link in the email that is posted under the text "You can also copy and paste the following URL into your browser:" and paste the link into another browser, such as Google Chrome or Firefox, which will then download the file automatically to their computer
Copy the contents that are displayed on the page and paste it into Excel manually
Details included in your exports
CSV exports include the following fields for each item of news or social post:
Date | Reach | Key Phrases | Twitter Followers | Is Verified (Twitter Only) |
Headline | Desktop Reach | Input Name | Twitter Following | *Likes |
URL | Mobile Reach | Keywords | Alternate Date Format | *Replies |
Opening Text | Twitter Social Echo | Twitter Authority | Time | *Retweets |
Hit Sentence | Facebook Social Echo | Tweet Id | State | *Comments |
Source | Reddit Social Echo | Twitter Id | City | *Shares |
Influencer | National Viewership | Twitter Client | Body | *Reactions |
Country | Engagement | Twitter Screen Name | Document Tags | *Threads |
Subregion | AVE | User Profile Url |
| |
Language | Sentiment | Twitter Bio |
|
*More information about expanded engagement data by source:
News - Social Echo Total, Editorial Echo
Twitter - Is Verified, Replies, retweets, likes
Reddit - Threads, reactions
TikTok - Shares, threads, reactions
YouTube - No engagement data, due to terms of service restrictions
Facebook - Comments, shares, reactions
Instagram - Threads, reactions
Facebook update:
You can now export Facebook content within a CSV and PDF export. This will also include Instagram hashtags, competitors verified handles and their content within your exports.
FAQ:
Q: What is Social Echo?
A: Social Echo helps you understand the real-time number of social shares for any editorial document. This tool will provide you with a volume of social media interactions (such as posts, shares, retweets, etc) with a specific online news article. More information can be found here.
Q: What is Editorial Echo?
A: Editorial Echo indicates how many times the article is referenced with a hyperlink in the body of a different article.
💡 Tip
Need more help? Feel free to reach out to us via Live Chat or check out our Customer Community.
Find answers and get help from Meltwater Support and Community Experts.