Closed anonymous-matomo-user closed 12 years ago
Deferring to feature release milestone.
Maybe the best way to implement better Ecommerce reporting in Piwik would be to extend the Goal Tracking plugin, rather than build another plugin. Goal tracking, with custom revenues, can already be a very basic ecommerce plugin.
I am working on Ecommerce tracking in Piwik. The main idea is to track, products purchased (name, sku, category), orders (with subtotal, tax, shipping, etc.) & cart abandonment.
There will be many changes in the Tracking API (new functions to track products, orders and cart adds). Also, few new APIs to report on all this interesting data.
The reports will appear in the Goals tab, which will be renamed "Ecommerce & Goals" if an Ecommerce goal is created.
I think we should include it in 1.5 - so 1.5 will be a mega major upgrade (with GeoIP and few other new features built by other developers as well).
Please allow updating existing ecommerce data. This would require to store a unique order ID when a goal is reached. Later on, one might update all data assigned to this order ID, e.g. the profit margin. This is required, because orders are often returned and sometimes not all information is available immediately after the conversion, e.g. if it's a new customer or what the website's internal profit margin is.
This would be a huge advantage compared to Google Analytics.
(In [4691]) Refs #898 Work in progress (but should leave trunk stable and not break anything)
new API functions to request Items (product) reports: getItemsSku, getItemsName, getItemsCategory. See doc:
If you are tracking Ecommerce orders and products on your site, the functions "getItemsSku", "getItemsName" and "getItemsCategory" will return the list of products purchased on your site, either grouped by Product SKU, Product Name or Product Category. For each name, SKU or category, the following metrics are returned: Total revenue, quantity, average price, average quantity, number of orders with this product.
By default, these functions returns the 'Products purchased'. These functions also accept an optional parameter &abandonedCarts=1. If the parameter is set, it will instead return the metrics for products that were left in an abandoned cart therefore not purchased.
The API also lets you request overall Goal metrics via the method "get": Conversions, Visits with at least one conversion, Conversion rate and Revenue. If you wish to request specific metrics about Ecommerce goals, you can set the parameter &idGoal=ecommerceAbandonedCart to get metrics about abandoned carts (including Lost revenue, and number of items left in the cart) or &idGoal=ecommerceOrder to get metrics about Ecommerce orders (number of orders, visits with an order, subtotal, tax, shipping, discount, revenue, items ordered)
What is left to do:
Feedback is most welcome ;)
(In [4692]) Refs #898 This missed the last commit
(In [4694]) Refs #898 Allowing same order ID in several websites
(In [4709]) Refs #898
(In [4723]) Refs #898
(In [4731]) Refs #2432 Increasing Custom Variable truncation limit to 100 chars (name and value each allowed 100 chars long) + tests This is to allow more safety margin in tracking Ecommerce product name views refs #898 Note: we do really need to work on Refs #2321 soon ;)
(In [4735]) Refs #898
(In [4740]) Refs #898 Showing Ecommerce orders & Abandoned cart in the Visitor Log, with detail of the order revenues (tax, shipping, discount, base, total), quantity of items in the cart, and then detail of each item (sku, name, category, price, quantity) + added 2 icons
(In [4741]) Refs #898 During Piwik installation, when creating first website, possible to enable Ecommerce during the install
(In [4742]) Live! real time also displays Ecommerce Orders and abandoned carts (with details in the tooltip... it can get quite big, it's a shame that firefox doesn't handle line breaks in tooltip, but other browsers do) Refs #898
Have you noticed my comment about updating tracked orders (comment no. 12)?
Yes I saw
If you have other feedback please write here!
minor nitpick: but I would prefer we use 'eCommerce' or 'e-Commerce', rather than 'Ecommerce'.
(In [4785]) Refs #898 When Ecommerce enabled, the first submenu of "Ecommerce & Goals" will be Ecommerce report. On click, loads a graph with below the following metrics: conversions, overall revenue, Average order value, conversion rate and number of purchased products The "segment" tables is similar to other Goal reports, except it shows the following metrics (for each country/continent/server hour/referrer etc.): Visits, Ecommerce orders, Total Revenue, Ecommerce conversion rate, Average Order value, Purchased products.
more to come in the UI...
(In [4786]) Refs #898 - Improving Ecommerce report:
What is left to do for 1.5 release:
Required
Nice to have for 1.5 (if not done, should be moved to Ecommerce analytics wishlist):
(In [4793]) Fixes #2373 - hiding the help icon on widgetize view REfs #898 Ecommerce orders log now refreshes properly on pagination rather than refreshing over the whole screen
Ecommerce Analytics tracking documentation added!
(In [4811]) Refs #898
(In [4812]) Refs #898 Adding metadata reports for Ecommerce metrics, and the 3 product reports
(In [4819]) Refs #898
(In [4840]) Refs #898 Only show in Orders Logs visits that actually have some ecommerce orders (rather than relying on the visitEcommerceStatus flag)
(In [4844]) Refs #898
(In [4845]) Refs #898
(In [4846]) Refs #898
(In [4847]) Fixes #898
All new features in #2448
(In [5415]) fixes #2706
This ticket is about defining the scope and new features of a Ecommerce plugin in Piwik.
The Ecommerce statistics feature is now built in Piwik, check it out! Keywords: ecommerce plugin