Good evening.
I have this requirement but do not know how to act.
A suggestion would be very helpful please.
I have a Google Sheet in which I now manually enter monthly WooCommerce sales data and monthly Adv costs from both Meta Ads and Google Ads (to quickly know what the difference is between site revenue and adv costs):
1 - The two WooCommerce data that I am interested in are (accessible on WordPress via Analytics/Revenue menu):
- monthly Net sales;
- monthly Total sales.
2 - of Google Ads data, I am interested in the monthly Total account Cost field;
3 - of Meta Ads data, I am interested in the monthly Total Spent value.
What I would like is for the Google Sheet file to automatically compile with these 4 values extrapolated from WooCommerce, Google Ads and Meta Ads.
Do you have any ideas, please? Is it possible to automate this data entry in some way?
Many thanks.
