Adloop imports data stocked in outside apps thanks to our Data Sources .

The Ad Sources are Data Sources connected to Ad platforms.

Add a Data Source

Adding a Data Source, nothing simpler! In the Data Source page, you just have to click on the button, a popin with the available connections appears.

You can search the connection by its name.

A small label appears on some Data Sources :

Connection types

Before connection a Data Source , you must have a access rights.

Each Data Source uses a specific connection mode, but there are 3 main types:

Dimensions and Metrics choice

Once the connection is effective, you have to choose the [[ Dimensions |Dimensions-in-Adloop]] and the [[ Metrics |Metrics-in-Adloop]] we have to get from the Data Source .

The default Dimensions or the default Metrics will be imported no matter what, because they are main elements of our reports. It is not possible to delete them.

The Other dimensions and the Other metrics can be selected if you need them.

noteIf you don’t find a Dimension or a Metric, ask the Adloop Support!

If you don’t find a Dimension or a Metric, ask the Adloop Support!

Imported period and import frequency

Adloop imports a year of data when a Data Source is added.

Once added, data are updated every 3 hours or 8 times a day.

Depending on the Data Sources and the API quotas, importing a year of data can take between 2 and 72 hours. Sometimes, you have to be patient!

Data Quality

See our page dedicated to [[ Data Quality |Data-Quality]].

It may happen that a data source you are using is not available in our list of API connectors. In this case, you can create a custom data source.

For each custom data source, you will be able to download external data files for full data completeness.

Only create a custom data source if you plan to import external data! Otherwise you can use the Organic Sources tab in the Matching section.

1. Create a custom data source

In the Data Sources tab, click on "Add" and select "Custom Ad Source".

You will then have to give a name to your data source as well as fill in its type (Affiliate, Social, SEO etc.)

Next you will need to import the file containing the data for the desired source into Adloop. This file must have headers and raw data (no formulas).

Supported formats are : XLSX, XLS, ODS and CSV (UTF-8 encoding).

It is better if your file contains a date column! This allows you to add the data of several days at once. Otherwise, you will have to upload one file per day.

This file can be used as a template for future imports. This will facilitate the import process the next time. It is therefore better if you upload a file directly from the advertising platform (unmodified).

You can click "Submit" to upload your file.

Next, Adloop asks you to indicate which row is the header: choose the column with the title of your columns.

You will now be presented with a screen asking you to map your column titles to Adloop dimensions or metrics. For each column you have to indicate which dimension or metric corresponds to.

Example: For my column called "Cost" in my file I choose the corresponding Adloop metric "Ad Spend".

For my column called "Campaign", I choose the corresponding Adloop dimension "Campaign Name".

If the metric or dimension is not available in the list, you can create custom ones. These will then be specific (not standardized) items. To do this, use the "Add metric" or "Add dimension" buttons.

If you don't want to import a column, choose the "Will not import" option. The data in the column will then be left out.

Choose the currency in which the data in the file is entered and, if applicable, the date.

At the end of the set-up you can choose between overwrite & add data options.

Overwrite: a new imported file on the same dates will erase the previous one

Add data: data on the same dates will be summed.

Your data source is now created!

2. Importing new data from a custom source

In the Data Source tab, select the data source for which you want to import data and click on the "Load new file" button

By clicking on this button, you have two options: upload a new file (and therefore make the column matches again) or use the configuration of a previous import. (By clicking on the arrow)

3. Manage the list of manual imports

By clicking on the button "Display custom imports", you access the list of imports for a given source.

From this list, you can delete one or more imports if the data are no longer up to date.

https://www.youtube.com/watch?v=n3ZbwelZeQ0

For the main Advertising Platforms, we are able to fetch automatically the data, several times a day, after the source is added in your Adloop space.

A data source is missing? Contact our Support Team to add it on our road map!

1. Add a data source

In the Data Sources tab, click on "Add" and select the desired data source.

The most popular ones can be found at the top and after they are organized per categories: Search, Shopping, Social…

You can also use the search bar to find directly the source you are looking for.

If the source is not yet available, you can use our [[custom data source function|Custom-data-sources]] to import data!

Once you have found your data source, click on it and follow the instructions on the screen.

1- Dimensions selection

Normalized dimensions are imported by default, but you can choose to import additionnal dimensions by ticking them.

2- Metrics selection

Normalized metrics are imported by default, but you can choose to import additionnal metrics by ticking them.

3- Data-sources specific steps

Some connectors have optional steps.

• Google & Facebook: custom conversions import

If you have set-up custom conversions on Google and Facebook thanks to conversion pixels, you can import them in Adloop as well.

4- Filter the data (optional)

You can choose to filter the entering data based on the naming of the campaigns, adgroups etc.

This is very useful if you have all your countries campaigns regrouped in the same Ad Account but you want to split your Adloop data per country.

It’s important to note! When adding more than one filter on the dimensions it’s either AND/OR depending on which operator you are using!

• if it is a "positive" operator (eg: contains, equals), it will be an OR

• if it is a "negative" operator (eg: is not equal to, does not contain), it will be an AND

So imagine you are doing something like the screen, it will be: IF the campaign begins with "Black Friday" or "Xmas" AND does not contain EN AND HU

.png)

5- Import

At the end of the process, click on the Start Import button and the data will start flowing in!

We will gather a full year of data history.

Connecting data sources

In order for Adloop to connect to your Rakuten Account and obtain the relevant data, we need you to create a specific report and give us the report's API url.

Dont' worry, we will guide you through the process !

1. Go to your

2. Go to the "Report" tab, click on "Choose Reports" and select "Revenue Report by Day"

3. Select the following columns:

• Transaction Date

• Publisher Name

• Publisher ID

• Number of Impressions

• Number of Clicks

• Total Commission

• Number of Orders

• Sales

1. Select the same timezone as your dataset, by clicking on the date picker.

2. Save your report

3. Click on "View Report" and select "Get API". This will give you an URL.

4. Copy the given URL and paste it in the field provided by Adloop.

That's it, well done !