Home Slack, Amazon & Search Console

Slack, Amazon & Search Console

Vikas Bansal
By Vikas Bansal
3 articles

Connecting Slack for weekly reports

Datadrew can send automated weekly performance reports directly to a Slack channel of your choice. This keeps your team informed about key metrics without needing to log into the Datadrew dashboard. Prerequisites - A Slack workspace where you have permission to add apps. - An active Datadrew account with your Shopify store connected and syncing data. Step-by-step connection 1. In Datadrew, go to Settings > Integrations. 2. Find the Slack card and click Connect. 3. You will be redirected to Slack's authorization page. 4. Sign in to your Slack workspace if prompted. 5. Slack will ask you to select a channel where Datadrew should post reports. You can choose an existing channel or create a new one (e.g., #datadrew-reports). 6. Click Allow to authorize. Datadrew will receive an incoming webhook URL for the selected channel. 7. You will be redirected back to Datadrew. The integration will be marked as connected. How the weekly report works Once Slack is connected and weekly reports are enabled, Datadrew sends a formatted performance summary to your chosen Slack channel on a weekly schedule. The report includes: Report contents The weekly report is organized by metric group and includes data from all your connected integrations: - Revenue metrics -- Total revenue, orders, average order value from Shopify. - Ad performance -- Spend, ROAS, CPC, and other advertising metrics from Facebook and Google Ads (if connected). - Website traffic -- Sessions, users, bounce rate from GA4 (if connected). - Email marketing -- Campaign performance from Klaviyo (if connected). Each metric shows the current period value, plus a comparison to the previous period with a percentage change indicator. Green indicators show improvements; red indicators show declines (relative to whether higher or lower is better for that metric). Enabling and disabling reports Connecting Slack does not automatically enable weekly reports. After connecting: 1. Go to your Datadrew settings. 2. Enable the Slack Weekly Report option. 3. Reports will begin sending on the next scheduled cycle. To stop receiving reports, you can disable the weekly report setting. Disconnecting Slack entirely will also disable reports. How Slack connection differs from other integrations Unlike your data integrations (Shopify, Facebook, Google, Klaviyo), the Slack connection: - Uses Slack's incoming webhook mechanism (not a full bot integration). - Only sends messages to the channel you selected -- it does not read your Slack messages or access other channels. - Does not create a data pipeline or sync data into Datadrew. Slack is an output channel, not a data source. Report format Reports are formatted using Slack Block Kit for clean, readable presentation. Each report includes: - Your store name and the reporting period dates. - Comparison period dates. - Metrics organized by group (Revenue, Ads, Website, Email). - A "View Your Dashboard" button linking to app.datadrew.io for deeper analysis. Metrics from integrations that are not connected will be automatically excluded from the report. Disconnecting To disconnect Slack: 1. Go to Settings > Integrations in Datadrew. 2. Find the Slack integration and click Disconnect. Disconnecting Slack will automatically disable weekly reports. You can reconnect at any time by repeating the setup process. Need help? Contact us at support@datadrew.io. Related articles - Setting up weekly Slack reports - Setting up weekly email reports - Managing and editing scheduled automations - How to connect Klaviyo Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Connecting Amazon Seller Partner

Datadrew supports connecting your Amazon Seller account through the Amazon Selling Partner (SP) API. This integration pulls your Amazon order, financial, and feedback data into Datadrew for unified e-commerce analytics alongside your Shopify store. Prerequisites - An active Amazon Seller Central account (Professional plan recommended). - An active Datadrew account with your Shopify store already connected. - Pop-ups enabled in your browser. Step-by-step connection 1. In Datadrew, go to Settings > Integrations. 2. Find the Amazon Seller card and click Connect. 3. You will be redirected to Amazon Seller Central's authorization page. 4. Sign in to your Amazon Seller Central account if prompted. 5. Amazon will ask you to authorize Datadrew to access your Selling Partner data. Review the permissions and click Authorize. 6. After authorization, you will be redirected back to Datadrew. The integration will be marked as connected. 7. Datadrew will detect your available Amazon marketplaces. Select the marketplace(s) you want to track. What data syncs Once connected, Datadrew syncs the following from your Amazon Seller account: - Orders -- Amazon order data including order IDs, status, dates, and totals. Synced incrementally based on the last update date. - Order items -- Line item details for each order including product information, quantities, and prices. - Seller feedback -- Customer feedback and ratings from your Amazon storefront. - Financial events -- Financial transaction data including fees, refunds, and settlements. - Financial event groups -- Grouped financial data for settlement periods. Marketplace support Datadrew currently connects to the North America (NA) Amazon marketplace endpoint, which covers: - Amazon.com (United States) - Amazon.ca (Canada) - Amazon.com.mx (Mexico) - Amazon.com.br (Brazil) Support for EU and Far East marketplace regions may be added in the future. What to expect after connecting - Initial sync imports your Amazon order history. This may take 30 minutes to several hours depending on your order volume. - Amazon data will be available to Drew AI for cross-platform analytics queries. - Ongoing syncs happen on the same schedule as your other integrations (daily for Starter, hourly for Pro). Disconnecting and reconnecting You can disconnect your Amazon Seller integration from Settings > Integrations. To reconnect, click Connect and complete the Amazon authorization again. You can also revoke Datadrew's access from your Amazon Seller Central under Apps > Manage Your Apps. Need help? Contact us at support@datadrew.io. Related articles - How to connect Amazon Seller - Connecting Google Search Console - Connecting multiple ad accounts - Understanding data sync and freshness Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Connecting Google Search Console

Connecting Google Search Console (GSC) to Datadrew lets Drew AI answer questions about your organic search performance -- keyword rankings, click-through rates, impressions, and more. This guide walks you through the connection process. Prerequisites - A Google account with Owner or Full user access to the Search Console property for your Shopify store's domain. - An active Datadrew account with your Shopify store already connected. - Pop-ups enabled in your browser. Step-by-step connection 1. In Datadrew, go to Settings > Integrations. 2. Find the Google Search Console card and click Connect. 3. A Google sign-in window will open. Sign in with the Google account that has access to your Search Console property. 4. Google will ask you to grant Datadrew read-only access to your Search Console data. Click Allow. 5. After authorization, you will be redirected back to Datadrew. 6. Datadrew will list all Search Console sites (properties) accessible with your credentials. Each property shows its site URL. 7. Select the property that corresponds to your Shopify store and click Confirm. How GSC data is used Unlike other integrations, Google Search Console data does not go through the our data pipeline data pipeline. Instead, it is accessed in real-time by Drew AI through the MCP gateway. This means: - Drew AI can answer live questions about your organic search performance. - You can ask about keyword rankings, search impressions, clicks, CTR, and average position. - Data is always fresh -- pulled directly from Google's API when you ask. What you can ask Drew AI With GSC connected, Drew AI supports questions like: - "What are my top organic keywords this month?" - "Which pages have the highest organic CTR?" - "Show me my search impressions trend for the last 90 days" - "What is my average position for [keyword]?" - "Compare my organic clicks this month vs. last month" Key metrics available | | | | | --- | --- | --- | | Metric | Definition | Why It Matters | | Impressions | Number of times your site appeared in Google search results. | Measures your organic visibility. More impressions mean more potential traffic. | | Clicks | Number of times users clicked through to your site from search results. | Your actual organic traffic from Google search. | | CTR | Click-through rate: clicks divided by impressions. | Indicates how compelling your search listings are. Improve titles and meta descriptions to boost CTR. | | Average Position | Your average ranking position in Google search results for a given query or page. | Lower numbers are better. Track position changes to measure SEO impact. | Disconnecting and reconnecting You can disconnect Google Search Console from Settings > Integrations. To reconnect, click Connect and complete the Google authorization again. Need help? Contact us at support@datadrew.io. Related articles - How to connect Google Search Console - Connecting multiple ad accounts - Understanding data sync and freshness - Connecting Amazon Seller Partner Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026