The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.
TypeScript clickhousemysqlnextjsopen-sourceplanetscaleprismatailwindcsstinybirdtypescriptupstashvercel
TAGS "Dub Misc Endpoints"
NODE coordinates_clicks_data
SQL >
%
SELECT
'click' AS event,
timestamp,
country,
city,
latitude,
longitude,
device
FROM dub_click_events_mv
WHERE
timestamp > now() - INTERVAL 5 MINUTE
AND country != 'Unknown' AND city != 'Unknown' AND city != 'Ashburn'
ORDER BY timestamp DESC
LIMIT 100
NODE coordinates_leads_data
SQL >
%
SELECT
'lead' AS event,
timestamp,
country,
city,
latitude,
longitude,
device
FROM dub_lead_events_mv
WHERE
timestamp > now() - INTERVAL 12 HOUR
AND country != 'Unknown'
AND city != 'Unknown'
AND city != 'Ashburn'
ORDER BY timestamp DESC
LIMIT 100
NODE coordinates_sales_data
SQL >
%
SELECT
'sale' AS event,
timestamp,
country,
city,
latitude,
longitude,
device,
amount
FROM dub_sale_events_mv
WHERE
timestamp > now() - INTERVAL 12 HOUR
AND country != 'Unknown'
AND city != 'Unknown'
AND city != 'Ashburn'
ORDER BY timestamp DESC
LIMIT 100
NODE endpoint
SQL >
%
SELECT *
FROM
(
SELECT *, NULL AS amount
FROM coordinates_leads_data
UNION ALL
SELECT *, NULL AS amount
FROM coordinates_clicks_data
UNION ALL
SELECT *
FROM coordinates_sales_data
)
ORDER BY
timestamp DESC
TYPE ENDPOINT