Weekly Campaign Checklist Emails

These emails are sent every week on Monday at 8am, Wednesday at 5pm, and Thursday at 5pm.

Their purpose is to ensure that key points of the campaigns are being done on every campaign in the system, as well as to highlight the work being done in the week for the various teams.

The way the values are calculated are:

Column	Description
Objectives	Looks at which of the following have been filled out: Key Objectives Campaign Objectives Campaign Target Market Key Performance Measures
POS and Mechanics	Looks at which of the following have been filled out: POS Mechanic Sampling Method Consumer Objectives Campaign Rules Additional Notes
Setup	Looks at which of the following have been filled out: Setup Image Setup Text
ROS Target	Looks at which of the following have been filled out: ROS Target Text ROS Target
SKU	Looks at which of the following have been filled out: Products Selected Questions Setup
Questionnaire	Looks at which of the following have been filled out: Questionnaire Created Questions Setup
Survey	Looks at which of the following have been filled out: Survey Created Questions Setup
Shifts	Total number of shifts over the time-period given for the email
Promoters Booked	How many shifts have promoters assigned to them
Promoters Still To Be Booked	The number of shifts that do not yet have promoters assigned to them
Venues GeoLocated	What % of the venues have GPS coordinates
Promoters Rates	'Yes' if every shift has a promoter rate set, if any single shift doesn't have a rate, this will be 'No'
Promoters with Pics	What % of the promoters associated with this campaign have pictures
Training Booked	Is any training scheduled? (Does not check that there are promoters invited to the training, just that it's scheduled)
Training Test Loaded	Looks at which of the following have been filled out: Test Created Questions Setup
Training Docs	Not pulled from the system, must be manually checked