timesummary

Attribute Name	Data Type	Description
ID	int	The unique identifier of the customer record in CDP.
DateInUnix	timestamp	The date in the UNIX format.
Year	int	The year in the timestamp.
QuarterNumber	int	The number of the quarter in the year.
QuarterName	string	The name of the quarter.
MonthNumber	int	The number of the month in the year.
MonthName	string	The name of the month.
MonthDayNumber	int	The number of the day in a month.
WeekDayName	string	The number of the day in a month.
YearWeekNumber	int	The number of the week in the year.
IsLast12M	boolean	This flag indicates if a date is from the last 12 months. The values are: True for the dates within the last 12 months. False for the dates which are not from the last 12 months.
IsLast6M	boolean	This flag indicates if a date is from the last 6 months. The values are: True for the dates within the last 6 months. False for the dates which are not from the last 6 months.
IsLast30day	boolean	This flag indicates if a date is from the last 30 days. The values are: True for the dates within the last 30 days. False for the dates which are not from the last 30 days.
IsLast7day	boolean	This flag indicates if a date is from the last 7 days. The values are: True for the dates within the last 7 days. False for the dates which are not from the last 7 days.
SpecialDayName	string	The name of the special day.
IsSpecialDay	string	This flag indicates if a day is a special day. It has Yes or No value.
IsOfficialHoliday	string	This flag indicates if a day is an official holiday. It has Yes or No value.
IsWeekend	string	This flag indicates if a day is a weekend. It has Yes or No value.
FiscalYear	int	A one year period that companies and governments use for financial reporting and budgeting.
FiscalQuarter	int	A three month period in which a company reports its financial results.
FiscalMonth	int	Any fiscal month of a fiscal year.
FiscalWeek	int	Seven days accounting period that is defined by the business.
RowCreated	timestamp	The time when the promotion record was created.
RowModified	timestamp	The time when the promotion record was last modified.
Batch	string	When the customer record was last modified in CDP. This is used for bucketing the ingestion of records into CDP.

Attribute Name	Data Type	Description
ID	int	The unique identifier of the customer record in CDP.
DateInUnix	timestamp	The date in the UNIX format.
Year	int	The year in the timestamp.
QuarterNumber	int	The number of the quarter in the year.
QuarterName	string	The name of the quarter.
MonthNumber	int	The number of the month in the year.
MonthName	string	The name of the month.
MonthDayNumber	int	The number of the day in a month.
WeekDayName	string	The number of the day in a month.
YearWeekNumber	int	The number of the week in the year.
IsLast12M	boolean	This flag indicates if a date is from the last 12 months. The values are: True for the dates within the last 12 months. False for the dates which are not from the last 12 months.
IsLast6M	boolean	This flag indicates if a date is from the last 6 months. The values are: True for the dates within the last 6 months. False for the dates which are not from the last 6 months.
IsLast30day	boolean	This flag indicates if a date is from the last 30 days. The values are: True for the dates within the last 30 days. False for the dates which are not from the last 30 days.
IsLast7day	boolean	This flag indicates if a date is from the last 7 days. The values are: True for the dates within the last 7 days. False for the dates which are not from the last 7 days.
SpecialDayName	string	The name of the special day.
IsSpecialDay	string	This flag indicates if a day is a special day. It has Yes or No value.
IsOfficialHoliday	string	This flag indicates if a day is an official holiday. It has Yes or No value.
IsWeekend	string	This flag indicates if a day is a weekend. It has Yes or No value.
FiscalYear	int	A one year period that companies and governments use for financial reporting and budgeting.
FiscalQuarter	int	A three month period in which a company reports its financial results.
FiscalMonth	int	Any fiscal month of a fiscal year.
FiscalWeek	int	Seven days accounting period that is defined by the business.
RowCreated	timestamp	The time when the promotion record was created.
RowModified	timestamp	The time when the promotion record was last modified.
Batch	string	When the customer record was last modified in CDP. This is used for bucketing the ingestion of records into CDP.

Attribute Name	Data Type	Description
ID	int	The unique identifier of the customer record in CDP.
DateInUnix	timestamp	The date in the UNIX format.
Year	int	The year in the timestamp.
QuarterNumber	int	The number of the quarter in the year.
QuarterName	string	The name of the quarter.
MonthNumber	int	The number of the month in the year.
MonthName	string	The name of the month.
MonthDayNumber	int	The number of the day in a month.
WeekDayName	string	The number of the day in a month.
YearWeekNumber	int	The number of the week in the year.
IsLast12M	boolean	This flag indicates if a date is from the last 12 months. The values are: True for the dates within the last 12 months. False for the dates which are not from the last 12 months.
IsLast6M	boolean	This flag indicates if a date is from the last 6 months. The values are: True for the dates within the last 6 months. False for the dates which are not from the last 6 months.
IsLast30day	boolean	This flag indicates if a date is from the last 30 days. The values are: True for the dates within the last 30 days. False for the dates which are not from the last 30 days.
IsLast7day	boolean	This flag indicates if a date is from the last 7 days. The values are: True for the dates within the last 7 days. False for the dates which are not from the last 7 days.
SpecialDayName	string	The name of the special day.
IsSpecialDay	string	This flag indicates if a day is a special day. It has Yes or No value.
IsOfficialHoliday	string	This flag indicates if a day is an official holiday. It has Yes or No value.
IsWeekend	string	This flag indicates if a day is a weekend. It has Yes or No value.
FiscalYear	int	A one year period that companies and governments use for financial reporting and budgeting.
FiscalQuarter	int	A three month period in which a company reports its financial results.
FiscalMonth	int	Any fiscal month of a fiscal year.
FiscalWeek	int	Seven days accounting period that is defined by the business.
RowCreated	timestamp	The time when the promotion record was created.
RowModified	timestamp	The time when the promotion record was last modified.
Batch	string	When the customer record was last modified in CDP. This is used for bucketing the ingestion of records into CDP.

Did not find what you were looking for?

Did not find what you were looking for?