Custom Date Dimensions? | Community
Skip to main content
TomBa12
Level 2
Aug 9, 2024 9:33 AM UTC
Question

Custom Date Dimensions?

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.

    7 replies

    Josh__Stephens
    Josh__Stephens
    New Participant
    Aug 12, 2024 11:07 PM UTC

    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.

     

     

    Translate
    MahimitraCh
    Level 3
    Aug 9, 2024 3:40 PM UTC

    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.

    Translate
      Jennifer_Dungan
      Jennifer_Dungan
      Level 2
      Aug 9, 2024 11:24 PM UTC

      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:

       

       

       

      Translate
      TomBa12Author
      Level 2
      Aug 12, 2024 9:28 AM UTC

      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:

       

      Translate
      Isha__Gupta
      Isha__Gupta
      Level 1
      Aug 9, 2024 9:47 AM UTC

      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

      Translate
      TomBa12Author
      Level 2
      Aug 9, 2024 2:07 PM UTC

      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


      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...