Identifying first-time ticket buyers

Hi Elizabeth,

I've got a screenshot for you below of the widget (which includes lots of other information that I use for concert wrap up) - sorry, had to redact the actual numbers.

Let me know if there's a specific part of the widget you need expanded on! 

This is the dashboard I use with this widget - I think if you change the data source to your "seats and tickets" cube you should be able to copy it or modify it for your use!
  SharingDashboard.dash

Cheers, Nicola

Nicola,

Thanks for sharing your dashboard. Also looking to get this in Analytics so really helpful.

I have imported into our Analytics environment but for all productions seasons I check am getting zero values for the "First Time Buyers", "% new audience" or "First Time Tickets" columns. 

Other columns are populating with data as I would expect. The formula for these columns also looks fine compared to your screengrab above. Any ideas for what might be causing this?

No worries if not as I can do some more digging and if needed raise with Tess.

Thanks, Donald

Donald Graham
Ticketing Systems & Data Manager
Birmingham Hippodrome, Hurst Street, Southside, Birmingham B5 4TB

Nicola,

Thanks for sharing your dashboard. Also looking to get this in Analytics so really helpful.

I have imported into our Analytics environment but for all productions seasons I check am getting zero values for the "First Time Buyers", "% new audience" or "First Time Tickets" columns. 

Other columns are populating with data as I would expect. The formula for these columns also looks fine compared to your screengrab above. Any ideas for what might be causing this?

No worries if not as I can do some more digging and if needed raise with Tess.

Thanks, Donald

Donald Graham
Ticketing Systems & Data Manager
Birmingham Hippodrome, Hurst Street, Southside, Birmingham B5 4TB

I don't know if this is what you're running into, but in this bit...

...for a Days Difference function, both fields should be "Days in..." level. Change the Years in First Performance Date to Days in First Performance Date.

Hi Chris,

Thanks for the suggestion but still coming up as zero. Is there anything else I can try? If not no worries - I can bring up with our ES contact.

Thanks, Donald

Hi Donald, 

Sorry you're having issues! I cobbled this together using a variety of past threads here on the forum, so unfortunately I don't completely understand the formula! 

Sometimes when I download other people's dashboards, I find I have to put each field in again for some reason (so deleting [Days in date] and then selecting it again from the list) 

Hope you get it sorted out!

No worries - thanks again for sharing. Even without it sharing, really helpful to have a place to start. 

I have tried re-adding the data elements but still not returning anything. Might be something to do with my filters. I will look at again with some colleagues - I'm sure we will get their evenetually!

Thanks again, Donald