Expand my Community achievements bar.

SOLVED

Looker studio integration

Avatar

Level 2

Hi ,

 

I am looking at a use case for my organization to build an integration between Adobe analytics and Looker studio. Are there any quick connectors/sources that I can use for this?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

Right, as I said, there are a few Connectors between Google Sheets and Adobe Analytics, I have two of these installed, but haven't really used them much:

 

Jennifer_Dungan_0-1690782318960.png

 

On the surface, I would probably start with Andrey Osadchuk's, only cause I know he's written a lot of Adobe Analytics blogs over the years, so he's got some name recognition to me... 

 

But you should absolutely be able to use Sheets API (which might be that one plugin, or something you are coding using Google Script)

 

Sounds like you are at least on the way to a working solution

View solution in original post

6 Replies

Avatar

Community Advisor and Adobe Champion

I've not pulled Adobe Data into Looker Studio before, but I did a quick check, but there seems to be a few (paid) connectors... most of which have free trial periods, but I am not sure that you have a budget for those...

 

Now, there is another option, but again, maybe not ideal... but you could try pull flattened data into something like Google Sheets using one of the Adobe Data Connectors there (I believe some of these are free), then connecting Looker Studio to Google Sheets.

 

But depending on what you are pulling, this could result in double counting UVs or Visits, since the data will be flattened, then abstracted from there... 

 

 

What specifically about Looker Studio are you trying to use? Have you considered just using Excel and Report Builder (direct connection between Adobe and Excel).. while you still have a potential for the "flat data double counting", if you do the work correctly (multiple requests for levels of context), you should be able to create similar reports to Looker Studio....unless there is something specific to Looker Studio... 

 

 

Avatar

Level 2

@Jennifer_Dungan  so did some digging and this is what I feel could solve my use case.

There is anyways a connector between Looker Studio and sheets, then the question becomes can I integrate Adobe data to sheets. To do this

 

Get a daily DWH report scheduled to FTP. 

Write a script(I am doing this in Python) to read the file from FTP

Write this script onto a Google sheets using the Sheets API

 

Additionally we can read the date range filter from LS to GS and this could be read using the Sheets API as input to the script.

 

Working on this, hopeully can create a scalable version soon.

Avatar

Correct answer by
Community Advisor and Adobe Champion

Right, as I said, there are a few Connectors between Google Sheets and Adobe Analytics, I have two of these installed, but haven't really used them much:

 

Jennifer_Dungan_0-1690782318960.png

 

On the surface, I would probably start with Andrey Osadchuk's, only cause I know he's written a lot of Adobe Analytics blogs over the years, so he's got some name recognition to me... 

 

But you should absolutely be able to use Sheets API (which might be that one plugin, or something you are coding using Google Script)

 

Sounds like you are at least on the way to a working solution

Avatar

Community Advisor and Adobe Champion

You're welcome.. and if you end up doing a custom solution connecting everything together, I would suggest writing a blog here on Experience League showing the process, and steps, etc.

 

I think it would be a fantastic read!