Guides

Living Workbook

Keep your Intelligence Workbook alive. Append new rows, refresh Power Query, and re-run the engine so every deliverable stays in sync with your latest data.

Open Dashboard Back to Engine
Weekly Workflow

Append + Refresh

  1. Export new LinkedIn data (Activity, Likers, Commenters).
  2. Append rows at the bottom of the Post Data sheet.
  3. Click the Refresh Power Query button on START HERE.
  4. Save, then re-run the Forensic Content Engine.
Living System ZIP

Portable Database

Every deliverables pack includes LinkedIn_Post_Exports.zip:

  • Original ZIP preserved when uploaded.
  • Placeholder ZIP included when not uploaded.
  • Add new exports, re-zip, and upload next time.
Integrity

Append-Only Rules

Never overwrite historical rows. The workbook compounds insights from every run.

Power Query

Manual Refresh

Use Data -> Refresh All after new data is appended.

Sync

OneDrive Tips

Let OneDrive finish syncing before refreshing to avoid partial updates.