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

SOLVED

Segment into weekday

henrikt69352218
Level 2
Level 2

Hi,

I am trying to find out how my sites visits and sales are distributed across the various weekdays over a timespan of lets say a year.

I could of course manually calculate the number by going trough all mondays and vice versa, but i suppose theres an easier way to do it?

Thanks in advance. 

1 Accepted Solution
Alexis_Cazes_
Correct answer by
Community Advisor
Community Advisor

Just to update this thread, this month Analysis Workspace will be updated and you will be able to use Day of the Week dimension out of the box Time-parting Dimensions in Analysis Workspace - YouTube

View solution in original post

12 Replies
rameshk28785
Level 5
Level 5

You may want to create a segment with "Day of Week" and add all weekday numbers as shown in below screenshot.

Dayofweek234.png

Hope it helps

henrikt69352218
Level 2
Level 2

I don't have the Day Of Week segment. The only i can find is day?

Alexis_Cazes_
Community Advisor
Community Advisor

I do not believe this dimension is available by default. I actually found no dimension by default that gives you week days unfortunately.

rameshk28785
Level 5
Level 5

This dimension needs to be setup by your account manager. Better you should contact your Adobe account manager to setup this dimension.

Alexis_Cazes
Employee
Employee

Do you have more details on how it is setup ? Is it retroactive once you enable it ?

rameshk28785
Level 5
Level 5

It needs to be setup by using a custom Time Parting variable (you may already have a prop or eVar set aside for this) and then classify Weekday/Weekend.

Alexis_Cazes_
Community Advisor
Community Advisor

I believe you are talking about the plugin getTimeParting .

it does not require the account management involvement and you should be able to add it to your Analytics implementation without any additional cost.

It won't be retroactive on the data so. 

Is it what you are talking about or there is a better solution ?

henrikt69352218 I do not think there is a retroactive solution to your problem, if you did not collect some sort of day of the week data prior. A manual approach will need to be used unfortunately

Alexis_Cazes_
Correct answer by
Community Advisor
Community Advisor

Just to update this thread, this month Analysis Workspace will be updated and you will be able to use Day of the Week dimension out of the box Time-parting Dimensions in Analysis Workspace - YouTube

View solution in original post

henrikt69352218
Level 2
Level 2

Hi Alexis! When will this feature be released, and do we have to make some kind of update in order to get it work?

Alexis_Cazes_
Community Advisor
Community Advisor

I believe it was yesterday: Marketing Cloud Help

I just checked in Analysis Workspace and I can see it.

Make sure you use Analytics Workspace tho.

Sheffali
Level 1
Level 1

Is there any options available  to make an alert on the basis of Average Mondays 

For Example :- I need to compare this Monday with the last 7 Mondays Average (Orders, Unique Visitors) if that is less than or greater than 10% then give me an alert.

Hope to find out some solutions from your side