Hello everyone, I’m new to Coda and I’m trying to organize some items but I’m having trouble. Below are the two cases I can’t solve:
Case 1) List of websites separated by commas
When connecting with my Google Search Console account and using the “Sites()” formula, it returns something like:
Text displayed on the screen:
https//:site1.com, https//:site2com, sc-domain:site3.com, https//:site4com
And the data structure is:
{"Url":"https//:site1.com"},{"Url":"https//:site2com"},{"Url":"sc-domain:eqseed.com"},{"Url":"sc-domain:site3.com"},{"Url":"https//:site4com"}
If I try to put this into a table, it occupies a single row:
Row 1: https//:site1.com, https//:site2com, sc-domain:site3.com, https//:site4com
I would like it to return each website in a separate row. Something like:
Property
Row 1: https//:site1.com
Row 2: https//:site2com
Row 3: sc-domain:site3.com
Row 4: https//:site4com
Case 2) Metrics of websites with different separators
When using the “SiteaAnalytics” formula:
[Google Search Console]::SiteAnalytics([myaccount],"sc-domain:site3.com",Today()-7,Today()-1)
The text displayed on the screen is:
123,456 clicks/9,876,543 impressions, 5.61% CTR
And the data structure is:
{"Summary":"123,456 clicks/9,876,543 impressions, 1.23% CTR","Clicks":123456,"Impressions":9876543,"ClickThroughRate":{"type":"per","value":0.0561},"Position":8.14}
In this second case, I also want to display each metric in a separate column instead of a single block. It would be even better if in the initial column I could retrieve the property and apply the “SiteAnalytics” formula to obtain the data for each row in the table that has the property.