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). |