Customer Insights with Data Cloud

The Accelerator for Customer Insights connects to standard Data Cloud objects to show you the “Art of the Possible” with customer data. This Accelerator shows the type of engagement most effective for each customer segment in order to inform decisions in near-real time. You can see how media engagement, revenue and customer lifetime value are driven by customers broken down into demographic and customer segments, and you can drill into individual customer details to make actionable decisions.

You’ll need a trial or licence for Tableau Desktop. Get started here, if you don’t have it already.

Want to map to your own Data Cloud instance? Download the workbook > save a local copy > edit the data source, and use your own Data Cloud instance and credentials.

Keyrus is a global Salesforce Partner, and they’ve built this Accelerator to make it as easy as possible for you to see and understand your customer data. Check out their video, or connect directly with them to learn more.

Answer Key Business Questions

• Which geographies have the most customers?
• Which customer segments have the most customers, and how has that changed YoY?
• Which age groups have the most customers, and how has that changed YoY?
• How does average revenue compare to the average number of products ordered by customer segment?
• How much time does each customer segment spend browsing online, and how does that compare to revenue generated?
• What are the order revenue and page browsing time of individuals within each customer segment?
• Which campaigns drive the most page visits and revenue, and how does that vary over time and by segment?

Monitor and Improve KPIs

• Average revenue by customer segment
• Total revenue by individual customer
• Average number of products ordered by customer segment
• Average customer lifetime value
• Average order quantity
• Total number of campaigns
• Average campaign browsing time by customer segment
• Total campaign browsing time by individual customer
• Total customers by state, age and customer segment
• Total number of page visits by customer segment and interest

Data Strategy

This Accelerator connects natively to Data Cloud. Data Cloud helps overcome common challenges to looking at one view of your customers by enabling you to connect data sources that are native to Salesforce with data sources that are external. Schemas include

• Campaign
• Sale
• Person
• Person’s Address
• Person’s Email
• Person’s Phone No.
• Person’s Session Analytics

Required Data Attributes

• Customer Count (Number – whole)
• Customer Count Delta YoY (%) (Number – decimal)
• Avg LTV Per Customer (Number – decimal)
• Avg Revenue Per Customer (Number – decimal)
• Avg Product Qty (Number – whole)
• # of Campaigns (Number – whole)
• Avg Product Qty Per Customer (Number – decimal)
• Avg Order Total (Number – decimal)
• RFM Segment (string)
• Campaign Source (string)
• Avg Page Browsing/Segment (Number – decimal)
• Person Province (geographic)
• Person Age (bin) (string)
• Customer Name (string)
• Gender (string)
• New Customer? (string)
• Last Order Date (date)
• Page Visits (Number – whole)
• Sales Attributable (Number – decimal)
• Page Interest (string)
• Campaign End Date (date)