sharepoint online site usage report not showing some sites

Hi Parag, it's true. Publishing sites are not reported in Office 365 SharePoint site usage reports. In many cases, information about publishing sites are very useful, and judging by your post I can see that it would be of use if you would be able to track them. For this type of detailed report, a third party analytics solution is usually needed. http://intlock.com tracks publishing sites amongst other aspects of portals that are usually not tracked with Office 365 and SharePoint. Its ability to provide detailed analyticst is a direct result of it being designed to connect specifically to all versions of SharePoint and Office365. For more information about Cardiolog Analytics, and for the option to book a free demo go to http://www.intlock.com