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 two ways export content-related data via the content stream actions and from a dashboard widget.
Check out this product tutorial which will walk you through these steps on your screen, or follow the simple steps below:
Export from the Content Stream
Within Search, Inbox or Explore, load the articles you'd like to export
Via the tick box, select the articles. If you have used the 'tick all' option and have more than 25 articles 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
You are able to export up to 20K articles at a time to an excel file and up to 100 articles 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.
Note: as per Facebook's terms of service and privacy policies, exporting Facebook & Instagram content has been disabled.
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.
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:
Alternate Date Format
Twitter Social Echo
Facebook Social Echo
Reddit Social Echo
Twitter Screen Name
User Profile Url
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.
Thank you for reading. If you have any further questions, feel free to reach out to us via Live Chat!