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 Adverity access to Walmart Connect, perform the following actions:
to giveTo create a Walmart Connect (Search) , follow these steps:
-
Open the Admin page in Walmart Connect.
-
In the API Partner - Advertiser Level section, click + Add Partner.
-
In the API Partner name drop-down menu, select Adverity (Read Access).
To create a Walmart Connect (Display) , you need approval from Walmart. To request approval, follow these steps:
-
Contact Adverity support (
support@adverity.com
) to request access to collect data using Walmart Connect (Display). -
The Adverity Support team will provide a form that you need to fill out and email to
product-connectivity@adverity.com
. -
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 Walmart Connect, follow these steps:
to fetch data from-
In the Authorization step of the datastream wizard, click Access Walmart Connect using your credentials.
-
Click Next.
-
In Search Advertiser ID, enter the search advertiser ID. You can find it in the Walmart Ad Center in Admin Management.
-
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:
-
(Optional) Rename your datastream.
-
In Advertising channel, select the channel for which you want to collect data.
-
In Report type, select the type of data to collect from Walmart Connect.
-
In Metrics, change the list of fields that you want to see in your data extract.
What's next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying enrichments to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice
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