Power BI Connector for Mailchimp

Build 25.0.9454

EcommerceOrders

Contains details of e-commerce orders tracked through connected stores, including order totals and customer details.

Table Specific Information

Select

The connector will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.

The StoreId can be retrieved by selecting the ECommerceStores view.

  • StoreId supports the '=' operator.
  • Id supports the '=' operator.
  • CampaignId supports the '=' operator.
  • Outreach_Id supports the '=' operator.
  • CustomerId supports the '=' operator.
  • HasOutreach supports the '=' operator.
For example: 
SELECT * FROM EcommerceOrders WHERE StoreId = 'Test_Store123'
SELECT * FROM EcommerceOrders WHERE StoreId = 'Test_Store123' and Id = '44'
SELECT * FROM EcommerceOrders WHERE CampaignId = '12144'
SELECT * FROM EcommerceOrders WHERE Outreach_Id = '12144'
SELECT * FROM EcommerceOrders WHERE CustomerId = '12144'
SELECT * FROM EcommerceOrders WHERE HasOutreach = true

Columns

Name Type ReadOnly Description
StoreId [KEY] String False

The unique identifier of the store where the order was placed. Each store represents an e-commerce integration connected to the Mailchimp account.

Id [KEY] String False

The unique identifier assigned to the order within the store. This value distinguishes the order from other transactions.

Customer String False

Details about the customer who placed the order. For existing customers, include only the customer ID to associate the order with their record.

CampaignId String False

The unique identifier of the Mailchimp campaign associated with the order, enabling marketing attribution and performance tracking.

FinancialStatus String False

The financial state of the order, such as refunded, processing, or cancelled, indicating its payment status.

FulfillmentStatus String False

The fulfillment progress of the order, such as partial or fulfilled, showing whether items have been shipped or completed.

CurrencyCode String False

The three-letter International Organization for Standardization (ISO) 4217 currency code that defines the currency used in the order.

OrderTotal Decimal False

The total monetary amount of the order, including products, taxes, and shipping costs, after discounts are applied.

TaxTotal Decimal False

The total tax amount applied to the order based on the products purchased and the buyer's location.

ShippingTotal Decimal False

The total shipping charge applied to the order.

TrackingCode String False

The Mailchimp tracking code applied to the order. It uses the 'mc_tc' parameter from eCommerce360-enabled tracking URLs to measure marketing impact.

ProcessedAtForeign Datetime False

The date and time when the order was processed in the connected store system.

CancelledAtForeign Datetime False

The date and time when the order was canceled, if applicable.

UpdatedAtForeign Datetime False

The date and time when the order record was last updated in the store.

ShippingAddress_Name String False

The full name of the recipient for the order's shipping address.

ShippingAddress_Address1 String False

The first line of the shipping address, typically the street address or P.O. box.

ShippingAddress_Address2 String False

An additional field for apartment, suite, or building details in the shipping address.

ShippingAddress_City String False

The city where the order is being shipped.

ShippingAddress_Province String False

The state or province listed in the shipping address.

ShippingAddress_ProvinceCode String False

The two-letter code representing the state or province in the shipping address.

ShippingAddress_PostalCode String False

The postal or ZIP code for the shipping address.

ShippingAddress_Country String False

The full name of the country where the order is shipped.

ShippingAddress_CountryCode String False

The two-letter ISO 3166-1 code for the shipping country.

ShippingAddress_Longitude Double False

The longitude coordinate associated with the shipping address location.

ShippingAddress_Latitude Double False

The latitude coordinate associated with the shipping address location.

ShippingAddress_Phone String False

The phone number associated with the shipping address, if provided.

ShippingAddress_Company String False

The company name associated with the shipping address, if applicable.

BillingAddress_Name String False

The full name of the person or company on the billing address.

BillingAddress_Address1 String False

The first line of the billing address, typically the street address or P.O. box.

BillingAddress_Address2 String False

An additional field for apartment, suite, or building details in the billing address.

BillingAddress_City String False

The city where the billing address is located.

BillingAddress_Province String False

The state or province listed in the billing address.

BillingAddress_ProvinceCode String False

The two-letter code representing the state or province in the billing address.

BillingAddress_PostalCode String False

The postal or ZIP code for the billing address.

BillingAddress_Country String False

The full name of the country for the billing address.

BillingAddress_CountryCode String False

The two-letter ISO 3166-1 code for the billing country.

BillingAddress_Longitude Double False

The longitude coordinate for the billing address location.

BillingAddress_Latitude Double False

The latitude coordinate for the billing address location.

BillingAddress_Phone String False

The phone number associated with the billing address.

BillingAddress_Company String False

The company name associated with the billing address, if applicable.

Lines String False

A list of the order's line items, each representing a product or variant purchased. Line items can be updated through the EcommerceOrderLines table.

Outreach_Id String False

The unique identifier of the marketing outreach associated with the order, such as an email campaign or ad.

Outreach_Name String False

The name of the outreach campaign linked to the order.

Outreach_Type String False

The type of marketing outreach, such as email, social, or advertisement.

Outreach_PublishedTime String False

The date and time when the outreach campaign was published, in ISO 8601 format.

TrackingNumber String False

The tracking number provided by the shipping carrier for the order.

TrackingCarrier String False

The name of the shipping carrier handling the order, such as UPS, FedEx, or DHL.

TrackingUrl String False

The URL provided by the carrier to track the shipment's delivery status.

LandingSite String False

The URL of the page where the buyer first arrived before completing the order, useful for analyzing marketing funnels.

Promos String False

A list of promotional or discount codes applied to the order. When updating, this field is fully replaced with new values.

OrderUrl String False

The URL of the order record within the e-commerce system, used for quick reference or access.

DiscountTotal Decimal False

The total value of discounts applied to the order across all items.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CustomerId String

A filter column used to query orders for a specific customer ID. This column is only valid for SELECT operations.

HasOutreach Boolean

If the value is 'true', restricts results to orders associated with an outreach campaign, such as an email or ad. This column is only valid for SELECT operations.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454