Windsor brings all your DatamedIQ data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
DatamedIQ Field Reference
![](https://windsor.ai/wp-content/uploads/2024/05/datamediq.png.webp)
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
account_id | TEXT | Account ID | The associated account id. | Dimensions |
account_name | TEXT | Account name | The associated account name | Dimensions |
brand | TEXT | Brand | Brand | Dimensions |
company_name | TEXT | Company Name | Company | Dimensions |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | Date | Dimensions |
day_of_month | TEXT | Day of month | Day of the month | |
month | TEXT | Month | Number of the month | |
pack | TEXT | Pack | Pack | Dimensions |
product_group | TEXT | Product Group | Product Group | Dimensions |
pzn | TEXT | Pzn | Pzn | Dimensions |
sales | NUMERIC | Sales | Sales | Metrics |
source | TEXT | Source | The name of the Windsor connector returning the row | |
today | DATE | Today | Today's date | |
units | NUMERIC | Units | Units | Metrics |
week | TEXT | Week | Week (Sun-Sat). | |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
year | TEXT | Year | Year | |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |