Overview

You can run this workflow for ==free== on Pipedream. It's a potential solution for this post on Reddit

Getting Started

1. Fork this workflow
2. Send HTTP requests to the URL provided by Pipedream -- add the name of the button you want to track to a query string parameter named button. E.g.,

https://xxxxx.m.pipedream.net?button=your-button-name

1. Run SQL queries to analyze your data (see sample query below)

How it Works

Pipedream provides an always-on URL to trigger Node.js workflows (and the data posted to the URL or sent on the query string can be referenced in the triggered code). Your workflow will run every time you make a request to the URL provided by Pipedream and will:

1. Capture HTTP requests
2. Use Node.js to construct an object with the event time and button name (passed in the query string)
3. Sends that object to Pipedream's SQL service, which will automatically detect the schema and create a table

You can then query the data sent to the SQL service (just select the SQL tab to the left — it can take up to 1-minute for your data to be ready to query after your workflow runs). Here's an example based on the object.

Try this SQL Query

SELECT 
  year(from_iso8601_timestamp(timestamp)) as year, 
  month(from_iso8601_timestamp(timestamp)) as month,
  day(from_iso8601_timestamp(timestamp)) as day,
  button as buttonName,
  count(button)
FROM 
  buttonclicks
GROUP BY 
  year(from_iso8601_timestamp(timestamp)), 
  month(from_iso8601_timestamp(timestamp)),
  day(from_iso8601_timestamp(timestamp)),
  button

Next Steps

Try modifying the code and workflow, and let us know if you have any feedback! You can contact us at support@pipedream.com or on Spectrum (just click the Community link in the header).

About Pipedream

Pipedream is an automation platform for developers. Build and run any workflow, based on any trigger, with no infrastructure.
Iterate quickly with built-in observability, automatic versioning and instant deploys.