Documentation

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.

Google Warning

The connector provided by Cadulis is currently under validation. You may receive a warning message from Google.

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

Google Data Studio datasource


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

Large Volume Ingestion

This method is not efficient for ingesting large volumes of data:

If you have more than a few thousand rows, you will probably need to use a faster or even sequenced ingestion method. Below is ingestion via bucket, but you could also use BigQuery or another big data engine ;)

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.

Google Data Studio datasource 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