Thank you all! Many of these will work but the solution with the ETL was the easiest. Thank you for the help!
Of course! And makes complete sense.
Valiant, Thank you for your detailed response! I do want to know what is the average session duration by day - by summing the difference between each user's last and first API call and dividing by total users - so your Beast Mode is helpful but I'm not sure I understand all of it and it's currently not populating when I…