Collect Team Alteryx Data for Internal KPIs

[caltang]

Hi all! 

I'm actually heading up a CoE and we're building + making great progress on all fronts except for one. Monitoring our users' usage of Alteryx community, getting badges, getting certifications, and overall progress with Alteryx. 

Right now, it's heavily dependent on self-reporting, which evidently leaves a lot of gaps! 

I'm currently pushing for users to sign up for the Maveryx community once the Alteryx license renewal period is here, so that when they renew, we can also capture their Community User ID. 

Is there a way or workflow that scrapes such information so that we can visualize it? It will be very helpful...

I'm trying to use the Download Tool, but once our user base is huge (>200). I don't think Alteryx's download tool can handle that many URLs.

In addition, I'm not sure how to even begin parsing for the information that we need...

Looking for all advice & comments!

Thanks!

[simonaubert_bd · Accepted solution]

Hello @caltang 

I really love your idea. However, I think you should post it in the... idea section instead.

For the moment, maybe a loop and then a download tool to "scrap" the data on?

Here what I did (without the loop). Dirty but works well

Best regards,

Simon

[simonaubert_bd · Accepted solution]

with several users

[caltang]

This is fantastic! 

But once you reach more than 100 users, I think the workflow slows down exponentially no?

[Qiu]

@simonaubert_bd 
Nice one!.
I will give a try to use your flow.😁

[caltang · Accepted solution]

I've enhanced your workflow further to include a few more details like User Rank & User ID as well:

 

Thanks for helping out @simonaubert_bd ! I will definitely write this as an idea / weekly challenge.

All credit goes to you!

Best,

Cal

[caltang]

By the way, @simonaubert_bd - is there a way to add a time-series element to it?

The badges have the time component with the date below the badge, and the "Earned by" is also an interesting metric to get a sense of how rare the achievement is.

You can submit this as a Weekly Challenge! I think it's very fun. @Qiu any advice on submitting this as a Weekly Challenge?

[ArnaldoSandoval · Accepted solution]

Hi @caltang @Qiu @simonaubert_bd 

I was working on this workflow as  well, my version has the following features:

• It handles a list of user names, from 1 user to as many as you need. There is not need to enter out Alteryx's User ID, the workflow sort that out.
• It output the Username, User ID, Badge Name, Alt Badge Name, and Badge Date (Badge Date is the date when you received the badge).
• Badge Name and Alt Bade Name always show the same value, but we don't know when Alteryx could extend these fields.
• The Badge Data is the date when you got awarded the badge, this field seem to be in UTC date format because I earned the "General Knowledge Certified" badge on the 2023-04-14 Sydney Time, while the page's HTML appear as 2023-04-13.
• No all the Badges include the date when we earned it, some of them include the day of the week when we earned it, without the calendar day. This field appears as null in the output.
• The workflow implements the macro "find username"; it resolves the User ID from the Username.

Workflow

The users to process are entered at the Second input tool (8)

This is the workflow output, it does not include the User Rank (at  the moment)

Hope this helps,

Arnaldo

[ArnaldoSandoval · Accepted solution]

Hi @caltang @Qiu @simonaubert_bd 

I added the User Rank to my workflow, now going with the name Get_Users_Badges_and_Dates-v01.

Actually our Alteryx's profile contains some meaningful attributes, I will be adding them.

hth

Arnaldo

[caltang]

Magnificent! I’ll look into it when I’m at work tomorrow, but the workflow is great. Thank you @ArnaldoSandoval !