📊 How to Track Who’s Giving vs Receiving Accepted Answers

🤝 Why These Metrics Matter

A healthy community isn’t just about questions getting answered—it’s about who’s asking and who’s stepping up to help. Tracking both sides shows:

Knowledge Hubs – Identify members or roles providing the most accepted answers (great for swag 💝 or “Top Contributor” badges).
Support Gaps – Spot roles that ask a lot but rarely answer, so you can offer training or resources.
Peer-to-Peer Success – Prove that the community, not just staff, is solving problems—key for ROI stories and resourcing decisions.

Below is a quick guide to build these insights in Dashboard Charts using the QnA data source. ⬇️

🤔 All Answers? Or Only Accepted Answers?

If you want to focus on accepted answers, make sure to set the filter Type = answer_accepted to focus your chart only on answers that were actually marked as accepted.

This ensures you're measuring verified solutions—not just any replies.

🧑‍⚖️ Who is Providing (Accepted) Answers

(the user who provided the answer that was ultimately marked Accepted)

Group by Insert User fields:

Field	What it tells you
`Insert User ID`	Unique ID of the answer-provider
`Insert User Name`	Display name of the answer-provider
`Insert User Rank Name`	Rank of the answer-provider

These fields capture the person who posted the solution that was eventually marked as accepted—perfect for recognizing top helpers.

If you don't have the accepted answer filter on, it will be folks that supplied answers in general, not just those who supplied the accepted answer.

🙋 Who is Receiving Verified Answers to their Questions

(the user who asked the question)

Group by Post Author fields:

Field	What it tells you
`Post Author Role Name`	Role of the question-asker
`Post Author Role Type`	Role type (Admin, Member, etc.)
`Post Author Role ID`	Role ID of the question-asker

These fields spotlight the groups benefiting most from community expertise.

Use these insights to celebrate contributors, balance support loads, and keep your community thriving. 🙌

Questions? Drop them below—happy chart-building!

Find more posts tagged with

Comments

Jocelyn

@Shauna one of the issues I face with our community is that I am unable to find out how many users are giving genuine answers on others question. Just finding the users who answer questions doesn't give me correct data as users might be commenting on their own questions and that could be considered a answer in analytics. I had created an idea about this to have dynamic filters so we could pull users who are not commenting on their own questions. Basically a filter - Parent record author name is not equal to Comment Author.

What would you advise to find such users who are answering questions in the community? Sometimes a user answers a question but their answer is not necessarily marked as accepted. Also type = answer_accepted doesn't give the correct data as the parent author can sometime mark their own comment as accepted. We have tested this thoroughly. Rather the badge first answer gives correct data.

Shauna

Hey @Jocelyn you raise some excellent points! There isn't a good way to do this out of the box today, but I will make sure this is considered for future improvements to our analytics.

That being said if you made a chart something like this:

…Where the insert username is the person whose answer was marked as accepted, and the post author name is the person who asked the question…

You could then export that data as a .csv and use an excel formula to discount any rows where the insertusername was equal to the post author name … a bit manual, but you know me, I like to offer any solution I can until we build an official way to do it :)

Jocelyn

Thanks @Shauna I am already using that to get the data I need. I was hoping for a better solution. Hope to see the improvements roll out soon.

Quick Links

Upcoming Events

HLV Connect: Open Session
⭐️ Got something cool to share? Have a victory in your community and want to show off your accomplishments with fellow community builders? 🙋 Got questions? Bring your community, tactical and random questions and get answers from peers and Vanilla experts! 🗓 Join our very own @ShannonHudebine and @IsabelleK, and a group of…
AI Study Group for Community Managers
Join our AI Study Group for Community Managers. At each session we'll discuss what group members are experimenting with and learning, how we're using AI in our communities, and help one another problem solve. The group meets monthly, and is open to any community professionals interested in the topic of AI. Hosted by our…
HLV Connect: Analytics Endpoints
Hey Vanilla friends 👋 Join @Branwyn T and @Kirstie as they explore the new options available in the analytics API to bulk export and download analytics data - perfect for setting up PowerBI dashboards and using AI tools to better understand your site’s ROI! Have any questions you want to ensure we cover? Add them to this…