Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Multiple files being sent in S3 data feed even though single file selected

srikoll
Level 2
Level 2

Hi,

 

I have configured a data feed file in analytics. Some of the columns selected are as below, and I selected "

 

Browser
Browser_type
color_depth
column_headers
connection_type
country
event
hit_data
operation_systems
plugins
search_engines

 

The compression format as "Zip", packaging type as "Single File", and destination as S3.

I'm able to receive a zip file with data. However, when I unzip, the data is shown as multiple seperate files (each for one column) instead of a single report.

 

Is it possible to receive all data as a single file?

 

Regards,

Sri

1 Accepted Solution
ForgotPassword4Times
Correct answer by
Level 3
Level 3

1.) It's best if you familiarize yourself with the documentation here:
https://docs.adobe.com/content/help/en/analytics/export/analytics-data-feed/data-feed-contents/dataf...

2.) Within that documentation you will find the below; what you are seeing is likely the expected behavior.  The separate files are for the lookup data.  You should find that one file 'hit_data.tsv' is significantly larger than the rest, which will have multiple columns and all of that hit data. If this file is missing try selecting a larger date range.

When extracted, the data file contains a single hit_data.tsv file with all data for that day, as well as lookup files for any required columns.

View solution in original post

4 Replies
ForgotPassword4Times
Correct answer by
Level 3
Level 3

1.) It's best if you familiarize yourself with the documentation here:
https://docs.adobe.com/content/help/en/analytics/export/analytics-data-feed/data-feed-contents/dataf...

2.) Within that documentation you will find the below; what you are seeing is likely the expected behavior.  The separate files are for the lookup data.  You should find that one file 'hit_data.tsv' is significantly larger than the rest, which will have multiple columns and all of that hit data. If this file is missing try selecting a larger date range.

When extracted, the data file contains a single hit_data.tsv file with all data for that day, as well as lookup files for any required columns.

View solution in original post

srikoll
Level 2
Level 2
Thank you. This is quite helpful link. One thing, which isn't clear from this document though is in the hit_data file, some columns have actual values while some columns have lookup index values, how do we find out which columns have actual values and which columns have look up values? Can we just assume that if there exists a look up file, then that will only contain a look up value in the hit_data file?
Column reference documentation lets you know which of the 9 columns have lookups.