data dictionary - export to excel | Community
Skip to main content
Level 2
November 8, 2024
Question

data dictionary - export to excel

  • November 8, 2024
  • 4 replies
  • 1972 views

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.

4 replies

Martinej
Level 2
November 8, 2024

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 🙂 

RohitNa1Author
Level 2
November 8, 2024

Thanks

 

FarazHusain
Adobe Employee
Adobe Employee
November 8, 2024

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.

 

RohitNa1Author
Level 2
November 8, 2024

Thanks

Isha Gupta
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 8, 2024

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

 

FarazHusain
Adobe Employee
Adobe Employee
November 8, 2024

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

 

Nick_Walter
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 8, 2024

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

Jagpreet_Singh_
Community Manager
Community Manager
November 18, 2024

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

Jagpreet Singh