We would like to track, over time, the performance of some of our contribution source codes (specifically, subscription renewal asks).
I cannot, however, find the source start date anywhere in the Contributions cube. Is this doable in Analytics?
Thanks!
Assuming that it is not available in another cube (I could not find it in Finance or Contributions Cube), you could use one of your ten Custom Categories in Analytics. The 10 Custom Categories are available in every cube.
However, be aware that attempting this and creating a bad query could cause your Analytics to not load correctly (been there, done that; oops).
https://www.tessituranetwork.com/Help_System/Tessitura_Left.htm#CSHID=Tessitura%2520Analytics%2FIntro%2520and%2520Overview%2FIntroduction.htm|StartTopic=Content%2FTessitura%2520Analytics%2FIntro%2520and%2520Overview%2FIntroduction.htm|SkinName=TN%20New
You would just need to figure out the SQL query to get the data column you want. They suggest you use the secure view versions of the tables.
Make sure you have an aggregate function in your select statement; so it will limit the rows to one. For example, "max(start_dt)".
Data Select - The SELECT portion of the SQL statement that will be constructed to populate the field, which must use an aggregate function to limit the results to one row.
The Data From column generally starts with dbo.V_CUSTOMER_WITH_PRIMARY_AFFILIATES q join....
Note: The resulting SQL statements from this table will "GROUP BY q.customer_no". There MUST be a table aliased as "q" and containing a "customer_no" column in every Data From value in order for the Constituent Summary load to succeed.
If your Analytics does not load the next time that is should, this generally means it does not like your query because it does not limit the rows to one. Make a copy of your query before deleting the text in the system table row. Then see if Analytics will load the next time it is supposed to load.
Thanks Neil; I don't think it exists, which is surprising. I'll look into creating a custom category.