Hey, I am getting data from my facebook ads account, and Stripe.
I have so far got all the data from facebook ads with each specific date, alongwith ad spend.
Now I want to retrieve the data from stripe, for each date, with the user paid amount.
Now please tell me, how can it been done, like which module I should use for this?
And I also want to to calculate ROAS, by dividing User Paid Amount/Ad Spend
I am using make for my automation
Hey @David_Czapor
You can get it like below:
For ad spend, you can use “list payment intents” module
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Hi, Thank you for quick response, I really appreciate that
Actually using set variable module doesn’t help. I just waana get total amount paid for each user by each date
For example if there were 5 individual users, who paid via Stripe
Then I waana sum up all that 5 amounts, and put it along that specific date in google sheet
Just assume it like this
30-11-2024 85000 (Summing up all the amounts for that specific date)
29-11-2024 90000 (Summing up all the amounts for that specific date)
…
…
I hope it helps you understand much better
Hey @David_Czapor
We didn’t suggest to use set variable. We actually wanted to draw your attention on the variables. To get your results, you can use aggregator after “search invoices” module and group by date.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Thanks for your response. I am using numeric aggregator module, and its grouping by date.
Now I am using stripe module, with Facebook module, but the problem is that I am getting ad spend for each date from Facebook, but when it comes to stripe its only sending the data for one single date, and repeats the same value.
Basically I also want to get data from Stripe for each date, as I am getting from facebook
Can you help me with this?
@samliew
There are 5 entries in your facebook module, hence, it is running all next modules 5 times. You need to aggregate results from facebook before running next module. This will prevent repeatedly running the next module for same data.
Next, to help you to correct mappings, please share the screenshot of what you have mapped in stripe module.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
This is my stripe module , and this is the numeric aggregator module screenshoot
I am sharing the screenshot for the stripe output
Its basically 5 operations, and all of them have same date 4 September
You have hardcoded the dates inside stripe module, that’s why its working for same data everytime. if you are using facebook module to get the dates, you should map the dates from facebook module then. if there is only one record per date in facebook module, then you do not need to aggregate data from facebook. If there are multiple for same date, then you need to aggregate.
get insights from facebook > search invoices (map date from facebook and do not format if you are using date operator. formatted date will only work with text operator > numeric aggregator > add a row in google sheet.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Thank you so much, Its finally working now
I am seeing different values for each date, alongwith Adspend from facebook
Now I want to sum the values from Stripe, whereas Its not doing this.
Also, I want it ,to update the google sheet with “0”, if there was no transaction at that particular date
In numeric aggregator, select the “target structure type” as “facebook” module. then you will be able to sum the values. For no transaction, use ifempty() function.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Its not working, after I set the target structure to Facebook module
Its giving the same output, can you give me another solution to this?
In the numeric aggregator module, the Date Start variable is taken from Faceook Insights module, and in Value, Amount Paid is taken from Stripe module
Could you please share the output bundle json from stripe module??? We will sort this out for you and share the solution.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
I have shared the json output bundle, from stripe module in a txt file.
I have shared it with you in a message, please take a look at it.
And also I want to format my numbers too
For example my client is from Europe, so in europe people normally use “,”
like this 8976,78
And in american style 8976.78
So i want my number to be in this format, where “.” must be replaced by “,” and google sheet must consider it as a number.
I have tried using format number, but then whenever I use “,”
Google sheet does not consider it as a number
