• Replies 6 replies
  • Subscribers 962 subscribers
  • Views 241 views
  • Users 0 members are here
Related

Lists in Analytics not showing all constituents

Jenni Daniel
$organization

Hi everyone! 

I've created a couple of lists that I'm trying to use to create dashboards to share with our deputy director. She wants to see two things:

  1. A list of all of our board members from 2018 to present with their giving by year, 2018 to present. To do this, I first created a list with board members (replacing individuals with households and also adding affiliated groups to capture their foundation giving, etc.). I then used the list as a filter for a pivot table widget (Rows: Constituent Display Name; Values: Total Received Amt; Columns: Cont Date Calendar Yr). 
  2. A list of donors who have made gifts of $10K+ this year. I also made a pivot table with this list as a filter (Rows: Constituent ID and Constituent Display Name; Values: Total Contribution Amt; Columns: Cont Date Calendar Month). 

I'm not seeing my full list of constituents in either widget. Any ideas why someone would show up in my results in List Manager but not in an Analytics dashboard?

Thanks!

Jenni Daniel
Director of Development
New Orleans Museum of Art

Parents
  • $organization

    Hi Jenni,

    A couple of other thoughts:

    I have been working on pulling a dashboard for board.  We put a plan in for each of our board members and pulling from the plans cube will show all board members, even if they haven't yet given.  Since we can link soft credited gifts to the plan, it will include those. 

    I have been trying to get the board's giving to other areas but am finding it challenging since some of it is soft credited.  I tried a list but realized that if a board member has a match from Company A and I include it on a list, Company A will appear in my dashboard when using a list filter, BUT if other people have matches from Company A, all that giving will be included so it's not an accurate account of the board giving.  (It will be great when Analytics will show soft credits.)

    I'm not sure if initiator might be useful or not.  I haven't yet tried it as we haven't been using initiator on the contributions, but I found initiator is a field in the widgets.  At some point I plan to test to see if using initiator, might be something to use for soft credits.  Perhaps someone else in the community has used this and can give some information about how that works.

    Best,

    T.C.

Reply
  • $organization

    Hi Jenni,

    A couple of other thoughts:

    I have been working on pulling a dashboard for board.  We put a plan in for each of our board members and pulling from the plans cube will show all board members, even if they haven't yet given.  Since we can link soft credited gifts to the plan, it will include those. 

    I have been trying to get the board's giving to other areas but am finding it challenging since some of it is soft credited.  I tried a list but realized that if a board member has a match from Company A and I include it on a list, Company A will appear in my dashboard when using a list filter, BUT if other people have matches from Company A, all that giving will be included so it's not an accurate account of the board giving.  (It will be great when Analytics will show soft credits.)

    I'm not sure if initiator might be useful or not.  I haven't yet tried it as we haven't been using initiator on the contributions, but I found initiator is a field in the widgets.  At some point I plan to test to see if using initiator, might be something to use for soft credits.  Perhaps someone else in the community has used this and can give some information about how that works.

    Best,

    T.C.

Children
No Data