β¬οΈImport All - What's Included?
Overview
The Import All feature imports a curated set of your data into Drivepoint in a single click. Rather than importing every available table, Import All pulls in the most commonly used, model-ready data with sensible default settings β so your model is populated quickly without manual configuration.
Only data sources that are connected and configured for your account will be imported. If you don't have a particular integration set up, those tables are automatically skipped.
What Gets Imported
Shopify (DTC)
Retention Predictions β Forecast based on the previous month's cohort, projected 5 years forward
Monthly Sales Pivoted β Monthly sales data in a model-ready pivot format
Amazon
Retention Predictions β Forecast based on the previous month's cohort, projected 3 years forward
Monthly Sales Pivoted β Monthly sales data in a model-ready pivot format
TikTok Shop
Retention Predictions β Forecast based on the previous month's cohort, projected 3 years forward
Monthly Sales Pivoted β Monthly sales data in a model-ready pivot format
Drivepoint
Retention Predictions β Forecast based on the previous month's cohort, projected 5 years forward
Monthly Sales Pivoted β Aggregated monthly data across all connected channels
Wholesale
Wholesale by PRA β Sales data grouped by SKU and retailer
Wholesale by Distribution Center β Sales data broken out by distribution center
Cin7 Omni
Sales Orders by Date β Monthly sales orders grouped by product name
Sales Orders Raw β Raw sales order data (orders with PO numbers)
Sales Orders Line Items β Line item detail for sales orders (orders with PO numbers)
Purchase Orders by Date β Monthly purchase orders grouped by product name
Purchase Orders Raw β Raw purchase order records
Purchase Orders Line Items β Line item detail for purchase orders
Products β Your full Cin7 Omni product catalog
Cin7 Core
Sales Orders by Date β Monthly sales orders grouped by product name, using Sale Order Date
Purchase Orders by Date β Monthly purchase orders grouped by supplier
Purchase Orders Line Items β Line item detail for purchase orders
Products β Your full Cin7 Core product catalog
WMS / 3PL (via Trackstar)
Orders β Fulfilled orders grouped by SKU, rolled up monthly
Inventory β Current inventory levels grouped by SKU
Returns β Returns grouped by SKU, rolled up monthly
Incoming Shipments β Inbound shipments rolled up monthly
Products β Your warehouse product catalog
What's Not Included
Some tables are available in Drivepoint but are intentionally left out of Import All. These tend to be raw, granular, or highly model-specific β importing them automatically can cause formatting issues or overwrite customized data in your model.
Tables not included in Import All:
Retention Variance, Nth Order Retention, EOM Projections
Sales Unpivoted (Shopify, Amazon, TikTok)
Cohorted Sales (Shopify, Amazon)
Product Sales Mix (Shopify, Amazon, TikTok)
Subscriber Metrics (Recharge)
Monthly Ads
These tables are still available to import individually from the import menu.
Frequently Asked Questions
What if I don't have one of these integrations connected? No problem β any table associated with a data source you haven't connected will simply be skipped. You won't see an error.
Can I still import individual tables? Yes. Import All is a convenience feature. All tables β including those not covered by Import All β remain available for individual import at any time.
How are date ranges determined? Where a date parameter is required (such as for Retention Predictions), Import All automatically uses the previous month as the reference point. You don't need to set this manually.
What if I want different settings than the defaults? Use the individual import option for that table instead. Import All is designed for a standard, out-of-the-box setup β for custom configurations, import tables individually and set your preferred parameters.
Last updated
Was this helpful?