Retrieve Snapshot v2 Reports (updated)
You can retrieve report snapshots by providing the snapshot ID and advertiser ID for an advertiser.
URL: GET/api/v2/snapshot
Note:
- The format of the report is CSV, enclosed in “gzip” file format.
- You can request the following type of snapshots:
- Reports for Sponsored Brand campaigns: Report snapshots provide Sponsored Brand campaign metrics like they do for non-Sponsored Brand campaigns, however, following are some rules that specifically govern metrics for Sponsored Brand campaigns:
- Clicks and Impressions are attributed as per clicks and
display for each item displayed in Sponsored Brand placement - Sponsored Brand placement is only available on
Search page; hence its metrics are included in Search page only
for page type report
- Clicks and Impressions are attributed as per clicks and
- Reports for Sponsored Brand campaigns: Report snapshots provide Sponsored Brand campaign metrics like they do for non-Sponsored Brand campaigns, however, following are some rules that specifically govern metrics for Sponsored Brand campaigns:
Sample Request
curl -X GET\
'https://developer.api.stg.walmart.com/api-proxy/service/WPA/Api/v1/api/v2/snapshot?advertiserId=600001&snapshotId=1' \
--header 'Authorization: Bearer <auth_token>' \ --header 'accept: application/json' \
--header 'WM_SEC.AUTH_SIGNATURE: ***********' \
--header 'WM_SEC.KEY_VERSION: 1' \
--header 'WM_CONSUMER.ID: adfwe-v23-faasd2r-afs-asdfqeff' \
--header 'WM_CONSUMER.intimestamp: 1565309779' \
Response
Element | Description | Type |
---|---|---|
snapshotId | ID of the snapshot to be retrieved | string |
jobStatus | An indicator to confirm status of snapshot generation. The possible values of jobStatus are: pending , processing , done , failed , expired | string |
details | URL of the snapshot file when jobStatus is done | string |
code | The response code can have following values: success , failure | string |
Note:
- Time to Live (TTL) for files generated is one day
If you want to retrieve keyword report based on the response for Create Report Request (Sample Response 1)
Sample Response 1 for report type Keyword
{ "code": "success", "snapshotId": "10", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
The snapshot file is in CSV format that includes response for each report type. You can request multiple report types in one request; however, the response would be captured in one zip/gzip file as explained in the “Types of Format” section.. It will have single CSV file returning response for all report types.
Example content of snapshotId “10” (in CSV format):
"date", "keywordId", "searchedKeyword", "biddedKeyword", "matchType", "campaignId", "adGroupId", "ntbUnits3days", "ntbOrders3days", "ntbRevenue3days", "ntbUnits14days", "ntbOrders14days", "ntbRevenue14days", "ntbUnits30days", "ntbOrders30days", "ntbRevenue30days", "bid", "numAdsShown", "numAdsClicks", "adSpend", "directAttributedSales3days", "directAttributedSales14days", "directAttributedSales30days", "advertisedSkuSales3days ", "advertisedSkuSales14days", "advertisedSkuSales30days", "attributedUnits3days", "attributedUnits14days", "attributedUnits30days", "brandAttributedSales3days", "brandAttributedSales14days", "brandAttributedSales30days", "relatedAttributedSales3days","relatedAttributedSales14days”, "relatedAttributedSales30days", "otherSkuSales3days ", "otherSkuSales14days ", "otherSkuSales30days ", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days" "2022-12-10", "800001", "key1", "bkey1", "exact", "800001", "800001", "52", "53", "54", "55", "56", "57", "59", "60", "61", "60", "100", "10", "6", "180", "184", "188","400", "40", "8", "12", "28", "76", "92", "140", "156", "12","76", "140", "20", "84", "148", "16", "80","144"
Note:
- maximum character length of 60 characters is returned for
searchedKeyword
searchedKeyword
field will provide:- search query entered by the site visitor, in an event when an ad is
delivered on Search Carousel or Search In-grid placements - Item ID (anchor item) specific to the Item Page on which the ad is
delivered, in an event when an ad is delivered on the item page
placements
- search query entered by the site visitor, in an event when an ad is
If you want to retrieve ad item report based on the response for Create Report Request (Sample Response 2)
Sample Response 2 for report type Ad Item
{ "code": "success", "snapshotId": "11", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “11” (in CSV format):
"date", "campaignId", "adGroupId", "itemId", "itemName", "itemImage", "numAdsShown", "numAdsClicks", "adSpend", "directAttributedSales3days", "directAttributedSales14days", "directAttributedSales30days", "advertisedSkuSales3days ", "advertisedSkuSales14days", "advertisedSkuSales30days", "attributedUnits3days",
"attributedUnits14days", "attributedUnits30days",
"brandAttributedSales3days", "brandAttributedSales14days", "brandAttributedSale30days", "relatedAttributedSales3days", "relatedAttributedSales14days","relatedAttributedSales30days", "otherSkuSales3days ", "otherSkuSales14days", "otherSkuSales30days ", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days" "2022-10-01", "609967", "771138915", "11047090", "Equate Ultra Strength Antacid Tropical Fruit Chewable Tablets, 1000 mg, 160 Count", "https://i5.walmartimages.com/asr/9f61df61-673e-4919-bfb2-03e84e028b90.c8effce29e8c1ae23262a32055eeb3be.jpeg?odnHeight=450&odnWidth=450&odnBg=ffffff ", "100", "10", "2", "2", "6","8", "3", "7", "25", "29", "47", "51", "3", "25", "5", "27", "49", "4","30", "40", "50", "26", "48", "11" "2022-10-02", "610534", "771139421", "11047090", "Equate Ultra Strength Antacid Tropical Fruit Chewable Tablets, 1000 mg, 160 Count", "https://i5.walmartimages.com/asr/9f61df61-673e-4919-bfb2-03e84e028b90.c8effce29e8c1ae23262a32055eeb3be.jpeg?odnHeight=450&odnWidth=450&odnBg=ffffff "
, "100", "10", "2", "3", "7", "25", "29", "47", "51", "3", "25", "5", "27", "49", "4", "26", "48", "11" "2022-10-03", "609968", "771138916", "34764454", "Equate Regular Strength Stomach Relief Liquid, 525 mg, 16 fl oz, 2 Count",
"https://i5.walmartimages.com/asr/a4778971-abd9-4df8-8518-edb04f344202.e18ccfb9237b0498e2bffc88526ccec0.jpeg?odnHeight=450&odnWidth=450&odnBg=ffffff",
"100", "10", "2", "3", "7", "25", "29", "47", "51", "3", "25", "5", "27", "49", "4", "26", "48", "11"
If you want to retrieve platform report based on the response for Create Report Request (Sample Response 3)
Sample Response 3 for report type Platform
{ "code": "success", "snapshotId": "12", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “12” (in CSV format):
"date", "campaignId", "adGroupId", "platform", "numAdsShown", "numAdsClicks", "adSpend", "directAttributedSales3days", "directAttributedSales14days", "directAttributedSales30days", "advertisedSkuSales3days ", "advertisedSkuSales14days", "advertisedSkuSales30days", "attributedUnits3days", "attributedUnits14days", "attributedUnits30days", "brandAttributedSales3days", "brandAttributedSales14days", "brandAttributedSales30days", "relatedAttributedSales3days","relatedAttributedSales14days", "relatedAttributedSales30days", "otherSkuSales3days", "otherSkuSales14days", "otherSkuSales30days", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days" "2022-10-05", "609967", "771138915", "desktop”, "100", "10", "2", "3", "7", "19", 25", "29", "47", "23", "39","5", "21","37", "4","20", "36", "11", 9", "19", "27", "27", "43", "29"
If you want to retrieve videoCampaigns report based on the response for Create Report Request (Sample Response 4)
Sample Response 4 for report type Video Campaigns
{ "code": "success", "snapshotId": "13", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “13” (in CSV format):
"date", "campaignId", "adGroupId", "numAdsShown", "numAdsClicks", "adSpend", "attributedUnits3days", "attributedUnits14days", "attributedUnits30days", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days", "viewableImpressions", "videoFirstQuartileViews", "videoMidpointViews", "videoThirdQuartileViews", "videoCompleteViews", "videoUnmutes", "video5SecondViews", "attributedSales3days", "attributedSales14days", "attributedSales30days", "videoImpressions", "viewThroughSales3days", "viewThroughSales14days", "viewThroughSales30days", "viewThroughOrders3days", "viewThroughOrders14days", "viewThroughOrders30days", "viewThroughUnitsSold3days", "viewThroughUnitsSold14days", "viewThroughUnitsSold30days", "completeViewRevenue3days", "completeViewRevenue14days", "completeViewRevenue30days", "haloCompleteViewRevenue3days", "haloCompleteViewRevenue14days", "haloCompleteViewRevenue30days", "totalCompleteViewOrders3days", "totalCompleteViewOrders14days", "totalCompleteViewOrders30days", "totalCompleteViewUnits3days", "totalCompleteViewUnits14days", "totalCompleteViewUnits30days" "2023-10-24", "600001", "600001", "200”, "20", "12", "106", "168", "114", "64", "66", "68", "156", "10","40", "60","40", "100", "120", "42", "174", "62", "20", "12.5", "38.5", "52.5", "20", "38", "48", "18", "38", "58", "18.5", "48.5", "58.5", "38.7", "68.5", "78.5", "23", "39", "48", "38", "58", "68"
If you want to retrieve videoKeywords report based on the response for Create Report Request (Sample Response 5)
Sample Response 5 for report type Video Keywords
{ "code": "success", "snapshotId": "14", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “14” (in CSV format):
"date", "campaignId", "adGroupId", "biddedKeyword", "matchType", "numAdsShown", "numAdsClicks", "adSpend", "attributedUnits3days", "attributedUnits14days", "attributedUnits30days",
"attributedOrders3days", "attributedOrders14days", "attributedOrders30days", "viewableImpressions", "videoFirstQuartileViews", "videoMidpointViews", "videoThirdQuartileViews", "videoCompleteViews","videoUnmutes", "video5SecondViews", "attributedSales3days", "attributedSales14days", "attributedSales30days", "videoImpressions", "keywordId", "viewThroughSales3days", "viewThroughSales14days", "viewThroughSales30days", "viewThroughOrders3days", "viewThroughOrders14days", "viewThroughOrders30days", "viewThroughUnitsSold3days", "viewThroughUnitsSold14days", "viewThroughUnitsSold30days", "completeViewRevenue3days", "completeViewRevenue14days", "completeViewRevenue30days", "haloCompleteViewRevenue3days", "haloCompleteViewRevenue14days", "haloCompleteViewRevenue30days", " totalCompleteViewOrders3days", "totalCompleteViewOrders14days", "totalCompleteViewOrders30days", "totalCompleteViewUnits3days", "totalCompleteViewUnits14days", "totalCompleteViewUnits30days" "2023-10-24", "600001", "600001", "bkey”, "exact", "100", "10", "53", "84", "57", "32", "33","34", "123", "10", "20", "30", "50", "60", "27", "43", "29", "21", "87", "20", "50", "12.5", "38.5", "52.5", "20", "38", "48", "18", "38", "58", "18.5", "48.5", "58.5", "38.7", "68.5", "78.5", "23", "39", "48", "38", "58", "68"
If you want to retrieve attributedPurchases
report based on the response for Create Report Request (Sample Response 6) :
Sample Response 6 for report type Attributed Purchases
{ "code": "success", "snapshotId": "15", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “15” (in CSV format)
"adGroupId", "advertisedItemId", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days", "attributionType", "campaignId", "date", "ntbOrders3days", "ntbOrders14days", "ntbOrders30days", "ntbRevenue3days", "ntbRevenue14days", "ntbRevenue30days", "ntbUnits3days", "ntbUnits14days", "ntbUnits30days", "purchasedItemId", "purchasedItemName", "totalSales3days", "totalSales14days", "totalSales30days", "totalUnits3days", "totalUnits14days", "totalUnits30days" "609967", "771138915", "33", "35", "40", "Advertised", "600001", "2023-10-24", "67", "80", "100", "49", "56", "67", "6","8", "12", "70003", "item1", "29", "47", "51", "3", "25", "50"
If you want to retrieve search Impression report based on the response for Create Report Request (Sample Response 7) :
Sample Response 7 for report type Search Impression, to retrieve trailing 30-day report with day-level aggregation
{ "code": "success", "snapshotId": "16", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “16” (in CSV format):
"date", "searchedKeyword", “campaignId”, "numAdsShown", "searchedKeywordImpressionShare", "searchedKeywordImpressionRank", "tosSearchedKeywordImpressionShare", "tosSearchedKeywordImpressionRank", "numAdsClicks", "adSpend", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days", “advertisedSkuSales3days”, “advertisedSkuSales14days”, “advertisedSkuSales30days”, “otherSkuSales3days”, “otherSkuSales14days”, “otherSkuSales30days”, “advertisedSkuUnits3days”, “advertisedSkuUnits14days”, “advertisedSkuUnits30days”, “otherSkuUnits3days”, “otherSkuUnits14days”, “otherSkuUnits30days” "2024-02-18", "sbkey1", "800005", "100", "30.71", "7", "21.21", "9", “10”, “4.41”, “2”, “3”, “4”, “35.6”, “94.21”, “260.45”, “10.32”, “77.67”, “440.2”, “4”, “6”, “9”, “1”, “3”, “7”
"2024-02-19", "sbkey1", "800005", "1000", "70.48", "5", "61.22", "12", “112”, “52.12”, “23”, “38”, “51”, “56.2”, “175.8”, “435.83”, “22.78”, “162.99”, “782.1”, “8”, “11”, “16”, “5”, “8”, “12”
…..................................... "2024-03-18", "sbkey1", "800005", "1500", "60.68", "12", "41.92", "30", “250”, “109.12”, “50”, “67”, “81”, “41.6”, “111.29”, “468.23”, “33.21”, “96.3”, “637.21”, “6”, “8”, “9”, “2”, “5”, “8”
If you want to retrieve search Impression report based on the response for Create Report Request (Sample Response 8) :
Sample Response 8 for report type Search Impression, to retrieve trailing 30-day cumulative report
{ "code": "success", "snapshotId": "17", "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “17” (in CSV format):
"startDate", "endDate", "searchedKeyword", “campaignId”, "numAdsShown", "searchedKeywordImpressionShare", "searchedKeywordImpressionRank", "tosSearchedKeywordImpressionShare", "tosSearchedKeywordImpressionRank", "numAdsClicks", "adSpend", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days", “advertisedSkuSales3days”, “advertisedSkuSales14days”, “advertisedSkuSales30days”, “otherSkuSales3days”, “otherSkuSales14days”, “otherSkuSales30days”, “advertisedSkuUnits3days”, “advertisedSkuUnits14days”, “advertisedSkuUnits30days”, “otherSkuUnits3days”, “otherSkuUnits14days”, “otherSkuUnits30days” "2024-02-18", "2024-03-18", "sbkey1", "800004", "100", "30.71", "7", "21.21", "9", “10”, “4.41”, “2”, “3”, “4”, “35.6”, “94.21”, “260.45”, “10.32”, “77.67”, “440.2”, “4”, “6”, “9”, “1”, “3”, “7”
If you want to retrieve Search Impression report based on the response for Create Report Request (Sample Response 9):
Sample Response 9 for report type Search Impression, to retrieve report with weekly aggregation
{ "code": "success", "snapshotId": "18", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “18” (in CSV format):
"weekOf", "searchedKeyword", “campaignId”, "numAdsShown", "searchedKeywordImpressionShare", "searchedKeywordImpressionRank", "tosSearchedKeywordImpressionShare", "tosSearchedKeywordImpressionRank", "numAdsClicks", "adSpend", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days", “advertisedSkuSales3days”, “advertisedSkuSales14days”, “advertisedSkuSales30days”, “otherSkuSales3days”, “otherSkuSales14days”, “otherSkuSales30days”, “advertisedSkuUnits3days”, “advertisedSkuUnits14days”, “advertisedSkuUnits30days”, “otherSkuUnits3days”, “otherSkuUnits14days”, “otherSkuUnits30days” "2024-03-03", "sbkey2", "800004", "100", "17.39", "106", "39.15", "108", “94”, “93.66”, “1”, “3”, “103”, “64.5”, “43.65”, “197.45”, “6.32”, “80.67”, “441.2”, “101”, “104”, “103”, “95”, “102”, “109” "2024-03-10", "sbkey2", "800004", "100", "28.11", "89", "7.15", "109", “93”, “91.11”, “4”, “5”, “106”, “24.6”, “61.21”, “205.45”, “10.32”, “85.67”, “479.2”, “104”, “103”, “95”, “93”, “101”, “98” "2024-03-17", "sbkey2", "800004", "100", "22.92", "118", "115.21", "106", “101”, “90.78”, “9”, “5”, “95”, “46.6”, “80.21”, “182.45”, “17.32”, “62.67”, “380.2”, “100”, “108”, “101”, “100”, “97”, “97”
If you want to retrieve Search Impression report based on the response for Create Report Request (Sample Response 10):
Sample Response 10 for report type Search Impression to retrieve report with monthly aggregation
{ "code": "success", "snapshotId": "19", "details": "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “19” (in CSV format)
"monthOf”, “searchedKeyword”, “campaignId”, "numAdsShown", "searchedKeywordImpressionShare", "searchedKeywordImpressionRank", "tosSearchedKeywordImpressionShare", "tosSearchedKeywordImpressionRank", "numAdsClicks", "adSpend", "attributedOrders3days", "attributedOrders14days", "attributedOrders30days", “advertisedSkuSales3days”, “advertisedSkuSales14days”, “advertisedSkuSales30days”, “otherSkuSales3days”, “otherSkuSales14days”, “otherSkuSales30days”, “advertisedSkuUnits3days”, “advertisedSkuUnits14days”, “advertisedSkuUnits30days”, “otherSkuUnits3days”, “otherSkuUnits14days”, “otherSkuUnits30days” "2024-02-01", "sbkey3", "800002", "2100", "123.1", "115", "10.48", "118", “100”, “88.97”, “1”, “7”, “107”, “14.6”, “67.21”, “189.45”, “6.32”, “68.67”, “374.2”, “94”, “97”, “99”, “93”, “97”, “93” "2024-03-01", "sbkey3", "800002", "2300", "280.39", "106", "39.15", "108", “94”, “93.66”, “1”, “3”, “103”, “64.5”, “43.65”, “197.45”, “6.32”, “80.67”, “441.2”, “101”, “104”, “103”, “95”, “102”, “109”
If you want to retrieve Out of Budget Recommendations report based on the response for Create Report Request (Sample Response 11) :
Sample Response 11 for report type Out of Budget Recommendations
{ "code": "success", "snapshotId": "20", "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId “20” (in CSV format):
"startDate", "endDate", "campaignId", "missedImpressionsLower", "missedImpressionsUpper", "missedClicksLower", "missedClicksUpper", "avgCapOutTime", "suggestedLatestDailyBudget", "suggestedLatestTotalBudget" "2023-10-04", "2023-10-11", "12345", "20", "25", "10", "15", "1000", "50", "100" "2023-10-04", "2023-10-11", "12346", "15", "20", "30", "35", "0900", "80", "130"
Sample Response 12 for report type Item Health
{ "code": "success", "snapshotId": "21", "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId "21" (in CSV format):
"date","itemId","primaryVariantId","publishStatus","campaignIds","adGroupIds","pageViews","pageViewLastWeek","buyBoxPct","buyBoxPctLastWeek","availabilityPct","availabilityPctLastWeek","listingQualityScore","contentScore","ratingScore","offerScore" "2025-04-03","55555555","55555555","Published","[1234567]","[444444]",1234,100,99.99,97.00,95.00,99.70,95,90,90,90
"2025-04-03","66666666","66666666","Published","[2345678]","[444444]",1234,70,99.99,97.00,94.00,99.30,95,90,90,90
"2025-04-03","777777777","777777777","Published","[3456789]","[456789]",234,50,99.99,97.00,93.00,99.10,95,90,90,90
Sample Response 13 for report type Item Keyword
{ "code": "success", "snapshotId": "22", "https://advertising.walmart.com/sp-reporting/xxxxxxxxxx-xxxx-xxxx-xxxx- xxxxxxxxxx_SNAPSHOT00000000000.gz?sp=r&st=2025-02-27T00:00:00Z&se=2025-03-07T00:00:00Z&spr=https&sv=2022-11-02&sig=xxxxxxxxxxxxxxxxxxxxx%3D&sr=f", "jobStatus": "done" }
Example content of snapshotId "22" (in CSV format):
"date","campaignId","adGroupId","itemId","keywordId","biddedKeyword","searchedKeyword","matchType","adSpend","numAdsShown","numAdsClicks","advertisedSkuSales3days","advertisedSkuSales14days","advertisedSkuSales30days","otherSkuSales3days","otherSkuSales14days","otherSkuSales30days","attributedOrders3days","attributedOrders14days","attributedOrders30days","advertisedSkuUnits3days","advertisedSkuUnits14days","advertisedSkuUnits30days","otherSkuUnits3days","otherSkuUnits14days","otherSkuUnits30days" 3/1/25,1111111,444444,12345678,987,unknown,example keyword,unknown,3,10,1,3.0,5.0,7.0,1.0,2.0,3.0,0,0,0,1,1,1,2,2,2
.....................................
3/3/25,1111111,444444,12345678,987,unknown,example keyword,unknown,3,10,1,3.0,5.0,7.0,1.0,2.0,3.0,0,0,0,1,1,1,2,2,2
Updated 23 days ago