Expand my Community achievements bar.

Last_Purchase_Number metric contains "String" value

Avatar

Level 3

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 situation? any help will be greatly appreciated. 

Note: in the screen shot, "abcdefg" is the masked data, however it's a string value got passed.

DineshRkumar_0-1716537325581.png

 

3 Replies

Avatar

Community Advisor

Your screenshot doesn't look like it was taken from any Adobe Analytics interface (Analysis Workspace, Data Warehouse, Data Feeds, etc.) It's showing a SQL statement, which Adobe Analytics doesn't support.

Can you please provide more information about the system that you're using? And also how you are collecting your data?

Avatar

Level 3

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"

Avatar

Community Advisor

If you're getting the data from Data Feed, then the values are exactly as they have been tracked to Adobe Analytics. In that case, this sounds like an implementation problem that you should discuss with your analytics implementation person.