Question

Segment Data Export not containing specific field

  • 28 February 2023
  • 5 replies
  • 31 views
V

Whenever I try to create Segments Data Export as shown in above image based on experience filter, by clicking on Create Export , the exported JSON file doesn’t contain experience field. How can this be acheived?

Also, is it possible to aggregate data based on custom property like experience ? If yes then how

5 replies

lindsay
Rank
Userlevel 4
Badge

Hi @vinodg006! Thanks so much for your question! 😊

From looking at the screenshot you provided, there’s a few things that come to mind that may be affecting the export here:

  1. First I’d double check that when you’re exporting the data, please ensure you are selecting “Events” type export:

    If you select “Events”, it will contain “EventVars” field that should have the properties you’re looking for! 

  2. If that doesn’t resolve the issue, I would like to take a closer look at “experience (string) - is set”. I am curious if the “is set” search criteria is returning the value you’re looking for. In order to look into this, I would send this over to support where they take a closer look and discuss the data you’re hoping to return here.

Please let me know if you’re still having issues after double checking the “Events” export type and we can send this off to support! 

 

Lindsay- Community Manager
V

@lindsay Thanks for the solution, it gave desired exported file.

But my other question is still unanswered

Is it possible to aggregate data based on custom event property like experience ? If yes then how

I need to achieve same result as we get in Metrics “Group By” in Segments also

 

Also one other question related to event data that I get, does event data means clicks and mouse movement also or only custom event data like in image?

 

lindsay
Rank
Userlevel 4
Badge

Hey @vinodg006! Thank you for your response! 

I’m glad the solution worked for your export! I’m so sorry I missed the second part of your question. 

If you’re hoping to aggregate the ‘experience’ custom event property in your export, I’m afraid that is not possible. You would need to use a data analyst or BI tool, or have some expertise in Excel/Google Sheet to form a calculation to find the sum of each of those 'experience' custom event properties. Something you are able to do however, is export the dimensionality metric by saving it to a dashboard, and then exporting it from the dashboard. 

As for your second question, events can be so much more than custom events! You can see a full overview of the user/event filters available to you here. 

Please let me know if you have any other questions! 

Lindsay- Community Manager
V

@lindsay Thanks for your solution for Dashboard Export as CSV option, it is giving desired output, but the data is limited to only 50 values, wanted to know

  1. If somehow can get all metric data exported via this Dashboard Export?
  2. Is their any API for this dashboard export available?
  3. How can I export Segment Events Export data, which will contain only desired columns, like I am only interested in getting EventVars and EventCustomName in exported file?
lindsay
Rank
Userlevel 4
Badge

Hey @vinodg006! I’m glad that solution worked out for you!

Thank you for those followup questions! 

  1. I’m afraid that you are not able to export more than the top 50 results of the dimensionality metric. This is a common feature request that our teams are aware of!
  2. You can export data within the FullStory UI as a CSV, JSON, or NDJSON file using one of our Search Exports or take advantage of our Data Export API endpoints (Using Segment Export API and Retrieving Data Export Extracts API). 
  3. Unfortunately, adjusting the fields in Data Export or Segment Export (either adding or removing) is not possible as these exports are meant to be raw data dumps. 

I hope this helps and I hope you have a great weekend! 😊

 

Lindsay- Community Manager

Reply


Terms & ConditionsCookie settings