Is there a way to include affiliations for constituents in analytics? We had teachers visit in July for appreciation month, and we added affiliations for each teacher's constituent record with their school. I am looking to pull analytics for how many teachers visited from each school and for the cities that each school is located. Is this possible? I tried searching for this field but only found "Constituencies Inc Affiliates" which is not the correct information. Any insight would be appreciated. Thank you!
Is this based on the Seats and Tickets cube? If so, I think there's a fundamental problem in that affiliate relationships can be one to many, and that would then require duplication of seats/tickets, e.g.:
Seat 1 | $10 | Teacher 1 | School 1
Seat 1 | $10 | Teacher 1 | Household 1
Seat Count = 2
Paid Amount $20
That said, you might be able to create a custom element for this. Those can sometimes break the no-duplication rules, but also for a specialized case like this you could build it on a view that ensures only one school affiliation per teacher.
Hi Mollie,
I assume the purchases are on the Teacher account, and you want to see the school, if so, I like Gawain's Constituent Element suggestion. It could be configured to show the name of the school when a constituent has a teacher affiliation to one. That in combination with their price types should allow you to distinguish between school and other purchases for a single Teacher.
If it's the other way around and the purchase is on the School account, then if you're flagging up the Teacher as the initiator you can probably already get to that with the INITIATOR CONSTITUENT dimension in Seats and Tickets.
Best,Chris