LookerStudio - Data source

Connect to Google Looker Studio (Looker Studio): https://datastudio.google.com/

Predefined Cadulis Data Source

2-Click Creation from Cadulis Export

From the configuration page of your data export on Cadulis, you can directly click on Create a DataStudio/LookerStudio data source

This link will open the LookerStudio data source creation page, already pre-filled with your Cadulis download code.

If you used this method, you can skip directly to report creation

Manual Creation with the Code

Click on Cadulis activities data source

Enter your Cadulis code, obtained from the export configuration page.

To create a data source for tracking your Cadulis licenses: Cadulis licenses data source

Proceed to report creation: your data source is configured!

Data Source

Log in to your previously configured Cadulis data source: click on Create, then Data source

You will then need to choose the connector

Cadulis

Search for Cadulis and select the partner connector provided by “Cadulis SAS” Cadulis activities.

You can also use the link Cadulis activities data source

Enter your connection code (previously obtained in your Cadulis export configuration) and confirm.

Remember to rename your data source so you can easily find it later!

Google Sheet

If you have configured the source in Google Sheet, select the Google Sheet connector

Select your Sheet file, as well as the sheet where you imported your data

At the top of the page, change the data source title: it will help you find it more easily!

Click on Connect

Google Cloud Storage

If you have set up the .csv export to a Google bucket, choose Google Cloud Storage

Select your file from the bucket

At the top of the page, change the data source title: it will help you find it more easily!

Click on Connect

Imported Fields

On this page you can refine the data type of the fields.

On this page you can pre-calculate fields, such as a lat_lon field, required for map visualization

Don’t worry: you can always come back later to modify the field types.

Your data source is configured!

You can always come back to edit it: refresh frequency, field types, etc.

Click on Create report

Bonus: lat_lon Field Calculation

For this example, we want to display a map with the positioned interventions.

DataStudio requires a field of type lat_lon but Cadulis only exposes latitude and longitude separately.

• Click on Add a field
• Field name: enter lat_lon
• In formula, write the following formula and save

CONCAT(location.latitude,",",location.longitude)

• Finally, you need to change the data type of the field, select Geographic data > Latitude,Longitude