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 metrics90 dimensions
The Partnerize connector exposes 97 fields (7 metrics, 90 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 10 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_ref_origin_id | TEXT | Click Ref Origin ID | The reference of the origin ID 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 approval 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 | Whether the conversion item is displayed to the publisher. |
| conversion_item_id | TEXT | Conversion Item ID | The unique identifier of the conversion item. |
| conversion_item_invoice_id | TEXT | Conversion Item Invoice ID | The unique identifier of the conversion item invoice. |
| 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 unique identifier of the conversion item status. |
| 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 51 fields.
Partnerize Conversions fields (advertiser_reference to ref_device_id)
| ID | Type | Name | Description |
|---|---|---|---|
| advertiser_reference | TEXT | Advertiser Reference | The reference of the advertiser. |
| attributed_click_cookie_id | TEXT | Attributed Click Cookie ID | The cookie of the click that led to the conversion. |
| attributed_click_id | TEXT | Attributed Click ID | The unique identifier of the click that led to the conversion. |
| attributed_click_last_ip | TEXT | Attributed Click Last IP | The last IP of the click that led to the conversion. |
| attributed_click_last_used | Attributed Click Last Used | The last used date of the click that led to the conversion. | |
| attributed_click_referer | TEXT | Attributed Click Referer | The referer of the click that led to the conversion. |
| attributed_click_set_ip | TEXT | Attributed Click Set IP | The set IP of the click that led to the conversion. |
| attributed_click_set_time | Attributed Click Set Time | The set time of the click that led to the conversion. | |
| attributed_click_status | TEXT | Attributed Click Status | The status of the click that led to the conversion. |
| attributed_click_type | TEXT | Attributed Click Type | The type of the click that led to the conversion. |
| 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 or of the click. |
| 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. |
| 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. |
Partnerize Conversions fields (ref_partnership_model to was_disputed)
| ID | Type | Name | Description |
|---|---|---|---|
| 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. |
| 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 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. |
| account_name | TEXT | Account Name | Account Name. |
| 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 |
| date | DATE | Date | The date of the conversion or of the click. |
| 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 |