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?

       

      Thanks,


      M.