Exports enables you to export sets of data (built in Reports ) in standart formats to applications outside Adloop. Those sets of data are automatically updated according to the chosen frequency #timesaver

1 - What is an Export Destination?

Very simple! Before being able to export data, you have to define a Destination. It is the location the Export will arrive to.

We are regularly adding new Destinations, email is the default destination. But sending data goes through Analytics apps, Data Visualisation or Datamarts.

To add Destinations other than email, you must have the corresponding access rights. If you don’t have access to it, contact your administrator within your organization.

To add a destination, simply click on +Add in Export Destinations and choose the desired Destination in the list.

2 - Available Export Destination

During the process of creating a destination, you will have to fill in a destination name. We advise you to give a precise name to each Destination you create, it will be easier later on.

To this day, the available Destinations are:

a - Email Destination

Nothing particularly difficult. Just type in the email adresses, separated by a comma in case of multiples email adresses.

b - Google Drive Destination

See our dedicated Google Drive page.

c - Server FTP ou SFTP Destination

See our dedicated FTP/SFTP page.

d - Google Chat Destination

Adloop sends the export files into a Google Chat room. See our step by step explanation in our dedicated Google Chat page.

e- Slack Destination

Adloop sends the export files into a Slack channel. See our step by step explanation in our dedicated Slack page.

Export destinations

For help with this Google Data Studio connector, please use the Adloop chatbot.

Connecting your Adloop Dataset to Data Studio

Creating a Google Data Studio Export Destination

Information needed by Data Studio

In the connection process, Data Studio will ask you for 3 pieces of information from Adloop.

This information can be pre-populated directly by Adloop but in some cases it is not present.

(1) The Auth Token can be found in your user profile in Adloop

(2) Workspace URL

This is the URL of the Workspace in which the Dataset you want to connect is located.

(3) Dataset ID

You can find it in the Dastasets page as a number: 1, 2, 3 ...

Adloop / Data Studio Connection

To start the connection, just click on :

If you want to receive your exports to an email address (yours or someone else’s!), nothing simpler.

Just add the desired email destination in the Expot destination page, by clicking on the button.

Then, choose Email

Write in the field the email address you want to use for the export.

You can write several addresses at once, just put a comma “,” between each address! And remember that if you choose this email export destination later, the export will be sent to all the email addresses in the destination .

Save your destination and you can already use it!

The Google Analytics export connector concerns what Google calls ' Cost Data ', i.e. the ability to import Impression, Clicks and Adspend metrics from the selected Data Sources in the Google Analytics Acquisition reports against the UTM dimensions.

How often will the import happen?

Once the connector is in place, Adloop will send daily data from the previous day. To ensure quality data, Adloop will also send data from D-3 on a daily basis (this may change as we indicate in our [[quality policy|Data-Quality]]).

A. Requirements for using the Google Analytics connector (cost data)

Only data from campaigns not managed by Google can be imported by this connector. Therefore, data from campaigns managed in Google Ads or Google Campaign Manager will not be imported.

1. Prepare the Matching between Data Sources and Google Analytics UTM

Google Analytics identifies the acquisition sources thanks to the UTM parameters (Source, Medium, Campaign etc.). The Platforms Data Sources have another form of nomenclature with specific dimensions.

Matching consists in matching the dimensions of the Platforms Data Sources you want to import with the UTM values of Google Analytics . This way Google will know where to put the data.

For more information about Matching, see the [[dedicated section|Matching]].

2. Create a Dataset in Google Analytics

To create a Dataset, follow the procedure below:

Admin > Data Import > Create

Select Cost Data then Continue

Give a name to the Dataset and select the Views it will impact (one or more)

Do not forget to select the Overwrite option. This is because Adloop sends data over several days to ensure that the indicators are completely reliable (see information on [[data quality|Data-Quality]]). If you leave the Summation option, the data will be added instead of replaced.

After validation the Google Analytics data set is created and you can copy its ID :

B. Creating the Export Destination and the Export in Adloop

1. Create the Export Destination

In the Export Destination, select the following connector:

• Name of the Destination

• Google Analytics account to send the data to

until you get to the screen where you are asked for the Data Set ID : (the ID retrieved from Google Analytics above)

Validate everything and that's it, your Destination is ready.

2. Create the Export itself

No difficulties in this process.

Step 2: Select the Data Sources you want to send to Google Analytics

This is where you need to make sure you have configured consistent matching rules for the Data Sources you want to send, otherwise you will get an error like this:

Step 3: Name your export

Adloop sends and updates the exports in a folder available on a FTP server (port 21) or sFTP (port 22).

The process and the fields to fill in are the same for FTP and sFTP. The only difference is that sFTP uses an encryption key to secure the data.

To allow Adloop to write in your FTP, you must connect it to Adloop with:

1. The server FTP address

2. Login and password

3. A folder name, if needed

1 - Allow Adloop to access your FTP

The connection process is just filling in the form boxes.

Login and password (sent by a system admin)

Host : address of your FTP server

noteIt must look like this: ftp.company.com

It must look like this: ftp.company.com

21 is the FTP default port / 22 is the sFTP default port You can use another port, sent by your system admin

Destination Folder : indicate the folder in which the files will be dropped.

2 - Submitting and checking the connection

By clicking on Submit, your connection will be checked according to your parameters.

In case the connection fails, you will have an alert:

If the connection is OK, you just need to name this Destination and you are done!

Your FTP or sFTP destination will now appear in your destinations list.

Adloop sends and updates the exports with a file in a Google Drive Folder.

To enable Adloop to write in your Google Drive, you have to connect it to Adloop by using your usual ID.

1 - Connect Adloop to Google Drive

The connection procedure is usual.

Click on Google Drive > Select an account

Authorize Adloop to access your Google Drive account.

Si your Google account is also linked to Google Ads or Google Analytics, the authorization will be valid for all the Google applications, you will only have to give once the connection authorization.

2 - Select a destination file

Once the connection set, you can create a destination file or select an existing folder for the Adloop exports.

New folder creation:

Your Google Drive Destination will now appear in the destinations list.

Adloop sends and updates the exports with a file in Google Sheets.

To enable Adloop to write in your Google Sheets, you have to connect it to Adloop by using your usual ID.

1 - Connect Adloop to Google Sheets

The connection procedure is usual.

Click on Google Sheets > Select an account


Your Google account is also linked to Google Ads or Google Analytics, the authorization will be valid for all the Google applications, you will only have to give once the connection authorization.


2 - Select a destination file

Once the connection set, you can create a destination file or select an existing folder for the Adloop exports.

New folder creation:

 Existing folder selection:

Name this destination and you are done!

Your Google Sheets Destination will now appear in the destinations list.