B2C Commerce Data in Tableau

Use your B2C Commerce data in Tableau to create dashboards and data views tailored to your specific business needs. The Salesforce B2C Commerce Cloud Connector exports your B2C Commerce analytics data to your Tableau instance. You can use Tableau's data visualization features to analyze your data without code.

Note Tableau offers numerous options and resources to visualize your data. We recommend taking advantage of the training resources available with your Tableau license to learn more about how to build, refine, and share your data visualizations with Tableau. For technical details and help, refer to the Tableau documentation.

Salesforce B2C Commerce Cloud Connector

Transform your commerce data into actionable insights with the Salesforce B2C Commerce Cloud Connector. Actionable insights help optimize customer experiences and accelerate revenue growth. This Java Database Connectivity (JDBC)-based connector provides access to your ecommerce data and the customer behavior insights that are stored in B2C Commerce. Direct connectivity to your commerce platform enables analysis of sales performance, customer journeys, and product engagement across digital touchpoints.

To download B2C Commerce Cloud connector from Tableau Exchange and set it up, see Salesforce Commerce Cloud Intelligence.

Common Data Terms

To get started with B2C Commerce data in Tableau, get familiar with some of the common data terminology used in B2C Commerce and Tableau.

Role–A set of properties assigned to a field in Tableau.
- Dimension–A qualitative field used to segment and expose the details in your data. For example, you can group the measure Gross Merchandise Value (GMV) by the dimensions customer type and date. The value of a measure depends on the context of the dimensions.
- Measure–A quantitative field used to show metrics or numerical data. A measure is considered a dependent property because a measure’s meaning depends on which dimensions are selected in Tableau, and its value depends on the context of the dimensions. Tableau refers to a measure’s meaning as granularity.
  B2C Commerce measures are either fully additive or semi-additive. A fully additive measure can be summed for dimensions used with the measure. Examples of aggregation functions that you can apply include sum, count, and average.
  
  A semi-additive measure is the result of a mathematical calculation or aggregation. It is summable, but the sums can differ depending on the included dimensions.
Aggregate–Specifies how data is combined. The amount of data aggregation in a Tableau chart affects how you evaluate the data and the discoveries that you can make. Aggregating semi-additive measures can generate erroneous results.

B2C Commerce Data Aggregations

The B2C Commerce Tableau Connector is a web data connector that groups your B2C Commerce data in subject areas. Each subject area consists of dimensions and measures derived from raw B2C Commerce data.

When you import your B2C Commerce data into Tableau, the connector applies the appropriate aggregation function to represent your data in Tableau. You can create meaningful data views by further aggregating your measures with the imported dimensions.

A data dashboard is a convenient way to show data from the same underlying subject area in easy-to-read charts and tables. Each dashboard element depends on a different aggregation of your data.