Adding external data into dashboards

Hello!

We occasionally have co-productions where tickets are sold through two different organizations. We traditionally manage this by placing the other seller's seats on hold/allocation, but their sales data does not write back into our database.

We don't plan on having the specifics of their sales write over to constituent records on our end - our agreement doesn't allow for that granularity in data sharing. Instead, we would like to include their sales totals in our analytics dashboards so we can get a more holistic picture of sales for these productions.

We receive sales reports from them in the form of .csv files autogenerated by Ticketmaster. For now, we track these sales separately from our own. I'm wondering whether anyone has any experience with adding external data to analytics dashboards, or whether that's even possible, and how you might recommend approaching this?

Warmly,

Andrew

Parents Reply Children
No Data