| Purple | No photo |
| Red | Column |
| Green | Featured |
| Blue | On site / Done |
| Orange | Standalone (no paywall) |
| Gray | Jacqueline's stories |
| Yellow | Slideshow |
| Metric | Source | Target (by Dec 2026) |
|---|---|---|
| Website sessions | Google Analytics 4 | 5,400–6,000/month |
| Newsletter subscribers | Mailchimp | 3,800 total |
| Newsletter open rate | Mailchimp | 40%+ |
| Top 5 articles by views | Google Analytics 4 | Informs content strategy |
| Digital ad revenue | Internal tracking | 3–5 clients |
| TikTok views/followers | TikTok analytics | Growth trend |
Source: Log into MetroCreative online. Save a Horoscope, Crossword, and Sudoku file. Unzip into NAS → Ads → Puzzle Page.
Horoscopes: Open horoscopes InDesign doc. Open horoscope file in TextEdit. Cmd+Shift+V then Cmd+V into InDesign text box. Place each sign in its spot. Adjust columns. Change date range (Sunday of paper week through following Saturday). Save in current week's puzzle page folder. Export PDF.
Sudoku: Open InDesign file from previous week. Grab the TIFF image from the unzipped sudoku file. Drag and drop into InDesign. Save and export in current puzzle page folder.
Crossword:
Puzzle Page Doc: Replace all previous week's PDFs with current week's (horoscope + sudoku). Save in puzzle page folder. Export PDF to where the paper's templates are saved.
If the puzzle page isn't used that week: move all files to the next week's puzzle page folder. Go back to MetroCreative and download a new horoscope file. Repeat as needed.
| Vendor | Purpose | Contact |
|---|---|---|
| MasterWeb | Printing press (weekly paper) | Mike & Antonina: miken@masterwebinc.ca Upload: insite.masterwebinc.ca |
| OJ Graphix | Commercial printing (general) | jay@ojgraphix.com joan@ojgraphix.com john@ojgraphix.com |
| DFS Group | Envelopes | printing@dfsbusiness.com |
| International Graphics | Commissioner stamps | Account #12988 |
| Lasalle Business Machines | Printer maintenance | office@lasallebm.ca 705-560-4252 |
| Dreamhost | Web hosting (VPS) | Servers: psmysql626197, vps29240 |
| MetroCreative | Puzzle content & word search | mcg.metrocreativeconnection.com |
| Google Ad Manager | Online ads on manitoulin.com | expositorsub@gmail.com |
| Mailchimp | Friday newsletter | Login: see credentials list |
| Shutterstock | Stock photos (newsletter) | — |
| Tool | Used For |
|---|---|
| Adobe InDesign | Newspaper layout, puzzle pages, ad design, templates |
| Adobe Lightroom Classic | Photo processing, auto tone, contact sheets, export |
| Adobe Photoshop | Web-worthy photo resizing (1200×800, 72ppi) |
| Adobe Acrobat | E-edition creation, PDF combining, linking, cropping |
| Adobe Illustrator | Crossword puzzle EPS files |
| TextEdit | Story text extraction, crossword clues, newsletter formatting |
| Microsoft Word | LJI article copies, newsletter content from Editorial |
| Chrome | Dreamhost, Google Ad Manager, Insite, Mailchimp, WordPress |
| WordPress | manitoulin.com and exploremanitoulin.com CMS |
| Mailchimp | Friday newsletter creation & distribution |
| Google Ad Manager | Website display advertising management |
| Google Analytics 4 | Website traffic & engagement tracking |
| Google Search Console | SEO performance monitoring |
| TikTok | Short-form video content |
| Finder / Dropbox | Photo retrieval (Expositor Dropbox) |
| NAS (Network Server) | Central file server: archives, templates, ads, PDFs |
| ChatGPT / AI Tools | Headline rewriting, article summaries, social captions, ad copy |
| Deadline | Task |
|---|---|
| Monday ~10am | All photos should be filed; editing should have started |
| Monday | PDFs uploaded to Insite (MasterWeb) |
| Before Wednesday | All jobs and notices uploaded to manitoulin.com |
| Wednesday 9am | E-Edition ready and uploaded to manitoulin.com |
| Wednesday morning | All stories uploaded for release |
| Thursday noon | Real estate proof reminders sent (if no response) |
| End of Thursday | PDF/JPEG ads should be started |
| Friday before noon | Newsletter sent via Mailchimp |
| End of every day | All computers shut down for server restart |
| 1st Monday of month | Monthly metrics report pulled and shared |
| Cmd+Option+P | Change document size |
| Cmd+Shift+U | Underline / Remove Underline |
| Cmd+X | Cut |
| Cmd+D | Import Photo |
| Cmd+Shift+V, then Cmd+V | Keep Text Formatting |
| Cmd+G | Group Items (drag over all first) |
| Right-click → Ungroup | Ungroup Photos |
| Cmd+F | Find item on document |
| Cmd+Shift+A | Pen tool with anchor points (then Shift+A each point) |
| W (nothing selected) | Preview mode |
| Spacebar (image selected in list) | Preview image |
Photos: Orange box = photo. Blue box = frame.
| Weekly ads list template | NAS → Expositor Templates → Monthly/Weekly ads list |
| Rolstons ad | NAS → Ads → Rolstons → 2024 (or sidebar) |