Frequently asked questions around data feeds.
post_prefix and columns without a
Columns without the
post_ prefix contains data exactly as it was sent to data collection. Columns with a
post_ prefix contains the value after processing. Examples that can change a value are variable persistence, processing rules, VISTA rules, currency conversion, or other server-side logic Adobe applies. Adobe recommends using the
post_ version of a column where possible.
If a column does not contain a
post_ version (for example,
visit_num), then the column can be considered a post column.
In Adobe Analytics, most variables are considered as case-insensitive for reporting purposes. For example, ‘snow’, ‘Snow’, ‘SNOW’, and ‘sNow’ are all considered the same value. Case sensitivity is preserved in data feeds.
If you see different case variations of the same value between non-post and post columns (for example, ‘snow’ in the pre column, and ‘Snow’ in the post column), your implementation uses both uppercase and lowercase values across your site. The case variation in the post column was previously passed in and is stored in the virtual cookie, or was processed around the same time for that report suite.
Data feeds do not include bots filtered by Admin console bot rules.
000values in the
post_event_listdata feed column?
Some spreadsheet editors, especially Microsoft Excel, automatically round very large numbers. The
event_list column contains many comma-delimited numbers, sometimes causing Excel to treat it as a large number. It rounds the last several digits to
Adobe recommends against automatically opening
hit_data.tsv files in Microsoft Excel. Instead, use Excel’s Import Data dialog box and make sure that all fields are treated as text.