Report an issue
Back to plugin list
plausible
Official
Premium

Plausible Analytics

The CloudQuery Plausible plugin extracts information from your Plausible Analytics Stats API and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v3.2.6

Type

Source

Platforms
Date Published

Mar 26, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Set up process


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync plausible.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview

The CloudQuery Plausible plugin extracts information from your Plausible Analytics Stats API and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).

Authentication

You must have a Plausible Analytics account and an API key. You can find your API key in the Plausible Analytics Settings.

Example Configuration

kind: source
spec:
  name: plausible
  path: cloudquery/plausible
  registry: cloudquery
  version: "v3.2.6"
  tables: ["*"]
  destinations: ["postgresql"]
  spec:
    site_id: "YOUR_SITE_ID"
    api_key: "${API_KEY}"

Configuration Reference

This is the (nested) spec used by this plugin:
  • site_id (string) (required)
    This is the value of your domain where plausible is deployed. If you're unsure, navigate to your site settings in Plausible and grab the value of the domain field.
  • api_key (string) (required)
    This is your secret API key which you can obtain for your account by going to your user settings page plausible.io/settings.
  • period (string) (optional) (default: 30d)
    Time period to fetch data.
  • filters (string) (optional) (default: empty)
    Filter results, see Plausible Analytics Filters.
  • metrics ([]string) (optional) (default: ["visitors", "pageviews", "bounce_rate", "visit_duration", "visits"])
    Metrics to sync. By default, the plugin will sync all metrics.
  • interval (string) (optional) (default: date)
    Reporting interval. Valid options are date (always) and month (when specified period is longer than one calendar month).
  • base_url (string) (optional) (default: https://plausible.io)
    Base URL for the Plausible API. If you are using self-hosted version this should be changed to the domain where plausible is hosted.
  • concurrency (integer) (optional) (default: 10000)
    Number of resources to sync in parallel.

Example Queries

Sum all visitors since date

select sum(visitors) from plausible_stats_timeseries where date >= '2021-01-01';

Select all dates where bounce rate was above 50%

select date, bounce_rate from plausible_stats_timeseries where bounce_rate > 50;


Subscribe to product updates

Be the first to know about new features.