EXPORT FLAT FILE

[peeyushbansal]

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.

[VaniBhemarasetty · Accepted solution]

@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

[peeyushbansal]

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

[Jennifer_Dungan]

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.