Skip to main content
surajyadav1041
Level 2
October 2, 2022
Solved

How to connect adobe analytics data to tableau?

How to connect adobe analytics data to tableau or export the same data in a CSV file on a desktop?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    leocwlau
    leocwlauAccepted solution
    Community Advisor
    October 3, 2022

    You can use the "Data Warehouse" function under the "Tools" menu and refer to https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/data-warehouse.html?lang=en for documentation.

    You have to select dimensions and metrics for the export and this determine the final export file size. If you use email as the destination, there are size limit on the final data size, and there is no size limit and you can choose to use tableau as export format if you use FTP as the destination.

     

    View in thread

    3 replies

    leocwlau
    Community Advisor
    leocwlauCommunity AdvisorAccepted solution
    Community Advisor
    October 3, 2022

    You can use the "Data Warehouse" function under the "Tools" menu and refer to https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/data-warehouse.html?lang=en for documentation.

    You have to select dimensions and metrics for the export and this determine the final export file size. If you use email as the destination, there are size limit on the final data size, and there is no size limit and you can choose to use tableau as export format if you use FTP as the destination.

     

    Translate
      eknott
      eknott
      October 6, 2022

      Hi! 
      As far as I know, there isn't yet a way to access your adobe data directly in tableau but there are some connectors that have been developed. 

      Daexus is a free connector https://www.daexus.io/products/ it also runs locally on your machine so its safe as no 3rd party servers access the data.

      To the second part of your question, I would reference @leocwlau answer for export. Here is also a visual explanation and other additional great resources/detail on this blog https://blog.openbridge.com/how-to-automate-adobe-data-warehouse-exports-490115329a8  

      Translate
        CristinaDaexus
        February 8, 2023

        Hey there, I'm Cristina and I helped found Daexus, I'm more than happy to set you up with a free trial account if you want to check it out. Just like @eknott pointed out, it's super safe as it only runs on your computer. More than happy to answer any questions!

        https://www.daexus.io/products 

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...