Export Data from activity logs

  • 15 October 2023
  • 1 reply
  • 176 views

 

Introduction

 

At times, it may be necessary to analyze the user activity logs outside the Customer.io environment. Doing so can offer greater flexibility, especially when using other applications for detailed data analysis purposes. Although directly exporting the logs is not available, there are alternatives that can be quite effective.

 

Problem

An issue arose on the necessity to export a CSV from the activity logs within Customer.io, with the goal of tracking and analyzing user activity on a platform. There was also an inquiry about the possibility of sending user events other than email opens and clicks to another app.

 

Solution

Here is the response to this question from our Support team:

Getting right into your concern here, I’m afraid there’s no way to export data from the Activity Log. We have an open request for a feature like this that our team is tracking feedback on and I have upvoted it on your behalf so that our Product team knows this is something that would be useful to you.

In the meantime, an alternative to get these attribute changes would be to use our API /listActivities endpoint. To get the data you need, you (or your developers) can make a GET request to the /listActivities endpoint. You can then add query parameters to pull the desired data (e.g. ''attribute change'').

Once you make this call, our system will return a response formatted as JSON, which can then be saved for your records. By default, we'll only return the first 10 results, so you can add another query parameter for "limit" to increase the number of results and/or use the "steps" parameter to paginate to the next group of results. You'll be able to see more details about this API endpoint by viewing our documentation here: https://customer.io/docs/api/#operation/listActivities

As for your other question, you can explore the option of integrating Reporting Webhooks. Reporting Webhooks send real-time message activity events (e.g. sends, opens, clicks) as JSON in an HTTP POST. They’re useful in many cases, including analyzing message activity outside of Customer.io.

You can learn more about it here: https://customer.io/docs/journeys/webhooks/.

 


1 reply

I would like to hereby upvote this as well!  When running a filter on the Activity Logs screen, it would be extremely convenient to be able to export those in the same way we can export queries from the People screen.

Reply