Expand my Community achievements bar.

SOLVED

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

Avatar

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

Avatar

Correct answer by
Level 4

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

Avatar

Correct answer by
Level 4

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.

Avatar

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.