Add value for Google ads

[elhanan cohen]

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.

 

[ArshilAhmad]

Hi @elhanan cohen,

Please try using Number Formatter: Perform Math Operation function for adding the values.

 

[elhanan cohen]

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.

 

[ArshilAhmad]

Please share the Workflow URL in which you have this use case.

 

[elhanan cohen]

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

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.).

 

[ArshilAhmad]

Please check out this thread and the workflow shared at the end.

How can I get the amount spent on google campaigns?

i need to know how much was spent on my google ads ad account. how can a get that?

forum.pabbly.com

 

[elhanan cohen]

Thank you!
but I don't receive the same same. he received one result, I received 30 results.

 

[elhanan cohen]

It splits the text.

If I could do exactly the opposite - plug it in and work on it with JS that would be great.

 

[ArshilAhmad]

You have to disable the Simple Response, then click on 'Save & Send Test Request'.