Windsor brings all your ProfitWell data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
ProfitWell Field Reference
Sample
https://connectors.windsor.ai/profitwell?fields=account_id,account_name,currency,timezone,date,created_on,activated_on,churned_on,updated_on,customer_id,email,firstname,lastname,mrr,total_spend,plans,status&api_key=[your API key]
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
account_id | TEXT | Account ID | The ProfitWell account ID | account |
account_name | TEXT | Account Name | The ProfitWell account name | account |
activated_on | TIMESTAMP | Activated On | The activation date of the customer | customer |
churned_on | TIMESTAMP | Churned On | The churn date of the customer | customer |
created_on | TIMESTAMP | Created On | The creation date of the customer | customer |
currency | TEXT | Currency | The ProfitWell account currency | account |
customer_id | TEXT | Customer ID | The customer ID of the customer | customer |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | The last updated date of the customer (duplicate of Updated On) | customer |
day_of_month | TEXT | Day of month | Day of the month | |
TEXT | The email address of the customer | customer | ||
firstname | TEXT | First Name | The first name of the customer | customer |
lastname | TEXT | Last Name | The last name of the customer | customer |
month | TEXT | Month | Number of the month | |
mrr | NUMERIC | MRR (Account currency) | The MRR of the customer in the account currency | customer |
plans | OBJECT | Plans | The plans of the customer | customer |
source | TEXT | Source | The name of the Windsor connector returning the row | |
status | TEXT | Status | The status of the customer | customer |
timezone | TEXT | Time Zone | The time zone of the ProfitWell account | account |
today | DATE | Today | Today's date | |
total_spend | NUMERIC | Total Spend (Account currency) | The MRR of the customer in the account currency | customer |
updated_on | TIMESTAMP | Updated On | The last updated date of the customer | customer |
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_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 |