Excel Add-in Scheduled Hourly Report - Time Zone Issue? | Community
Skip to main content
J
JustMe222
July 26, 2022
Solved

Excel Add-in Scheduled Hourly Report - Time Zone Issue?

  • July 26, 2022
  • 2 replies
  • 809 views

I have a report set up using the Excel add-in, scheduled to email hourly, with refreshed hourly metrics - today and yesterday, this year and last year.  It looks perfect in Excel at any time of day, but the emailed version breaks after 6PM, showing no data for all hours of today and now populating today's data in the yesterday fields.  I'm CST so I'm guessing this has to do with time zones...though the hour of day continues to match CST, just the date itself seems to flip at 6 PM.  How do I fix this so that what is scheduled/emailed matches my time zone?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by JustMe222

Can't claim to have it fully figured out, but after much testing it seems that my data displays based on UTC, but the date fields in Excel display in PST.  So as a CST person I have to use one field forced back 5 hours to convert UTC to CST to pull the data and a different field forced forward 2 hours to display my dates in CTS vs. PST.  Good luck to any others who have to try to navigate this!

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 26, 2022

This may sound like a silly question, but your Reporting Suite is configured to be in CST right? It almost sounds like your reporting suite may be configured to be on GTM or UTC (or maybe another time zone in and around there)

J
JustMe222Author
July 26, 2022

Are you asking about within Adobe Analytics or is there an additional setting I should be looking at in Excel?  In AA, yes, and the hours all appear correct in my report.  What's strange is that the date seems to flip to the next day at 6PM, but my hourly reporting continues to report 6PM, 7PM, etc...almost like the hours are in CST but the day is in UTC.  To further the mystery, when I refresh the report in Excel, it all looks correct, but the hourly scheduled email from Excel is wrong the last 6 hours of the day.

J
JustMe222AuthorAccepted solution
July 29, 2022

Can't claim to have it fully figured out, but after much testing it seems that my data displays based on UTC, but the date fields in Excel display in PST.  So as a CST person I have to use one field forced back 5 hours to convert UTC to CST to pull the data and a different field forced forward 2 hours to display my dates in CTS vs. PST.  Good luck to any others who have to try to navigate this!

Terms & ConditionsAccessibility statement

Loading footer...