Collecting data from Walmart Connect

This guide explains how to collect data from Walmart Connect. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

Creating a datastream to collect data from Walmart Connect

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Walmart Connect.

Authorization: Allow Adverity to access Walmart Connect

Before creating an authorization to give Adverity access to Walmart Connect, perform the following actions:

To create a Walmart Connect (Search) authorization, follow these steps:

  1. Open the Admin page in Walmart Connect.

  2. In the API Partner - Advertiser Level section, click + Add Partner.

  3. In the API Partner name drop-down menu, select Adverity (Read Access).

To create a Walmart Connect (Display) authorization, you need approval from Walmart. To request approval, follow these steps:

  1. Contact Adverity support (support@adverity.com) to request access to collect data using Walmart Connect (Display).

  2. The Adverity Support team will provide a form that you need to fill out and email to product-connectivity@adverity.com.

  3. Adverity will forward your request to the Walmart Connect partnership team. You will be able to collect display reports in Adverity once Walmart sets up the requested connection.

To set up a new authorization to fetch data from Walmart Connect, follow these steps:

  1. In the Authorization step of the datastream wizard, click Access Walmart Connect using your credentials.

  2. Click Next.

  1. In Search Advertiser ID, enter the search advertiser ID. You can find it in the Walmart Ad Center in Admin Management.

  2. In Display Advertiser ID, enter the display advertiser ID. You will be able to collect data only after this connection is approved by Walmart.

Configuration: Choose the data you want to collect from Walmart Connect

To choose what data to collect and customize the Walmart Connect datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Advertising channel, select the channel for which you want to collect data.

  1. In Report type, select the type of data to collect from Walmart Connect.

  1. In Metrics, change the list of fields that you want to see in your data extract.

What's next?

Advanced Walmart Connect tips

How can I calculate "derived metrics" using the data I have collected?

In Adverity, the Walmart Connect connector allows you to fetch a number of metrics that you can then use to calculate "derived metrics". For more information, see the Walmart Connect Snapshot Reports documentation.

You can add these derived metrics to your Walmart Connect data in two ways:

  • Create a calculated KPI that uses a formula to calculate the derived metric using the metrics in your data

  • addfieldx that uses a Python expression to add a column to your data extract containing the derived metric

The list below explains the calculation that your calculated KPI formula or Python expression needs to perform in order to calculate each derived metric.

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