Bitly Profiledat Better -

: Data entities in modern APIs (like Bitly's v4 API) frequently use fields like profiledAt

SELECT profiledat->>'country' AS country, profiledat->>'device_type' AS device_type, COUNT(*) AS clicks FROM bitly_click_logs WHERE click_date = '2025-04-01' GROUP BY 1, 2 ORDER BY clicks DESC; bitly profiledat

The original URL, the shortened URL, and the date/time of creation. Engagement Data: Clicks, views, and interactions with Bitly links/QR codes. : Data entities in modern APIs (like Bitly's