Skip to main content

Customer Addresses

The data model includes measures for managing pricing and shipping timelines of items in the Customer Addresses data model. It captures Price Base as the original price, Price Adj for any adjustments, and Back Ord Price for back-ordered items. Ship Days quantifies the shipping times while various views segment addresses by country, city, state, and filter active addresses.

Benefits of This Data Model​

  • Improved Pricing Management: The data model allows for precise management of item pricing by capturing original Price Base, Price Adj for adjustments, and Back Ord Price for back-ordered items.
  • Enhanced Shipping Time Analysis: Ship Days measure in the data model provides insights into shipping timelines, enabling better assessment and optimization of shipping processes.
  • Efficient Customer Address Segmentation: Various views in the data model segment customer addresses by country, city, and state, facilitating targeted marketing campaigns and better customer relationship management.
  • Streamlined Address Filtering: The Active Addresses view filters out inactive addresses, ensuring that marketing and shipping efforts are focused on active customers only.

Key Performance Indicators (KPIs)​

  • Back Ord Price: This measure represents the price for back-ordered items in the Customer Addresses data model.
  • Price Adj: Price Adj is a measure capturing any price adjustments applied to items in the Customer Addresses data model.
  • Price Base: Price Base is a foundational measure denoting the base price of items in the Customer Addresses data model.
  • Ship Days: Ship Days is a measure indicating the number of days taken to ship items to customers in the Customer Addresses data model.

Available Visualizations​

View NameDescription
Customer AddressesProvides a consolidated list of customer addresses.
Addresses by CountryBreakdown of customer addresses based on country.
Addresses by CityBreakdown of customer addresses based on city.
Addresses by StateBreakdown of customer addresses based on state.
Active AddressesAddresses currently in use by active customers.