Add value for Google ads
Status: Open · Asked by elhanan cohen on · 0 views
I receive from Google Ads separate results for each campaign and for each device from which users surf. I am trying to add all the values. Does anyone have an idea?
I can use the code but need to somehow catch all the output from the previous step.
Hi @elhanan cohen,
Please try using Number Formatter: Perform Math Operation function for adding the values.
thanks!
I searched dynamic functions because I run the zap on some Google ads accounts, so the number of the same fields is not static.
Please share the Workflow URL in which you have this use case.
The workflow is like this:
Every 8 hours the workflow runs.
It pulls all the records from Airtable, including the access details to my advertising accounts.
There is a counter that actually runs a different account each time for checking (in the case of 3 accounts - first line 1, second line 2, third line 3, and again. According to the number of advertising accounts).
At this point, I go to Google Ads Results and request the ad results of the ad account that the workflow is currently handling.
The problem is that Google Ads results are split into campaigns and browsing methods, and I want to consolidate everything according to the fields (once CPC, once conversions, etc.).
Please check out this thread and the workflow shared at the end.
https://forum.pabbly.com/threads/how-can-i-get-the-amount-spent-on-google-campaigns.14312/post-71932
Thank you!
but I don't receive the same same. he received one result, I received 30 results.
It splits the text. 
If I could do exactly the opposite - plug it in and work on it with JS that would be great.
You have to disable the Simple Response, then click on 'Save & Send Test Request'.