Calculating Repurchase Rate

[Skotland]

Hi forum!

I'm reaching out because I've been working with this repurchase overview for a couple of weeks now and I can't seem to find a good way to solve this issue.

What I want to see is the repurchase rate of a product - per month. Short explained: how many customers that have purchased this product - makes a repurchase. Per month.

I have 4 columns - Customer ID / Transaction # / Order Date / Order Month

Does any of you have any experience with this type of calculation or can refer to any examples?

Thanks for all help!!

 

[steve the fish]

I cant see a column there that refers to product at all?

 

[Skotland]

I cant see a column there that refers to product at all?

Sorry for not being specific, but it's only for 1 product - and all transaction are this product.

 

[steve the fish]

Can you not use a pivot table?

 

[Skotland]

Can you not use a pivot table?

I've tried looking at this https://medium.com/@matsutton/repurchase-rate-the-most-overlooked-ecommerce-kpi-337bccde184b

But I'm not sure what the last formula is doing. It's looking at cell I3 which is not shown in the screenshot at the bottom.