If the customer does not have a record of a purchase in your store, then clicking the ‘activate account’ option on the site link will not do anything. If you would like to give the customer the option to create an account, then you would simply put an additional ‘create a new account’ link below the site link in your HTML, to give the customer that option.