Thanks, @Chitra.Lal for the detailed answer.
Did Analytics API meet your requirements? If you thought @Chitra.Lal covered everything please mark her response as an accepted solution. It would help others with similar issues find the answer quickly.
Let us know if you have further questions.
... View more