country_clicks = df['countries'].apply(lambda x: eval(x)).apply(pd.Series).sum()
Bitly shortens URLs and provides link management, click analytics, and user profile/account metadata. "ProfileData" refers to the user/account metadata Bitly associates with an account and exposes via its web interface and API endpoints. ProfileData is used for personalization, analytics, and administration.
Use the GET /v4/bitlinks/bitlink/clicks endpoint to retrieve raw click data. Example request:
curl -X GET "https://api-ssl.bitly.com/v4/bitlinks/bit.ly/example/clicks?unit=day&units=30" \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"
Response includes timestamps, referrers, and geolocation data suitable for feeding into a data warehouse or BI tool like Tableau, Power BI, or Google Looker Studio.
| Method | How to Access |
|--------|----------------|
| Bitly Dashboard | Click on any short link → “Stats” or “Export” (CSV) |
| Bitly API | GET /v4/bitlinks/bitlink/clicks and /countries, etc. |
| Bulk Export | Enterprise plans offer full account exports via support. |
| Legacy profile.dat | No longer used in modern Bitly; replaced by structured JSON/CSV exports. |
Only if you are on an enterprise plan and have enabled “detailed click tracking” in your group settings. Otherwise, the field returns null.
You share the same link on LinkedIn, Reddit, and WhatsApp. Profile data shows Reddit drives the most clicks but LinkedIn drives the longest average session duration (via integrated UTM). You reallocate budget accordingly.
Bitly organizes profile data into three main tiers depending on your account plan: