Hi, all-
Wondering if anyone has set up a new to file widget in analytics to see the most recently created accounts. Ideally, I'd like a date filter to select the appropriate date range (last seven days, last 30 days, etc.).
I tried using the field below, but upon further research have discovered that this field is based upon a membership scan or sub-line item, not account create date, so not what I need.
https://www.tessituranetwork.com/Help_System/Content/Tessitura%20Analytics/Data%20Dictionary/Seats%20and%20Tickets%20Cube.htm
Is there an account create date field that I am overlooking?
Thanks!
Hi Rachel,
Not sure if this is helpful but the create date dimensions are specific to the cube that your dashboard is referencing. If you use the memberships cube, for instance, the create date dimension is based on membership create date, rather than a ticket related create date. However I don't think any of the create date fields are for the creation of the constituent record
One option for getting this date is to configure one of the custom date filters on the constituent dimension to pull constituent create date. These custom categories are defined in the TX_ANALYTICS_DIVISION_ELEMENT table.
Amanda,
That's very helpful! Thank you. I'll have to look into configuring one of the custom date fields for this purpose.
Appreciate your response!
One other option I just thought of is to create a list with Constituent create date as your criteria with the date relative to run date of the list and use that as a filter for your fields. I believe you would have to set the list to generate each day so that updated data was captured in Analytics.
Filtering using lists is described here: https://www.tessituranetwork.com/Tessitura_Analytics/Tessitura_Analytics.htm#Designing%20Dashboards/Filter%20by%20List.htm%3FTocPath%3DDesigning%2520and%2520Editing%2520Dashboards%7CDashboard%2520and%2520Widget%2520Filters%7C_____3
That sounds like that could work! Since analytics is refreshed nightly, I would likely have to set my list to the previous day, correct?
Thank you so much for your help with this!
Your data would always be a day behind in Analytics but your list criteria should be set to the actual date range you want to see, if that makes sense - The data pulled into Analytics would be based on the data in the list for the last time it was generated on the night of each incremental load. So if you wanted to see constituents created the day before in Analytics you would set the list criteria to the run date of your list and then run it at the end each day before your Analytics incremental runs.