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...

 

178

Comentários

127 comentários
  • Thanks for your efforts, I tried it out and received the data, though the date range is limited, will check back at some point to see if any updates to capture specified range etc. Cheers

    0
    Ações de comentário Permalink
  • Jake Lodge, you sir are my hero.  Thank you, great stuff !

    0
    Ações de comentário Permalink
  • Colby Pines -- Thanks for sharing.  When trying it out, it only grabs my running data (which is minimal) but none of my cycling data (most of what I do).  I don't have any options once I "connect to strava" on the road-rash website.  Any help?

    Thanks!

    0
    Ações de comentário Permalink
  • Hey Jarrett, thanks for writing.  That is currently by [lack of] design, actually. It's currently an issue here: https://github.com/wcpines/road-rash/issues/5.  

    There are two issues here.

    1) The strava API limitations. Strava limits what data is exposed in certain calls in their API, as well as how many calls you can make, so it's hard to grab everything before they shut you down

    2) I simply didn't build anything for selecting activity type.  If you take a look at page 2, you'll see that Jake built something with some flexibility. Here's a link to his comment: https://support.strava.com/hc/en-us/community/posts/208838457/comments/213791228

    That said, I don't know if his project still works.  Frankly, I'm shocked that mine does :P.  

     

    TL;DR Until Strava's API is more robust and lets developers grab more data and make more calls, it's not going to really be worth it to add functionality to what I built, which was sort of just an experiment and an effort to grab my own running data. I think it's part of Strava's defensive business model to actually make it more difficult to get your data; they lock you in. 

     

    Cheers,

    CP

    0
    Ações de comentário Permalink
  • This is an older thread and I can do it in Map My Ride, I have not been able to figure it out in Strava, did they ever make it possible?

    0
    Ações de comentário Permalink
  • What? This is not possible from Strava? This is the basic from an app that stores all the activities. You can do better than Garmin , Strava. Please add this feature

    0
    Ações de comentário Permalink
  • I too would like to see a download (*.csv) of the activity data.  Hard-code the fields to include just about everything about the ride (activity type, equipment, date, duration, miles, etc. and the users can do anything they want within Excel.

     

    1
    Ações de comentário Permalink
  • We have a group in Strava that would like to reward the member with most commuter miles.

    Nope. Without an email to support, doesn't look like we can gen our personal reports or consolidate them at the group level.

    Simple .csv export would suffice.

    0
    Ações de comentário Permalink
  • @Colby

     

    How can i export my bike sessions?

    0
    Ações de comentário Permalink
  • Here's what I did - under "My Activities" filtered to "Rides".  20 results per page.  Highlight all of the data on the page, right click "copy".  Switch to excel, right click "paste" using the option that does not keep source formatting.  Scroll to the bottom of that data (to be ready for the next one).  Back to STRAVA, hit the arrow for next 20 activities.  For me when I did that the highlighted text stayed highlighted, so just right click "copy", lather rinse repeat.  I had about 200 activities so yes it took 10 copy/paste iterations.  

    Then.....in Excel, did a sort to get rid of unnecessary lines.  To strip the numbers from the text I used the LEN formula to count the number of characters in the cell, used the Find function to find where the last text was so I could use either the LEFT or RIGHT function to strip out the numbers.  Then the VALUE function to get the stripped numbers (still treated as text by excel) into a true number.  Each of these functions in it's own column to get the desired result, and had to do this for each piece of data I wanted.  Then copy down of course.  Wasn't as hard as this description sounds.  

    All of this to Find out that STRAVA's own numbers don't add up by almost 10 miles over a year, and compared to my manual log it was off by 24.55 miles for the year.  That sucks !  

     

    1
    Ações de comentário Permalink
  • It looks like Strava is not interested in building this feature. This was first requested over 3.5 years ago, (just looking at the discussion thread alone) which an a very long time for any company and ancient time for new tech company like Strava.

    There is not even a response to say "We are" or We are not" developing this feature. Total arrogance.

    Like others have said, I will also be reviewing my Premium subscription if this does not appear soon. I will be evaluating competitor websites to make me ready jump ship if Strava continue to ignore such a basic request.

    1
    Ações de comentário Permalink
  • It still makes me laugh that people are hoping that strava will change anything to improve its functionality. Keep seeing the same desires; CSV, export, weekly/monthly/annual stats, chronological feed etc...

    Strava haven't listened to its users and implemented any requests for years, why are they going to change now?

    I use strava less and less, only still use it because the rides automatically upload from garmin. I came on here to see if any of the things had actually been developed... nope.

    Garmin is much improved and that's what most of my 'friends' are moving over to.

    0
    Ações de comentário Permalink
  • Log on to strava on a laptop / desktop > go to settings > bottom of the right hand list is "download your data" request where Strava sends a zip file of your activities.

    I'm still waiting for mine to come through but probably wouldn't come back to the site if I didn't post this now. 

    I hope it works and comes through in good format. And if it does LOL at how long it's taken anyone in this thread to find that.

    Enjoy

    0
    Ações de comentário Permalink
  • @Fred McLeod - when I tried it, it sent me zip file of mall my GPX traces. Good for creating a local backup but Not useful for reporting and analysis

    1
    Ações de comentário Permalink
  • @Fred yeah that’s the standard to get some data. But if you want some good data-analyses this won’t work. The data is limited. What you need is a database where each ride is a different table to relate to the overall table. This makes it possible to slice over date and time and get max power, cadance, height, speed, distance, etc. It’s possible through the Strava API, but if you don’t have some programming or similar skills it’s difficult. I’m using Power BI at the moment which is perfect for this use. But it would be easier if the data can be fully extracted. So everyone can use there own data the way they want.

    0
    Ações de comentário Permalink
  • Did this ever get resolved? I exported data now and got gpx files which are a bit of a nightmare. Veloviewer is cool but only gives the last 25 activities so it has its limitations

    0
    Ações de comentário Permalink
  • Really amazing that Strava just can't be bothered. Veloviewer does a great job, but it will cost you to get ALL your data. As a premium Strava subscriber, I think it's ridic I have to pay another company to get my Strava data for me! But I'll do it: I know holding my breath for Strava is an exercise in futility. Its idea of a perk is 10% off expensive cycling shoes.

    0
    Ações de comentário Permalink
  • This is truly difficult to believe. In addition I have not seen a response from Strava, not one. In the big picture this is a relatively simple implementation for Strava. My thinking is that my "Premium" membership must go...

    0
    Ações de comentário Permalink
  • Look on the bright side ladies and gents: at least now we can add emojis to our activities and give more kudos...what a joke

    0
    Ações de comentário Permalink
  • I went looking for this feature and found this thread, leading me to conclude the Excel download feature doesn't exist.   But here's a partial workaround:   View "My Activities" and you get an HTML tabular view in your browser.   You can select the whole table and copy/paste into excel.   Then with some manual formatting efforts (I had to merge cells and delete blank rows), you can get a nice Excel list of your activities.    Alas, it has time, distance, and elevation, but does not have average pace or heart rate.   Bummer.

    -1
    Ações de comentário Permalink
  • Yeah...Chris Miller you’re experiencing the same bummer as all of us. And above all, the excel nerds to be downloaded each time you do a new ride. At this moment I’m using the Strava API and Power BI so my data is allways live. Search the web for these two items and you settled. 👍

    0
    Ações de comentário Permalink
  • If someone would develop and share an MS Excel workbook with VBA macros that talk to the Strava API, the world would be a better place!    I am a software developer and have the experience to do this, just not the time.    Maybe later when I'm retired.  :-)

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

    Having been frustrated by this for a long time, I've been experimenting with the Strava API to create an app where you can download all your activities as a CSV file. Here is a work-in-progress app that seems to work fine for me. Give it a try if you want and let me know if it works for you as well.

    https://tengelin.shinyapps.io/StravaDownload/

    //Martin

    1
    Ações de comentário Permalink
  • Martin,

    Great job!! I have been trying to find a way to analyze how many miles came from Zwift! This made that easy. I did have to convert the raw data from metric to miles, but that is easy. 

    Thanks,

    Bill

    0
    Ações de comentário Permalink
  • Thanks Bill, very glad to hear it was helpful. I can look into an option to switch between miles and km, good idea.

    0
    Ações de comentário Permalink
  • Hello again Bill! I've updated the app, so now it should download the activities as metric or imperial depending on the preference you have selected in Strava. Let me know if it works!

    https://tengelin.shinyapps.io/StravaDownload/

    //Martin

    1
    Ações de comentário Permalink
  • 2018 and still no way to download data to Excel?? Where is the data file stored on your phone?

    0
    Ações de comentário Permalink
  • A download from the My Activities screen would be very useful, with the inclusion of gear or bike descriptions

    0
    Ações de comentário Permalink
  • Martin. Thanks. This is great!!!!

    Very sad that Strava are not engaging with this conversation. What do they think is going to happen if they provide a data file to users? That everyone will desert the site??

    You would have thought in an age of GDPR, that transparency and sharing data that they own about users, sharing an excel file would have been pretty easy.

    0
    Ações de comentário Permalink
  • Thanks Dominic, completely agree.

    0
    Ações de comentário Permalink

Por favor, entrar para comentar.

Não encontrou o que estava à procura?

Nova publicação