Nov 14, 2023
To see the extraction orders configuration, you need to click on the order name in the extraction orders list.
The page header shows the extraction order name and status.
On the top right corner of this page, you’ll see Run Extraction button and a button for starting/pausing data extraction for an Extraction Order depending on its status.
Click this button to run the Extraction order for the selected date range.
Here you see one line from the data tables list and the data structure preview.
It contains brief information precisely about the data table to which the current extraction order refers:
The last column shows how many extraction orders relate to this table by granularity and the number of orders for each of these three statuses.
If there is no extraction orders in a certain status, then this status is not shown.
Hover over each status to see a tooltip:
IMPORTANT: A throbber (loading icon) means that at least one extraction order with the syncing status relates to this data table.
Hover over the loading icon to see how many extraction orders are currently syncing.
If all the extraction orders related to the data table have the syncing status you will see the total number of orders and zero on a gray background.
Data structure preview is displayed if data has already been extracted.
IMPORTANT: Metrics (CPC, CPM, CPA, etc.) calculated as a ratio of dynamic values will not be pushed to the destination or shown in your BI tools (PowerBI, Tableau, etc.) since there is no use in calculating such metrics in advance and storing them. These metrics will be available only in Improvado widgets.
Let's take CPC as an example. Cost per click for a period is calculated by dividing the overall cost of your ads by the number of clicks your ads received.
CPC = total_cost / number_of_clicks
Let's calculate CPC using the values given in the table above:
CPC = $1288.3 / 64 = $20.13
Avg.CPC = $21.84
As you see, CPC for a week is not equal to the CPCs for the same seven days. You will also get an inaccurate result if you use the average value.
This tab includes the same settings blocks you used when creating this extraction order. The set of parameters depends on the selected data source and extraction template.
Now historical data settings are available here!
To refresh the historical data you need to:
The maximum historical data depth varies due to the API specifics of different data sources. If customer needs historical data depth over the preset maximum value, it is necessary to raise a request via Improvado Service Desk. Our team will check if it is technically possible.
Here you can set the frequency of data extraction by changing the scheduling settings and adding or deleting schedules.
You can add one or several more by clicking the Add Schedule on the top right corner of this section.
If it is not available, it means you have reached your limit that is determined by your contract. To increase it, please get in touch with your Customer Success Manager.
Also, can delete the schedule by clicking the “trash bin” icon, but it is impossible to delete a schedule if it is the only one.
The schedule has the following settings:
Now you can schedule data extraction daily, weekly (by selecting the day of the week), and monthly (by choosing a day of the month).
The first schedule always has a default lookback window (you can not change it):
IMPORTANT: No lookback window for last day and last day (inc) extraction templates.
Previously the subsequent schedules had a Live lookback window. Now we’ve added the possibility to choose the max lookback window option.
Available dimensions and metrics are presented the same way as before: all available are on the left, all selected on the right. The “locker” icon shows those dimensions, but also, some metrics are selected by default, and you can not deselect them because they define the data table structure.
If you need to update your extraction order, it is essential to remember the following: