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

WhatsApp

The date when contact was made by a channel (drill-up is available).
Contact Month Date Email

Landing Page

Mobile

SMS

WhatsApp

The month when contact was made by a channel (drill-up and drill-down are available).
Contact Quarter Date Email

Landing Page

Mobile

SMS

WhatsApp

The quarter when contact was made by a channel (drill-up and drill-down are available).
Contact Year Date Email

Landing Page

Mobile

SMS

WhatsApp

The year when contact was made by a channel (drill-up and drill-down are available).
Contact Time Time Mobile

SMS

WhatsApp

Actual contact time (drill-up is available).

Common Dimension Data Type Channel Description
Response Date Date Email

Landing Page

Mobile

SMS

WhatsApp

The date when response was received (drill-up is available).
Response Month Date Email

Landing Page

Mobile

SMS

WhatsApp

The month when response was received (drill-up and drill-down are available).
Response Quarter Date Email

Landing Page

Mobile

SMS

WhatsApp

The quarter when response was received (drill-up and drill-down are available).
Response Year Date Email

Landing Page

Mobile

SMS

WhatsApp

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

WhatsApp

Actual response time (drill-up is available).