Is it possible to use a date range feature when filtering data in the SF integration?

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?