Learn how to interact with this dataset using the Ouro SDK or REST API.
API access requires an API key. Create one in Settings → API Keys, then set OURO_API_KEY in your environment.
Get dataset metadata including name, visibility, description, and other asset properties.
Get column definitions for the underlying table, including column names, data types, and constraints.
| Column | Type |
|---|---|
| date | timestamp with time zone |
| metric | text |
| value | integer |
Fetch the dataset's rows. Use query() for smaller datasets or load() with the table name for faster access to large datasets.
Update dataset metadata (visibility, description, etc.) and optionally write new rows to the table. Writing new data will replace the existing data in the table. Requires write or admin permission on the dataset.
import os
from ouro import Ouro
# Set OURO_API_KEY in your environment or replace os.environ.get("OURO_API_KEY")
ouro = Ouro(api_key=os.environ.get("OURO_API_KEY"))
dataset_id = "019a9d64-c2da-747a-927a-5de34694f416"
# Retrieve dataset metadata
dataset = ouro.datasets.retrieve(dataset_id)
print(dataset.name, dataset.visibility)
print(dataset.metadata)# Get column definitions for the underlying table
columns = ouro.datasets.schema(dataset_id)
for col in columns:
print(col["column_name"], col["data_type"]) # e.g., age integer, name text# Option 1: Query data by dataset ID (returns Pandas DataFrame)
df = ouro.datasets.query(dataset_id)
print(df.head())
# Option 2: Load data by table name (faster for large datasets)
table_name = dataset.metadata["table_name"] # e.g., "platform_metrics_2025_08_22_to_2025_11_19_a236195e_d435_4238_a3"
df = ouro.datasets.load(table_name)
print(len(df))import pandas as pd
# Update dataset metadata
updated = ouro.datasets.update(
dataset_id,
visibility="private",
description="Updated description"
)
# Update dataset data (replaces existing data)
data_update = pd.DataFrame([
{"name": "Charlie", "age": 33},
{"name": "Diana", "age": 28},
])
updated = ouro.datasets.update(dataset_id, data=data_update)This post covers platform trends from August 22 to November 19, 2025. It notes that overall usage has fallen in the last 30 to 45 days. Daily active users are staying very low, around 1–3 per day in November, with several days showing no activity. New user sign-ups remain modest, about 2–6 per day, with a few spikes early in November. Despite steady new users, current activity does not follow, pointing to activation or retention issues after sign-up. Creation and engagement are weak in November after larger bulk uploads in September and October. Views, comments, reactions, and newsletter activity have dropped to small numbers, with occasional brief bumps. Monetized assets appear only sporadically. Overall, the trend is a clear decline from September–October. The main challenge seems to be sustaining creation and improving early engagement to convert new users into regular activity.