Custom analysis and actions for order data

There are a variety of options out there for small businesses looking to put their products on the internet for the first time. Shopify is the obvious heavyweight, but there are other folks in the ring too: Squarespace, Wix, Square, Weebly, and Webflow all come to mind.

Getting products out there on the web is an achievement in its own right, but as the orders start rolling in you'll want to take the next step: engaging with customers and crunching data. That's where Parabola comes in. Our generic API connector steps work 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.

It's time to take your ecommerce business to the next level with Parabola!

Get Started With This Template >
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 API Enrichment 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 API Enrichment step, and pop in the Clearbit URL:{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.

Getting your order data into Parabola

The first, and sometimes most difficult step, is getting your data into Parabola. Don't worry, we're here to help, and the smart money says you're going to be successful.

Our generic API connector 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, but you can click here to find a template for connecting to your preferred provider.

The Squarespace Commerce API is pretty easy to use. We drag out an API Import step and plug in the appropriate url: 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 transformations 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.

Send your data somewhere else

Once you've summarized, aggregated, or just inspected your order data, you might want to send it on to another destination for visualization, record keeping, or some other purpose. We've got you covered.

We made it as easy to get data out of Parabola as it is to get data in. We're directly connected to fifteen external services (and also CSV + Excel downloads), but again the power lies in our generic API Export. If the service you want to export to supports a REST API, you can probably put your data there.

If you run into any trouble please reach out to us on Intercom (the chat thing on our site). We're always happy to help!

Get Started With This Template >
Start automating with Parabola
Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.