Analytics reports inconsistent/incorrect data

  • Resolved rebeccaolson

    (@rebeccaolson)


    3 years, 11 months ago

    I love the look and ease of use of the Analytics reports, but I am having serious issues with the accuracy of the data. I noticed it because I’ve been having difficulty pulling tax revenue reports (that ticket opened separately).

    As I was troubleshooting, I started comparing the Analytics tax report to the Woocommerce>Reports>Taxes report to see if I could figure out where the error was, and discovered much bigger issues throughout the entire Analytics reporting structure. The numbers do not match on a regular basis. There are inconsistencies between the reports with the tax amount, the number of orders, Net Sales, etc. There are inconsistencies between Analytics and Woocommerce>Reports, but also within different Analytics reports (eg: See “Total Tax” below).

    I have no idea which (f any) reports are accurate, and it’s causing me quite a bit of stress since we’re coming up on tax time. You can see from the different report examples below that the numbers are different all around – there doesn’t seem to be any consistency. Any help would be greatly appreciated.

    Examples
    Report: Analytics>Orders
    Orders 1493, Net Sales $44,739.10,

    Report: Analytics>Taxes
    Orders 663, Total Tax $1637.37

    Report: Analytics>Revenue
    Total Tax $3271.46, Net Sales $44,739.10

    Report: Woocommerce>Reports>Orders
    Orders 1493, Net Sales $44,887.10

    Report: Woocommerce>Reports>Taxes
    Total Tax: $3279.35, Orders 1215

    Note: I am using Jetpack to automatically calculate sales tax. I also use the Point of Sale plugin for Woocommerce for our brick & mortar store.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    Hi @rebeccaolson

    Thanks for reaching out. Could you try deleting all previously imported orders from Analytics > Settings:

    https://docs.woocommerce.com/document/woocommerce-analytics/#analytics-settings__import-progress

    Then reimport all order data from the same page after the deletion process has completed? This will ensure all data is present.

    As for the differences between each report type, this is expected since each account for its own report type. Depending on which report you’re viewing, taxes or refunds may be omitted to given details about that specific report. The details for each report can be found here:

    https://docs.woocommerce.com/document/woocommerce-analytics

    Apart from that, we have seen customizations or plugins that add to WooCommerce features or a product’s price conflict with these reports. So, you’ll want to review installed plugins to see if any adjusted or discounted products/orders and reach out to that plugin’s developers to see if there are any conflicts with compatibility.

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    Another thing,

    It may be helpful to view a smaller range of dates or even a single day to compare with the orders under WooCommerce > Orders to help make sense of the data.

    Same issue here with our thriving ecommerce website. We have noticed the discrepancies between Reports and Analytics since Analytics was launched.

    We reached out for support at least a year ago when Analytics was launched and got vague excuses then, so we continued using the standard Reports.

    Now that we are getting warnings about Reports being deprecated and Analytics being the only option, we are digging back into this… and still seeing significant discrepancies between Reports and Analytics numbers.

    @johndcoy response about different reports having different totals doesn’t make sense when there are discrepancies comparing Gross Sales, Taxes, or Shipping totals. These are all values that should be identical, regardless of which reporting tool is used. Gross is Gross, Taxes are Taxes, and Shipping is Shipping… granted that there may be taxes on shipping, but then it should be possible to run numbers and see that overstated shipping would be balanced by understated taxes.

    The Analytics totals that we have analyzed for the past 12 months showed these differences… I couldn’t see any options to upload a readable spreadsheet or screenshot, so here’s a link: https://www.screencast.com/t/mjVx5uiBWJrW

    Here’s the data (sorry about the formatting):

    Report – Analytics Date Orders Gross / Total Sales Net Sales / Revenue Coupons Taxes Shipping
    Difference 2021 January 0 -$468.52 -$488.47 0 $0.00 $29.90
    Difference 2020 December 0 $0.00 $0.00 0 $0.00 $29.90
    Difference 2020 November 0 $0.00 -$45.08 0 $0.00 $59.85
    Difference 2020 October 0 $0.00 $1,090.84 0 -$224.43 $134.60
    Difference 2020 September 0 $0.00 -$1,267.49 0 $0.00 $104.60
    Difference 2020 August 0 $0.00 -$5.99 0 $0.00 $39.90
    Difference 2020 July 0 $0.00 -$80.65 $0.00 $0.00 $89.75
    Difference 2020 June 0 $0.00 -$159.61 $0.00 $0.00 $129.65
    Difference 2020 May 0 $0.00 -$79.80 $0.00 $0.00 $99.75
    Difference 2020 April 0 $0.00 -$29.90 $0.00 $0.00 $64.80
    Difference 2020 March 0 $0.00 -$29.90 $0.00 $0.00 $34.85
    Difference Total 12 Months 0 -$468.52 -$1,096.05 $0.00 -$224.43 $832.50`

    Hello, I have a problem with Products Report.
    https://docs.woocommerce.com/document/woocommerce-analytics/#products-report

    The results of my filtering is more than 25 products, but I see only 25 products and I haven’t pagination. Also if I click on Download button the result is always 25 products.
    There is a fix? Can you help me?

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Analytics reports inconsistent/incorrect data’ is closed to new replies.