Documentation

Interpret numbered exports from Data Warehouse Time Dimensions

Last update: Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

This article provides guidance on interpreting the numerical values that appear when exporting Time Dimensions such as ‘Year’, ‘Quarter’, ‘Month’, and ‘Day’ from the Data Warehouse in Adobe Analytics.

Description description

Environment

Adobe Analytics

Issue/Symptoms

When you export Time Dimensions like ‘Year’, ‘Quarter’, ‘Month’, and ‘Day’ from the Data Warehouse, the results appear as numbers. You are uncertain about what these numbers represent.

Date Range Year
Date Range Quarter
Date Range Month
Date Range Day
Date Range Hour
Date Range Minute
Page Views
1230001
1230601
1230801
1230817
123081700
12308170000
16
1230001
1230601
1230801
1230817
123081700
12308170001
11
1230001
1230601
1230801
1230817
123081700
12308170002
14
1230001
1230601
1230801
1230817
123081700
12308170003
11
1230001
1230601
1230801
1230817
123081700
12308170004
16
1230001
1230601
1230801
1230817
123081700
12308170005
18
1230001
1230601
1230801
1230817
123081700
12308170006
7

Resolution resolution

Refer to the interpretation chart below to understand what each numerical value represents in the exported data.

Date Range Year
Date Range Quarter
Date Range Month
Date Range Day
Date Range Hour
Date Range Minute
Page Views
1(23)0001
1(230601)
1(2308)01
1(230817)
1(23081701)
1(2308170001)
16
2023
Q3 (Since 2023-07-01 is the first day of third quarter)
2023-09 (Add 1 to ‘08’)
2023-09-17
2023-09-17 01H
2023-09-17 00:01
16
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f