CRSTBL Client Onboarding Guide

We’re excited to partner with you and ensure a seamless onboarding experience. This guide outlines the steps required to integrate with CRSTBL, providing clarity on system setup, data requirements, and ongoing communication.

1. Getting Started

Main Point of Contact

Please provide the contact information for the main person who will be coordinating with CRSTBL.

What You Need to Begin

  • A signed pilot agreement or kickoff confirmation
  • Key internal stakeholders assigned (IT, Sales, Operations, etc.)
  • Access to relevant data systems (ERP, CRM, WMS, etc.)
  • A designated point of contact for onboarding

2. Understanding Your KPIs

Share the metrics, goals, or KPIs you currently track across different areas of your business.

Current Challenges

Success Criteria

3. System Integration

Access & Permissions

To ensure smooth data transfer, we need to identify your core systems:

Data Access Method

  • API/Web Service
  • Scheduled file export (CSV, Excel, etc.)
  • Shared reporting tools/databases

Security Considerations

  • Firewall/IP allow list updates may be required
  • Read-only access is preferred for data sharing

4. Data Requirements

Key Data Points Needed

To optimize your experience with CRSTBL, we require the following datasets in detail:

  • Orders & Invoice transactions (sales history, order history, invoice history)
  • Purchase transactions (purchase records, purchase orders, purchase received)
  • Product Catalog (SKU details, pricing, descriptions, categories)
  • Customer Accounts (retailers, distributors, key accounts, customer classification, sales channel)
  • Inventory (stock levels)
  • Pricing (Price tiers, customer pricing, discounts)

Age of Data:

  • 24 months transactional data (minimum — more is better!)

Data Validation & Mapping

Once access is granted, we will:

  • Perform a test data extraction
  • Validate data for completeness and accuracy
  • Identify any missing or custom fields
  • Map data fields to CRSTBL’s internal structure

5. Reporting & Insights

What CRSTBL program are you participating in?

Customized Dashboards

To align with your business objectives, we will set up tailored reports and dashboards to provide actionable insights in the following areas:

Account-Level Breakdown

Gain a deeper understanding of account performance and sales contribution to inform targeting, engagement, and forecasting strategies.

  • Identify key accounts contributing the most to overall volume trends
  • Segment accounts based on performance tiers:
    • High-growth
    • Stable
    • Declining
  • Highlight significant accounts with notable changes in order volume
  • Provide insights into purchasing behavior, frequency, and patterns
SKU Performance Analysis

A detailed breakdown of product-level trends to optimize sales and inventory.

High-Performing SKUs
  • Identify products driving the most revenue and sales volume
Declining SKUs
  • Highlight any SKU in the top 20% of sales from the previous period that has experienced a decline of:
    • 30% / 20% / 10% (filterable criteria)
  • Drill-down analysis:
    • Identify accounts that ordered the flagged SKU in the previous two periods
    • Flag those experiencing a similar decline (30% / 20% / 10%)
  • Determine if declines are linked to:
    • Broader category or market trends
    • Seasonal fluctuations
    • Account-specific factors
SKU Segmentation
  • Categorize SKUs by sales velocity:
    • Fast-moving
    • Moderate
    • Slow-moving
  • Assess SKU profitability and impact on margin
  • Identify potential product gaps or bundling opportunities
Additional Insights
  • Sales Performance Trends – Evaluate revenue growth and fluctuations.
  • Inventory Insights – Monitor stock levels and product movement.
  • Order-to-Invoice Lifecycle – Track the efficiency of order fulfillment.
  • Marketing Program Impact – Assess engagement and conversion performance.
Quality Assurance

Before going live, we will:

  • Validate all reports against expected workflows
  • Conduct internal QA on visualizations and metrics
  • Share quick wins or early insights

6. Communication & Progress Tracking

What is your preferred method of communication for regular check-ins?

Regular Check-Ins

We will schedule recurring meetings to ensure alignment, discuss progress, and address any concerns.

  • Weekly status updates
  • Weekly progress calls
  • Monthly performance reviews

Tracking & Issue Resolution

We maintain an internal log of milestones, blockers, and action items to ensure transparency throughout the onboarding process.