Building on this KB article I've created a macro which will do all the work for you and allow you to send the data into your favourite data storage device.
You can download just the macro from the gallery.
If you use Tableau and want to take advantage of a pre-built workbook take a look at this workflow.
There's also a blog post on The Information Lab website.
Here's some screenshots of what you can extract:
Solved! Go to Solution.
Hello Craig, thank you for sharing this awesome workflow. I can't seem to get a link to download it. Could you share the link please as none of the above work. Thank you.
@craigbloodworth @dataMack The link to download the macro is no longer working. Please provide a download link. Thank you.
@AndrewLCan you post the macro, or @ another Alteryx admin for this?