Analyze your Squarespace orders data

Selling products on the web is the first step, but as the orders start rolling in you'll soon want to start engaging with customers and crunching data. That's where Parabola comes in. Our Pull from an API step works with all of the ecommerce storefronts mentioned above, and makes it easy to analyze, act and react based on things that happen in your store. This example shows how to pull orders data from Squarespace, manipulate it, and send it somewhere else, like Google Sheets.

Analyze your Squarespace orders data

Getting your order data into Parabola

Our Pull from an API step works with a huge variety of e-commerce platforms; the hard part is just finding the documentation and getting connected. In this example we demonstrate connecting to the Squarespace Commerce API.

The Squarespace Commerce API is pretty easy to use. We drag out a Our Pull from an API step and plug in the appropriate url: https://api.squarespace.com/1.0/commerce/orders. Next you'll need to create an API key by following the instructions on this page. You use this API key in Parabola by creating clicking 'Add Custom Header.' The header key is 'Authorization', and the header value is 'Bearer YOUR_TOKEN.'

Manipulating order data in Parabola

Now that you've got your order data in, it's time for the fun part! This simple example just shows how to filter for orders that are 'pending' in Squarespace, but Parabola's breadth of steps enable you to build practically any custom logic you can think of:

  • Want to aggregate transactions per product?
  • Find your most profitable customers and set up a custom email engagement campaign?
  • Calculate growth rate since your store launched?
  • Send weekly summary emails to others in your business?

Once your data is in Parabola, the sky is the limit. If you have an idea for something crazy you should reach out to us on Intercom. We've seen a lot of requests come through and can share some wisdom.

I need to make an API request for each order

A quick detour here - what if you needed make an API call once for every order that has come in the last seven days? Parabola's Enrich with an API step lets you do just that: call a third party API once for each row of data.

So let's say you wanted to find out a bit more about each of your new customers by passing their email addresses to a service like Clearbit. You'd need to sign up for an account and follow the instructions here to get started, but once you've done that Parabola can take care of the rest.

You'll want to drag out a new Enrich with an API step, and pop in the Clearbit URL:

https://person.clearbit.com/v1/people/email/{customerEmail}

Note the curly braces around customerEmail? That means Parabola will substitute whatever value is in the column of that name as it makes each request. We'll iterate through every row in your dataset, ask Clearbit for info on the customer, and add the response on as additional columns in your dataset.