Ability to generate Training Reports from your Strava data

Having just worked my way through my 2013 training data to find out my weekly, monthly and total training amounts, it occurred to me that it would be handy to be able to generate these as reports automagically within Strava.

  • Weekly, monthly, annual and all time reports for any week/month/year.
  • Report describes total mileage, training time, number of activites, HR maximum/average etc. - all the usual information.
  • Reports can be activity type specific (one report for runs, one for rides) or aggregated.
  • Users configure which report types they want generated automagically (and optionally emailed to them) based on period and activity type.
  • Custom reports (specific date ranges, previous weeks/months/years etc,.) can be created ad-hoc if I wanted.

 

After all, we're using a site like Strava because we crave data and comparative competition - more data is exactly what we always want...

 

177

Comentários

126 comentários
  • I really would love to be able to export to csv as this give much flexibility to analyse your training data depending on the question at hand.

    1
    Ações de comentário Permalink
  •  Yes please I have a certain workout I would like to be able to compare over time and chart improvements in my conditioning.

    0
    Ações de comentário Permalink
  • Yes ability to export to excel would be very useful. I have set my Garmin to upload data to both Strava and FetchEveryone as the latter does have a one click export all data to excel option.

    0
    Ações de comentário Permalink
  • The most basic version of this seems like it would be so easy to provide. It is frustrating that I can't do it: get one row of data for each workout, including all the obvious attributes applicable at that level, such as workout type, date, duration, distance, avg HR, max HR, suffer score. Trying to copy and paste from the web page results in the inclusion of all kinds of HTML garbage and is a waste of time.

    0
    Ações de comentário Permalink
  • Hi,

    This is something I've been working on as a side project recently and, although it needs a fair bit of polishing around the edges, it gets the job done :)

    The process is a) select the fields you're interested in, b) select the activity types to include and c) select the date range. All through a form like this:

           

    https://gnar.jakelodge.co.uk/register 

    15
    Ações de comentário Permalink
  • Well done, Jake Lodge! I just tried your creation, and it worked great. I would only wish for some heart rate data in the mix. Otherwise, it is exactly what I was hoping for. I got the fields I wanted, fewer events than I asked for (perhaps a built-in beta constraint?), and Excel opened it right up. Thank you!

    0
    Ações de comentário Permalink
  • Nice!  Haven't had much time to play with it yet...but also noted it returned limited number of rows.

    1
    Ações de comentário Permalink
  • Thanks Jake Lodge... I just tried it and YES it worked.

    Maybe I should wait for an upgrade where it would be possible to export ALL my activities to one csv file instead of files of thirty something activities. I'm trying to export everything from a few years back and it will take some (painfull) time...

    But don't get me wrong, this is a fantastic job as it is !

    1
    Ações de comentário Permalink
  • Jake Lodge, this is the deal!  Now we are talking!  All relevant data and more is available in your system.  Only two issues that I noticed: a) Data range is pretty much fixed to about 4 months old to date of export.  Could not change the range. b) No sure I can understand the speed data (avg and max) as the number does not match either miles or km.  Is there a formula to be used to convert to either miles or km?  Thanks a lot for a great job!                                                  

    0
    Ações de comentário Permalink
  • Thanks for all the great comments!

    I'm making changes quite often at the moment so lots of the small issues should get ironed out soon hopefully.

    speed is meters/second. Just added pace (min/mile & min/km) and mph / kph fields, along with a couple of others. 

    Strava imposes a limit on the number of activities that can be returned in one go, and limits the requests per unit time. So, at the moment the rows are limited to 40 activities.

    2
    Ações de comentário Permalink
  • Jake Lodge: Well done and thanks for letting me test it. Would be nice to include the type of bicycle or model with the data. I ride a tandem with my wife and that data is always going to be different than when I ride for training or fitness purposes. Currently, I'll just try to include the term "tandem" in the ride description so I can filter by that. Thanks, again. Nicely done.

    0
    Ações de comentário Permalink
  • There is an extension for Google Chrome that will give you a lot of data that might be helpful. It is Stravistix.

    0
    Ações de comentário Permalink
  • @JakeLodge - any update on your tool and making available to a wider audience?

    0
    Ações de comentário Permalink
  • Hi @JakeLodge,

    all the invitation codes are already used, can you give me new one please? 
    I would really appreciate it. 

    Thanks

    0
    Ações de comentário Permalink
  • Hi @DavidSchorow, @TomPeregrine

    I haven't been able to conduct any work on this for one reason or another since the summer, so it's still pretty clunky. Nonetheless, I've updated the post above with some new codes.

    Cheers

     

    ps. Sorry for the long delay David, I have no excuse, but my mailbox is a mess..

    pps. Any feedback welcome on here or anonymously here! https://goo.gl/forms/qkg3V58gLaikBuvW2

     

     

    2
    Ações de comentário Permalink
  • I also like a connection. I've been trying to live link strava to Power bi, but didn't got it working yet. This would be nice for starters. Anyone else got strava/Power bi experience? Any good tips are welcome.

    0
    Ações de comentário Permalink
  • Strava! Export to csv...are you ever going to listen to your user base and add this capability?

    -- New to Strava Premium and highly dissapointed with the lack of reporting features.

    4
    Ações de comentário Permalink
  • Totally agree that there should be more options to generate reports for activity history. Export to csv seems like a no brainer.

    Also... we have the ability to log training for anything from cykling to nordic ski etcetera, but can only view totals for cykling, running and swimming.

    Please add functionality to reports and exports!!

    0
    Ações de comentário Permalink
  • Hi Jake Lodge.  I was wondering if there is a technical or other reason why the static trainer activities do not show up in the downloads.  Thank you!

    0
    Ações de comentário Permalink
  • Please add an excel / csv download.  that would be so helpful!

    Echo all these comments!

     

    0
    Ações de comentário Permalink
  • One word to Jake Lodge: AWESOME!  Ok, I can't stop at one.  This is unbelievably fantastic!  Kudos and thank you Jake Lodge! Strava, if you are listening - there are 2 and only 2 features that would get me to sign up for premium: 1) GPX download from others (you already have), and 2) Log download such as created by Jake Lodge.  The GPX download by itself hasn't been quite enough, but if you had a nice, fully functional download similar to Jake's, count me in.

    1
    Ações de comentário Permalink
  • Hi @JakeLodge,

    Any chance the invite code fairy will be returning with some new codes? :)

    Thanks

    ~Ron

    0
    Ações de comentário Permalink
  • Jake Lodge, thank you!  Worked beautifully, for the first time ever I can see how much I'm actually riding certain bikes (answer: probably not enough to justify a new purchase...)

    0
    Ações de comentário Permalink
  • btw I just used one of the random codes he included and it worked.

    0
    Ações de comentário Permalink
  • Jake's tool works great - data with a side of Shane!  Thanks!

    0
    Ações de comentário Permalink
  • +1

    I'd like the ability to download a CSV with a line item for each activity, along with the usual data (date, time, distance, etc.) so I could create my own custom reports.

    0
    Ações de comentário Permalink
  • @Jake Lodge Your tool is fantastic, thank you so much for your work!

    0
    Ações de comentário Permalink
  • Looks like @Jake Lodge beat me to it, but I'm also playing around with building an activity CSV exporter.  It provides a limited number of fields, and only works for runs at the moment, but if people want to test it out, you're more than welcome to.  Like he mentioned, the rate limiting makes it hard to get all activities with all the fields you want. 

    Site is here.

    Code, if anyone is interested (or wants to file a bug report) is here.

    1
    Ações de comentário Permalink
  • @Colby Pines, thanks for sharing. looks like it only pulls data for the current year? Is there any way to pull 2016 data and even just for a date range?

    0
    Ações de comentário Permalink
  • @ Al G.

    Thanks for taking a look!  I'll have to investigate the issue later this week. The expected behavior is that it pulls your entire history.  If you know a little Ruby, you're welcome to glance at the relevant code here. (Offhand I don't know why this wouldn't be capturing other years unless something with Strava's  API or the wrapper I used [already] changed.)

    Do also note that there's another issue involving the actual mailing of the CSV.  Gmail occasionally blocks the server from logging in, so I'll need to fix that too.  It was admittedly hacky. 

    2
    Ações de comentário Permalink

Por favor, entrar para comentar.

Não encontrou o que estava à procura?

Nova publicação