Piwik Pro Connector Reference

The Piwik Pro connector exposes 44 fields (10 metrics, 34 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Piwik Pro Fields

Piwik Pro General fields

The General report of the Piwik Pro connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The Piwik PRO website or app ID.
account_name	TEXT	Account Name	The Piwik PRO website or app ID.
date	DATE	Date	The date of the metrics.

Piwik Pro Report fields

The Report report of the Piwik Pro connector includes 24 fields.

ID	Type	Name	Description
avg_time_on_page	NUMERIC	Average Time On Page	The average time visitors spent on the page, in seconds.
bounce_rate	PERCENT	Bounce Rate	The share of sessions during which visitors viewed one page.
campaign	TEXT	Campaign Name	The name of the online campaign taken from utm_campaign.
channel	TEXT	Channel	The channel of the incoming traffic.
city	CITY	City	The city from which a visitor entered the site or app.
country	COUNTRY	Country	The country from which a visitor entered the site or app.
custom_event_action	TEXT	Custom Event Action	The action of the custom event.
custom_event_category	TEXT	Custom Event Category	The category of the custom event.
custom_event_name	TEXT	Custom Event Name	The name of the custom event.
entries	NUMERIC	Entries	The number of page views that were the first during a session.
exits	NUMERIC	Exits	The number of page views that were the last during a session.
goal_conversion_rate	PERCENT	Goal Conversion Rate (Sessions)	The share of sessions during which visitors completed a goal.
goal_conversions	NUMERIC	Goal Conversions	The total number of completed goals, repeated goals included.
medium	TEXT	Medium	The category of the traffic source.
page_url	TEXT	Page URL	The URL of the page on which an event took place.
page_views	NUMERIC	Page Views	The number of times a page was visited.
pagetitle	TEXT	Page Title	The title of the page on which an event took place.
referrer_url	TEXT	Referrer URL	The URL of the page that referred a visitor to the site.
session_entry_url	TEXT	Session Entry URL	The URL of the first visited page during the session.
sessions	NUMERIC	Sessions	The number of sessions performed by visitors.
source	TEXT	Source	The origin of the incoming traffic.
source_medium	TEXT	Source / Medium	The combined source and medium of the incoming traffic.
unique_page_views	NUMERIC	Unique Page Views	The number of times a page was uniquely visited in a session.
visitors	NUMERIC	Visitors	The number of unique visitors.

Piwik Pro other fields

The Piwik Pro connector has 17 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024|20