Weld
Start free
Notion model

Pages created

New database rows per day, data source and creator: how fast each tracker, CRM or request log in Notion is filling up.

See the SQLAll Notion models
Grain
creation date (UTC) x data source x creator
Built from
  1. 4
    Raw tables
  2. 4
    Staging
  3. 2
    Core
  4. 1
    Analytics
Reads from Notion
data_sourcepagepage_propertyuser
Ships as
Weld and dbt SQL, open source on GitHub
core.notion.pages_created
1-- core.notion.pages_created
2-- New database rows per day, data source and creator: how fast each tracker,
3-- CRM or request log in Notion is filling up.
4-- Grain: creation date (UTC) x data source x creator.
5--
6-- Archived and trashed pages are kept and counted separately, so a page created
7-- and later deleted still shows up on the day it was created.
8
9SELECT
10    DATE(created_at)                 AS created_date,
11    data_source_id,
12    data_source_title,
13    created_by_id,
14    created_by_name,
15    COUNT(*)                         AS pages_created,
16    COUNTIF(is_archived)             AS pages_since_archived
17FROM {{core.notion.database_pages}}
18GROUP BY 1, 2, 3, 4, 5

This model and the 6 it depends on. Deploy them together; refs like {{staging.…}} resolve to the matching folders in Weld, and the dbt view uses source() and ref().

Notes

How it counts. And where it stops.

Archived and trashed pages are kept and counted separately, so a page created and later deleted still shows up on the day it was created.

Raw tables it reads

  • raw.notion.data_source
  • raw.notion.page
  • raw.notion.page_property
  • raw.notion.user

More Notion models

Put Notion in front
of your agents.

Connect Notion, deploy the models, and ask questions in Claude, Cursor or ChatGPT. Free for 14 days, no credit card.

Start for freeTalk to us