Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Piwik PRO data to
Piwik PRO Connector Reference
10 metrics34 dimensions
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 | 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 | 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 |