Maybe you already read it in the getting started guide: in the export section of your partner UI, you can export most of the data relevant for you in CSV, XLS, and XML format. In some cases, however, you might want to import data automatically. This article explains to you how to do so.
Creating a report an export URL
Getting the export link
To prepare your automated data import, you need to create an export URL. The easiest way to do this is to get the download link in the export section of your UI. Just log in, and click on Insights -> Exports in the main navigation menu. Proceed to select the kind of data you want to export and the file type you want the data to be exported in. As was mentioned above, you can choose from CSV, XLS, and XML formats. Just right-click on the relevant format icon in the relevant row and select the target URL via the browser window. Suppose you choose the day to day reporting and want to export them in CSV format. In this case, your URL will look more or less like this:
The export-demonet.network.biz is the domain. The export element is used for all export links related to the platform, the other elements identify the platform you are admitted to. Your domain will be different than the presented one and specific to the network you work with.
The 256a6f26-b72b-37f8e24ee373/statsdaily_2209.csv element is called the path. It can be subdivided in the following elements:
The 256a6f26-b72b-37f8e24ee373/ is the API key, which identifies you as a partner.
The statsdaily element is the name of the report.
_2209 is the user ID identifying you as the user for which the report is generated.
The .csv element is the file extension, indicating the format you choose.
The jobid is used to identify the export in the context of your partner UI.
To prepare your link for automated usage, start by removing the jobid from the export link. After you have removed the jobid, you need to apply filters to specify the data you export automatically. You can find a complete overview of the available filters in the table below.
These filters need to be added to the export link using the following structure:
Place the first filter immediately after the question mark in the export link and begin all further elements with an ampersand. If you do so, your link will look more or less like this: