I am having a problem and none of the support material seems to address the issue in a manner I can understand.
I would like to:
- Read from Google Analytics 4 the Active User metric for each month of the year.
- Write the value to a table in Zoho Analytics
I have done this on a single month basis repeated for every month of the year. Eg read May-23 value, write May-23 value, read June-23 value, etc. Very frustrating because first it is dumb, but second I cannot write a zap for a month that does not yet exist. So I have to update the Zap at the start of the each month for the new month.
What I can do is read monthly data for all months in the year. This gives me the data month by month. Then I use a Zap loop and it converts the data to look like:
01,02,03…12
1000,1500,2000…1400
Where the first line is the month number (e.g. 1 is January) and the second line is the data (e.g. 1000 active users in January).
All good so far. But now I want to write to the database. I add Zoho Analytics to the loop (there is a shadow box around the widget).
My expectation is we will loop through the data like this:
First iteration
01
1000
Second iteration
02
1500
Etc
Instead the widget is presented with:
01,02,03…12
1000,1500,2000…1400
There is no looping. It treats the loop step as though it is completed before it calls the next processing step.
Not sure what I am missing.
Kind regards,
Alex
