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