{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Email Planning Template","Sheet1"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Email Planning Template","index":0,"n_rows":15,"n_cols":17,"rows_kept":15,"merged":[[0,3,0,5],[0,7,0,14],[0,15,0,16]]}
[{"$nulls":3},"Email Campaign Template- ",{"$nulls":3},"Email Results Tracking",{"$nulls":7},"A/B Test Planning & Results"]
[null,"Email Campaign","Owner","Content Owner","Subject Line","Send List","Suppression List","Total Emails Sent","Total Emails Delivered","Total Emails Opened","Total Clicks","Deliverability","Open Rate","Clickthrough Rate"," No Of Leads Generated","A/B Test Description","Summary of A/B Test Results"]
[null,"Ex: Lead Nurturing or Value Messaging ","Who on your organization is responsible for  this email campaign ?","Who is creating the content ","What subject line are you going to use to impress recipients to open your email?","Name of your email list, such as \"BNI \" \" YESCon  Event Attendees","Names of lists you want to exclude from your send. Ex: Current Prospective customer List ","How many email  did you send ?","Of the email addresses you sent your email to, how many actually landed in an inbox? (Total Sent- Undelivered )","Of the email addresses you sent your email to, how many were opened?","How many unique individuals clicked a link in your email?","Automatically calculates Total Emails Delivered / Total Emails Sent. Above 95% is ideal, but hard to achieve if your list(s) are purchased.","Automatically caclucates Total Emails Opened / Total Emails Delivered. An open rate of 20% means that for every 10 emails delivered, 2 were opened.","Automatically caclulates the percent of recipients who clicked through from your email (ex: to a landing page) out of total emails opened.","How many customeres replied or expressed intrest ","Describe any A/B test you're conducting with this email send.","What were the results? Which variation won?"]
[]
["Email Send Date","2020-07-27","Rajkumar","Vennila","How to close a Sale ?","YEScon list 2019, BNI list","TiE",{"v":2000,"d":"2,000"},{"v":1967,"d":"1,967"},120,55,{"$f":"I5/H5","v":{"v":0.9835,"d":"98.35%"}},{"$f":"J5/I5","v":{"v":0.061006609049313675,"d":"6.10%"}},{"$f":"K5/J5","v":{"v":0.4583333333333333,"d":"45.83%"}},7]
["Email Send Date",{"$nulls":10},{"$f":"I6/H6","v":{"$error":"#DIV/0!"}},{"$f":"J6/I6","v":{"$error":"#DIV/0!"}},{"$f":"K6/J6","v":{"$error":"#DIV/0!"}}]
["Email Send Date",{"$nulls":10},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Email Send Date",{"$nulls":10},{"$f":"I8/H8","v":{"$error":"#DIV/0!"}},{"$f":"J8/I8","v":{"$error":"#DIV/0!"}},{"$f":"K8/J8","v":{"$error":"#DIV/0!"}}]
["Email Send Date",{"$nulls":10},{"$f":"I9/H9","v":{"$error":"#DIV/0!"}},{"$f":"J9/I9","v":{"$error":"#DIV/0!"}},{"$f":"K9/J9","v":{"$error":"#DIV/0!"}}]
["Email Send Date",{"$nulls":10},{"$f":"I10/H10","v":{"$error":"#DIV/0!"}},{"$f":"J10/I10","v":{"$error":"#DIV/0!"}},{"$f":"K10/J10","v":{"$error":"#DIV/0!"}}]
["Email Send Date",{"$nulls":10},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Email Send Date",{"$nulls":10},{"$f":"I12/H12","v":{"$error":"#DIV/0!"}},{"$f":"J12/I12","v":{"$error":"#DIV/0!"}},{"$f":"K12/J12","v":{"$error":"#DIV/0!"}}]
["Email Send Date",{"$nulls":10},{"$f":"I13/H13","v":{"$error":"#DIV/0!"}},{"$f":"J13/I13","v":{"$error":"#DIV/0!"}},{"$f":"K13/J13","v":{"$error":"#DIV/0!"}}]
["Email Send Date",{"$nulls":10},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total",{"$nulls":6},{"$f":"SUM(H5:H14)","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(I5:I14)","v":{"v":1967,"d":"1,967"}},{"$f":"SUM(J5:J14)","v":120},{"$f":"SUM(K5:K14)","v":55},{"$f":"I15/H15","v":0.9835},{"$f":"J15/I15","v":0.061006609049313675},{"$f":"K15/J15","v":0.4583333333333333},{"$f":"SUM(O5:O14)","v":7}]

{"sheet":"Sheet1","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"hidden":true}
["STATUS"]
["Not Started"]
["In Progress"]
["Ready to Test"]
["Scheduled"]
["Sent"]