Walmart Connect: Tips and best practices

Calculating derived metrics

Use either Calculated KPIs or a custom script to compute derived metrics from Walmart Connect data. Examples:

Total Attributed Sales

advertised SKU sales + other SKU sales 

Units Sold

advertised SKU units + other SKU units 

View Through Rate (VTR)

views / impressions 

Click Through Rate for Views (vCTR)

total clicks / total viewable impressions 

Total Complete View Attributed Sales

advertised complete view attributed sales + other complete view attributed sales 

ROAS (click attributed + complete view attributed)

(total attributed sales + advertised complete view sales + other complete view sales)/ ad spend 

ROAS (click attributed+ complete view attributed+ view through attributed)

(total attributed sales + advertised complete view sales + other complete view sales + view through attributed sales) / ad spend