Actual action not in Redshift when calling trackEnhancedEcommerceAction

For data modelers & consumers Redshift
1

Hi,

I’m implementing ecommerce using the code below:

window.snowplow('addEnhancedEcommerceImpressionContext',
  'WM7',
  'Euromaid WM7 7kg Front Load Washing Machine',
  'Top Sellers',
  'Euromaid',
// .. etc
);

indow.snowplow('trackEnhancedEcommerceAction',
  'add'
);

However, the action (add, view, etc.) doesn’t seem to come into Redshift. I run the below query and ‘add’ is not returned…

select ga.*, e.* 
from com_google_analytics_enhanced_ecommerce_impression_field_object_1 ga 
inner join atomic.events e on ga.root_id=e.event_id

Can anyone advise where I might be able to find it? Everything else comes through fine (price, brand, etc.)

Thanks!

2

It looks like that method of the Javascript tracker adds data into the com_google_analytics_enhanced_ecommerce_action_1 table so you’ll also want to join on this.

trackEnhancedEcommerceAction: function (action, context, tstamp) {
    ...

    core.trackSelfDescribingEvent({
        schema: 'iglu:com.google.analytics.enhanced-ecommerce/action/jsonschema/1-0-0',
        data: {
            action: action
        }
    ...
1 Like
3

Legend!! That’s it!