Maybe @cocastro can point you in the right direction when he’s back from SXSW?
I need to check out the dashboard metrics of Salesforce. It’s been a while since I looked under the hood of SFDC.
There are a few non-tech ways of doing this. The easiest is to use a sample. List 100 members who joined in the past month and individually check how many made a contribution. If you can run a SQL query, then we’ve used this for discourse:
SELECT (SELECT user_id FROM user_stats WHERE user_id = u.id LIMIT 1) user_id, u.name, e.email, to_char(u.created_at, ‘YYYY-MM-DD HH24MIDD’) joined,
to_char(p.created_at, ‘YYYY-MM-DD HH24MIDD’) post_created, t.title topic_title,
WHEN 1 THEN ‘Topic’
FROM posts p
LEFT JOIN topics t ON p.topic_id = t.id
LEFT JOIN users u ON p.user_id = u.id
LEFT JOIN user_emails e ON u.id = e.user_id
WHERE p.created_at = (
FROM posts pp
LEFT JOIN topics tt
ON pp.topic_id = tt.id
WHERE pp.user_id = p.user_id
AND tt.archetype IN (‘regular’, ‘banner’)
AND p.created_at > CURRENT_TIMESTAMP - INTERVAL ‘30 day’
ORDER BY u.name
^ that tends to be the most effective ways of getting the results you want.
Otherwise, I’d ping Salesforce and ask.