EXPORT FLAT FILE | Community
Skip to main content
P
peeyushbansal
Level 3
September 12, 2023
Solved

EXPORT FLAT FILE

  • September 12, 2023
  • 1 reply
  • 1546 views

How can we export the excel file with all variables in column from adobe report export. We dont need visualization data but all variables as columns in flat excel file.

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 VaniBhemarasetty

@peeyushbansal You can use data feeds, where you can get the columns .tsv file in the zip file, however you might also need lookups as well, because you will not get the exact name of the column in the data feed. Otherwise, we do not have any direct method to extract these columns in an excel

1 reply

VaniBhemarasetty
Adobe Employee
VaniBhemarasettyAdobe EmployeeAccepted solution
Adobe Employee
September 12, 2023

@peeyushbansal You can use data feeds, where you can get the columns .tsv file in the zip file, however you might also need lookups as well, because you will not get the exact name of the column in the data feed. Otherwise, we do not have any direct method to extract these columns in an excel

P
peeyushbansalAuthor
Level 3
September 12, 2023

how to use data feeds can you please share steps @vanibhemarasetty 

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 12, 2023

Keep in mind that Data Feeds, while indeed flat, are the complete raw data collected by Adobe, they require a lot of processing and logic to take into account things like "exclude_hits" from being part of your data set....

 

Another way to get flat data is to use the Data Warehouse Exports... these come from the processed data and should match up better with what you see in Workspace.

 

You could also investigate using the API to extract data from the processed Adobe data.

Terms & ConditionsAccessibility statement

Loading footer...