ahmaddiaa
6 months agoActive Member
Parsing .txt from API "Export Users By Segment"
Hello Everyone!
I manage a daily newsletter. To measure user engagement, we categorize users by how many emails they open per week.
I'm facing trouble using the export file from "Export Users By Segment" API endpoint. here is my workflow:
- export "External_id" and " campaigns_received" fields from the recipient segment.
- for each External_id, check how of last week's emails are "opened"
- throw that data into my python script to graph the % of users who open emails 5, 4, 3, 2, 1 times a week.
How can i parse the exported user details to look readable, like the sample braze response? this will make it tons easier to understand and therefore work with the data.
Here is what the (dummy) data looks like
vs what i want it to look like:Thanks a lot!!