added api views for generating url and click count query