Extract yearly data in different columns

Hi, I'm trying to extract some conversions data from analytics, starting from January 1st  2016 to now.

I'd like to get those data organized with in the first column the day number (1 to 365), in the second, third and fourth column the years 2016, 2017 and 2018, so that I can see immediately how was it going 3 years ago  or similar stuff.

Is it possible?

Thanks a lot


  • Hi Giovanni,

    it's not possible to get the day number from any of the data sources. You can get the date though. Click on the split by dimension selector and you'll see all available time related dimensions in the beginning of the list. You can then duplicate that query for another year next to it and so on.

    Best regards,

    -Supermetrics Team

Login to post a comment