Export Console Quickstart
In this tutorial we cover the basics of creating an export using the Export Console.
Using the Export Console you can create one-time and recurring exports of historical data based upon your Meltwater searches. You can download the results in CSV and JSON format, and can use the results in a BI Tool such as Tableau or Microsoft PowerBI.
Before you start
To run through this tutorial, you will need:
- Your Meltwater app login credentials
- A Saved Search in your Meltwater App account
What we will cover
- Accessing the Export Console
- Creating a one-time export
- Viewing your exports
- Getting the Data URL for your export
- Creating a recurring export
Types of exports
There are two types of exports:
- One-time exports - these exports are run once, the data will not be refreshed. Use one-time exports when you just want to get an export of data for a specific time period.
- Recurring exports - these exports give you the ability to setup an export once and get results updated regularly. Use recurring exports when you need to have the latest data for the predefined time span e.g. "last weeks data refreshed every week". This works well in combination with the scheduled refresh functionality of many BI tools.
1. Accessing the Export Console
You can access the Export Console from the left-hand navigation.
You will be asked to to sign in with your Meltwater application credentials.
Signing in gives you access to the searches you have saved in your Meltwater account.
2. Creating a one-time export
Exports are generated using searches you've created on app.meltwater.com.
Select one of your Meltwater Searches from the dropdown menu.
Select 'One-time' as the export type.
For one-time exports you must give a
START DATE and an
END DATE for the time window of your export. Only documents published within this time will be included in the results.
You are now ready to export the data. Click
Create Export to create the data export.
3. Viewing your exports
Once you've created your export, it will be listed Exports overview.
When your export is created, it will have an initial status of
PENDING. Depending on the size of the export it could take from a minute to over half an hour to complete.
Check the status of the exports by pressing the Refresh button. Do NOT use the browser refresh option or you'll need to enter your Meltwater credentials again.
Once the export is complete you'll see it's status will change to
4. Getting the Data URL for your export
Once an export has finished you can get the URL to access your export data by clicking the
The CSV format is ideal for importing into a spreadsheet or BI Tool. The JSON format can also be imported into a BI Tool which can process JSON data.
Note that the CSV format include less fields than the JSON format as it isn't possible to express all the available data in CSV format. Take a look at the Exports Formats & Fields page for full details.
If you'd like to bring the data into a BI Tool take a look at our importing data guides.
5. Creating a recurring export
Let's take a closer look at a Recurring Export.
For a recurring export select 'Recurring' as the export type.
For recurring exports you'll need to provide a different set of parameters.
First, you need to specify the Frequency for the export. You can choose from
Next you specify the Time Window for your export, that is what period of data is included each time the export runs. This is a multiple of the Frequency you selected.
For example, if you chose
Daily and enter
2 for this field the export will run each day and include the last 2 days of data.
Finally you can specify the precise time of your export. Your options depend on your selected frequency:
- time of the day for
- time and day of the week for
- time and day of the month for
Note that the export will be run
30 minutes after the end of the export period.
For example, if you set up a
Weekly export starting
09:00, the export will run every Sunday at 09:30 and will contain data from that Sunday at 09:00, to the previous Sunday at 09:00.
When you configure your recurring export you'll be shown a schedule of the upcoming exports which will help you check your settings.
Each time a recurring export runs the new data overwrites the data of the previous run. Therefore you download new data from the same URL each time the export completes.
You can see the recurring exports you have running by looking at the Exports Overview table. Recurring exports that are active have the status