Cointelegraph: Bitcoin, Ethereum, Crypto News (340K)
Contains personal information related to email campaigns, sign-ups, and engagement tracking for users. Below is an overview of the key fields:
Key Data Fields:
- Email Address: The user’s email address.
- First Name: First name of the participant (empty in the provided data).
- Last Name: Last name of the participant (empty in the provided data).
- MEMBER_RATING: Likely the rating based on the user's engagement or activity.
- OPTIN_TIME: The time when the user opted into the campaign.
- OPTIN_IP: The IP address from which the user opted in.
- CONFIRM_TIME: The time when the user confirmed their opt-in.
- CONFIRM_IP: The IP address from which the confirmation was received.
- LATITUDE: Latitude of the user's location.
- LONGITUDE: Longitude of the user's location.
- GMTOFF: The offset from GMT at the user’s location.
- DSTOFF: The daylight saving time offset at the user’s location.
- TIMEZONE: The user's time zone.
- CC: The user's country code.
- REGION: The user's region code (e.g., a city or state).
- CLEAN_TIME: When the user data was last "cleaned" or updated.
- CLEAN_CAMPAIGN_TITLE: The name or title of the campaign in which the user was engaged.
- CLEAN_CAMPAIGN_ID: An ID associated with the specific campaign.
- LEID: A unique identifier for the user’s record in the system.
- EUID: Another unique identifier for the user's engagement.
- NOTES: Additional notes on the user’s participation (this field may be empty or include information on campaign activity).
- TAGS: Campaign-specific tags, possibly detailing which campaigns the user engaged with or was part of.
Sample Breakdown:
- Email: swilson@amelco.co.uk
- Member Rating: 1
- Opt-in Time: 2018-10-01 11:24:15
- Latitude/Longitude: 51.5128000, -0.0947580
- Country Code: UK
- Region: LND (London)
- Clean Campaign Title: "Charlie Lee: Next Month’s Halving Will Be a ‘Shock’ to Litecoin Mining, BTC Broke Out of the $12,500, but Did Not Manage to Sustain It, & Other News"
- Last Changed: 2019-07-10 18:34:07
- Email: kaniginufij168@gmail.com
- Member Rating: 1
- Opt-in Time: 2022-01-01 17:41:38
- Latitude/Longitude: 48.4600000, 35.0200000
- Country Code: UA (Ukraine)
- Region: Zaporozhye
- Clean Campaign Title: "Bitcoin dips below $47K as US dollar surge dampens BTC price performance, & Other News"
- Last Changed: 2022-01-03 18:24:04
- Email: f.r.a.ncis.henry19.64@gmail.com
- Member Rating: 1
- Opt-in Time: 2019-12-23 14:10:36
- Clean Campaign Title: "Binance Jersey shuts operations less than two years after launch, & Other News"
- Notes: Includes campaign segments tagged by dates in 2020, possibly referring to multiple campaign activities or interactions.