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.
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 @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...
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 "############"