We sell digital products called through shopify. Some products are made in collaboration with people who will receive a royalty.
We advertise these products on facebook ads, and have dedicated adset/campaign names assigned to each product. This way we can easily track adspend per product.
What we do now:
- we manually track facebook ad spend per product and add it into our spreadsheet
- we manually track transaction fees, payout fees & VAT from shopify, and add it into our spreadsheet
- we manually track gross revenue / orders per product, and add it into our spreadsheet
What we want to do:
- automatically track orders from shopify → fetch VATtax amount / country code / gross revenue etc
- automatically track adspend per product via campaign/adspent level
- automatically track payout fees, transactions fees
- put all this information into 1 spreadsheet, where we will run our setup. We will need to streamline this with your method of setting up the flow. Only that way we can make sure we have a 100% waterproof flow.
Would love to hop in a call and explain of this in detail.
Hello @Jimmake, welcome to the make Hire a pro section , I would love to work with you on this, you can book a call Here to discuss the project requirements and you can checkout my upwork profile Here
Hey @Jimmake,
Since the main scope of your project is the right data tracking for your profits per sale for each product, the most important thing is to correctly structure your data in sheets.
If you work with Google Sheets, I would recommend using a separate sheet per object like the following:
- Shopify transaction report
- Facebook spends
- Pivot table combining data from both tables aggregated on product level/ Sale level/ monthly level
Make already has integration with shopify to get all required details from your sales including the royalty details if they are tracked in there. Using G=Facebook ads modules you can get details per add which you can collect them frequently like every X hours. Then you run your calculations or even use Google Looker Studio for data intelligence.
Based on your workload and the rest of the operations, it may be worth thinking about a database solution with a low cost for your business that can centralize your data in one place. For example, Airtable is one solution like this.
I am doing co-building sessions where we build your live system and integrations together. This helps to get the solution done during the call and make progress for your business on the same day. Since we work together, you get to know how your system actually works and how you can update the settings of your own system, so later you can make improvements by yourself.
Happy to schedule a 30-min conversation with no commitment to share my suggestions on your project. Here is my calendar link: https://cal.com/dimitrisgoudis/meet-dimitris
Thanks
Yours sincerely,
Dimitris Goudis | 3Nuggets.io
Hi, As an automation expert with 8 years of experience, I specialize in streamlining workflows using Make.com. I can set up a fully automated system to pull order data, VAT, country codes, revenue, ad spend, and transaction fees from Shopify and Facebook Ads, and send everything into a centralized Google Sheet. This will eliminate your manual work and ensure a reliable, real-time, and accurate tracking process for each product. I’m confident I can build a solid and scalable flow tailored to your setup.
You can book a 30-minute call with me here: [https://calendly.com/farhan-aviary1103].
For more details, feel free to check my profile: [https://www.upwork.com/freelancers/farhana401].
