Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

Digging through your post stats by downloading your community content as JSON and parsing it Edited

Hey there I'm still relatively new here, but I see that some of you have 1000s of posts, and if you're a nerd like me, you might be interested in statistics like, "How many of my posts were answers to questions, as opposed to comments on blogs or discussions?"

If the fine folks at Atlassian could add some timestamp to the data they publish, we could even answer questions like "How many posts did I do every month?" or "Do I spend more time answering questions at night, or in the morning?"

My community content

So, maybe you're wondering - how do I find this data? Well, if you edit your comunity profile and scroll down to the bottom, you'll see a few links at the bottom, and you'll want to click on "My community content":

Screen Shot 2021-01-22 at 10.53.45 AM.png

So you'll end up with a file named my_community_content.json. JSON just means that it's structured data, but lucky for us, Atlassian has added formatting to make it readable for humans too.

If you open it up in a text editor, you'll see a section called "images", which is a list of links to every image you've uploaded to community.atlassian.com.

The next section is "messages", which contain the subject, text, and "category" of every post you've made. So far the categories I've found are:

      "qanda" : "Questions"
      "blog" : "Articles"
      "forum" : "Discussions"

Can Atlassian please add timestamps? Tags? Product? Views/Likes?

Unfortunately there's no timestamps in the data, but I know Atlassian has the data (it's right there in your Recent Activity), so hopefully they can also add it to this export file? Oh, and what about tags, so we could see how many cloud vs server questions we answer? (Ahem, Cloudies.) It would also be really useful to see what product area we were posting to. Oh, and views and likes? How about everything in Recent Activity? Am I asking too much? :-}

Generic Statistics

Anyways though, until we get timestamps, we can still get generic stats, using some good old Unix command-line tools (these are standard on Mac/Linux, and if you want to play with them on Windows, you could install Cygwin). On my Mac, I opened up the Terminal app and typed the commands below in bold (everything after the $ sign):

$ cd Downloads
Downloads $ grep '"qanda" : "Questions"' my_community_content.json | wc -l
71
Downloads $ grep '"forum" : "Discussions"' my_community_content.json | wc -l
4
Downloads $ grep '"blog" : "Articles"' my_community_content.json | wc -l
5

So what's happening here? Well, first off, I'm changing to the Downloads directory, which for me is the default location for saved files.

Then I'm doing a grep which searches each line of a file for a particular string of text. Then I'm "piping" those search results into wc -l which counts the number of lines that were just found by grep.

So then, my humble stats show that I've posted 71 comments/answers to Questions, 4 comments on Discussions, and 5 comments on Articles.

What else is this good for?

One handy use of of this data might be to answer the question "I posted an answer about XXX but I can't find the question because it was years ago and it's not coming up in search."

Well, now you can just download your content and search through it with the text editor of your choice.

What if I want to convert my posts into a more readable format or do interesting things like graphing data, etc?

Great question! So, if and when Atlassian adds timestamps, views, likes, then we could process the data with tools like jq or python, and even bring that data into Excel/Google Sheets to make neat graphs.

But I'm probably getting ahead of myself. If you would like Atlassian to provide more metadata in the export file with our own posts, please like this post!

Thank you for your time!

6 comments

Hi @Darryl Lee 

I like your curiosity :) and you made me curious as well, I think my weekend will be good.

Ravi

Like # people like this

Hi @Darryl Lee these are cool hints! I am gonna give it a try :) need to pimp up my numbers firstly and contribute more as I'm back to community after a break. 

Eva

Like Darryl Lee likes this

Very cool, @Darryl Lee  :-)

@Darryl Lee , This is one of the best postings I've read in a while. I love your writing style and how extremely helpful the information you provided is to me. I have two profiles so want to compare what is done under each one.

Cheers!

Like # people like this
John Funk Community Leader Jan 25, 2021

What a great idea!

Dave Liao Community Leader Jan 25, 2021

@Darryl Lee - thanks for pulling this together!

For any Windows users out there, first install Windows Subsystem for Linux (WSL), and you can follow along at home inside Windows Terminal. 😉 No need for Cygwin, though Cygwin is a little "lighter" resource-wise.

Thanks - yeah, it's been a while since I've been on a Windows-system proper. I've heard good things about WSL, and I'd probably install it if I had the chance. But heh, yeah a whole VM just to run grep and wc seems a bit much. :-}

OTOH, having a true *nix (ok fine, BSD) environment on a Mac was/has been a game-changer for somebody coming from a *nix sysadmin background.

Like Dave Liao likes this

In case anybody remembers this thread...

So apparently Atlassian Community runs on the Khoros platform.

I posted to their forums and got back exactly... nothing.

I'm guessing as their customer, it would have to be Atlassian (@Daniel Eads?) filing a feature request with Khoros.

Who knows? Maybe it will "gather interest" and we can all vote on it. ;-P

Like # people like this
Daniel Eads Atlassian Team Feb 22, 2021

Khoros doesn't function the same way as Atlassian does when it comes to public-facing feature requests and roadmaps. They have an ideas board where you can post / vote, although I haven't yet seen strong evidence that it factors heavily into their priorities.

Like Dave Liao likes this

Thanks for replying, Daniel.

Alas, my Developer account does not have access to that page, since I'm not a customer.Screen Shot 2021-02-22 at 1.31.22 PM.png

Comment

Log in or Sign up to comment
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you