In this blog I will be summarising my research into a data strategy solution for an e-commerce company.

A data strategy is not just about collecting data. It’s putting in place certain processes and structures to guide the way a business uses data.

Asking the right questions.

• What are your business goals?
  • Move to a more data-driven business
  • Automate data processing to save time
  • Improve consistency in reporting – using a s single source of data truth
• What data do you need?
  • For an ecommerce brand
    • Affiliate: AWIN
    • E-commerce: Shopify, woocommerce, Amazon Selling Partner, Amazon Ads, Google Merchant Center
    • Email: Klaviyo, Active Campaign
    • Search: Google Adwords, Google Search Console, Bing Ads, Google Trends
    • Social: Facebook Ads, Facebook Pages, TikTok, Instagram, LinkedIn, Pinterest
    • Tracking: Analytics
• What is the best place to store it?
  • There are two main options here; data lakes or data warehouses. Both solve the same problem – a safe and accessible way to store data. Data warehouses are specifically designed to hold structured, processed data. This allows for much faster analysis. However for that exact reason data warehouses are less flexible than data lakes. Data lakes accommodates for both structured and unstructured data hence being move flexible.
• What Kind of software do you need for its analysis?
  • An ETL tool can be used to extract, transform and load data sources. Pulling data from source data is an easy job. There are many tools that do that for you.