A Friend — Distribution

Daily Compile — Pipeline

2 min read

Today

TABLE WITHOUT ID
  file.link AS "Entry",
  format AS "Fmt",
  owner AS "Owner",
  stage AS "Stage",
  hook AS "Hook"
FROM "Backlog"
WHERE date = date(today)
SORT time ASC

This Week

TABLE WITHOUT ID
  date AS "When",
  file.link AS "Entry",
  format AS "Fmt",
  owner AS "Owner",
  stage AS "Stage",
  hook AS "Hook"
FROM "Backlog"
WHERE date >= date(today) AND date < date(today) + dur(7 days)
SORT date ASC, time ASC

Next 14 Days

TABLE WITHOUT ID
  date AS "When",
  file.link AS "Entry",
  format AS "Fmt",
  stage AS "Stage"
FROM "Backlog"
WHERE date >= date(today) AND date < date(today) + dur(14 days)
SORT date ASC

By Stage (open work)

TABLE WITHOUT ID
  file.link AS "Entry",
  date AS "When",
  format AS "Fmt",
  owner AS "Owner"
FROM "Backlog"
WHERE stage != "published"
GROUP BY stage
SORT date ASC

By Format (cadence check vs §2 targets)

FormatTarget/wkActual this week
A1 B-Roll/UGC1$= dv.pages('"Backlog"').where(p => p.format === "A1" && p.date >= dv.date("today") && p.date < dv.date("today") + dv.duration("7 days")).length
A2 BF-Content1-2$= dv.pages('"Backlog"').where(p => p.format === "A2" && p.date >= dv.date("today") && p.date < dv.date("today") + dv.duration("7 days")).length
A3 Carousel1-2$= dv.pages('"Backlog"').where(p => p.format === "A3" && p.date >= dv.date("today") && p.date < dv.date("today") + dv.duration("7 days")).length
B1 Challenge1-2$= dv.pages('"Backlog"').where(p => p.format === "B1" && p.date >= dv.date("today") && p.date < dv.date("today") + dv.duration("7 days")).length
B2 Reaction1$= dv.pages('"Backlog"').where(p => p.format === "B2" && p.date >= dv.date("today") && p.date < dv.date("today") + dv.duration("7 days")).length
C1 Cross0-1$= dv.pages('"Backlog"').where(p => p.format === "C1" && p.date >= dv.date("today") && p.date < dv.date("today") + dv.duration("7 days")).length

Recently Published

TABLE WITHOUT ID
  file.link AS "Entry",
  published_at AS "Published",
  format AS "Fmt",
  post_url AS "URL"
FROM "Backlog"
WHERE stage = "published"
SORT published_at DESC
LIMIT 10

Graph View