Deliver Data Model Dimensions for Date and Time in Google Looker
The following table lists the Date and Time dimensions for trend analysis:
| Common Dimension | Data Type | Channel | Description |
|---|---|---|---|
| Contact Date | Date | Email Landing Page Mobile SMS |
The date when contact was made by a channel (drill-up is available). |
| Contact Month | Date | Email Landing Page Mobile SMS |
The month when contact was made by a channel (drill-up and drill-down are available). |
| Contact Quarter | Date | Email Landing Page Mobile SMS |
The quarter when contact was made by a channel (drill-up and drill-down are available). |
| Contact Year | Date | Email Landing Page Mobile SMS |
The year when contact was made by a channel (drill-up and drill-down are available). |
| Contact Time | Time | Mobile SMS |
Actual contact time (drill-up is available). |
| Common Dimension | Data Type | Channel | Description |
|---|---|---|---|
| Response Date | Date | Email Landing Page Mobile SMS |
The date when response was received (drill-up is available). |
| Response Month | Date | Email Landing Page Mobile SMS |
The month when response was received (drill-up and drill-down are available). |
| Response Quarter | Date | Email Landing Page Mobile SMS |
The quarter when response was received (drill-up and drill-down are available). |
| Response Year | Date | Email Landing Page Mobile SMS |
The year when response was received (drill-up and drill-down are available). |
| Response Hour of the Day | Number | The hour when the actual response was received. | |
| Contact Time | Time | Mobile SMS |
Actual response time (drill-up is available). |