Export data for offline analysis (DSO exports feature)

Modified on Fri, 22 Aug at 2:45 AM

You provided the CommerceIQ team with information about your company’s operations when your Digital Shelf Optimization account was being configured - information like your brands and products and categories they belong to, retailers where you sell, etc.

We use that information to build reports for

Whether content on your product listing pages is strong enough
How you’re product listings are showing up when consumers search for related keywords
Whether your products are being listed at prices you’d expect
Whether price promotions for your products are active and displaying across retailers as you’d expect
Which of your products are in and out of stock
Whether ratings and reviews for your products are strong enough

There are built in reports to answer each of these questions in the platform, but you can also export the data that drive these reports for offline analysis.

To export data, click Exports on the main menu. Click to expand the Select an export type dropdown. Click to choose one of these reports for export:

Product Content - product full data
Product Content - product basics and compliance
Pricing
Pricing - Daily
Multi-Location Pricing - Daily
Promotion
Search Ranking
Availability
Rating and Reviews Summary
Rating and Reviews
Category Ranking
Banners

Product Content - product full data

The Product Content Report provides a complete view of the product data we collect from your product detail pages (PDPs) across supported retailers. Use this report to review, audit, and improve the content, compliance, and performance of your online listings.

Categorization: Retailer, category, brand, manufacturer
Basic content: Title, bullets, description, image count
Advanced content: Video, subscription, enhanced content
Compliance: Ingredients, country, allergens, storage, nutrition
Buy box: Price, seller name, quantity

Use the Product Content Report when you want to:

Audit your product listings: Ensure titles, images, and descriptions are complete and follow best practices
Identify compliance issues: Check that required regulatory fields (e.g., allergens, country of origin) are properly populated
Review advanced content coverage: Understand where enhanced content or video may be missing
Monitor buy box presence: Track who is winning the buy box, current pricing, and displayed quantity
Compare content across retailers: Spot inconsistencies or gaps in your content by retailer, brand, or product

Product Content - product basics and compliance

The product basics and compliance report is a formatted excel export that contains the underlying information that feeds the Product Content -> Product Basics report and the Product Content -> Product Compliance reports. The cells in the export are color coded using the same rules as their respective reports.

This report is ideal for conducting a product content quality audit at the SKU level across multiple content dimensions. Here’s how you could use it effectively:

1. Fix product name mismatches

Column AC ("Name Actions") shows entries like “Product name does not match with preferred name”
Use this to align retailer-facing product names with brand-approved naming conventions, improving brand consistency and search visibility

2. Prioritize content score improvements

Use the colored scoring columns to quickly identify low-performing areas. For example:

Brand Score (AD): If low, update the brand attribution metadata
Image Score (AE) and Description Score (AF): Add or improve imagery and product descriptions
Legal Score (AG): A low score here may indicate missing or incorrect legal disclaimers or required info

3. Audit compliance content

Look at columns AR–AX to spot missing regulatory or product-specific info.

4. Evaluate pricing and promotions

Columns AH–AN help you track pricing accuracy:
- Original Price vs. Promotion Price
- Unit Pricing
- Discounts
- Promotion Text & Type

This is useful to verify promotional compliance or identify if pricing discrepancies could be impacting your buy box or conversion rate.

Pricing

This report provides a detailed view of product pricing and promotion across retailers at the SKU level. The report shows average selling and promoted prices, as well as promotional depth and duration. It also highlights strategic SKU flags like new, core, and priority items. Weekly retail pricing snapshots are included to help monitor price changes over time. This report is ideal for tracking pricing consistency, and evaluating promotional effectiveness.

This report has the following data points:

Average Selling Price: The typical price shoppers are paying
ASP Per Unit of Measure: Lets you compare pricing across pack sizes and retailers
Average Base Price: Price when not on promotion
Average Promoted Price: Price when on promotion
Average Promotional Deal Level: Indicates average discount depth
Weeks on Promotion: Total number of weeks the SKU has been promoted over a given time window

Price report use cases

Use Case	How
Track pricing trends	Compare weekly price points across retailers to identify changes, price hikes, or dips.
Evaluate promo effectiveness	Use average promoted price, deal level, and weeks on promo to analyze promotion depth and duration.
Normalize pricing	Use unit of measure pricing to compare similar SKUs with different pack sizes or formats.
Retailer price compliance	Use GTIN-level tracking to spot discrepancies across retail partners.

Pricing - Daily

The Pricing Daily Report provides daily, SKU-level pricing data across your product portfolio. It allows you to closely monitor pricing and promotion activity on a day-to-day basis, helping you identify trends, spot anomalies, and evaluate how pricing strategies are being executed across retailers. This report is especially useful for tracking compliance, reacting to competitor moves, and measuring the impact of short-term promotions.