4 Replies Latest reply on Mar 14, 2016 5:27 AM by Mirissa Ladent

    Working out day of registration from Google Analytics data

    Mirissa Ladent

      Hi all,


      I need help with some calculations. In the attached workbook, I use Custom Dimensions collected via Google Analytics to determine the day a user registered on our site (we're working on improving our implementation, but in the meantime, that's the best workaround I could find to give Marketing some notion of how the site is performing).

      As you can see, the table that is produced isn't very user-friendly - I can't even sort it by date.


      Now, what I'd like to do is build a chart that shows how many registrations we had each day since launch. Does anyone know how I'd do that?

      The issue I have is that the chart needs to only include the earliest date at which the user id, membership id, and industry sector were first recorded together. Can you help?