Data from Date/time fields loads into analytics reports based on the server time zone, regardless of the time zone set in your account.

Example of working with deals

1. Create a new deal and note its name and creation time. In this example, Deal #1728 was created at 5:41 PM.

2. Open Google Looker Studio and create a table to check the exact deal creation time.

3. Add these dimensions to the table:

• Unique key: Deal ID
• Deal name: Deal name
• Created on: Deal creation time based on the server’s local time

In the table, Deal #1728 appears with a different time than the one shown in CRM.

This can make reports harder to read. To fix this, manually adjust the time in the analytics system.

Change the time zone for deal fields in Google Looker Studio

Create a calculated field to adjust the time zone for imported deal fields.

1. Click Add dimension.
2. Click Create field.
3. Enter a field name.
4. Add this formula: DATETIME_ADD(Created on, INTERVAL -1 hour).
5. Click Apply.

You can now use the new field with the updated time zone in your reports.