{"id":22809,"date":"2023-09-30T13:25:37","date_gmt":"2023-09-30T13:25:37","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=22809"},"modified":"2026-03-09T07:51:12","modified_gmt":"2026-03-09T07:51:12","slug":"coupon-usage-report-in-woocommerce","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/coupon-usage-report-in-woocommerce\/","title":{"rendered":"How to Get a WooCommerce Coupon Usage Report (3 Practical Methods)"},"content":{"rendered":"\n<p>Coupons are one of the most effective marketing tools for increasing conversions in WooCommerce stores. Store owners frequently use discount codes, promotional coupons, and limited-time offers to attract new customers and encourage repeat purchases. However, simply creating coupons is not enough. To understand whether your promotions are working, you need to analyze how customers actually use those coupons.<\/p>\n\n\n\n<p>A WooCommerce coupon usage report helps store managers track the performance of each coupon code. By reviewing these reports, you can see how many times a coupon has been used, how much discount it generated, and which promotions are driving the most sales. These insights are essential for optimizing your marketing strategy and improving the effectiveness of your discount campaigns.<\/p>\n\n\n\n<p>WooCommerce provides a basic coupon analytics report inside the default WooCommerce Analytics dashboard. This report shows information such as coupon codes, number of orders, discount types, and usage statistics. While useful, the default WooCommerce coupon analytics report has several limitations when you need deeper insights or more flexible filtering.<\/p>\n\n\n\n<p>For example, store owners often need to analyze coupon code stats across specific date ranges, track coupon usage by customer, or export coupon reports for further analysis in Excel. These advanced reporting needs usually require either custom SQL queries or a specialized WooCommerce reporting plugin.<\/p>\n\n\n\n<p>In this guide, we will explore three practical ways to generate a WooCommerce coupon usage report. You will learn how to use WooCommerce Analytics, create reports directly from the database using SQL queries, and generate advanced coupon reports using a WooCommerce reporting plugin.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"3 practical methods to get WooCommerce coupon usage report?\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/PLJ7YsSgnwg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Method 1: Get WooCommerce coupon usage report without a plugin<\/h2>\n\n\n\n<p>When you install WooCommerce to build your online store, the <strong>Reports<\/strong> or <strong>Analytics<\/strong> tabs are displayed in the WordPress dashboard based on the WooCommerce version installed on your site.<\/p>\n\n\n\n<p>You can get a simple coupon usage report in these tabs by following the below instructions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Coupon usage report in WooCommerce report<\/h3>\n\n\n\n<p>If you are using the old version of WooCommerce, generating a coupon usage report is possible by going to the&nbsp; <strong>WooCommerce -&gt; Reports<\/strong> menu.&nbsp;<\/p>\n\n\n\n<p>Then, on the reports page, you can find the<strong> Coupon by date<\/strong> option under the <strong>Orders<\/strong> tab at the top of the table.&nbsp;<\/p>\n\n\n\n<p>This report shows the maximum discount and the number of coupons used on your site in a certain period. To select the period, click on one of the default options, such as year, last month, etc., or enter a desired date in the custom option.<\/p>\n\n\n\n<p>You can filter this chart based on a single coupon by getting help from the <strong>Filter by coupon option<\/strong> in the left panel.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-report-menu-and-choose-coupon-by-date-column.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1901\" height=\"871\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-report-menu-and-choose-coupon-by-date-column.png\" alt=\"select report menu and choose coupon by date tab in WooCommerce\" class=\"wp-image-22810\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-report-menu-and-choose-coupon-by-date-column.png 1901w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-report-menu-and-choose-coupon-by-date-column-500x229.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-report-menu-and-choose-coupon-by-date-column-1536x704.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-report-menu-and-choose-coupon-by-date-column-1000x458.png 1000w\" sizes=\"(max-width: 1901px) 100vw, 1901px\" \/><\/a><figcaption class=\"wp-element-caption\">Coupon report in WooCommerce<\/figcaption><\/figure>\n\n\n\n<p>In the left panel, you can also choose to see the <strong>Most Popular<\/strong> and <strong>Most Discounts<\/strong> reports.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">WooCommerce coupon statistics using WooCommerce Analytics<\/h3>\n\n\n\n<p>If you are using the new version of WooCommerce, the <strong>Coupons<\/strong> reports are in the list of <strong>Analytics<\/strong> menu as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-coupons-menu.png\"><img decoding=\"async\" width=\"160\" height=\"347\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-coupons-menu.png\" alt=\"select coupons menu in WooCommerce analytics report\" class=\"wp-image-22812\"\/><\/a><figcaption class=\"wp-element-caption\">Coupon statistics using Analytics<\/figcaption><\/figure>\n\n\n\n<p>On the coupons report page, first, you have access to the filter options, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Date Range<\/strong>: In this field, you can set the date range for receiving coupon reports.<\/li>\n\n\n\n<li><strong>Show<\/strong>: This field is the filter option that allows you to filter the reports based on the below options:<\/li>\n<\/ul>\n\n\n\n<p><strong>All coupons<\/strong>: By choosing this option, the data related to all coupons will be displayed to you.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-options-in-coupons-report-page.png\"><img decoding=\"async\" width=\"851\" height=\"245\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-options-in-coupons-report-page.png\" alt=\"filter options in coupons report page WooCommerce\" class=\"wp-image-22814\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-options-in-coupons-report-page.png 851w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-options-in-coupons-report-page-500x144.png 500w\" sizes=\"(max-width: 851px) 100vw, 851px\" \/><\/a><figcaption class=\"wp-element-caption\">All coupons report<\/figcaption><\/figure>\n\n\n\n<p><strong>Single coupon<\/strong>: With this option, you can only analyze the report for one special coupon.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/single-coupon-tab.png\"><img loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"174\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/single-coupon-tab.png\" alt=\"single coupon tab in WooCommerce report\" class=\"wp-image-22815\"\/><\/a><figcaption class=\"wp-element-caption\">Show single coupon report<\/figcaption><\/figure>\n\n\n\n<p><strong>Comparison<\/strong>: If you choose this option, you can select two or more coupons to compare their data in the report.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/comparison-option.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1693\" height=\"311\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/comparison-option.png\" alt=\"comparison option in WooCommerce coupon report\" class=\"wp-image-22818\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/comparison-option.png 1693w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/comparison-option-500x92.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/comparison-option-1536x282.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/comparison-option-1000x184.png 1000w\" sizes=\"(max-width: 1693px) 100vw, 1693px\" \/><\/a><figcaption class=\"wp-element-caption\">Compare between coupons<\/figcaption><\/figure>\n\n\n\n<p>For example, if you choose <strong>All coupons<\/strong> and set the date for <strong>Previous Year<\/strong>, the result is like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-customizing-coupons-page.png\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"610\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-customizing-coupons-page.png\" alt=\"result customizing coupons page in WooCommerce report\" class=\"wp-image-22819\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-customizing-coupons-page.png 650w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-customizing-coupons-page-500x469.png 500w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><figcaption class=\"wp-element-caption\">Last year coupons report<\/figcaption><\/figure>\n\n\n\n<p>In addition to the filtering option, you can export the data from the table as a CSV file.<\/p>\n\n\n\n<p>The WooCommerce coupon usage report table displayed under the chart also allows you to manage the data in the table. In this table, the following data is presented:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Coupon code<\/strong>: The specific code you assigned to each WooCommerce coupon.&nbsp;<\/li>\n\n\n\n<li><strong>Orders<\/strong>: The number of orders used the coupon.<\/li>\n\n\n\n<li><strong>Created<\/strong>: The date that the coupon is created.<\/li>\n\n\n\n<li><strong>Expires<\/strong>: The expiry date of the coupon.<\/li>\n\n\n\n<li><strong>Types<\/strong>: Coupon types.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/manage-data-table.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1685\" height=\"738\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/manage-data-table.png\" alt=\"result manage data table in coupon report WooCommerce \" class=\"wp-image-22820\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/manage-data-table.png 1685w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/manage-data-table-500x219.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/manage-data-table-1536x673.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/manage-data-table-1000x438.png 1000w\" sizes=\"(max-width: 1685px) 100vw, 1685px\" \/><\/a><figcaption class=\"wp-element-caption\">Coupon usage report table in WooCommerce<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Example 1: How to WooCommerce get coupon by code in WooCommerce analytics?<\/h4>\n\n\n\n<p>If a WooCommerce store needs a report on the usage of its coupon code, the following steps are required:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set the <strong>Date range.&nbsp;<\/strong><\/li>\n\n\n\n<li>Open the <strong>Show <\/strong>combobox and choose <strong>Single coupon.&nbsp;<\/strong><\/li>\n\n\n\n<li>Insert the <strong>Coupon code<\/strong> in the box and choose it from the list.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-coupon-code-for-single-coupon.png\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"396\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-coupon-code-for-single-coupon.png\" alt=\"set date range and select single coupon in WooCommerce Report\" class=\"wp-image-28328\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-coupon-code-for-single-coupon.png 960w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-coupon-code-for-single-coupon-500x206.png 500w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/a><figcaption class=\"wp-element-caption\">Show report of specific coupon in Analytics<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can get the WooCommerce coupon used in order report as illustrated below.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/result-single-coupon.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1429\" height=\"1205\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/result-single-coupon.png\" alt=\"result single coupon in WooCommerce Report\" class=\"wp-image-28329\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/result-single-coupon.png 1429w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/result-single-coupon-500x422.png 500w\" sizes=\"(max-width: 1429px) 100vw, 1429px\" \/><\/a><figcaption class=\"wp-element-caption\">Coupon usage report chart in WooCommerce Analytics<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Example 2: How to compare coupon usage statistics in WooCommerce analytics<\/h4>\n\n\n\n<p>The below instructions are useful when an online store needs a report on the usage of its coupon codes and compare their statistics:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set your desired <strong>Date Range.<\/strong><\/li>\n\n\n\n<li>Choose <strong>Comparison <\/strong>for the <strong>Show <\/strong>field.<\/li>\n\n\n\n<li>Insert the coupon codes in the search box of <strong>Compare Coupon Codes <\/strong>&#8211; At least two coupon codes must be inserted.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-compare-coupon-codes.png\"><img loading=\"lazy\" decoding=\"async\" width=\"916\" height=\"271\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-compare-coupon-codes.png\" alt=\"select compare coupon codes field in WooCommerce Report\" class=\"wp-image-28330\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-compare-coupon-codes.png 916w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-compare-coupon-codes-500x148.png 500w\" sizes=\"(max-width: 916px) 100vw, 916px\" \/><\/a><figcaption class=\"wp-element-caption\">Select comparison in coupon report<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the <strong>Compare <\/strong>button.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-compare-button.png\"><img loading=\"lazy\" decoding=\"async\" width=\"364\" height=\"213\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/select-compare-button.png\" alt=\"Choose Compare button in WooCommerce Report\" class=\"wp-image-28331\"\/><\/a><figcaption class=\"wp-element-caption\">Click on Compare button<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>As shown below, you can see the reports of coupon codes side by side and compare them easily in the chart<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/Compare-Coupon-Codes-result.png\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"612\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/Compare-Coupon-Codes-result.png\" alt=\"Compare Coupon Codes result in WooCommerce Report\" class=\"wp-image-28332\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/Compare-Coupon-Codes-result.png 650w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/Compare-Coupon-Codes-result-500x471.png 500w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><figcaption class=\"wp-element-caption\">Result of coupon comparison report<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It is also possible to compare information like the number of orders, order amount, created and expiry dates, and discount type in the below table.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/download-coupon-code-report.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1280\" height=\"234\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/download-coupon-code-report.png\" alt=\"download coupon code report in CSV format\" class=\"wp-image-28333\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/download-coupon-code-report.png 1280w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/download-coupon-code-report-500x91.png 500w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><figcaption class=\"wp-element-caption\">Download created report<\/figcaption><\/figure>\n\n\n\n<p>If you need to get the report in the CSV format, you can press the <strong>Download<\/strong> button on top of the table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Method 2: Generate WooCommerce coupon usage report by SQL<\/h2>\n\n\n\n<p>If you are a WordPress expert, you may know that by running SQL queries in the database management system, it is possible to generate a WooCommerce coupon usage report.<\/p>\n\n\n\n<p>To run a SQL query, you need to login to the PHPmyadmin and then select your WordPress database table and click on the SQL tab. Now, you can insert the entire SQL query code and click \u201cGo\u201dbutton.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/database-sql-tab.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1065\" height=\"641\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/database-sql-tab.jpg\" alt=\"Database SQL tab in phpMyAdmin\" class=\"wp-image-26999\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/database-sql-tab.jpg 1065w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/database-sql-tab-500x301.jpg 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/database-sql-tab-1000x602.jpg 1000w\" sizes=\"(max-width: 1065px) 100vw, 1065px\" \/><\/a><figcaption class=\"wp-element-caption\">Create report using SQL query<\/figcaption><\/figure>\n\n\n\n<p>For example, by running the below SQL query, you can get a report about all the coupons in your online store:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \nit_woocommerce_order_items.order_item_name AS 'order_item_name', \nit_woocommerce_order_items.order_item_name AS 'coupon_code', \nSUM(woocommerce_order_itemmeta.meta_value) AS 'total_amount', \nSUM(woocommerce_order_itemmeta.meta_value) AS 'coupon_amount' , \nCount(*) AS 'coupon_count' \nFROM \nwp_woocommerce_order_items as it_woocommerce_order_items \nLEFT JOIN wp_posts as it_posts ON it_posts.ID = it_woocommerce_order_items.order_id \nLEFT JOIN wp_woocommerce_order_itemmeta as woocommerce_order_itemmeta ON woocommerce_order_itemmeta.order_item_id=it_woocommerce_order_items.order_item_id \nWHERE \nit_posts.post_type = 'shop_order' AND \nit_woocommerce_order_items.order_item_type = 'coupon' AND \nwoocommerce_order_itemmeta.meta_key = 'discount_amount'&nbsp; \nGroup BY \nit_woocommerce_order_items.order_item_name ORDER BY total_amount DESC<\/code><\/pre>\n\n\n\n<p>If you run this query, a WooCommerce coupon usage report is generated, listing the data in the below columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Coupon code:<\/strong> Display the used coupon code.<\/li>\n\n\n\n<li><strong>Coupon amount:<\/strong>&nbsp; The total amount value of the coupon usage.<\/li>\n\n\n\n<li><strong>Coupon count: <\/strong>Show the coupon usage count.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-coupon-report-sql-code.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"167\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-coupon-report-sql-code.jpg\" alt=\"result coupon usage report by SQL code in database\" class=\"wp-image-22821\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-coupon-report-sql-code.jpg 632w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-coupon-report-sql-code-500x132.jpg 500w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/a><figcaption class=\"wp-element-caption\">Result of report using query<\/figcaption><\/figure>\n\n\n\n<p><strong>Recommendations:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Backup your website before running this SQL code to prevent any potential problem.<\/li>\n\n\n\n<li>If you don\u2019t have any experience in coding, ask an expert to do this task for you.<\/li>\n<\/ul>\n\n\n\n<p>As you may notice, the methods mentioned above are not very flexible, especially when you need detailed information about coupon usage in your store. The ultimate solution for this problem is using the WooCommerce report plugin. Continue reading to learn more about it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Method 3: Get coupon usage reports from the WooCommerce report plugin<\/h2>\n\n\n\n<p>The <span style=\"text-decoration: underline\"><a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=coupon-reports\" target=\"_blank\" rel=\"noreferrer noopener\">WooCommerce reports plugin<\/a><\/span> is an amazing tool by which you can receive various reports like sales reports, coupon reports, stock reports, etc. This plugin can be a better alternative to WooCommerce&#8217;s default reporting system by providing features such as filtering and searching.<\/p>\n\n\n\n<p>In this plugin, it is possible to receive various types of WooComerce coupon reports. Let&#8217;s see how to generate them and use the practical features of this unique plugin to customize them.<\/p>\n\n\n\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center main-cta-cnt has-background is-layout-flex wp-container-core-columns-is-layout-4a33225c wp-block-columns-is-layout-flex\" style=\"background-color:#3d67ff;padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-group is-layout-constrained wp-container-core-group-is-layout-4f39da6d wp-block-group-is-layout-constrained\" style=\"padding-top:15px\">\n<p class=\"single-cta-heading has-white-color has-text-color has-link-color wp-elements-0991dc6851cfc99e0f24c91f59e458e6\" style=\"font-size:26px;font-style:normal;font-weight:800\">REPORTiT &#8211; Advanced WooCommerce Reporting<\/p>\n\n\n\n<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-6f8451d1053f3822818c76682414f872\" style=\"font-size:16px\">The easy way to get WooCommerce coupon usage report<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button main-cta-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=coupon-reports\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#ffffff;background-color:#0fba5e;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener\">Buy Plugin<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link has-white-background-color has-text-color has-background wp-element-button\" href=\"https:\/\/wordpress.org\/plugins\/ithemelandco-woo-report\/\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#3d67ff;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"355\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png\" alt=\"REPORTiT - Advanced WooCommerce Reporting plugin by ithemeland\" class=\"wp-image-48725\" style=\"width:440px;height:auto\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png 532w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner-500x335.png 500w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p>In this plugin, it is possible to receive two types of coupon reports. Let&#8217;s see how to generate them and use the practical features of this unique plugin to customize them.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">WooCommerce coupon usage report<\/h3>\n\n\n\n<p>To create any report in the WooCommerce report plugin, you must open its main page by clicking on the <strong>iT Woo Report<\/strong> in the WordPress dashboard.<\/p>\n\n\n\n<p>Then, to access the <strong>Coupon<\/strong> report, find the <strong>More Reports<\/strong> tab in the plugin dashboard and choose <strong>Coupon<\/strong> from the list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-coupon-menu.png\"><img loading=\"lazy\" decoding=\"async\" width=\"262\" height=\"289\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-coupon-menu.png\" alt=\"select coupon menu in WooCommerce report dashboard\" class=\"wp-image-22823\"\/><\/a><figcaption class=\"wp-element-caption\">Open Coupon report in REPORTiT plugin<\/figcaption><\/figure>\n\n\n\n<p>The coupon report page has no data at first glance, so you need to follow the below instructions to get the WooCommerce coupon usage report:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the <strong>Search<\/strong> button to see the filter form.<\/li>\n\n\n\n<li>Use the built-in calendar to set the <strong>Date<\/strong> <strong>From <\/strong>and <strong>Date To<\/strong> fields.<\/li>\n\n\n\n<li>Set one of the below filters (optional):<\/li>\n<\/ul>\n\n\n\n<p><strong>Coupon Code<\/strong>: choose any coupon code to WooCommerce get coupon by code report.<\/p>\n\n\n\n<p><strong>Discount Type<\/strong>: choose one of the discount types from the list to filter the coupons report.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Press the <strong>Search<\/strong> button to instruct the plugin to generate the <strong>Coupon<\/strong> report in the specified date range.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-form-coupon-menu.png\"><img loading=\"lazy\" decoding=\"async\" width=\"389\" height=\"862\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-form-coupon-menu.png\" alt=\"filter form coupon usages in coupon report\" class=\"wp-image-22825\"\/><\/a><figcaption class=\"wp-element-caption\">Select report date range in Search form<\/figcaption><\/figure>\n\n\n\n<p>As you may notice in the below picture, the coupon report is a simple table containing the following columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Coupon Code<\/li>\n\n\n\n<li>Coupon Count<\/li>\n\n\n\n<li>Coupon Amount<\/li>\n<\/ul>\n\n\n\n<p>A total report at the bottom of the table allows you to review the <strong>Total coupon count<\/strong> and <strong>amount<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-coupon-count-and-coupon-amount.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1617\" height=\"529\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-coupon-count-and-coupon-amount.png\" alt=\"result of coupon reports in WooCommerce reports plugin\" class=\"wp-image-22826\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-coupon-count-and-coupon-amount.png 1617w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-coupon-count-and-coupon-amount-500x164.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-coupon-count-and-coupon-amount-1536x503.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-coupon-count-and-coupon-amount-1000x327.png 1000w\" sizes=\"(max-width: 1617px) 100vw, 1617px\" \/><\/a><figcaption class=\"wp-element-caption\">Result of created report<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">WooComerce coupon discount report<\/h3>\n\n\n\n<p>Another helpful report you can create in this plugin is the coupon discount report.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-coupon-discount-menu.png\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"300\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-coupon-discount-menu.png\" alt=\"select coupon discount menu in WooCommerce reports plugin dashboard\" class=\"wp-image-22827\"\/><\/a><figcaption class=\"wp-element-caption\">Open Coupon Discount report in REPORTiT plugin<\/figcaption><\/figure>\n\n\n\n<p>To generate the report, you need to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the <strong>Search<\/strong> icon.<\/li>\n\n\n\n<li>Set a date range in the <strong>Date From<\/strong> and <strong>Date To<\/strong> fields.<\/li>\n\n\n\n<li>Choose <strong>Coupon Codes<\/strong> and <strong>Discount type<\/strong> to filter the report if needed.&nbsp;<\/li>\n\n\n\n<li>Press the <strong>Search<\/strong> button.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-form-coupon-discount-menu.png\"><img loading=\"lazy\" decoding=\"async\" width=\"387\" height=\"860\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/filter-form-coupon-discount-menu.png\" alt=\"filter form coupon discount report in WooCommerce reports plugin\" class=\"wp-image-22828\"\/><\/a><figcaption class=\"wp-element-caption\">Filter coupon discount data by date range<\/figcaption><\/figure>\n\n\n\n<p>In this report, you can find the below information in separate columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Coupon Code<\/strong><\/li>\n\n\n\n<li><strong>Discount Type<\/strong><\/li>\n\n\n\n<li><strong>QTY<\/strong><\/li>\n\n\n\n<li><strong>Discount Amount<\/strong><\/li>\n<\/ul>\n\n\n\n<p>At the bottom of the table, the <strong>Total Product Quantity<\/strong> and <strong>Total Discount Amount<\/strong> are also reported.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-product-qty-and-discount-amount.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1629\" height=\"545\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-product-qty-and-discount-amount.png\" alt=\"result of coupon discount type reporting\" class=\"wp-image-22829\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-product-qty-and-discount-amount.png 1629w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-product-qty-and-discount-amount-500x167.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-product-qty-and-discount-amount-1536x514.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/result-total-report-in-product-qty-and-discount-amount-1000x335.png 1000w\" sizes=\"(max-width: 1629px) 100vw, 1629px\" \/><\/a><figcaption class=\"wp-element-caption\">Result of Coupon Discount report<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">WooCommerce coupon usage report for specific user<\/h3>\n\n\n\n<p>One of the most important WooCommerce coupon statistics is about the coupon usage of customers. Analyzing this report helps store managers to offer personal promotions to each customer based on the preferred discount type.<\/p>\n\n\n\n<p>To generate WooCommerce coupon report for specific user in this plugin, you need to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose <strong>All Orders<\/strong> report from <strong>Order<\/strong> menu (1).<\/li>\n\n\n\n<li>Open the <strong>Filter form<\/strong> and set a date range.<\/li>\n\n\n\n<li>Insert a coupon code in the related text box (2).<\/li>\n\n\n\n<li>Press the <strong>Search<\/strong> button.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/all-orders-filter-by-coupon.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1901\" height=\"819\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/all-orders-filter-by-coupon.png\" alt=\"all orders filter by coupon in WooCommerce report\" class=\"wp-image-27000\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/all-orders-filter-by-coupon.png 1901w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/all-orders-filter-by-coupon-500x215.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/all-orders-filter-by-coupon-1536x662.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/all-orders-filter-by-coupon-1000x431.png 1000w\" sizes=\"(max-width: 1901px) 100vw, 1901px\" \/><\/a><figcaption class=\"wp-element-caption\">Create coupon usage report in REPORTiT<\/figcaption><\/figure>\n\n\n\n<p>Now, you can see WooCommerce coupon statistics about all customers that placed orders by using that specific code.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/filter-coupon-usage-by-customer-name.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1056\" height=\"579\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/filter-coupon-usage-by-customer-name.png\" alt=\"filter coupon usage by customer name in all orders form\" class=\"wp-image-27001\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/filter-coupon-usage-by-customer-name.png 1056w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/filter-coupon-usage-by-customer-name-500x274.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/filter-coupon-usage-by-customer-name-1000x548.png 1000w\" sizes=\"(max-width: 1056px) 100vw, 1056px\" \/><\/a><figcaption class=\"wp-element-caption\">Result of coupon usage by customers in All Orders report<\/figcaption><\/figure>\n\n\n\n<p>It is also possible to get WooCommerce coupon for specific user by inserting the customer\u2019s names in the <strong>Search<\/strong> box located above the report table. (3)<\/p>\n\n\n\n<p>For example, if you want to see which coupons has been used by <strong>User 1<\/strong> in your online shop, you can simply write <strong>User 1<\/strong> in the <strong>Search<\/strong> box. So, the plugin will filter the <strong>Orders<\/strong> received by <strong>User 1<\/strong> in the table. Now, you can review the coupon codes used by this user in the coupon code column of the table.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/user-searching.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1650\" height=\"504\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/user-searching.png\" alt=\"user searching in All orders form\" class=\"wp-image-27002\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/user-searching.png 1650w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/user-searching-500x153.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/user-searching-1536x469.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/user-searching-1000x305.png 1000w\" sizes=\"(max-width: 1650px) 100vw, 1650px\" \/><\/a><figcaption class=\"wp-element-caption\">Show coupon usage report for specific user<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Extra features of WooCommerce report plugin<\/h3>\n\n\n\n<p>In addition to generating different reports, the WooCommerce report plugin provides extra features to help store managers better control their reports.&nbsp;<\/p>\n\n\n\n<p>Here, you can get familiar with some of them:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/extra-features-report-plugin-1024x73.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1611\" height=\"73\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/extra-features-report-plugin.png\" alt=\"extra features coupon report in WooCommerce report plugin\" class=\"wp-image-22831\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/extra-features-report-plugin.png 1611w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/extra-features-report-plugin-500x23.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/extra-features-report-plugin-1536x70.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/extra-features-report-plugin-1000x45.png 1000w\" sizes=\"(max-width: 1611px) 100vw, 1611px\" \/><\/a><figcaption class=\"wp-element-caption\">Customize report columns<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Select columns of coupon usage report<\/strong><\/h4>\n\n\n\n<p>The select columns option allows you to customize the columns of your report. You can mark\/unmark any columns you want to observe its data on the report in the dropdown list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-columns-options-field.png\"><img loading=\"lazy\" decoding=\"async\" width=\"332\" height=\"143\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-columns-options-field.png\" alt=\"select columns options field in coupon report\" class=\"wp-image-22833\"\/><\/a><figcaption class=\"wp-element-caption\">Select coulmns to show<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><strong>Download WooCommerce coupon usage report to CSV, PDF or Excel<\/strong><\/strong><\/h4>\n\n\n\n<p>This field is useful when exporting or printing your report. By pressing the <strong>Download<\/strong> icon, exporting the WooCommerce coupon usage report is possible in CSV, Excel, and PDF formats. You can also print the report directly by clicking on the <strong>Print<\/strong> options from the list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-download-icon-options-field.png\"><img loading=\"lazy\" decoding=\"async\" width=\"208\" height=\"218\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/select-download-icon-options-field.png\" alt=\"select download icon and export coupon usage report in WooCommerce report plugin\" class=\"wp-image-22834\"\/><\/a><figcaption class=\"wp-element-caption\">Export created report in differnet format<\/figcaption><\/figure>\n\n\n\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center main-cta-cnt has-background is-layout-flex wp-container-core-columns-is-layout-4a33225c wp-block-columns-is-layout-flex\" style=\"background-color:#3d67ff;padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-group is-layout-constrained wp-container-core-group-is-layout-4f39da6d wp-block-group-is-layout-constrained\" style=\"padding-top:15px\">\n<p class=\"single-cta-heading has-white-color has-text-color has-link-color wp-elements-0991dc6851cfc99e0f24c91f59e458e6\" style=\"font-size:26px;font-style:normal;font-weight:800\">REPORTiT &#8211; Advanced WooCommerce Reporting<\/p>\n\n\n\n<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-6f8451d1053f3822818c76682414f872\" style=\"font-size:16px\">The easy way to get WooCommerce coupon usage report<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button main-cta-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=coupon-reports\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#ffffff;background-color:#0fba5e;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener\">Buy Plugin<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline is-style-outline--2\"><a class=\"wp-block-button__link has-white-background-color has-text-color has-background wp-element-button\" href=\"https:\/\/wordpress.org\/plugins\/ithemelandco-woo-report\/\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#3d67ff;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"355\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png\" alt=\"REPORTiT - Advanced WooCommerce Reporting plugin by ithemeland\" class=\"wp-image-48725\" style=\"width:440px;height:auto\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png 532w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner-500x335.png 500w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Why analyzing the WooCommerce coupon usage report is important?<\/h2>\n\n\n\n<p>One important way to increase WooCommerce sales is to use discount codes and coupons. IIf you regularly offer coupons, you need to know how many customers use them. You can get deep insights into the coupon usage in your online store by analyzing WooCommerce coupon report data, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify which coupons are most popular among your customers.<\/li>\n\n\n\n<li>Find out if customers are aware of your coupons depending on how you advertise them.<\/li>\n\n\n\n<li>Check which promotional methods have the most conversions for your coupons.<\/li>\n\n\n\n<li>Identify the coupons that make the most impact on the customers to buy from the store.<\/li>\n\n\n\n<li>Improve marketing strategies that retain loyal customers.<\/li>\n\n\n\n<li>Evaluate the effect of promotional plans on attracting new customers.<\/li>\n<\/ul>\n\n\n\n<p>The goal of any coupon is to increase sales of your online store. That&#8217;s why analysis of WooCommerce coupon usage reports is very valuable for store managers and can help them identify if the offering coupons are working.&nbsp;&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Coupons play a critical role in the growth of many WooCommerce stores. They help attract new customers, increase conversions, and encourage repeat purchases. However, without analyzing coupon performance, it is difficult to know whether your promotional strategies are truly effective.<\/p>\n\n\n\n<p>A WooCommerce coupon usage report provides valuable insights into how discount codes are performing. By reviewing coupon statistics such as total usage, discount amount, and order counts, store managers can identify the most successful promotions and improve their marketing strategies.<\/p>\n\n\n\n<p>Although WooCommerce includes a basic coupon analytics report, many stores require more advanced reporting capabilities. In these situations, using SQL queries or a specialized WooCommerce reporting plugin like REPORTiT can provide deeper insights and more flexible reporting options.<\/p>\n\n\n\n<p>By regularly analyzing coupon usage reports, store owners can better understand customer behavior, optimize their discount campaigns, and increase overall sales performance in their WooCommerce store.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column blog-faq-section is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">FAQ<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">What is a WooCommerce coupon usage report?<\/h4>\n\n\n\n<p>A WooCommerce coupon usage report is a report that shows how customers use coupon codes in an online store. It usually includes information such as coupon codes, number of times each coupon was used, total discount amounts, and related orders. Store managers use this report to evaluate the effectiveness of their promotional campaigns.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">How can I check coupon usage in WooCommerce?<\/h4>\n\n\n\n<p>You can check coupon usage in WooCommerce through the Analytics section of the WooCommerce dashboard. The coupons report shows the number of orders that used each coupon code and other related statistics within a selected date range.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Can I export WooCommerce coupon reports?<\/h4>\n\n\n\n<p>Yes, WooCommerce allows exporting coupon analytics data as CSV files. In addition, advanced reporting plugins may allow exporting coupon usage reports to Excel, PDF, or other formats for deeper analysis.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Why should store owners analyze coupon usage statistics?<\/h4>\n\n\n\n<p>Analyzing coupon usage statistics helps store owners understand which promotions attract customers and which discount campaigns generate the most sales. This data allows businesses to optimize their marketing strategies and design more effective promotional offers.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Is there a plugin for advanced WooCommerce coupon reports?<\/h4>\n\n\n\n<p>Yes, REPORTiT &#8211; WooCommerce reporting plugin provides advanced coupon analytics and reporting features. This plugin allows store managers to filter coupon data, generate detailed reports, and analyze coupon performance more accurately than the default WooCommerce analytics.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Coupons are one of the most effective marketing tools for increasing conversions in WooCommerce stores. Store owners frequently use discount codes, promotional coupons, and limited-time offers to attract new customers and encourage repeat purchases. However, simply creating coupons is not enough. To understand whether your promotions are working, you need to analyze how customers actually [&hellip;]<\/p>\n","protected":false},"author":1990,"featured_media":22836,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50,73],"tags":[],"class_list":["post-22809","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","category-woocommerce"],"featured_image_url":"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/09\/get-coupon-usage-reports-500x335.jpg","excerpt_plain":"Coupons are one of the most effective marketing tools for increasing conversions in WooCommerce stores. Store owners frequently use discount codes, promotional coupons, and limited-time offers to attract new customers and encourage repeat purchases. However, simply creating coupons is not enough. To understand whether your promotions are working, you need to analyze how customers actually [&hellip;]","_embedded":{"wp:term":[[{"term_id":50,"name":"Tutorials","slug":"tutorials","term_group":0,"term_taxonomy_id":50,"taxonomy":"category","description":"Follow and learn the latest educational articles about WordPress plugins and WooCommerce here","parent":0,"count":256,"filter":"raw"},{"term_id":73,"name":"WooCommerce","slug":"woocommerce","term_group":0,"term_taxonomy_id":73,"taxonomy":"category","description":"Do you use WooCommerce to manage your online store? We suggest you read this category of WooCommerce articles.","parent":50,"count":205,"filter":"raw"}]]},"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/22809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/users\/1990"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/comments?post=22809"}],"version-history":[{"count":3,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/22809\/revisions"}],"predecessor-version":[{"id":50920,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/22809\/revisions\/50920"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media\/22836"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media?parent=22809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/categories?post=22809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/tags?post=22809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}