Study Case 01:
Cold Emailing Database

This is a template I used on one of my previous BI projects. 

It has been modified for confidentiality reasons, but the essence is the same: to keep track of a wide array of emails addresses used in cold-emailing campaigns and ensuring their integrity.

• Software used: Google Sheets (Microsoft Excel can work as an alternative).

• Techniques used: Formulas (VLOOKUP, COUNTIF, INDEX and MATCH), self-made cleaning scripts (to compile information and organize it more efficiently).