EXPORT FLAT FILE

3 replies
1545 views
Translate

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.

Analytics

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

VaniBhemarasettyAccepted solution

Employee

@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

VaniBhemarasettyAccepted solution

Employee

@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

Translate

P

peeyushbansalAuthor

Level 3

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

Translate

Jennifer_Dungan

Level 2

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.

Translate

Sign up

Login with SSO

Login to the community

Login with SSO