Analysis tool needed for Facebook and Google Ads

premmels
New Member
5 0 0

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:

Screenshot from 2021-03-04 09-49-20.png

And another example on how a monthly overview could lok like for one product:

Screenshot from 2021-03-04 09-53-11.png

Does anyone have a suggestion for a tool/solution that will automate this analysis?

Thanks,
Patrick

0 Likes
premmels
New Member
5 0 0

Any ideas?

0 Likes

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:

 

Screenshot 2021-03-05 at 15.00.07.png

And you also have the ability to customise and create your own reports, so that you can build the exact table you need
Screenshot 2021-03-05 at 15.01.06.png

Happy to help: link to the app is here: https://apps.shopify.com/polar-analytics and website https://polaranalytics.co/

 

 

Polar Analytics Team
Multichannel analytics software, no engineering required.
Try free for 14 days here: https://www.polaranalytics.co
0 Likes