Question
i'm own an e-commerce company with a subscription product. We have customer purchase and behavior data stored in S3, EC2, and AWS database.
We also have other data sources we want to combine: multiple merchant accounts, google ads, facebook ads, Google analytics, Google sheets, video analytics, zendesk, amazon connect, email marketing data, quickbooks, appended data, etc
I want to move it to a place (athena, redshift, bigquery + data studio?) were we can pull the data, merge data sources together, and start to analyze it.
Any suggestions on what would be the best choice for my use case?
Answer
Best Choice will be BigQuery + Looker Studio (Data Studio)
Why?
• Super easy to connect to Google Ads, Facebook, Google Analytics, Sheets, etc.
• Natively works with Looker Studio (formerly Data Studio) for reporting.
• Can ingest files from AWS S3, Google Sheets, or APIs.
• Serverless — no infra management.
• Scales well, pricing is based on what you query.
