Looker studio integration | Community
Skip to main content
A
AbhranilPal
July 28, 2023
Solved

Looker studio integration

  • July 28, 2023
  • 1 reply
  • 7507 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

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:

 

 

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 🙂

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 28, 2023

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... 

 

 

A
AbhranilPalAuthor
July 31, 2023

@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.

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    July 31, 2023

    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:

     

     

    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 🙂

      Terms & ConditionsAccessibility statement

      Loading footer...