Looker Studio | Creating a date dimension from a datetimestamp

Looker Studio: Creating a date dimension from a datetimestamp

Often when building a dashboard you will want to group activities (metrics) by a datetime dimension.

This could be day, week, month, year etc.

Looker studio lets you select any of those attributes once you have dragged this into the chart.
However, you may want to control the date or time roll up yourself. If you are wanting to create a data based value, you will need to convert a datetimestamp into a date value. 
This can also be used in a filter the data on your page or chart. 

We have created a short  on so you can follow along.  In this example, we use the createdTimestamp datetime dimension from our ActiveCampaign data connector.

For more video you can visit our YouTube channel

    • Related Articles

    • ActiveCampaign: Converting timestamps to your local timezone

      In your ActiveCampaign account you will typically have it set to your local time zone. This allows you to set campaigns to run at at time you are familiar with. Equally this could apply to deals, tasks, automations. Any feature that you are using. In ...
    • Looker Studio: Speed up your dashboards

      Have you been in meeting or presentation and wanted to be able to share insight on Looker Studio but were hesitant because you never know how long you will be waiting your dashboard to render? If the answer to to that question is yes. Have you tried ...
    • ActiveCampaign: Using resource "Campaign Report Open List"

      When you create a data source using the resource 'Campaign Report Open List' you will need to use the date dimensions 'tstamp' and 'tstamp_iso'. It also required the use of a parameter for the 'campaign id' there are several ways to obtain a campaign ...
    • ActiveCampaign: Creating your first Looker Studio data source to build your custom Dashboard

      Build Your Report Adding and authorising Find My Insight ActiveCampaign Connector in Google Data Studio. This guide shows you how to use a Find My Insight Connector for Data Studio, It's pretty simple, just add and then authorize the connector. This ...
    • ActiveCampaign: Using the Ecomm Integration resources for Shopify

      The ActiveCampaign data connector includes three ecommerce resources that you are able to connect to. (For a full description of the resources you can refer to the resource document from page 14 onwards) These are ecomCustomers ecomOrderProducts ...