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 Partnerize data to
Partnerize Connector Reference
7 metrics80 dimensions
The Partnerize connector exposes 87 fields (7 metrics, 80 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
timezone Timezone
Enforce a specified Timezone.
Possible values (152)
UTCAfrica/AlgiersAfrica/BanguiAfrica/CasablancaAfrica/Dar_es_SalaamAfrica/JohannesburgAfrica/TripoliAfrica/WindhoekAmerica/AdakAmerica/AnchorageAmerica/Argentina/Buenos_AiresAmerica/AsuncionAmerica/BelemAmerica/BogotaAmerica/CaracasAmerica/CayenneAmerica/ChicagoAmerica/CuiabaAmerica/El_SalvadorAmerica/Glace_BayAmerica/GodthabAmerica/GuayaquilAmerica/GuyanaAmerica/HavanaAmerica/IndianapolisAmerica/JamaicaAmerica/La_PazAmerica/LimaAmerica/Los_AngelesAmerica/MiquelonAmerica/MontevideoAmerica/NoronhaAmerica/ParamariboAmerica/PhoenixAmerica/Porto_AcreAmerica/ReginaAmerica/SantiagoAmerica/Sao_PauloAmerica/ScoresbysundAntarctica/DavisAntarctica/DumontDUrvilleAntarctica/MawsonAntarctica/RotheraAntarctica/SyowaAntarctica/VostokAsia/AlmatyAsia/AnadyrAsia/AqtauAsia/AqtobeAsia/AshgabatAsia/BaghdadAsia/BakuAsia/BishkekAsia/BruneiAsia/ChoibalsanAsia/ColomboAsia/DiliAsia/DubaiAsia/DushanbeAsia/Hong_KongAsia/HovdAsia/IrkutskAsia/JakartaAsia/JayapuraAsia/JerusalemAsia/KamchatkaAsia/KarachiAsia/KrasnoyarskAsia/Kuala_LumpurAsia/KuwaitAsia/MagadanAsia/MakassarAsia/ManilaAsia/NovosibirskAsia/OmskAsia/OralAsia/QyzylordaAsia/SakhalinAsia/SeoulAsia/ShanghaiAsia/SingaporeAsia/TaipeiAsia/TashkentAsia/TbilisiAsia/ThimbuAsia/TokyoAsia/UlaanbaatarAsia/VladivostokAsia/YakutskAsia/YangonAsia/YekaterinburgAsia/YerevanAtlantic/AzoresAtlantic/BermudaAtlantic/Cape_VerdeAtlantic/Jan_MayenAtlantic/South_GeorgiaAtlantic/StanleyAustralia/BrisbaneAustralia/HobartAustralia/MelbourneAustralia/PerthAustralia/SydneyBrazil/WestCETEETESTEurope/AthensEurope/LisbonEurope/LondonEurope/MoscowEurope/ParisEurope/SamaraGMTHSTIndian/ChagosIndian/ChristmasIndian/KerguelenIndian/MaheIndian/MaldivesIndian/MauritiusIndian/ReunionMST7MDTPacific/ApiaPacific/AucklandPacific/EasterPacific/EfatePacific/EnderburyPacific/FakaofoPacific/FijiPacific/FunafutiPacific/GalapagosPacific/GambierPacific/GuamPacific/KiritimatiPacific/KosraePacific/MajuroPacific/NauruPacific/NiuePacific/NoumeaPacific/PalauPacific/PitcairnPacific/PonapePacific/Port_MoresbyPacific/RarotongaPacific/TahitiPacific/TarawaPacific/TongatapuPacific/TrukPacific/WakePacific/WallisPacific/Yap
Partnerize Fields
Partnerize Clicks fields
The Clicks report of the Partnerize connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| click_cookie_id | TEXT | Click Cookie ID | The unique identifier of the cookie. |
| click_id | TEXT | Click ID | The unique identifier of the click. |
| click_last_ip | TEXT | Click Last IP | The last IP of the click. |
| click_last_used | Click Last Used | The last used date of the click. | |
| click_referer | TEXT | Click Referer | The referer of the click. |
| click_set_ip | TEXT | Click Set IP | The set IP of the click. |
| click_set_time | Click Set Time | The set time of the click. | |
| click_status | TEXT | Click Status | The status of the click. |
| click_type | TEXT | Click Type | The type of the click. |
Partnerize Conversion Items fields
The Conversion Items report of the Partnerize connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| conversion_item_approved_at | Conversion Item Approved At | The approved date of the conversion item. | |
| conversion_item_category | TEXT | Conversion Item Category | The category of the conversion item. |
| conversion_item_commission | NUMERIC | Conversion Item Commission | The commission of the conversion item. |
| conversion_item_display_to_publisher | BOOLEAN | Conversion Item Display to Publisher | The display to publisher of the conversion item. |
| conversion_item_id | TEXT | Conversion Item ID | The unique identifier of the conversion item. |
| conversion_item_invoice_id | TEXT | Conversion Item Invoice ID | The invoice ID of the conversion item. |
| conversion_item_last_update | Conversion Item Last Update | The last update date of the conversion item. | |
| conversion_item_meta_data | OBJECT | Conversion Item Meta Data | The meta data of the conversion item. |
| conversion_item_publisher_commission | NUMERIC | Conversion Item Publisher Commission | The publisher commission of the conversion item. |
| conversion_item_reject_reason | TEXT | Conversion Item Reject Reason | The reject reason of the conversion item. |
| conversion_item_sku | TEXT | Conversion Item SKU | The SKU of the conversion item. |
| conversion_item_status | TEXT | Conversion Item Status | The status of the conversion item. |
| conversion_item_status_id | TEXT | Conversion Item Status ID | The status ID of the conversion item. |
| conversion_item_value | NUMERIC | Conversion Item Value | The value of the conversion item. |
| conversion_item_voucher_codes | OBJECT | Conversion Item Voucher Codes | The voucher codes of the conversion item. |
Partnerize Conversions fields
The Conversions report of the Partnerize connector includes 45 fields.
Partnerize Conversions fields (account_id to ref_user_context_id)
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. |
| account_name | TEXT | Account Name | Account Name. |
| advertiser_reference | TEXT | Advertiser Reference | The reference of the advertiser. |
| campaign | TEXT | Campaign | The name of the campaign. |
| campaign_id | TEXT | Campaign ID | The unique identifier of the campaign. |
| campaign_title | TEXT | Campaign Title | The name of the campaign. |
| clickref | TEXT | Click Reference | The reference of the click. |
| commission | NUMERIC | Commission | The commission of the conversion. |
| conversion_id | TEXT | Conversion ID | The unique identifier of the conversion. |
| conversion_lag | NUMERIC | Conversion Lag | The lag of the conversion. |
| conversion_reference | TEXT | Conversion Reference | The reference of the conversion. |
| conversion_status | TEXT | Conversion Status | The status of the conversion. |
| conversion_time | Conversion Time | The time of the conversion. | |
| conversion_type | TEXT | Conversion Type | The type of the conversion. |
| conversion_value_id | TEXT | Conversion Value ID | The unique identifier of the conversion value. |
| country | COUNTRY | Country | The country of the conversion. |
| creative_id | TEXT | Creative ID | The unique identifier of the creative. |
| creative_type | TEXT | Creative Type | The type of the creative. |
| currency | TEXT | Currency | The currency of the conversion. |
| currency_conversion_rate | TEXT | Currency Conversion Rate | The currency conversion rate of the conversion. |
| currency_original | BOOLEAN | Currency Original | The original currency of the conversion. |
| customer_reference | TEXT | Customer Reference | The reference of the customer. |
| customer_type | TEXT | Customer Type | The type of the customer. |
| date | DATE | Date | The date of the conversion. |
| device_id | TEXT | Device ID | The unique identifier of the device. |
| last_modified | Last Modified | The last modified date of the conversion. | |
| meta_data | OBJECT | Meta Data | The meta data of the conversion. |
| publisher_commission | NUMERIC | Publisher Commission | The publisher commission of the conversion. |
| publisher_id | TEXT | Publisher ID | The unique identifier of the publisher. |
| publisher_name | TEXT | Publisher Name | The name of the publisher. |
| ref_conversion_metric | TEXT | Ref Conversion Metric | The reference of the conversion metric. |
| ref_conversion_metric_id | TEXT | Ref Conversion Metric ID | The reference of the conversion metric ID. |
| ref_device | TEXT | Ref Device | The reference of the device. |
| ref_device_id | TEXT | Ref Device ID | The reference of the device ID. |
| ref_partnership_model | TEXT | Ref Partnership Model | The reference of the partnership model. |
| ref_partnership_model_id | TEXT | Ref Partnership Model ID | The reference of the partnership model ID. |
| ref_traffic_source | TEXT | Ref Traffic Source | The reference of the traffic source. |
| ref_traffic_source_id | TEXT | Ref Traffic Source ID | The reference of the traffic source ID. |
| ref_user_context | TEXT | Ref User Context | The reference of the user context. |
| ref_user_context_id | TEXT | Ref User Context ID | The reference of the user context ID. |
Partnerize Conversions fields (referer_ip to was_disputed)
| ID | Type | Name | Description |
|---|---|---|---|
| referer_ip | TEXT | Referer IP | The IP of the referer. |
| source_referer | TEXT | Source Referer | The referer of the source. |
| specific_creative_id | TEXT | Specific Creative ID | The unique identifier of the specific creative. |
| value | NUMERIC | Value | The value of the conversion. |
| was_disputed | BOOLEAN | Was Disputed | The status of the dispute. |
Partnerize other fields
The Partnerize 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 |
|---|---|---|---|
| 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 | |
| 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 |