Hello everyone,
I'm having a weird issue with Analytics. We have a few contributions showing up as the wrong Campaign in Analytics. The widget is just pulling Campaign and Contribution Amount filtered to a contribution date between 7/1/19 - Latest date. I looked at a contribution with an issue and the Campaign and Fund are correct in the contribution (this FY), but the Source/Appeal associated is from a different Fiscal Year. My widget is not pulling Source or Appeal.
Instead of using the Campaign listed in the contribution, Analytics appears to use the Source as the primary way of associating a contribution to a Campaign.
Visually: contribution Source -> Appeal -> Campaign
It appears that if we enter a wrong source code at contribution entry, the contribution to count towards the wrong campaign in Analytics. Is anyone else having this issue?
Hi Neil,
Both the Campaign of the Source and that of the Contribution are available in the Analytics Contributions cube. Here's a screenshot of both fields in play using my sample database. The widget data dictionary is up in front of the widget showing the source of the two fields in the widget:
https://www.tessituranetwork.com/Help_System_v151/Content/Tessitura%20Analytics/Data%20Dictionary/Contributions%20Cube.htm?Highlight=campaign|campaign|campaign
The contribution's campaign comes from the CAMPAIGN dimension, while the source's campaign comes from the SOURCE dimension.
If after reviewing this you're otherwise pulling the field in a way that you'd expect the correct results, please open a support ticket for further investigation.
Thanks,Chris
Thanks Chris! This fixed the dashboard. I should've known better. When it gives odd results, check you assumptions.
Good news is that I can use the Campaign of the Source to help find errors at contribution entry.