Step by step guide how to integrate Eskimi reports to Data Studio

Introduction:

We have an option for basic integration with Google Data Studio, but it is very basic, so the information we can transfer is Impressions, spend, clicks, but nothing advanced like media spend, or top creatives.

Another thing is that we have created this Google Data studio for one of our clients, so it is not fully done I would say and we could struggle in the future if we need to fix something or update, as this was created with external developers. So we can try and help to integrate this for the client, but explain that this is BETA version, and might not deliver as expected.

Guide: 

1. Here is the whole project: https://script.google.com/d/1hMynjLYLcn24olG_9INpfqgD3OPTcvrXIYu7IOBFQdroDehgjJkt2v_a/edit?usp=sharing

Link can be opened only if you are a part of the “Eskimi” organization. So make a copy of this project. This contains the data studio connector code and is already deployed. This can obtain basic campaign stats, and video metrics.

When the project is copied and you are owner of new project - share the link with client, double check that you are sharing link for client with permission "view only"

2. Connector instance

To create a new connector URL to share with our external users in the copied project you will need to select Deploy -> New deployment. 

 

After you create a new deployment you will get a pop up where you will need to select the Configurations.

1. On the left side you will see "Select type", next to is a cog icon, click on that icon and select all types ("Web app", "API Executable", "Add-on" and "Library")

2. In the "Who has access" field you need to select "Anyone with Google Account" (Leave "Execute as" field as yourself).

After these steps click "Deploy"

After you deploy the project you will get redirected to another window that will ask you to Authorize the access, so just click on "Authorize access" and authorize it with your own internal domain.

After you will authorize the access you will be given a new connect "Data Studio Add-on URL" that you will need to copy.

The final step is to share the access with the client. 

In the top right corner you will see an icon that says "Share this project with others" - click on it.

Then you will receive a new pop up, in that pop up enter clients email and set the access to "Viewer" (It's important to share the access as "Viewer", otherwise the external users could make changes in our projects). Also in the messages tab you need to paste the connector URL that you copied previously.

After the client receives the access and the connector URL then they need to open that URL. After opening it they should see a message "Authorise" - they need to click on it.

After they click on "Authorize" they might get a warning that the app contains sensitive information, they should click on "Advance" and "Go to Copy of eskimi-datastudio-connector" and Allow the access.

After these steps the client will be able to Authorise with the connector.

3. Authorise with the connector

To authorise with the connector client will need to:
OAUTH USERNAME - This is the Eskimi DSP Login (EMAIL ONLY)
OAUTH PASSWORD - This is the Eskimi DSP login password
OAUTH CLIENT ID - This is the API Client ID obtained from the DSP once logged in ( https://dsp.eskimi.com/admin?function=userApi ). Client ID has to be generated via that link if it does not exist yet - only when logged in with client credentials. 
OAUTH SECRET - This is the API Client Secret obtained from the DSP once logged in ( https://dsp.eskimi.com/admin?function=userApi ). Once client generated Client ID on previous step, the secret will be generated as well. It is visible only when  logged in with client credentials. 

*CAMPAIGN IDS - Here you can enter separate account Campaigns ID’s for which you want to obtain the data, has to be separate with the ; symbol. If you leave the campaign field empty it will take the last 15 campaigns from the account.

Attaching a video of how to share the access: