Posted on

WooCommerce and Google AdWords Customer Match

Google AdWords Customer Match lets you show ads to your customers based on data about those customers that you share with Google. Customer Match is a useful advertising tool for many business goals, from increasing brand awareness to driving performance. For example:

  • On YouTube, reach new audiences, by targeting similar audiences to your most valuable customers.
  • On Gmail, reach your customers or a similar audience with personalized ads at the top of their inbox tabs, in addition to your email campaigns.
  • On the Search Network, optimize your campaigns by adjusting your bid based on what you know about your customers’ activities.

Keep your clients’ sensitive data safe – use WooReports to encrypt your customers’ email addresses before uploading them to Google AdWords. Use Customer Behaviour reports, grid view, to get Hashed Email SHA256 data.

Read more by following this link.

Posted on

WooCommerce Inventory Level

Inventory management touches many parts of your WooCommerce business. When you forgo management, you can’t forecast sales. You can’t efficiently get items to customers when they need them.

This can lead to different types of problems. Carrying too much inventory ties up capital. Too little means missed opportunities for sales. Both affect your customer experience.

Inventory management can benefit you in many ways, like:

  • It prevents overselling. When inventory isn’t tracked, it can lead to you incorrectly listing available inventory on your site or marketplace. Nothing is worse than telling a customer you can’t ship an item they bought because you actually don’t have it.
  • It provides a better customer experience. Tracking inventory means that customers can check online for inventory levels, whether for online or in-store. Employees are also better equipped to help customers with this information too.
  • You can track and forecast sales. If anything, this should be a major advantage of implementing a robust inventory management system. Tracking your sales means you can estimate how much inventory you’re going to need on hand during different parts of the year. This helps you avoid making or ordering too much or too little.
  • Inventory management helps speed up shipping processes within the warehouse. When you don’t rely on manual entry, you can quickly know that you have the inventory on hand to ship. You’ll have more control over your inventory and be able to track it over different locations.

With these types of benefits, it’s easy to see why inventory management should be one of your top priorities.

WooReports offers you ability to understand your current stock levels and it’s associated value at price, sales price and cost. Just follow the simple steps below to access the report:

  1. If you do not have WooReports installed, follow these instructions
  2. Go to Stock at sales value report, simple Grid view
Posted on

WooCommerce Average Order Value (AOV)

AOV is considered a key metric by many online retailers, because the higher you can encourage AOV to be, the more income your store will get.

The basic calculation is: (Sum of Revenue Generated)/(# of Orders) = Average Order Value

As example, to calculate your store’s average order value, simply divide total revenue by the number of orders. To keep things simple, let’s say that in the month of September, your web store’s sales were $31,000 and you had a total of 1,000 orders. $31,000 divided by 1,000 = $31, so September’s monthly AOV was $31.

Calculating average order value in WooCommerce could not be easier, just:

  1. If you do not have WooReports installed, follow these instructions
  2. Go to Sales by Each Order report, Pivot Grid view
  3. Enable the Configurator by clicking the Configurator drop-down, select Right
  4. Takeout all fields, leaving just Order Id and Order Value in Values section of the Configurator
  5. Apply Average (Avg) as aggregate function on Order Value, by clicking on Order Value > Field Settings; feel free to rename the as you like, we’ve renamed it “Avg Order Val”
  6. Apply Count as aggregate function on Order Id, by clicking on Order Id > Field Settings; feel free to rename the as you like, we’ve renamed it “# Orders”
  7. Select what you other fields you want to see on Row and Column labels of the Configurator; in our screenshot, below, we’ve selected Month and Year
Posted on

WooCommerce Products Affinity

Products affinity looks at which products were frequently ordered together by customers – think Amazon’s ‘Customers also bought’ section. By analysing this, you’ll be able to spot patterns in customer’s orders in order to accurately cross-sell to future customers purchasing one of those products.

Now you can easily spot these relationships between products and link or group your products together in WooCommerce as follows this is https://docs.woocommerce.com/document/managing-products/#linked-products-section.

  • Identify products likely to be purchased together
  • Identify anchor products that drive sales of other associated products
  • Determine items that create a pull-through and need to be promoted
  • Enhance sell-in and in-store placement recommendations with credible, fact- based analysis
  • Develop optimal promotion plans that benefit you and your suppliers
  • Identify true and artificial affinities among products
  • Identify product relationships in multi-channel environment

Spotting these relationships is easy with WooReports’s new report, Products Affinity.

The report displays a matrix of all your ordered products within a given time interval and shows at the intersection of each two products how many times both products have been ordered together.

Posted on

Overview of WooReports Dashboard, the new face of WooReports

With the new redesign of WooReports, you now exposes data from your WooCommerce store, without storing it on our servers, and you access it through modern UI composed of simple data grids, charts and our unique pivot grids.

WooReports is composed of:

  • a WordPress plugin which exposes store data through a secure and authorized method – we call this API (follow this link for setup instructions), and
  • a responsive and modern user interface which allows data access and perform analysis – we call this Dashboard, accessible at https://woo.report/dashboard/.

This article presents a quick overview of WooReports Dashboard.

  • Welcome screen of WooReports
  • Select your WooCommerce store, once you’ve authenticated WooReports API with WooReports Dashboard (this is a secure method provided by WooCommerce)
  • Select / search the report you desire, using the Menu tree on the left
  • Upon Report selection, from the menu, data will be fetched using default filter values; to change these values press the funnel button in the header of the data grid panel; set your desired report filters; obviously, report filters vary by report; not all reports have available filters
  • Easy code completion and data validation is available for filter fields (and usually for most input or display fields)
  • Report data can be displayed using at least two methods, simple Grid and an Pivot Grid; Pivot Grid is quite similar to Microsoft’s Pivot feature; Fields are available, they can be positioned in a matrix, on columns, rows and at the intersection, offering you the possibility to analyze the data in the desired way
  • In Pivot Grids, fields can be expanded and collapsed
  • In Pivot Grids, subtotals can be displayed or not
  • In Pivot Grids, totals can be displayed or not
  • Data can be refreshed (re-fetched from your server – from WooCommerce) by pushing the button in the header of the data grid panel
  • The data display panel can be maximized for deeper focus on analyzed data
  • Data can be exported, showing Pivot Grid export feature; in Pivot Grid, you can export either only visible data, or all configured/initial displayed data, both in Excel and CSV formats
  • Data can be displayed also in simple Grids, a tabular display of data
  • Data export is available in Grids as well, both in Excel and CSV formats
  • Some reports have comprehensive filter fields, like Customer Behavior report
  • Filter fields validation is ensured by date selectors, number increment-ors and drop-down lists
  • Once data is fetched from your server, Pivot Data can be further filtered, for example, if you want to look at products that their name start with ‘Product’
  • By pressing the question mark button in the header of the data grid panel, the help window is displayed
  • Each reports is briefly presented in a help window
  • Once WooCommerce Stores are defined (see this article on how to achieve it), they need to be authenticated; this procedure must be done just one time
Posted on

Setting up WooReports

With the new redesign of WooReports, we not only changed the UI/UX, but the entire solution.

WooReports is composed of:

  • a WordPress plugin which exposes store data through a secure and authorized method – we call this API, and
  • a responsive and modern user interface which allows data access and perform analysis – we call this Dashboard (following this link for a quick overview), accessible at https://woo.report/dashboard/.

This article explains how WooReports API is installed and configured to work with WooReports Dashboard.

  1. Install WooReports API (Free) from WordPress.org repository; this is a standard step for most WordPress/WooCommerce users. Make sure you have the previous versions of WooReports deactivated or uninstalled from your site.

    Note 1: WooReports API is found at WordPress.org, https://wordpress.org/plugins/wooreports-free/
    Note 2: For How To install a plugin, go to http://www.wpbeginner.com/beginners-guide/step-by-step-guide-to-install-a-wordpress-plugin-for-beginners/

  2. Go to WooCommerce > Settings page > Integration tab > optionally, select WooReports if you have more than one tab and you should see this screen, where you need to specify the email address and the store path of your store; by default, these values will be pre-populated for you, make sure to change them accordingly. Click Save to proceed.

    Note 1: In case your server can user secure http, then be sure to set it accordingly.
    Note 2: Usually API security should be enabled; you can however disable it, but this will make WooReports API endpoints accessible by applications which are not authorized with WooCommerce.

  3. You will be taken yo https://woo.report for to login/register your user and store your website path as a WooReports Store. Login/register to proceed.

    Note 1: Make sure you are logged of from https://woo.report.
    Note 2: In case you already have a user with https://woo.report, you need not to register another user, you can add your store to the existing list of stores.

  4. You will be taken to your Account page, at WooReports Stores subpage, where you have all your stores listed, or just the newly created one. Each store will need to be authorized just one and you do that by clicking Authorize button, next to your store.

    In case you have multiple stores, you can set one of them to be the default one, and it will be default selected when you access WooReports Dashboard.

  5. You will be taken to your store (your website) to perform autorization of your store with WooReports. You will need to login to your store (or, in case already logged in, you will skip this step)

  6. You will be asked to accept authorization of WooReports with your store.

    Note 1: In case you have logged to your store which has unsufficient privileges, then this process will fail. You need to be logged in with a user that holds manage_store capability; or, a user in any of these roles Administrator or a Store Manager.

  7. Once you authorize your store, you will be taken back to WooReports and your store will have read permissions set. No other actions can be performed your your store, unless you have several of them, thus allowing you to set only one as default, as previously mentioned.

  8. Click the top link Dashboard or follow this link, and you will be taken to WooReports Dashboard.

Posted on

Stock at sales value in WooCommerce

Why is stock valuation important?

Most of WooCommerce stores use WooCommerce inventory management to track the stock of the products. Having an accurate valuation of inventory is important because the reported amount of inventory will affect the cost of goods sold, gross profit, and net income on the income statement, and the amount of current assets, working capital, total assets, and store owner’s equity reported on the balance sheet. Continue reading Stock at sales value in WooCommerce

Posted on

WordPress Accurate Geolocation Map

Plot our visitors and WordPress users on Google Maps to see exactly from where they are accessing your website!
Continue reading WordPress Accurate Geolocation Map

Posted on

WordPress Accurate Geolocation

Many of businesses which run operations close to a particular market need nowadays to understand from which locations their visitors, users or customers are accessing their website, from where they are using the website, from where they are placing orders or booking services.

There are for sure usage scenarios of high accurate geolocation data for such business owners and just to name a few, consider these ones:

  • a local news website which wants to advertise stores in close proximity of it’s visitors or users
  • a restaurant which takes online orders with pick-up delivery
  • a barber shop, hairdresser saloon, medical shop which wants to expand and needs to position the next locations in proximity to it’s existing customers
  • etc.

Continue reading WordPress Accurate Geolocation

Posted on

Announcing WooReports integration with WooCommerce Subscriptions

Did you know that it costs five times as much to attract a new customer, than to keep an existing one?

The first rule of any business is to retain customers and build a loyal relationship with them, and thereby avoid customer acquisition costs. It’s a well-established fact that 44% of companies have a greater focus on customer acquisition vs. 18% that focus on retention. Also, it’s true that only 40% of companies and 30% of agencies have an equal focus on acquisition and retention. Continue reading Announcing WooReports integration with WooCommerce Subscriptions