⬇️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?