Exports
Exports allow you to export datasets (built with Reports) into standard formats to applications outside of Adloop. Those datasets will update automatically according to the chosen frequency #timesaver
1 - Our objective: send fresh data without effort to your data ecosystem
Adloop says to copying - pasting! Updating your Dashboards, Excels, Datamarts with marketing data must take 5 minutes per day, tops. Set up your exports and Adloop will send the data in time.
What will I be able to export?
You can export everything that is in your Dataset. All the normalized dimensions or the ones that are source-specific, all the standards or calculated metrics, EVERYTHING! We can’t do more than that .
What triggers the Exports?
They will be sent automatically depending on the frequency set-up once the data sources are updated.
Adloop is first getting fresh data from the Data Sources we are connected too, and then we send the exports.
If some data couldn’t be updated, because the Data Source was unavailable, Adloop will nonetheless send the export. Then, we will do it again once the data have been updated.
How frequently?
You can choose how frequentLY the exports need to be sent: several times per day, daily, weekly etc.
Where do the Exports go?
Several Destinations are available, Exports can come under the form of CSV or Excel files, as well as data feeds to databases. Most of the time, our Exports are used to feed Dashboards built under Excel, Google Data Studio, Tableau… or Datamarts in AWS, Azure, Snowflake…
How do I select the data to put in my Export?
First, you have to build a Report containing all the data you want to send in your Export. A Date type column (day, week, month, year) will probably necessary in order for the external application to deal with the data.
2 - Components of an Adloop Export
Prerequisites - In order for the Exports to function, you need first to set-up:
One or several Data Sources
A Report with the data to export
One or several Export Destinations
An Export needs several elements to function:
Element | Details |
---|---|
Destination | The Destination is the application the Export will be send to. You must have created an Export Destination first. |
Report | The Report with the data you want to export. |
Segmentation | By default, the data in the report are agregated on the selected timeframe. If you want to have a breakdown per day or per week, you have to segment your data. |
Format | Adloop exporte les données dans des formats standards (Excel, CSV). Certaines destinations demandent des formats spécifiques qui sont gérés nativement par Adloop. |
Frequency | How often you want Adloop to export your data |
Name | The Export name is completely free, but we advise you to be precise. Indeed, if one day you have 15 active Exports, you will be happy you named them right in the beginning! |
3 - Create an Export
From the Exports page in the Export Center
Go to the Exports page using the sidebar, you can create an Export by clicking on
From the Report to Export
You can create an Export directly from the Report you are creating or editing by clicking on the button (More button) and by selecting the corresponding menu item.
Exports