Here you  go... trying to match e3 Adobe workspace count 465,  but getting 538..SELECTSUM(CASE WHEN (Post_Event_List_Text LIKE '%,202,%' AND Post_Event_List_Text LIKE '%,1,%' AND Post_cart_abandonment_campaign_eVar13 ='Cart Abandonment campaign') THEN 1 ELSE 0 END) as e3 FROM    table-name-maskedWHE...

Thanks @Jennifer_Dungan  for your prompt response. I have been to those sites & have used it. However, still my SQL query is not giving the desired output.

Hi All, I am trying to create a visit segment to filter out visit having event3(,202,), event 35(,234,) and eVar13 exist. @Jen

Thanks @leocwlau ,  We don't see  visid_high, post_visid_low, visit_num, visit_start_time_gmtfrom data feed raw data file,  however we have"Post_Vis_High_Identifier,    Post_Vis_Low_Identifier,    Visit_Number,    Visit_Start_Gmt_Timestamp"  so I am using the same.  This giving me ...

Hi Team, Can you please help me Creating Visit Level segment for Data feed raw data? for instance:  Segment visits having eVar9 = "campaign"

Hi @yuhuisg , Yes, its from SQL,  we have setup  Data feed data flow into internal Data server for marrying Adobe data with 3rd party data. For the first time we saw "String" value in "Last_Purchase_Number"

Hi Team,Last_Purchase_Number is a auto generated metric based on customer order frequency. And Implementation guy has no control over it.  However, for the first we are seeing   Last_Purchase_Number  is paasing "String" value due to which our data processing system is broken. Is anybody faced this s...

However, we can't play much in other editor than Excel.. any better way.. please suggest..

Hi Team,,, Yesterday I received raw data from Data feed in zip format. After extracting it, when I opened the file seeing "event_list" column is getting converted into "##########". not able to understand the content behind it. Please suggest here how to extract data from "############"