2b:null 2c:["$","title",null,{"children":"Bluesky Post Statisticator | ændra | Observable"}] 31:[] 2f:{"id":"88e1049956b01320","slug":"bluesky-post-statisticator","title":"Bluesky Post Statisticator","thumbnail":"98001e54203ac4e73590b3ceecd11799c7aab754bdb3d45c273769c261142874","access_level":"public","create_time":"$D2025-07-16T20:09:06.839Z","update_time":"$D2025-07-17T14:24:07.835Z","view_time":null,"first_public_time":"$D2025-07-17T11:13:56.340Z","fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"41a0ad302e6865ac","login":"aendra","name":"ændra","avatar_url":"https://avatars-next.observableusercontent.com/b5f17deae8366d50c449e79008e4365ce3c09546ff39dff72e6c4495c3806ba5","tier":"starter_2024"},"version":118,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"522665abee3378cc","login":"aendra","name":"ændra.","avatar_url":"https://avatars-next.observableusercontent.com/b5f17deae8366d50c449e79008e4365ce3c09546ff39dff72e6c4495c3806ba5","tier":null}],"members":[{"type":"team","id":"41a0ad302e6865ac","login":"aendra","name":"ændra","avatar_url":"https://avatars-next.observableusercontent.com/b5f17deae8366d50c449e79008e4365ce3c09546ff39dff72e6c4495c3806ba5","tier":"starter_2024","role":"editor"},{"type":"individual","id":"522665abee3378cc","login":"aendra","name":"ændra.","avatar_url":"https://avatars-next.observableusercontent.com/b5f17deae8366d50c449e79008e4365ce3c09546ff39dff72e6c4495c3806ba5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Bluesky Post Statisticator","cells":[{"id":0,"value":"# Bluesky Post Statisticator\n\nThis will generate a CSV spreadsheet of Bluesky post statistics (number of likes, reposts, quotes and replies) from a given timeframe. \n\nAll processing is done in-browser and no data is stored anywhere.\n\n**It takes `(total posts / 100) * 0.1 seconds` to pull all your posts after clicking \"Login\". If it appears nothing to be happening, please be patient and wait a few minutes!**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":16,"value":"viewof actor = Inputs.text({label: 'Handle', placeholder: 'aendra.com'});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":27,"value":"viewof password = Inputs.password({label: 'App password', submit: 'Login'});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5,"value":"viewof start = {\n const d = new Date();\n d.setMonth(d.getMonth() - 1);\n\n return Inputs.date({\n label: \"Start date\",\n value: d,\n max: new Date()\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":7,"value":"viewof end = {\n return Inputs.date({\n label: \"End date\",\n value: new Date(),\n min: start\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":74,"value":"{\n if (!posts) return html``;\n const data = posts.map(({post}) => ({date: post.indexedAt, text: post.record.text, likes: post.likeCount, reposts: post.repostCount, replies: post.replyCount, quotes: post.quoteCount, link: post.record.embed?.external?.uri })).sort((a, b) => b.date - a.date);\n const downloadData = new Blob([d3.csvFormat(data)], { type: \"text/csv\" });\n\n const filename = `${user.data.handle}_analytics_${start.toISOString().split('T').shift()}_to_${end.toISOString().split('T').shift()}.csv`;\n const size = (downloadData.size / 1024).toFixed(0);\n const button = DOM.download(\n downloadData,\n filename,\n `Download ${filename} (~${size.toLocaleString(\"en-US\")} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":82,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":11,"value":"api = import('https://esm.sh/@atproto/api');","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":55,"value":"agent = {\n if (!actor || !password) return;\n const agent = new api.AtpAgent({service: 'https://bsky.social'});\n await agent.login({identifier: actor, password});\n return agent;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":59,"value":"user = agent && actor && await agent.getProfile({actor});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":19,"value":"posts = {\n if (!user) return;\n const { did } = user.data;\n let cursor;\n let posts = [];\n let DELAY = 100;\n do {\n const { data } = await agent.getAuthorFeed({\n actor: did,\n cursor,\n limit: 100\n });\n console.log(data);\n cursor = data.cursor;\n posts = [...posts, ...data.feed];\n\n await new Promise((r) => setTimeout(r, DELAY));\n } while (cursor && new Date(posts[posts.length - 1].post.indexedAt) >= start);\n\n return posts.filter(\n (d) =>\n new Date(d.post.indexedAt) <= end &&\n new Date(d.post.indexedAt) >= start &&\n !d.reason\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 30:"$2f:body"