Partnerize Connector Reference

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.

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	TIMESTAMP	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	TIMESTAMP	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	TIMESTAMP	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	TIMESTAMP	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	TIMESTAMP	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	TIMESTAMP	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	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