I want to have custom report which will show Product view count and total quantity ordered and ratio of these two in a report.
Please give me some idea how I can create this report in admin.

1 Answer 1


You probably can start from the table report_viewed_product_aggregated_daily and join it with the sales_bestsellers_aggregated_daily. Both contain product_id and names.

I can also take care about products with zero views/purchases, probably as a separate section.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.