API Connectors

users-love-us medal soc2
Send your ProfitWell data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

ProfitWell Connector Reference

2 metrics33 dimensions
Fields

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]

The ProfitWell connector exposes 35 fields (2 metrics, 33 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


ProfitWell Fields

ProfitWell account fields

The account report of the ProfitWell connector includes 4 fields.

ID Type Name Description
account_id TEXT Account ID The ProfitWell account ID
account_name TEXT Account Name The ProfitWell account name
currency TEXT Currency The ProfitWell account currency
timezone TEXT Time Zone The time zone of the ProfitWell account

ProfitWell customer fields

The customer report of the ProfitWell connector includes 13 fields.

ID Type Name Description
activated_on TIMESTAMP Activated On The activation date of the customer
churned_on TIMESTAMP Churned On The churn date of the customer
created_on TIMESTAMP Created On The creation date of the customer
customer_id TEXT Customer ID The customer ID of the customer
date DATE Date The last updated date of the customer (duplicate of Updated On)
email TEXT Email The email address of the customer
firstname TEXT First Name The first name of the customer
lastname TEXT Last Name The last name of the customer
mrr NUMERIC MRR (Account currency) The MRR of the customer in the account currency
plans OBJECT Plans The plans of the customer
status TEXT Status The status of the customer
total_spend NUMERIC Total Spend (Account currency) The MRR of the customer in the account currency
updated_on TIMESTAMP Updated On The last updated date of the customer

ProfitWell other fields

The ProfitWell connector has 18 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
source TEXT Source The name of the Windsor connector returning the row
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