thread Re: How can I find out who my best customers are? in Archived Discussions (Read Only)

How can I find out who my best customers are?

312jenlyn — Wed, 03 Aug 2016 03:48:52 GMT

I would like to have a report of who my best customers are like who spends the most with my business.

Re: How can I find out who my best customers are?

Tom — Sat, 06 Aug 2016 01:50:29 GMT

Hey @312jenlyn, great question!

If you're using Customer Engagement, I'd recommend having a look at your "Regulars Group" which includes customers that visited your business three times in the last six months. You can also adjust the settings of this group by clicking Actions > Edit Group in your directory. Learn more about this in our Support Center.

Hope this helps and, of course, please don't hesitate to reply with any other questions!

Re: How can I find out who my best customers are?

square_marc — Wed, 30 May 2018 00:26:35 GMT

@Tom I am also wondering about this. For example, how can I find a list of customers sorted by sales? Or number of visits? Or average transaction size? The only way I found was to export customers into Excel. Am I missing something?

Re: How can I find out who my best customers are?

Chad — Thu, 31 May 2018 18:28:35 GMT

Hello @square_marc, currently we do not have the ability to sort by sales, visits, or transaction size.

It sounds like you've already found the one work around I was going to suggest.

If you still have questions, feel free to reach out to me! 😀

Re: How can I find out who my best customers are?

ggfgourmet — Mon, 10 Dec 2018 14:55:22 GMT

Last year, Square sent me an e-mail about this. I remember clicking on the link and I was able to see my customers in ranking order by sales. Was that maybe a feature that existed last year but has since been deleted? It was not a paid service or trial.

Re: How can I find out who my best customers are?

Tom — Tue, 11 Dec 2018 23:03:04 GMT

Thanks for surfacing this, @ggfgourmet. I went to check on this and I wasn't able to find more information on the email campaign that you mentioned. Is there any chance you still have it saved in your archives? If you have any other details on the subject line, content, or URL that it linked out to, I'll be happy to have another look!

Re: How can I find out who my best customers are?

ggfgourmet — Wed, 12 Dec 2018 03:21:49 GMT

Yes, I found it! I tried the links, but they get a 404 now. 😞 The e-mail came from Square Reports with a subject line of “Your year at a glance”

I was hoping to access this info to gift my top customers this year. The e-mail came on 1/3/18.

It gave me total sales, number of customers served, average trans, best day of the week, customer stats (link: https://squareup.com/subscriptions/r?ee=4b22d6cbeddec3f132c7883a020c50072e6808a47c9497f2295a1d10--ZD1vTnlyNXZaM1lFb0lsY2t0JmU9JTIzc2VlLW15LWN1c3RvbWVyLWxpc3QtMSZtJTVCbWVyY2hhbnQtdG9rZW4lNUQ9MU1OQVZQTUVNWVg5SCZtJTVCc2VuZC1kYXRlJTVEPTIwMTcwMTAxJm49ZW1haWxjbGljayZyPWh0dHBzJTNBJTJGJTJGc3F1YXJldXAuY29tJTJGbG9naW4lM0ZlbmMlM0RleUpsYm1NaU9pSkJNVEk0UjBOTklpd2lkR0ZuSWpvaVZtdHNSekJITVdKQlQwbFFVRUp3Y21GWlJtcE5VU0lzSW1Gc1p5STZJa0V4TWpoSFEwMUxWeUlzSW1sMklqb2lPR2xsVkhSU2NFUjJUR0ZST0hOR2FpSjkuY0hmYVQ5c1VDSjBEeko4MTRTMlpjUS5LS0N3ZDEtSmNLSTZ3OEx1LlFwYllGUDRDU0JISDNQX2ZqZGNMSXMwSThsdFZaMGNTMlZLQUNzNEJyQ01HLktLejJiMXZySkZvSms2eE5HclRRaUElMjZyZXR1cm5fdG8lM0QlMjUyRmRhc2hib2FyZCUyNTJGY3VzdG9tZXJzJTI1MkZsaXN0) and top customer info.

Re: How can I find out who my best customers are?

ggfgourmet — Wed, 12 Dec 2018 21:43:00 GMT

[personal information redacted]

Screen shots of the e-mail.

Re: How can I find out who my best customers are?

Tom — Wed, 12 Dec 2018 21:47:14 GMT

Got it. Thanks for helping with this information, @ggfgourmet. Very helpful. I don't have specifics on hand for if this campaign will go out again next year, but I'll surface this internally and circle back with any other information that I can find.

Re: How can I find out who my best customers are?

tewsfamily — Wed, 02 Jan 2019 03:00:54 GMT

I just got my summary email for 2018, and it lists the stats for my best customer, but when I click on "meet your best customer" it takes my to a page that no longer exists. Is there a way for be to get this information without subscribing to more services?

Re: How can I find out who my best customers are?

VanKalkerFarms — Wed, 02 Jan 2019 13:57:49 GMT

@tewsfamily, I was just looking at that too and mine also didn't work.

@katieand any idea why the links aren't working?

The pics below are from our mobile farmer's market location and clicking the link in the pic below brings up the following error message.

Re: How can I find out who my best customers are?

katieand — Thu, 03 Jan 2019 18:03:49 GMT

Hi @tewsfamily & @VanKalkerFarms - This link is broken right now 😞 I'm looking in to this and will share any updates as soon as I learn more. Thanks for catching this!

Re: How can I find out who my best customers are?

katieand — Thu, 03 Jan 2019 21:48:48 GMT

@tewsfamily - I just got confirmation that this should be fixed now! Let me know if you continue seeing anything funky. Apologies again about that

Re: How can I find out who my best customers are?

ggfgourmet — Fri, 04 Jan 2019 02:00:20 GMT

@katieand Unfortunately, my link is still broken. It makes me log into my Square account, then I receive the message "Page not found. We couldn't find that page."

Any more ideas? The e-mail must have generated from some sort of database of information, but it's not linking it.

Thank you,

Jen @ggfgourmet

Re: How can I find out who my best customers are?

ggfgourmet — Fri, 04 Jan 2019 02:19:42 GMT

@Tom just wondering if you found out anything about this? I don't know if you and @katieand work together but it would be so helpful to access this information (received via e-mail for year ending 2018 but the link for top customer doesn't work; I haven't checked the rest of the links).

Thank you,

Jen of @ggfgourmet

Re: How can I find out who my best customers are?

VanKalkerFarms — Fri, 04 Jan 2019 03:41:37 GMT

@katieand link still gives same error message I posted before.

Re: How can I find out who my best customers are?

Vj1210 — Fri, 04 Jan 2019 13:57:45 GMT

I'm getting the same error messages when I click on the link for this. Just wanted to follow this thread, hopefully it's fixed at some point!

Re: How can I find out who my best customers are?

Tom — Fri, 04 Jan 2019 18:29:37 GMT

Hey @Vj1210, @VanKalkerFarms, and @ggfgourmet—I'm really sorry for the disruption this is causing. I went to check on the status of this issue and there are a few more remaining tangles that need to be sorted out. Some sellers might encounter the error message until our Engineering Team is able to finalize the fix.

I'm keeping an eye on this internally and it looks like they're closing in. We'll update this thread as soon as everything is fully resolved.

Re: How can I find out who my best customers are?

Tom — Fri, 04 Jan 2019 19:52:24 GMT

Update: our Engineering Team was able to fully resolve the broken link issue. 🎉

You should be redirected to the correct page where you can view your top customer insights. Please don't hesitate to let us know if any questions remain, and thank you for your patience. 😅

Re: How can I find out who my best customers are?

Ramat — Wed, 25 Mar 2020 18:04:07 GMT

Are there any plans to add a report option to look at customers by total sales and # of visits?

This would be a very important report for my business. Other's too I'm guessing by the other comments over the past several years on this post.

Not having this leaves a big gap in our ability to effectively market.