data dictionary - export to excel | Community
Skip to main content
RohitNa1
Level 2
Nov 8, 2024 12:16 PM UTC
Question

data dictionary - export to excel

Hi all is it possible to export data dictionary in adobe workspace to a excel file ?

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

    10 replies

    Nick_Walter
    Nick_Walter
    New Participant
    Nov 8, 2024 2:30 PM UTC

    There isnt a button in Workspace to download them all but I have been able to get similar to what you are asking for with and API query. The documentation for this is here: https://adobedocs.github.io/analytics-2.0-apis/#/Calculated%20Metrics

    Translate
      Jagpreet_Singh_
      Jagpreet_Singh_
      Employee
      Nov 18, 2024 7:41 AM UTC

      @rohitna1  Did you find the suggestion helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

      Translate
      Isha__Gupta
      Isha__Gupta
      Level 1
      Nov 8, 2024 1:47 PM UTC

      Hi @rohitna1 ,

      I remember trying something like this in past using some third party tool.Can't recall which one was that. You may consider using  Observepoint SDR Builder or  Adobe Configuration Export

       

      Reference blog by @jennifer_kunz  - https://www.digitaldatatactics.com/index.php/2018/02/02/new-industry-tool-adobe-configuration-export/

       

      Best,

      Isha

       

      Translate
        FarazHusain
        FarazHusain
        Employee
        Nov 8, 2024 1:51 PM UTC

        I think these tools only download report suite variable configurations, just like report suite API. Not sure if these are exposed to a data dictionary as we don't have a public API for the same. An idea to expose API is also logged in the community - https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/expose-the-adobe-analytics-data-dictionary-in-the-adobe/idi-p/630464

         

        Translate
        FarazHusain
        FarazHusain
        Employee
        Nov 8, 2024 12:52 PM UTC

        Hey @RohitNa1, Unfortunately, this is not currently supported, as mentioned by @Martinej . Also, I don't think we have any API exposed to it. You can upvote this idea - https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/export-adobe-analytics-dictionary-to-csv-xlsx-file/idi-p/640156 such that product team consider this feature request in the future releases.

         

        Translate
          RohitNa1Author
          Level 2
          Nov 8, 2024 1:12 PM UTC

          Thanks

          Translate
          Martinej
          Martinej
          Level 2
          Nov 8, 2024 12:47 PM UTC

          Hi RohitNa1

          As far as i'm concerned there is no feature that enables you to directly export the data dictionary from AA (yet). I tried looking through the documentation. But there might be other API-based tools that can do that. I can't really remember any off the top of my head.. But I will check up on it 🙂 

          Translate
            RohitNa1Author
            Level 2
            Nov 8, 2024 1:13 PM UTC

            Thanks

             

            Translate
            Terms & ConditionsAccessibility statement

            Loading footer...