Ok, here is document:
https://docs.google.com/spreadsheets/d/1YGkY2Yz1RefwcG4nqJ1lbnEfTghn7pRtb9di2HICiaA/edit?usp=sharing
captured before hour.
I leave it as-is just extract username but later make regex to extract their posts and ugc posts.
This is Top 4291 as far as i see.
Here is procedure how to get it:
- wget https://moz.com/community/users - i love *nix command line tools but you can use web browser and save as HTML.
- Open HTML for editing.
- Find " var top_users =" and delete everything BEFORE it. Now document should start as "[[1,"
- Find "]];" and delete semicolon and everything AFTER it. Now documents should end with "]]"
- As you can see we have well formated JSON. Bad news - i can't import it in Sheets due bug in =ImportJSON function.
- Let's go in PlanB - https://json-csv.com/
- Copy all JSON into clipboard
- Paste it on json-csv.com
- Push button, get CSV
- Import CSV into Google Docs
- Enjoy!
Just use some of mine formulas to extract number of posts or UGC. I can make formula for extracting username too.