Getting Started

Navigating the sidebar and main menu

Overview Datadrew's sidebar is your primary way to navigate the platform. It is organized into clear categories so you can quickly find dashboards, reports, and settings. Sidebar categories The sidebar is divided into the following main sections: Drew AI At the top of the sidebar, you will find Drew AI — your AI-powered analytics assistant. Click here to open a chat where you can ask questions about your store in natural language. For example: "What were my top-selling products last month?" or "How is my Facebook Ads ROAS trending?" Dashboard Your main analytics dashboard with an overview of key metrics across Shopify, advertising, and customer analytics. This is your daily starting point. Acquisition Reports focused on how you attract customers and drive traffic: - Ads — Blended summary across platforms, plus individual views for Google Ads and Facebook Ads - Website Traffic — Google Analytics data showing sessions, traffic sources, and conversions - Product Performance — A comprehensive view merging ad data with product-level sales metrics including ROAS, LTV, and repeat rate - Hourly Performance — Real-time hourly breakdown of revenue, ad spend, ROAS, and conversions across all channels Retention Reports that help you understand and improve customer loyalty: - Cohort Analysis — LTV cohorts, product cohorts, location cohorts, and custom cohorts showing how customer groups retain over time - Customer — RFM analysis, new vs. returning customers, customer segments, and purchase frequency - Industry Benchmarks — See how your store compares to similar merchants - Repurchase Rate — Analyze which products drive the most repeat purchases Products Product-focused analytics: - Product Performance — Detailed product-level metrics with ad data - Basket Analysis — Discover which products are frequently bought together - Repurchase Rate — Track which first-purchase products lead to repeat buyers Integrations Manage your connected data sources. This is where you connect and monitor Facebook Ads, Google Ads, Google Analytics 4, Klaviyo, and Google Search Console. Settings Configure your Datadrew account: - Store — Store-level settings and configuration - Integrations — Another path to manage your connected platforms - Global Filters — Set default filters like excluded order tags or specific sales channels - Scheduled Reports — Set up automated weekly email reports - Invite Member — Add team members to your workspace - Subscription — View and manage your plan - Support — Access help resources and contact support Store selector At the bottom of the sidebar, you will find the store selector. If you have multiple Shopify stores connected, use this to switch between them or activate the consolidated view for stores with the same currency. Collapsing the sidebar You can collapse the sidebar to a narrow icon-only view by clicking the collapse button at the top. This gives you more screen space for dashboards and reports. Click again to expand it. Tip: Hover over collapsed sidebar icons to see tooltips with the section name, or click to expand a category and see all its sub-items. Need help? If you cannot find a particular report or have questions about navigation, reach out to us at support@datadrew.io or use the in-app chat. Related articles - Understanding the Datadrew dashboard overview - Store Performance dashboard overview - Using date range and comparison filters - Setting up global filters

Understanding the Datadrew dashboard overview

Overview The Datadrew dashboard is your command center for e-commerce analytics. It gives you an at-a-glance view of your store's performance, combining data from Shopify, your ad platforms, and Google Analytics into a single, unified view. Dashboard sections When you open the dashboard, you will see several key sections, each designed to highlight a different aspect of your business: Blended ad metrics At the top of the dashboard, you will find your blended advertising metrics. These combine data from Facebook Ads and Google Ads into unified totals for: - Total ad spend — combined spend across all connected ad platforms - Revenue — total Shopify revenue for the selected period - ROAS — return on ad spend (revenue divided by ad spend) - CPA — cost per acquisition - Orders and AOV — total orders and average order value Shopify metrics The Shopify section shows your core store metrics: total revenue, number of orders, average order value, customers, and refunds. You can compare these to previous periods to track growth or decline. New vs. existing customers This section breaks down your revenue and order count by new customers versus returning customers, helping you understand your retention at a glance. LTV growth A summary of your customer lifetime value trends, showing how your cohorts are performing over time. LTV cohort analysis A compact view of your cohort retention heatmap, showing how customer groups from different months continue to generate revenue over time. RFM segments A treemap visualization of your customer base segmented by Recency, Frequency, and Monetary value. This helps you quickly see how many customers are champions, loyal, at risk, or lost. Growth benchmarks Industry benchmarks that show how your store compares to similar Shopify merchants, helping you gauge whether your metrics are above or below average. Using the date picker At the top of the dashboard, you will find the date picker. Use it to select any custom date range or choose from quick presets like "Last 7 days," "Last 30 days," or "Last quarter." All sections on the dashboard update based on your selected date range. The setup widget If you are new to Datadrew, you will also see a setup widget on the dashboard. This widget tracks your onboarding progress and shows recommended next steps like connecting Google Ads, setting up scheduled reports, or trying Drew AI. You can dismiss it once you have completed the steps. Tip: The dashboard is designed to be your daily starting point. Bookmark it or pin Datadrew in your Shopify admin for quick access. Need help? If any section of your dashboard is not loading or shows unexpected data, contact us at support@datadrew.io or use the in-app chat. Related articles - Navigating the sidebar and main menu - Store Performance dashboard overview - Installing Datadrew from the Shopify App Store - Your first 7 days with Datadrew

Connecting your Shopify store

Overview When you install Datadrew from the Shopify App Store, your Shopify store is automatically connected. Datadrew uses Shopify's secure OAuth system to access your store data — no API keys or manual configuration needed. This article explains what happens behind the scenes when your store connects and how to verify everything is working. How Shopify connects automatically During installation, Shopify grants Datadrew read access to the following data from your store: - Orders — order history, line items, discounts, and fulfillment status - Customers — customer profiles, addresses, and purchase history - Products — product details, variants, images, and inventory - Refunds — order refund records and amounts This data is synced into Datadrew's analytics engine and is used to power your dashboards, cohort analysis, RFM segmentation, product performance reports, and Drew AI. Checking your Shopify sync status 1. Open Datadrew from your Shopify admin (Apps > Datadrew). 2. Navigate to Integrations in the sidebar. 3. Look for the Shopify integration card. It will show one of the following statuses: - Syncing — Your data is currently being imported. This is normal for the first sync. - Synced — Your data has been successfully imported and is up to date. - Disconnected — There is an issue with the connection. See troubleshooting below. Initial sync timeline The first data sync depends on the size of your store: - Small stores (under 10,000 orders) — typically 15 to 30 minutes - Medium stores (10,000 to 100,000 orders) — 1 to 3 hours - Large stores (over 100,000 orders) — up to 6 hours After the initial sync, data is refreshed automatically on a daily schedule. Certain metrics like hourly performance update more frequently. Multi-store support If you manage multiple Shopify stores, you can install Datadrew on each one separately. Stores with the same currency can be viewed together in Consolidated View, which aggregates analytics across stores on a single dashboard. To switch between stores, use the store selector at the bottom of the sidebar. Note: Each Shopify store requires its own Datadrew installation. Consolidated View is available on select plans and is read-only — you cannot make changes to individual store settings while in consolidated mode. Need help? If your Shopify data is not syncing or the connection appears disconnected, reach out to us at support@datadrew.io or use the in-app chat. We can check your sync status and help resolve any issues. Related articles - Installing Datadrew from the Shopify App Store - Understanding the Datadrew dashboard overview - Shopify data sync — what's included - Understanding data sync and freshness

Installing Datadrew from the Shopify App Store

Overview Datadrew is an AI-powered e-commerce analytics platform built specifically for Shopify merchants. It brings together data from Shopify, Facebook/Meta Ads, Google Ads, Google Analytics 4, Klaviyo, and Google Search Console into one unified dashboard — and lets you ask questions about your business using Drew AI, your personal analytics assistant. Installing Datadrew takes just a few clicks from the Shopify App Store. Prerequisites - An active Shopify store (any plan) - Store owner or staff account with permission to install apps Step-by-step installation 1. Visit the Shopify App Store listing. Go to https://apps.shopify.com/customer-lifetime-value or search for "Datadrew" in the Shopify App Store. 2. Click "Install" on the Datadrew app listing page. You will be redirected to your Shopify admin. 3. Review the permissions. Datadrew requests read access to your orders, products, and customer data so it can generate analytics. Review the listed permissions and click "Install app" to confirm. 4. Create your account. After installation, Datadrew will open inside your Shopify admin. You will be prompted to create a Datadrew account with your email address and a password. This account lets you access Datadrew across devices and invite team members. 5. Complete the onboarding steps. Once logged in, you will see an onboarding flow that guides you through connecting your ad accounts, choosing a plan, booking an onboarding call, and inviting your team. What happens after installation As soon as you install Datadrew, your Shopify data begins syncing automatically. This includes orders, customers, products, and refunds. The initial sync typically takes between 15 minutes and a few hours depending on your store size. While your Shopify data syncs, you can get a head start by connecting your advertising and marketing platforms (Facebook Ads, Google Ads, Google Analytics 4, Klaviyo, or Google Search Console) from the Integrations page. Note: Datadrew is embedded directly inside your Shopify admin, so you can always access it by going to Apps > Datadrew in your Shopify dashboard. Need help? If you run into any issues during installation, reach out to us at support@datadrew.io or use the in-app chat. We are happy to help you get set up. Related articles - Connecting your Shopify store - Understanding the Datadrew dashboard overview - Your first 7 days with Datadrew - How Datadrew uses your Shopify data