{"id":16312,"date":"2022-09-14T19:51:30","date_gmt":"2022-09-14T23:51:30","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=16312"},"modified":"2023-06-16T11:34:23","modified_gmt":"2023-06-16T15:34:23","slug":"customer-list-export-report","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/customer-list-export-report\/","title":{"rendered":"Customer List Export Report"},"content":{"rendered":"\n<p>There are multiple reports you can run within Artisan to view customer information. One of these reports is the &#8220;Customer List Export Report.&#8221; This report can list customer ID, e-mail, first and last name, street, city, state, zip code, phone numbers, and date they became a customer. You can then export this information to your marketing program of choice, if necessary.<\/p>\n<hr \/>\n<h3>Accessing the Report<\/h3>\n<p>There are two ways you can access this report. From the top of the screen, click on \u201c<strong>Reports<\/strong>,\u201d \u201c<strong>Customer Reports<\/strong>,\u201d and \u201c<strong>Customer List Export Report<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h44_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16320 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h44_01.png\" alt=\"\" width=\"542\" height=\"368\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h44_01.png 542w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h44_01-300x204.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>Or, from the \u201c<strong>Main Menu<\/strong>,\u201d click on \u201c<strong>Reports<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16241 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10-1.png\" alt=\"\" width=\"677\" height=\"482\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10-1.png 677w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10-1-300x214.png 300w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/a><\/p>\n<p>Select \u201c<strong>Customer Reports<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-16321 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_16.png\" alt=\"\" width=\"704\" height=\"501\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_16.png 833w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_16-300x214.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_16-768x547.png 768w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>Click on \u201c<strong>Customer List Export Report<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_52.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-16322 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_52.png\" alt=\"\" width=\"733\" height=\"524\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_52.png 829w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_52-300x215.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h45_52-768x549.png 768w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/a><\/p>\n<p>Either way, you\u2019ll end up at the following screen.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_15h50_53.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16316 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_15h50_53.png\" alt=\"\" width=\"686\" height=\"462\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_15h50_53.png 781w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_15h50_53-300x202.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_15h50_53-768x517.png 768w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/a><\/p>\n<hr \/>\n<h3>Report Fields<\/h3>\n<p><strong>Only Customers w\/Complete Mailing Address? &#8211;\u00a0<\/strong>With this selected, only customers that have all mailing address fields filled out in their customer record will be included in the report.<\/p>\n<p><strong>Select &#8211;\u00a0<\/strong>This dropdown includes any customer types you have created (ex. retail or wholesale). Leave this set to all to display all customers across all customer types, or select one to only display the customers within that specific customer type.\u00a0<\/p>\n<p><strong>Whose &#8211; <\/strong>This dropdown further filters your customers by birthday or anniversary. For example, if you want to only show customers with birthdays coming up in the next month, select &#8220;Birthdays&#8221; in the first dropdown, then &#8220;Next Month&#8221; in the next dropdown.<\/p>\n<p>You can also filter this report by customers who bought a certain quantity of items, spent a certain amount, or returned items. You can further filter this by including only certain categories, vendors, item codes, and other details.<\/p>\n<hr \/>\n<h3>Report Example<\/h3>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h33_21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16318\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h33_21-1024x240.png\" alt=\"\" width=\"1024\" height=\"240\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h33_21-1024x240.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h33_21-300x70.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h33_21-768x180.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h33_21.png 1389w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><em>Click image to expand<\/em><\/p>\n<p>In this example, we chose to display all of our customers, regardless if they have a complete mailing address or not.\u00a0<\/p>\n<p>To export your report, click on the purple arrow (export button) at the top left corner of the screen. Or click on &#8220;Report&#8221; and &#8220;Export.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h47_53-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16327 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h47_53-1.png\" alt=\"\" width=\"395\" height=\"174\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h47_53-1.png 395w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h47_53-1-300x132.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/a><\/p>\n<p>\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h48_37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16325 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h48_37.png\" alt=\"\" width=\"216\" height=\"95\" \/><\/a><\/p>\n<p>From here, select the file type from the dropdown. For example, most email programs require the comma-delimited (CSV) file type.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h49_58.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16328 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-15_08h49_58.png\" alt=\"\" width=\"205\" height=\"261\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are multiple reports you can run within Artisan to view customer information. One of these reports is the &#8220;Customer List Export Report.&#8221; This report can list customer ID, e-mail, first and last name, street, city, state, zip code, phone numbers, and date they became a customer. You can then&#8230;<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[339],"ht-kb-tag":[],"class_list":["post-16312","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-customer-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=16312"}],"version-history":[{"count":7,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16312\/revisions"}],"predecessor-version":[{"id":19910,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16312\/revisions\/19910"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=16312"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=16312"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=16312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}