Report an issue
Back to plugin list
simple-analytics

Simple Analytics

A Simple Analytics source plugin for CloudQuery that loads raw page view and event data from Simple Analytics to any database, data warehouse or data lake supported by CloudQuery, such as PostgreSQL, BigQuery, Athena, and many more.

Publisher

simple-analytics

Repositorygithub.com
Latest version

v2.0.0

Type

Source

Platforms
Date Published

Nov 15, 2023

Price

Free

  • simple_analytics_events
  • simple_analytics_page_views

Simple Analytics Events

The simple_analytics_events table shows data for Simple Analytics Events.

https://docs.simpleanalytics.com/api/export-data-points

The primary key for this table is _cq_id.

Columns
NameType
added_isotimestamp[us, tz=UTC]
added_unixint64
browser_nameutf8
browser_versionutf8
country_codeutf8
_cq_iduuid
_cq_parent_iduuid
datapointutf8
device_typeutf8
document_referrerutf8
hostnameutf8
hostname_originalutf8
is_robotbool
lang_languageutf8
lang_regionutf8
metadatajson
os_nameutf8
os_versionutf8
pathutf8
path_and_queryutf8
queryutf8
screen_heightint64
screen_widthint64
session_idutf8
user_agentutf8
utm_campaignutf8
utm_contentutf8
utm_mediumutf8
utm_sourceutf8
utm_termutf8
uuidutf8
viewport_heightint64
viewport_widthint64
Subscribe to product updates

Be the first to know about new features.