Bluesky Public Data metrics and dimensions

7 metrics29 dimensions

Search fields

DATASOURCE

dataSourceName

Field label	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

POST

post_id

Field label	Post ID
Description	Unique identifier of the post
Field type	dimension
Data type	string.text.value

post_text

Field label	Post text
Description	Text content of the post
Field type	dimension
Data type	string.text.value

post_created_at

Field label	Post created at
Description	Date and time the post was created
Field type	dimension
Data type	string.time.datetime

post_url

Field label	Post URL
Description	URL to view the post on Bluesky
Field type	dimension
Data type	string.text.url

user_handle

Field label	User handle
Description	Handle of the post's author. For reposts this is the original author, which differs from Queried handle (the queried account whose feed the repost appears in)
Field type	dimension
Data type	string.text.value

user_display_name

Field label	User display name
Description	Display name of the post author
Field type	dimension
Data type	string.text.value

user_avatar_url

Field label	User avatar URL
Description	Avatar image of the post author
Field type	dimension
Data type	string.text.url

user_created_at

Field label	User created at
Description	Account creation date of the post author
Field type	dimension
Data type	string.time.datetime

is_repost

Field label	Is repost
Description	True if this feed item is a repost by the queried account (the other post fields then describe the original post and its author); false for the account's own posts
Field type	dimension
Data type	bool

like_count

Field label	Like count
Description	Number of likes on the post
Field type	metric
Data type	int.number.value

repost_count

Field label	Repost count
Description	Number of reposts
Field type	metric
Data type	int.number.value

reply_count

Field label	Reply count
Description	Number of replies to the post
Field type	metric
Data type	int.number.value

quote_count

Field label	Quote count
Description	Number of quote posts
Field type	metric
Data type	int.number.value

PROFILE

handle

Field label	Handle
Description	Bluesky handle of the user
Field type	dimension
Data type	string.text.value

display_name

Field label	Display name
Description	Display name of the user
Field type	dimension
Data type	string.text.value

description

Field label	Description
Description	Profile bio/description
Field type	dimension
Data type	string.text.value

avatar_url

Field label	Avatar URL
Description	URL of the profile's avatar image
Field type	dimension
Data type	string.text.url

profile_url

Field label	Profile URL
Description	URL to the user's Bluesky profile
Field type	dimension
Data type	string.text.url

created_at

Field label	Created at
Description	Account creation date
Field type	dimension
Data type	string.time.datetime

queried_handle

Field label	Queried handle
Description	The Bluesky handle you queried — the account whose feed, followers or following list this row belongs to. On reposts it differs from User handle, which is the original post's author
Field type	dimension
Data type	string.text.value

followers_count

Field label	Followers count
Description	Number of followers
Field type	metric
Data type	int.number.value

following_count

Field label	Following count
Description	Number of accounts being followed
Field type	metric
Data type	int.number.value

posts_count

Field label	Posts count
Description	Total number of posts
Field type	metric
Data type	int.number.value

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

system_metadata.query_excluded_accounts

Field label	Excluded invalid accounts
Description	A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type	dimension
Data type	string.text.json

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse