Windsor brings all your Omnisend data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Omnisend Field Reference

Fields

ID	Type	Name	Description	Report
campaigns__allsubscribers	BOOLEAN	campaigns.allSubscribers	campaigns.allSubscribers	campaigns
campaigns__bounced	NUMERIC	campaigns.bounced	campaigns.bounced	campaigns
campaigns__campaignid	TEXT	campaigns.campaignID	campaigns.campaignID	campaigns
campaigns__clicked	NUMERIC	campaigns.clicked	campaigns.clicked	campaigns
campaigns__complained	NUMERIC	campaigns.complained	campaigns.complained	campaigns
campaigns__createdat	TEXT	campaigns.createdAt	campaigns.createdAt	campaigns
campaigns__enddate	TEXT	campaigns.endDate	campaigns.endDate	campaigns
campaigns__fromname	TEXT	campaigns.fromName	campaigns.fromName	campaigns
campaigns__name	TEXT	campaigns.name	campaigns.name	campaigns
campaigns__opened	NUMERIC	campaigns.opened	campaigns.opened	campaigns
campaigns__segments	OBJECT	campaigns.segments	campaigns.segments	campaigns
campaigns__sent	NUMERIC	campaigns.sent	campaigns.sent	campaigns
campaigns__startdate	TEXT	campaigns.startDate	campaigns.startDate	campaigns
campaigns__status	TEXT	campaigns.status	campaigns.status	campaigns
campaigns__subject	TEXT	campaigns.subject	campaigns.subject	campaigns
campaigns__type	TEXT	campaigns.type	campaigns.type	campaigns
campaigns__unsubscribed	NUMERIC	campaigns.unsubscribed	campaigns.unsubscribed	campaigns
campaigns__updatedat	TEXT	campaigns.updatedAt	campaigns.updatedAt	campaigns
campaigns__url	TEXT	campaigns.url	campaigns.url	campaigns
carts__cartid	TEXT	carts.cartID	carts.cartID	carts
carts__cartrecoveryurl	TEXT	carts.cartRecoveryUrl	carts.cartRecoveryUrl	carts
carts__cartsum	NUMERIC	carts.cartSum	carts.cartSum	carts
carts__contactid	TEXT	carts.contactID	carts.contactID	carts
carts__createdat	TEXT	carts.createdAt	carts.createdAt	carts
carts__currency	TEXT	carts.currency	carts.currency	carts
carts__email	TEXT	carts.email	carts.email	carts
carts__phone	TEXT	carts.phone	carts.phone	carts
carts__products	OBJECT	carts.products	carts.products	carts
carts__updatedat	TEXT	carts.updatedAt	carts.updatedAt	carts
contacts__address	TEXT	contacts.address	contacts.address	contacts
contacts__birthdate	TEXT	contacts.birthdate	contacts.birthdate	contacts
contacts__city	TEXT	contacts.city	contacts.city	contacts
contacts__clicked	NUMERIC	contacts.clicked	contacts.clicked	contacts
contacts__contactid	TEXT	contacts.contactID	contacts.contactID	contacts
contacts__country	TEXT	contacts.country	contacts.country	contacts
contacts__countrycode	TEXT	contacts.countryCode	contacts.countryCode	contacts
contacts__createdat	TEXT	contacts.createdAt	contacts.createdAt	contacts
contacts__email	TEXT	contacts.email	contacts.email	contacts
contacts__firstname	TEXT	contacts.firstName	contacts.firstName	contacts
contacts__gender	TEXT	contacts.gender	contacts.gender	contacts
contacts__identifiers	OBJECT	contacts.identifiers	contacts.identifiers	contacts
contacts__lastname	TEXT	contacts.lastName	contacts.lastName	contacts
contacts__opened	NUMERIC	contacts.opened	contacts.opened	contacts
contacts__optins	OBJECT	contacts.optIns	contacts.optIns	contacts
contacts__phone	OBJECT	contacts.phone	contacts.phone	contacts
contacts__phonenumber	TEXT	contacts.phoneNumber	contacts.phoneNumber	contacts
contacts__postalcode	TEXT	contacts.postalCode	contacts.postalCode	contacts
contacts__segments	OBJECT	contacts.segments	contacts.segments	contacts
contacts__sent	NUMERIC	contacts.sent	contacts.sent	contacts
contacts__state	TEXT	contacts.state	contacts.state	contacts
contacts__status	TEXT	contacts.status	contacts.status	contacts
contacts__statuses	OBJECT	contacts.statuses	contacts.statuses	contacts
contacts__tags	OBJECT	contacts.tags	contacts.tags	contacts
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
orders__billingaddress	OBJECT	orders.billingAddress	orders.billingAddress	orders
orders__cartid	TEXT	orders.cartID	orders.cartID	orders
orders__contactid	TEXT	orders.contactID	orders.contactID	orders
orders__contactnote	TEXT	orders.contactNote	orders.contactNote	orders
orders__couriertitle	TEXT	orders.courierTitle	orders.courierTitle	orders
orders__courierurl	TEXT	orders.courierUrl	orders.courierUrl	orders
orders__createdat	TEXT	orders.createdAt	orders.createdAt	orders
orders__currency	TEXT	orders.currency	orders.currency	orders
orders__customfields	OBJECT	orders.customFields	orders.customFields	orders
orders__discountcode	TEXT	orders.discountCode	orders.discountCode	orders
orders__discountsum	NUMERIC	orders.discountSum	orders.discountSum	orders
orders__discounttype	TEXT	orders.discountType	orders.discountType	orders
orders__discountvalue	NUMERIC	orders.discountValue	orders.discountValue	orders
orders__email	TEXT	orders.email	orders.email	orders
orders__firstname	TEXT	orders.firstName	orders.firstName	orders
orders__fulfillmentstatus	TEXT	orders.fulfillmentStatus	orders.fulfillmentStatus	orders
orders__lastname	TEXT	orders.lastName	orders.lastName	orders
orders__orderid	TEXT	orders.orderID	orders.orderID	orders
orders__ordernumber	NUMERIC	orders.orderNumber	orders.orderNumber	orders
orders__ordersum	NUMERIC	orders.orderSum	orders.orderSum	orders
orders__orderurl	TEXT	orders.orderUrl	orders.orderUrl	orders
orders__paymentmethod	TEXT	orders.paymentMethod	orders.paymentMethod	orders
orders__paymentstatus	TEXT	orders.paymentStatus	orders.paymentStatus	orders
orders__products	OBJECT	orders.products	orders.products	orders
orders__shippingaddress	OBJECT	orders.shippingAddress	orders.shippingAddress	orders
orders__shippingmethod	TEXT	orders.shippingMethod	orders.shippingMethod	orders
orders__shippingsum	NUMERIC	orders.shippingSum	orders.shippingSum	orders
orders__source	TEXT	orders.source	orders.source	orders
orders__subtotalsum	NUMERIC	orders.subTotalSum	orders.subTotalSum	orders
orders__tags	OBJECT	orders.tags	orders.tags	orders
orders__taxsum	NUMERIC	orders.taxSum	orders.taxSum	orders
orders__trackingcode	TEXT	orders.trackingCode	orders.trackingCode	orders
orders__updatedat	TEXT	orders.updatedAt	orders.updatedAt	orders
products__categoryids	OBJECT	products.categoryIDs	products.categoryIDs	products
products__createdat	TEXT	products.createdAt	products.createdAt	products
products__currency	TEXT	products.currency	products.currency	products
products__description	TEXT	products.description	products.description	products
products__images	OBJECT	products.images	products.images	products
products__productid	TEXT	products.productID	products.productID	products
products__producturl	TEXT	products.productUrl	products.productUrl	products
products__status	TEXT	products.status	products.status	products
products__tags	OBJECT	products.tags	products.tags	products
products__title	TEXT	products.title	products.title	products
products__type	TEXT	products.type	products.type	products
products__updatedat	TEXT	products.updatedAt	products.updatedAt	products
products__variants	OBJECT	products.variants	products.variants	products
products__vendor	TEXT	products.vendor	products.vendor	products
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date