We pay for Tinybird to get analytics in self hosted Ghost 6.0?

Ghost 6.0 is here and the most prominent new feature is the “native analytics”.

Only this native analytics is based on a third-party tool TinyBird.

All the announcements and documents so far have avoided any information on whether self-hosted Ghost users need to have a paid account of TinyBird or not.

I understand that TinyBird has a free tier but it also mentions “1000 queries per day” limit on the free tier.

I hope it’s not the same as the MailGun feature.

2 Likes

Tinybird has a free tier, and as a self hoster, you can also well…self host it:

They say it’s for testing and development, but other than the missing UI, I have not seen any difference. This is what’s running on Magic Pages at the moment.

Also, quick edit: @muratcorlu and I spoke about this a few days ago, and Murat pointed out that it’s just a Clickhouse database with a wrapper. So, pretty sure there are ways for the community to re-write that wrapper, if somebody has strong feelings about adding a third-party dependency, similar to how people wrote third-party proxies for Mailgun.

7 Likes

(Not related to the local container.)
While I was checking the limitations of their free plan, I noticed that:

  • 1,000 queries per day (Includes requests to API endpoints and SQL queries)

Does that mean a user with the free plan is only allowed to collect analytic records up to 1,000 page-views (or events) per day?


@jannis Any resources available for integrating the local container with Ghost 6.0?

1 Like

Thank you for your comment. I forgot to add this in the original post. There is limitation on the free tier and that is what prompted me to ask this question.

1 Like

Yes, indeed. In addition to that, it also counts to the query requests you make from your Ghost Admin. So let’s’ say you navigated in your Ghost Admin and made 50 requests to Tinybird API to show some analytics data, then your pageview limit for that day becomes 950.

3 Likes

I’m not sure if that’s all correct @truekasun @muratcorlu. According to somebody who says they work at Tinybird,

The 1000 API requests limit per day only applies to reads, not writes, so you’re pretty much just limited by how often you view your dashboard if you want to stay on the free plan.

3 Likes

Thanks for sharing this. Interestingly confusing. I couldn’t find my reference on their documentation but their announcement blog post even doesn’t use “query”, it just say “1000 requests per day”. And to write data, you also make a query request. A guide to Tinybird's new pricing model

But if that’s the case, then it’s quite good.

If someone can try on a website which has more than 1000 page views a day, please share the result.

1 Like

I found the reference that I relied on:

1k queries per day in total for all Workspaces in the Organization. Applies to API Endpoints and Query API calls.

Limits · Tinybird Docs.

Ghost TrafficAnalytics makes an api call to Events endpoint to write pageviews. If this documentation is correct, that would mean it will count from our daily limit.

PS: I asked same on Reddit, hopefully he/she can clarify this.

2 Likes

I initially thought all requests would count toward the 1,000 requests/day limit, but based on what I’m seeing in our setup, only requests made from the Admin dashboard (e.g. checking analytics charts) seem to count. For example, refreshing analytics page in Ghost can use up 15-30 requests.

We’re also running Clicky Analytics on the site, and there have been a few visitors today. However, the request count is still showing 0. Which suggests that visitor-side tracking and events don’t consume any requests from the quota.

5 Likes

There’s a nice writeup about how it works over here from the Tinybird folks:

2 Likes

One other thing I noticed is that even if we don’t refresh the page, switching to another tab and then back to the analytics page still sends three requests to Tinybird. This could be due to the real-time data fetching. I checked this in the Safari browser.

2 Likes