Ecommerce tracking data not populating

Hi,

The data is getting populated in the data layer, but is not getting populated in the snowplow tables.
My snowplow config for enhanced ecommerce is correct, what can be the other reason for the non pulation of data?

@Manav_Veer_Gulati, if you are certain the data is sent to the collector than the data might have failed validation during the enrichment step. Depending on your pipeline setup you need to examine your bad data.

2 Likes

@ihor
I checked but I’m not able to get that the dat type error is in which field

   `{
"line": "2019-06-25\t17:00:01\tTXL52-C1\t368\t62.156.2.18\tGET\td1qkeqs71ytz4c.cloudfront.net\t/i\t200\thttps://www.grover.com/de-de/featured/deals\tMozilla/5.0%2520(Macintosh;%2520Intel%2520Mac%2520OS%2520X%252010.10;%2520rv:67.0)%2520Gecko/20100101%2520Firefox/67.0\tstm=1561482005614&e=ue&ue_pr=%257B%2522schema%2522%253A%2522iglu%253Acom.snowplowanalytics.snowplow%252Funstruct_event%252Fjsonschema%252F1-0-0%2522%252C%2522data%2522%253A%257B%2522schema%2522%253A%2522iglu%253Acom.google.analytics.enhanced-ecommerce%252Faction%252Fjsonschema%252F1-0-0%2522%252C%2522data%2522%253A%257B%2522action%2522%253A%2522view%2522%257D%257D%257D&tv=js-2.6.1&tna=snplow1&aid=snowplowweb&p=web&tz=Europe%252FBerlin&lang=en-GB&cs=UTF-8&f_pdf=0&f_qt=0&f_realp=0&f_wma=0&f_dir=0&f_fla=1&f_java=0&f_gears=0&f_ag=0&res=1920x1080&cd=24&cookie=1&eid=26c8a1d6-b2fd-48df-8b1a-c3f1ebfbca17&dtm=1561482005612&vp=1595x849&ds=1595x11143&vid=1&sid=c7f0674d-ddd4-4211-8313-c339d92efb22&duid=474a733e-1131-486f-97ee-3f687a10d5a4&fp=2195191575&refr=https%253A%252F%252Fwww.grover.com%252Fde-de&url=https%253A%252F%252Fwww.grover.com%252Fde-de%252Ffeatured%252Fdeals&co=%257B%2522schema%2522%253A%2522iglu%253Acom.snowplowanalytics.snowplow%252Fcontexts%252Fjsonschema%252F1-0-0%2522%252C%2522data%2522%253A%255B%257B%2522schema%2522%253A%2522iglu%253Acom.snowplowanalytics.snowplow%252Fweb_page%252Fjsonschema%252F1-0-0%2522%252C%2522data%2522%253A%257B%2522id%2522%253A%2522b4345334-b8ee-4cdb-a4ee-5fc0b79a799a%2522%257D%257D%252C%257B%2522schema%2522%253A%2522iglu%253Acom.google.analytics.enhanced-ecommerce%252FimpressionFieldObject%252Fjsonschema%252F1-0-0%2522%252C%2522data%2522%253A%257B%2522id%2522%253A19315%252C%2522name%2522%253A%2522SAMSUNG%2520GQ55Q80RGTXZG%2520QLED%2520TV%2522%252C%2522list%2522%253A%2522seoProducts%2522%252C%2522position%2522%253A8%252C%2522price%2522%253A958.8%252C%2522currency%2522%253A%2522EUR%2522%257D%257D%252C%257B%2522schema%2522%253A%2522iglu%253Aorg.w3%252FPerformanceTiming%252Fjsonschema%252F1-0-0%2522%252C%2522data%2522%253A%257B%2522navigationStart%2522%253A1561481978673%252C%2522unloadEventStart%2522%253A1561481980568%252C%2522unloadEventEnd%2522%253A1561481980605%252C%2522redirectStart%2522%253A0%252C%2522redirectEnd%2522%253A0%252C%2522fetchStart%2522%253A1561481979151%252C%2522domainLookupStart%2522%253A1561481979151%252C%2522domainLookupEnd%2522%253A1561481979151%252C%2522connectStart%2522%253A1561481979151%252C%2522connectEnd%2522%253A1561481979151%252C%2522secureConnectionStart%2522%253A1561481978673%252C%2522requestStart%2522%253A1561481979176%252C%2522responseStart%2522%253A1561481980565%252C%2522responseEnd%2522%253A1561481980593%252C%2522domLoading%2522%253A1561481980568%252C%2522domInteractive%2522%253A1561481982727%252C%2522domContentLoadedEventStart%2522%253A1561481982812%252C%2522domContentLoadedEventEnd%2522%253A1561481982813%252C%2522domComplete%2522%253A1561481984124%252C%2522loadEventStart%2522%253A1561481984124%252C%2522loadEventEnd%2522%253A1561481984154%257D%257D%255D%257D\t-\tHit\tbzHYEGx946wIC2C3GEzlly5HbpARF0_LVlPYd0zz00Z9H--Vf0eUlw==\td1qkeqs71ytz4c.cloudfront.net\thttps\t1664\t0.002\t-\tTLSv1.2\tECDHE-RSA-AES128-GCM-SHA256\tHit\tHTTP/2.0\t-\t-",
"errors": [
{
	"level": "error",
	"message": "error: instance type (integer) does not match any allowed primitive type (allowed: [\"string\"])\n    level: \"error\"\n    schema: {\"loadingURI\":\"#\",\"pointer\":\"/properties/id\"}\n    instance: {\"pointer\":\"/id\"}\n    domain: \"validation\"\n    keyword: \"type\"\n    found: \"integer\"\n    expected: [\"string\"]\n"
}],
"failure_tstamp": "2019-06-25T17:33:01.053Z"

}`

@Manav_Veer_Gulati, the error message indicates that string is expected in place of an integer for the id property. I believe it’s related to impressionFieldObject schema: https://github.com/snowplow/iglu-central/blob/master/schemas/com.google.analytics.enhanced-ecommerce/impressionFieldObject/jsonschema/1-0-0#L13-L15. The value you have is an integer 19315 whereas it should have been the string β€œ19315” instead.

Here’s an extract from your payload (you need to URL decode the raw event twice in your case to see it):

{
  "schema": "iglu:com.snowplowanalytics.snowplow/contexts/jsonschema/1-0-0",
  "data": [
    {
      "schema": "iglu:com.google.analytics.enhanced-ecommerce/impressionFieldObject/jsonschema/1-0-0",
      "data": {
        "id": 19315,
        "name": "SAMSUNG GQ55Q80RGTXZG QLED TV",
        "list": "seoProducts",
        "position": 8,
        "price": 958.8,
        "currency": "EUR"
      }
    }
  ]
}
1 Like