28:null 29:["$","title",null,{"children":"Maximum Sheep Dashboard | David Jurelius | Observable"}] 2e:T5bc,videos = { // Get the playlistId for the channel let youtubeUrl = `https://www.googleapis.com/youtube/v3/channels?part=contentDetails&id=UCO1cgjhGzsSYb1rsB4bFe4Q` let url = `${baseUrl}/youtube?query=${youtubeUrl}` url = url.replace(/query=(.+)$/, (match, group1) => `query=${encodeURIComponent(group1)}`) let response = await fetch(url, {credentials: 'include'}) let body = await response.json() yield body // Get the list of videos youtubeUrl = `https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&maxResults=50&playlistId=${body.items[0].contentDetails.relatedPlaylists.uploads}` url = `${baseUrl}/youtube?query=${youtubeUrl}` url = url.replace(/query=(.+)$/, (match, group1) => `query=${encodeURIComponent(group1)}`) response = await fetch(url, {credentials: 'include'}) body = await response.json() let videos = body.items yield videos // Follow the paginated results while (body.nextPageToken) { url = `${baseUrl}/youtube?query=${youtubeUrl}&pageToken=${body.nextPageToken}` url = url.replace(/query=(.+)$/, (match, group1) => `query=${encodeURIComponent(group1)}`) response = await fetch(url, {credentials: 'include'}) body = await response.json() if (Array.isArray(body.items)) { videos = videos.concat(body.items) // Sort and put latest first videos.sort((a, b) => (new Date(b.snippet.publishedAt) - new Date(a.snippet.publishedAt))) } yield videos } }2f:[] 2c:{"id":"609728a7db831273","slug":"maximum-sheep-dashboard","title":"Maximum Sheep Dashboard","thumbnail":"dfe0e0864c028c35b4c38fcac5d1084bbbcd285725c6326703466859a799b36a","access_level":"public","create_time":"$D2018-03-08T14:21:07.269Z","update_time":"$D2019-10-24T13:11:22.177Z","view_time":null,"first_public_time":"$D2018-03-19T13:42:21.250Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b35dacede5eb4428","login":"chhib","name":"David Jurelius","avatar_url":"https://avatars-next.observableusercontent.com/6c47f89102662d157fb2f771c0dfa3354afba43af5ad86b4d50dbf98a3245ecc","tier":"starter_2024"},"version":445,"publish_version":445,"role":null,"authored":false,"authors":[{"type":"individual","id":"6b3a69b04cd96a9d","login":"chhib","name":"David Jurelius","avatar_url":"https://avatars-next.observableusercontent.com/6c47f89102662d157fb2f771c0dfa3354afba43af5ad86b4d50dbf98a3245ecc","tier":null}],"members":[{"type":"individual","id":"6b3a69b04cd96a9d","login":"chhib","name":"David Jurelius","avatar_url":"https://avatars-next.observableusercontent.com/6c47f89102662d157fb2f771c0dfa3354afba43af5ad86b4d50dbf98a3245ecc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Maximum Sheep Dashboard","cells":[{"id":272,"value":"md`# Maximum Sheep Dashboard\n**Refresh cookie**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":0,"value":"md`## Patreon\nJust nu är det **${pledgesActive.length}** aktiva patrons!\n\n- Aktiva pledges före avgifter: **$${Math.round(activePledge)} / ${Math.round(activePledge*usd2sek)} kr** \n- Preliminära pledges efter avgifter: **$${Math.round(predictedPledge)} / ${Math.round(predictedPledge*usd2sek)} kr** \n - _Prediction +10%:_ $${Math.round(predictedPledge*1.1)} / ${Math.round(predictedPledge*usd2sek*1.1)} kr\n- Avgifter: **${Math.round((1-predictedPledge/activePledge)*100)}%, $${Math.round(activePledge-predictedPledge)} / ${Math.round((activePledge-predictedPledge)*usd2sek)} kr**\n - _Prediction +10%:_ ${Math.round((1-predictedPledge*1.1/activePledge)*100)}%, $${Math.round(activePledge-predictedPledge*1.1)} / ${Math.round((activePledge-predictedPledge*1.1)*usd2sek)} kr\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":400,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":296,"value":"md`## YouTube\nPå YouTube har det publicerats **${videos.length}** videor. Den senaste var **[${videos[0].snippet.title}](https://www.youtube.com/watch?v=${videos[0].snippet.resourceId.videoId})** som publicerades **${moment(videos[0].snippet.publishedAt).format('YYYY-MM-DD HH:mm')}**.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"table(videos.map(v => {return {\n title: v.snippet.title, \n publishedAt: moment(v.snippet.publishedAt).format('YYYY-MM-DD'),\n weekday: moment(v.snippet.publishedAt).format('dddd')\n}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"table(bitly.map(l => {return {\n title: `${l.title} (${l.keyword_link})`, \n createdAt: moment(l.createdAt).format('YYYY-MM-DD'),\n weekday: moment(l.createdAt).format('dddd'),\n clicks: l.clicks.total_clicks,\n}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"viewof baseUrl = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"predictedPledge = pledgesActive\n .map(pledge => ((pledge.attributes.amount_cents * (1-0.079) - 35) || 0))\n \t.reduce((amount, currentValue) => amount + currentValue) / 100\n\n\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"activePledge = pledgesActive\n .map(pledge => (pledge.attributes.amount_cents || 0))\n \t.reduce((amount, currentValue) => amount + currentValue) / 100","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"pledgesActive = pledges.filter(pledge => !(pledge.attributes.declined_since))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"pledges = {\n const patreonUrl = `https://www.patreon.com/api/oauth2/api/campaigns/1137737/pledges?type=pledge&sort=created&page%5Bcount%5D=100`\n let body = {links: {next: patreonUrl}}\n let pledges = []\n while (body.links && body.links.next) {\n let url = `${baseUrl}/patreon?query=${body.links.next}`\n url = url.replace(/query=(.+)$/, (match, group1) => `query=${encodeURIComponent(group1)}`)\n let response = await fetch(url, {credentials: 'include'})\n body = await response.json()\n if (Array.isArray(body.data)) {\n pledges = pledges.concat(body.data)\n }\n yield pledges\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"usd2sek = {\n const response = await fetch(`https://api.fixer.io/latest?base=USD`)\n const body = await response.json()\n return body.rates.SEK\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"moment = require('moment')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":382,"value":"videoData = {\n const video = videos[11]\n \n let params = {\n 'ids': `channel==${video.snippet.channelId}`,\n 'start-date': moment(video.snippet.publishedAt).format('YYYY-MM-DD'),\n 'end-date': moment(video.snippet.publishedAt).add(30, 'd').format('YYYY-MM-DD'),\n 'metrics': 'views,comments,likes,dislikes,estimatedMinutesWatched,averageViewDuration',\n 'filters': `video==${video.snippet.resourceId.videoId}`\n }\n // Get the playlistId for the channel\n let youtubeUrl = `https://www.googleapis.com/youtube/analytics/v1/reports?${Object.keys(params).map(key => key + '=' + params[key]).join('&')}`\n let url = `${baseUrl}/youtube?query=${youtubeUrl}`\n url = url.replace(/query=(.+)$/, (match, group1) => `query=${encodeURIComponent(group1)}`)\n console.log(url)\n let response = await fetch(url, {credentials: 'include'})\n let body = await response.json()\n yield body\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"bitly = { \n return fetch(urlFromPath('/v3/user/link_history'))\n .then(parseBody)\n .then(linksFromBody)\n .then(decorateWithClickData)\n \n function decorateWithClickData(linkDatas) {\n return Promise.all(\n linkDatas.map(linkData => \n clicks(linkData.link).then(clicksData => ({\n ...linkData,\n clicks: clicksData\n })) \n )\n )\n }\n \n function clicks(link) {\n return fetch(urlFromPath('/v3/user/clicks') + '&link=' + encodeURIComponent(link))\n .then(parseBody)\n .then(body => body.data)\n }\n function urlFromPath(path) { \n const token = '4b32aae28d5dc3eeca0e00202b9e916fce9565a1'\n return 'https://api-ssl.bitly.com' + path + '?access_token=' + token \n }\n function parseBody(response) { return response.json() }\n function linksFromBody(body) { return body.data.link_history }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"import { table } from \"@gampleman/table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"