Pivotal Analytics

Pivotal Analytics is a different way to work with all the data you collect while running your eCommerce business. Instead of working with flat reports, Pivotal Analytics allows you to work with data across multiple levels, helping you answer questions you didn't even know you had about how your business is performing. This type of advanced analytics is perfect for businesses that want to make data-driven decisions about how they plan to grow. 

What Makes up a Pivotal Analytics Report?

At first glance, a Pivotal Analytics report looks similar to any other flat report and can be split into 4 main pieces.

 

Values

Values represent the data that you're interested in. It's what's being pulled out of Linnworks when you run a report. You can include more than one value in a single report, as each value will be contained within its own column.

piValues

Columns

Adding columns to your report lets you group your values using a measure you're interested in. For example, if you've selected Order Count as a value for your report, selecting Order Dates as a column lets you group all your orders by date.

piColumns

Each column can be further split into sub-columns. Including sub-columns lets you expand your report to drill down further into a single measure. For example, adding Year, Month, and Day to your Order Dates column lets you focus on specific days in the year that interests you.

Rows

Adding rows to your report lets you group your values using a measure you're interested in. For example, if you've selected Order Count as a value for your report, selecting Order Channel as a column lets you group all your orders by channel.

piRows

Each row can be further split into sub-rows. Including sub-row lets you expand your report to drill down further into a single measure. For example, adding channel and subsource to your Order Channel row lets you focus on specific websites and marketplaces your interested in.

Filters

Adding a filter allows you to thin out your report, to remove any data that you're not interested in reporting.

piFilters

By adding filters you can further tailor your report to meet your needs, removing any irrelevant data that could negatively influence the data you're trying to extract.

Rebuilding a Report

It's likely that while your working with analytics, someone else in your business is using Linnworks to perform another task, like processing orders or creating listings. Pivotal Analytics is designed to work with very large datasets, and working with your database in this manner may end up slowing down your colleagues. 

So instead of pulling all your data out of Linnworks every time a report is run, Analytics takes a snapshot of the data it needs and keeps a copy of it for its own purposes. This way you can investigate and manipulate data without interfering with the rest of the system. 

To keep the data your reports are working with up to date, you can rebuild your report to pull the latest data from your Linnworks database. 

piRebuild

This ensures that the data your reporting is up to date, including all your latest orders and stock movements.

Exporting Data

Once you've configured a report to show you the data you're looking for, you can export the results as a .xlsx file.

piExport

Your exported file will be structured exactly how you've configured the report in Linnworks, with any expanded columns and rows.

Prebuilt Reports

Pivotal Analytics comes with a range of pre-built reports for you to run. These reports can be further customised to add your own values, columns, rows and filters. Click one of the prebuilt reports below to learn about how the report is built. 

  • Orders by Channel
  • Product sales by Month
  • Product sales by month (composites)
  • Returns by Month and Channel
  • Shipping Service by Country
  • Currency Conversions
  • Sales by Hour
  • Inventory - Over time
  • Inventory - Consumption Report
  • Inventory - Consumption Over X Days

Custom Reports

If the prebuilt reports don't offer the results you're looking for, then you can build a brand new report that's configured to return the data you're looking for.

Learn how to create your own Pivotal Analytics reports.