Hi guys,
I'm looking for an analysis tool that allows me to merge the data from
- shopify orders
- Facebook Ads
- Google Ads
- (optional: Google Analytics)
- (optional: Amazon FBA)
My goal is to get both a day to day (in form of a table) as well as a monthly (could be in form of diagrams) overview of
- spendings on Facebook Ads and Google Ads
- revenue from sales resulting from Facebook, Google or organically (i.e. not from an ad)
- earnings from Facebook, Google or organically (revenue - spendings - other costs like product costs or shipping)
- ROAS/ROI for Google and Facebook Ads
- number of orders from Facebook, Google or organically
- quantity of sold products from Facebook, Google or organically
All this data should be possible to filter by each product as well as a summary of all products.
Here's an example on how a table could look like in the daily view for one product:
And another example on how a monthly overview could lok like for one product:
Does anyone have a suggestion for a tool/solution that will automate this analysis?
Thanks,
Patrick
Hi @premmels,
This is exactly what you will find on Polar Analytics. In just one click, you can connect your Shopify Store, Facebook Ads, Google Ads, Google Analytics and 15+ other connectors. Data will get stored, aggregated and refreshed every day -
And directly within the app, you can access a broad range of ready-made reports and templates on CAC, LTV, ROAS and more:
And you also have the ability to customise and create your own reports, so that you can build the exact table you need
Happy to help: link to the app is here: https://apps.shopify.com/polar-analytics and website https://polaranalytics.co/
