Sending the New Venues email to new venues
1. Filter the ‘_New venues and renewals marketing leads’ spreadsheet by the ‘new or renewals column’ to just show new venues.
2. Next, filter the ‘booked into new venues’ column to ‘N’.
3. This should give you the list of venues who are eligible to feature in new venues newsletter and eligible to purchase a ‘spot’ in it.
4. Go to the shared drive.
5. Go to Marketing ‘New Venues’ folder in email templates (Shared Drive>Marketing>Email Templates)
6. Open the template in this folder.
7. You will see this is a template email that has text pre-written and some attachments.
8. Go through the list on the filtered spreadsheet that don’t have any initials or a date in the ‘Contacted’ column (column F) and send the email (individually/one by one) to each of the email addresses on this list.
9. Log this in the CRM in their history.
10. Finally, pop your initials and the date into the ‘contacted’ column in the spreadsheet and save.
11. Un-filter the New Venues and Renewals spreadsheet and save.