Custom Date Dimensions? | Community
Skip to main content
T
TomBa12
August 9, 2024
Question

Custom Date Dimensions?

  • August 9, 2024
  • 3 replies
  • 1410 views

Hello,

Is it possible to create custom date type dimensions like Day, Week etc. Our analysts have asked for dimensions like Financial Year and Financial Quarter- I know you could create date ranges for these, but they're after a single dimension they can drag in and have it split into multiple values like Day does. I had a crack at adding a classification but it doesn't seem possible to add classifications to date objects either.

Cheers

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

    3 replies

    Isha__Gupta
    Community Advisor and Adobe Champion
    Isha__GuptaCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    August 9, 2024

    Hi @tomba12 ,

    I can only think of custom implementation to achieve this. On each tracking call, you can pass a variable which can populate the value like financial year 2023 or Quarter 2024Q2. Of course, this would require bit of a JavaScript along with non-retroactive tracking. Maybe other experts in this community might have a better idea.

    Best,
    Isha

    T
    TomBa12Author
    August 9, 2024

    Hi @isha__gupta ,

    Thanks for your answer. This is the solution I was thinking of, or at least passing a date string as an eVar and then building classifications based on that, but the lack of retroactive tracking is holding me back. Just checking there isn't a solution that can apply for past data before I implement the evar.

    Cheers,
    Tom


    M
    MahimitraCh
    August 9, 2024

    You do have some dimensions already given by adobe right ?

    But if we want financial year to start from april and custom requirements then may be we can raise ticket with adobe for given RS.  Or we can go with custom implementation in adobe launch or tags.

      Jennifer_Dungan
      Community Advisor and Adobe Champion
      Jennifer_DunganCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      August 9, 2024

      Custom Date ranges can also be created like this, and still split into "Days".


      For instance, I have some custom "Monday to Sunday" date ranges to align with marketing needs, and they can be broken out:

       

       

       

      T
      TomBa12Author
      August 12, 2024

      Hi Jennifer,

       

      Sorry, wasn't very clear in my original post, but I'm after a new date dimension that will split out in the same way Day does, rather than split out into days if I drag days in to the workspace.
      Creating date ranges is useful, but if the analysts want to check something over the last year at a financial week level, they would have to drag in 52 different date ranges for each financial week- wondering if it is possible to create a 'Financial Week' dimension that they can drag in and have it split out into all the FW values for the given report date range. Is this something it's possibly to get added to our reports by raising a support ticket?

      I've mocked it up here:

       

      Josh__Stephens
      Community Advisor
      Josh__StephensCommunity Advisor
      Community Advisor
      August 12, 2024

      You can update the calendar settings if the option your company uses is a standard one.  Not exactly sure what all that updates in traditional Analytics and any issues that could cause.

      Doesn't help in AA, but in CJA you can change more settings and they're applied retroactively.  You can set the first month in the year, for example.  And the year dimension will then show the year number and date range.  Q1 in this case, would be July-Sept.

       

       

      Terms & ConditionsAccessibility statement

      Loading footer...