>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #2479605. --> Reported by: [shnark](https://www.drupal.org/user/2293700) >>> <h2 id="summary-problem-motivation">Problem/Motivation</h2> <p>Follow-up to <span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-17"><a href="https://www.drupal.org/project/mentoring/issues/2232047" title="Status: Closed (outdated)">#2232047: [META] Get ready for DrupalCon</a></span></p> <p>We want to communicate with people who sign up to mentor. We invite people to join the monthly mentoring call, provide links to resources and remind them about mentor events at DrupalCon.</p> <h2 id="summary-proposed-resolution">Proposed resolution</h2> <p>We are using MailChimp for mentor communications. We have templates that we can reuse with minor changes. Another nice thing is that email campaigns can be scheduled ahead of time.</p> <h3>Download form submissions</h3> <ol> <li><a href="https://events.drupal.org">Log in</a> to event site and navigate to the mentor sign-up form (<em>Community</em> &gt; <em>Sign up to be a sprint mentor</em></li> <li>Click on Results</li> <li>Click on <strong>Included export components</strong> and uncheck <em>Include all components</em></li> <li>Check <em>First Name</em>, <em>Last Name</em>, <em>drupal.org username</em>, <em>Email</em></li> <li>In the <strong>Download range options</strong>: if this is the first time you are downloading, leave <em>All submissions</em> selected. Otherwise, you can check <em>Only new submissions since your last download</em></li> <li>Click Download and open the downloaded spreadsheet.</li> <li>Add a column with the label <strong>DrupalCon Mentor</strong> and type location and year, for example <em>Asia 2016</em>, move the cursor to bottom right of the cell so it turns into a plus sign and drag the cursor down to fill all cells in the column with <em>Asia 2016</em></li> </ol> <p>Example spreadsheet with mentor sign ups:</p> <h3>Import to MailChimp</h3> <ol> <li><a href="http://mailchimp.com/">Log in to MailChimp</a></li> <li>Click on the list name, then Add Subscribers, then Import Subscribers</li> <li>Select copy/paste from file </li> <li>Copy the contents of the spreadsheet and paste into the text area (together with column labels</li> <li>Check the "I understand that my billing plan may be automatically upgraded" box and click Next</li> <li>MailChimp should automatically match column names, click <strong>Save</strong> on each column, then click Next </li> <li>On the next screen, <strong>Subscribed</strong> should be checked. Also, check <strong>Auto-update my existing list</strong></li> <li>Click <strong>Import</strong> to add/update subscribers.</li> </ol> <h3>Create a campaign (mailing)</h3> <ol> <li>Click Campaigns, then Create Campaign</li> <li>Select <em>Regular Campaign</em></li> <li>Select <em>Send to a saved segment</em> and choose the appropriate DrupalCon segment (for example, <strong>Asia 2016</strong>)</li> <li>One the next screen, enter an internal name for your campaign (For example: "First contact with Asia 2016 mentors" or "Asia mentors thank you dinner")</li> <li>Write the subject of the email</li> <li>On the <em>Select a template</em> screen, click <strong>Saved Templates</strong> and choose one of the existing templates</li> <li>Replace text and photos as appropriate and click Next </li> <li>Click Send to send immediately, or Schedule to send the email at a later date</li> </ol> <h3>Replicate a campaign</h3> <p>When new mentors sign up, you might have to repeat some of the campaigns:</p> <ol> <li>From the list of campaigns, click on the far right button and select <em>Replicate</em></li> <li>Next, select <strong>Send to a group or new segment</strong></li> <li>Change <em>any</em> to <strong>all</strong> and add the following conditions: <ul> <li>Choose the DrupalCon Mentor grop (for example, <strong>Asia 2016</strong>)</li> <li><strong>Info changed</strong> is after <strong>the last campaign was sent</strong></li> </ul> </li> <li>Click the Refresh count link to update the number of recipients (we should not re-send to the whole list, or whole segment, just the people who signed up after the last campaign was sent)</li> <li>Click Next and follow the usual steps for a campaign</li> </ol> <h3>MailChimp templates</h3> <ol> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=38efaa7ef9">Sign up to mentor</a></strong>. This message is sent to mentors from the last 2-3 DrupalCons. </li> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=4fc12aa220">First contact with mentors</a></strong>. Introduce mentors to the Mentor spreadsheet.</li> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=b9014a63d4">Mentor Meta Meeting</a></strong>. Invite mentors to join the monthly mentoring meta meeting.</li> <li><strong>Get more mentors.</strong> Depending on how the signups are going, send to anyone on the mentor list who has not yet signed up.</li> <li><strong><a href="http://us9.campaign-archive1.com/?u=21d08743f8197c93f4eaf819e&amp;id=694e58ff99">Mentor resources</a></strong>. Links to "Mentoring at Drupal Events" and "Contributor Tasks". Send ? weeks before DrupalCon.</li> <li><strong><a href="http://us9.campaign-archive1.com/?u=21d08743f8197c93f4eaf819e&amp;id=dc4f7baf3b">Mentor events at DrupalCon</a></strong>. Orientation, sprint demo, issue triage.</li> <li><strong><a href="http://us9.campaign-archive1.com/?u=21d08743f8197c93f4eaf819e&amp;id=4acb88d747">Suggested sessions for mentors, sprint participants and contributors</a></strong>.</li> <li><strong><a href="http://us9.campaign-archive1.com/?u=21d08743f8197c93f4eaf819e&amp;id=b1664a5de6">First contact with mentors - condensed</a></strong> - send to mentors who have just signed up in the last few days before, or during DrupalCon</li> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=6584dab1c7">Reminders before DrupalCon</a></strong>. Dinner, T-shirt, Booth, Mentor events. Also sent after mentor orientation to any mentors who signed up on site.</li> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=3d5d4675a6">Final tips before Sprint day</a></strong>. Wear comfortable shoes, drink water, you will do great.</li> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=266b79b84b">Mentor Thank You Dinner</a></strong>. Sent in the early afternoon on Sprint Day, to thank the dinner sponsor and remind mentors about the location, time and directions.</li> <li><strong><a href="http://us9.campaign-archive2.com/?u=21d08743f8197c93f4eaf819e&amp;id=50da42bb1a">Mentor Survey</a></strong>. Requires setting up a survey in SurveyMonkey or an open Google doc for free-form comments. Can be prepared ahead of time and scheduled.</li> </ol> <h2 id="summary-remaining-tasks">Remaining tasks</h2> <ul> <li>??</li> </ul>