Overview
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 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 login, and click on export 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:
https://export-demonet.ingenioustech.biz/256a6f26-b72b-37f8e24ee373/statsdaily_2209.csv?jobid=30578a36
Structure of the export link
This link contains the following elements:
The https:// is the protocol.
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.
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 magic key, which identifies you as a partner.
The statsdaily element is 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.
Applying filters
Overview
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 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 login, and click on export 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:
https://export-demonet.ingenioustech.biz/256a6f26-b72b-37f8e24ee373/statsdaily_2209.csv?jobid=30578a36
Structure of the export link
This link contains the following elements:
The https:// is the protocol.
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.
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 magic key, which identifies you as a partner.
The statsdaily element is 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.
Applying filters
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:
filter[filtername]=filtervalue
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:
https://export-demonet.ingenioustech.biz/256a6f26-b72b-37f8e24ee373/statsdaily_2209.csv?filter[a:advertiser]=123&filter[timerange_type]=dynamic&filter[timerange]=thisweek1&filter[a:status]=3
[table id=12 /]
Available export files
Apart from the day to day reporting, which is called statsdaily, the following reports are available:
Reporting reports
Per product category (name: statsproduct)
Per advertiser (name: statsadvertiser)
Per conversion (name: reporttransactions)
Per ad media (name: statswm)
Per referrer (name: statsreferrer)
Per subID (name: statssubid)
Other reports:
Ad media (name: wm-export)
Advertiser data (name: mlist)
Product categories (name: prd)
Payment data (name: billing)
Vouchers (name: vouchers)
To use them, all you have to do is replace the name of the report.
Server restraints
Due to limited server capacity, the maximum number of files you can export is 10 per report per hour.