Is it possible to use a date range feature when filtering data in the SF integration?
Hi everyone! I’m working on our Salesforce dashboard, which will ideally be our source of truth for community KPIs for internal stakeholders when it’s fully operational.
At the minute, my immediate team is using it to track our KPIs every quarter. I’m finding it difficult to pull data from last quarter as there isn’t a date range filter I can use (eg. made a post between: 1st Jan and 31st March). The only filter that seems relevant is ‘Last Post Date” and it doesn’t work well in this circumstance. If I use ‘Last Post Date’ and use a relative “Last Quarter” date, it excludes the people who have posted since in the new quarter and doesn’t give me an accurate number. I can’t figure out a simple way to pull this data on Salesforce.
Has anyone dealt with this before? Thanks!
Page 1 / 1
Yes, it’s possible. I have a ton of date range based reporting in my salesforce dashboard.
The best part of the Salesforce integration is that it syncs a ton of community member activities (visits, topics, replies, likes) in addition to the community members. You need to build your reporting based on those activities, not on the fields in the Community Member (user) object.
@DannyPancratz Can you give me an example of the filters you would use on SF to pull a report of everyone who posted on your community at least once between 1st Jan and 31st March? It would be super helpful, thanks!
@ruth.kenrick
Sure, my Monthly Active Users report is an example. We define MAU as someone with at least 1 visit within the calendar month.
For building the report, we’re using measuring Community Members with Activities as the thing to measure, not any attribute on the Community Member object (ex. Last Activity Date).
Here’s how the report is built:
I know from experience that you can adjust your filters for activity date to between two specific dates, if that’s what you need. But … if you’re just looking at who was active in the first quarter (Jan - March)
The report date setting is what does the monthly roll-up for us, and we use a copy of the same report to do our Quarterly Active Users, just adjusting the setting from Calendar Month to Quarter.
In summary, we’re doing reporting on Community Member Activities, pulling in the name of the Community Member, then doing a Unique Count of Community Members with activities during that timeline. And grouping by Date.
That allows us to aggregate and count unique Monthly Active Users with visualizations like line or column charts.
Thanks! @DannyPancratz
Does Community member activity in Salesforce also measure registrations as activity? I ask because when I created a filter for ‘last visit date’ greater than a certain date it gave. me one # - when I added another filter, ‘# Community activities’ to be greater than 1, is showed another number (12 less).
I am trying to get the most accurate representation of Active Users and Active Accounts monthly and quarterly, have you found Salesforce to give you more accurate data?
If you ever had a profile with us, there's no need to create another one. Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.