Menu
By
chrisH
WooCommerce has long been the go-to ecommerce platform for WordPress powered sites. It’s easy to use and integrates well with many WordPress templates, turning a website or a blog into a storefront.
As expected, WooCommerce collects data about each purchase on the site. While some of this is also available in Google Analytics, provided you’ve set up that integration, relying on WooCommerce’s data reporting can be helpful and easy, especially when you leverage a third-party connector from Power My Analytics (PMA).
While there are other ways to get sales data into Data Studio, connecting WooCommerce directly via PMA has several advantages. First, because WooCommerce separates the data you’d want into separate reports. You need an export for products, another for sales per day, another for coupon usage. Second, some data isn’t even available for export, like information on your customers. The PMA connector, on the other hand, requires you to connect only once and pulls a wealth of data automatically. While you can get some sales data from Google, you would have to set up ecommerce tracking – not a simple task. Furthermore, WooCommerce contains your actual sales data. Getting it directly from the source is always better. If you use WooCommerce regularly and need better reporting, it’s worth the monthly cost.
The steps we outline here ultimately prepare your data for the WooCommerce dashboard available in our store. It’s turnkey and ready for your data, but you could also create your own dashboard for the data you’ll pull.
Check out these Woocommerce Looker Studio Templates below available to download
Either use the WooCommerce dashboard or open a blank dashboard and add a data source. The quickest way to find the PMA WooCommerce connector is to search “WooCommerce.” It’s the only WooCommerce connector that should show up. Select it from the list of “Partner Connectors.”
Use the search bar to find the PMA WooCommerce connector quicker.
If you’ve connected data with PMA before, this should be really familiar. If not, don’t worry, it’s easy. First, make sure you actually have a PMA account. Data Studio will prompt you to sign in or create an account with PMA before you can proceed.
Once you have an account, select a hub (you probably only have one hub) and your user account.
You’ll be prompted to add a currency before you can finalize the connection.
PMA will then open a popup box and prompt you to input your site address and API keys. They give instructions on the popup, but we’ll repeat them here.
If you’re using the WooCommerce Template, just add your new data connector at the report level or onto each chart one by one.
Here are some metrics to be sure to utilize when looking into your WooCommerce data.
Products
The most important metric is which products are selling and how much. And if you want to dive deeper, look at the net sales on each, not just total sales or gross sales. You may find areas to optimize, especially on shipping or otherwise.
Customer Data
Who are your top customers? How often are they ordering? Where are they located in the world or your country? It may tell you where to focus more attention or give you a chance to reward your best customers.
Inventory
Use the Data Studio connection to manage your WooCommerce inventory. Stay up to date with products that are running low and products that are slow to move off the shelves.
A marketplace for buying and selling original marketing resources. 1000’s of resources available, come and browse today.
