I would like to pull data on how frequenctly the cusotmer visits the site or their last visit. Can anyone help me on logic or advise the best practice?
You may try using the default Visitor Retention reports from Reports & Analytics.These reports help to identify how often visitors return to your site.
Here is a document for more details: Visitor Retention
Hope this helps!