Collecting data from Walmart Connect

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 Collecting data in Adverity. 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.

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

  4. 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.

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

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

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

  5. In Metadata type, select the metadata type which you want to collect. Currently, only campaign metadata is supported.

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:

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
Contents