How do I pull Organic Sessions (non-customers) to Klipfolio using an API call?

contacts

#1

Hello fellow Developers!

I've run into a problem... My Klipfolio 'Klip' showing Organic Sessions (non-customers) 'broke down' in March. The reason being that our Google Analytics setup was tampered with.

So is it possible to pull in Organic Sessions (from non customers, segmented on a visit to a specific URL) to Klipfolio using an API call? I want to build a Year-to-Date overview, and have it automatically pull in new data every x min.

I have step 1 down: that is, Create Data Source in Klipfolio. But how do I phrase the query?

(The query on the image is the standard query prompted by Klipfolio when creating a new data source)

Thank you

!