Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

JustMe222
JustMe222
Online

Badges

Badges
4

Accepted Solutions

Accepted Solutions
1

Likes Received

Likes Received
0

Posts

Posts
3

Discussions

Discussions
0

Questions

Questions
3

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by JustMe222
Customize the badges you want to showcase on your profile
Re: Excel Add-in Scheduled Hourly Report - Time Zone Issue? - Adobe Analytics 29-07-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!

Views

30

Likes

0

Replies

0
Re: Excel Add-in Scheduled Hourly Report - Time Zone Issue? - Adobe Analytics 26-07-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 ...

Views

45

Likes

0

Replies

0
Excel Add-in Scheduled Hourly Report - Time Zone Issue? - Adobe Analytics 25-07-2022
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 thi...

Views

53

Likes

0

Replies

3