Export Enhanced Content Reports from Report Builder

[CommunityMod_WM]

Unlock the full potential of enhanced content analytics and conversion data with the export capabilities of Report Builder. This article provides detailed descriptions of the exportable enhanced content insights in Report Builder, also known as summary reports. Reference this guide to understand the information offered in each summary report and make the best selection to perform in-depth analyses, share insights with others, or integrate data into other applications.

Who should export Enhanced Content Summary Reports from Report Builder?

Any organization that seeks to build advanced visualizations or custom dashboards and trackers utilizing the data that fuels the curated reports in the Enhanced Content Reporting Suite should consider using the exports available in Report Builder.

Guide to Enhanced Content Summary Reports

The summary reports referenced below are available to export from Report Builder when a new insights export is being created. In the first step presented when the Insights Export tool is launched, select the report type “Enhanced Content Report” to view the following options:

• Metric Definitions & Syndigo Terminology
• Device Insights
• Enhanced Content Projects
• Enhanced Content Sections
• Enhanced Conversion
• Enhanced Coverage
• Enhanced Lift
• Enhanced Lift Product Insights: Raw
• Experience Insights
• Pages Insights
• Video Insights
• Widget Insights

Reference the key columns and optional, contextual information available for each report export below.

Metric Definitions & Syndigo Terminology

• Collection Type: This is the enhanced content attribute that determines whether the content should be made available for all sites by default (Generic) or if availability should be restricted to one retailer. This is specified when content is created.
• Caption: This is the text entered into the Caption attribute available for many Syndigo enhanced content widget types.
• Carts: An abbreviation of the term “Conversions”, which is a hybrid metric that represents the count of add-to-cart events or completed transactions – depending on the retailer. The formula to calculate conversions is: Add-to-cart events or Transactions / Sessions. 
• Cart Value: Also referred to as “Conversion Value”, this is the total revenue associated with conversions (add-to-carts or completed transactions). Value is calculated using the formula: Product price * Units added-to-cart or purchased. 
• Clicks: The sum of interactions per visit. Unlike interactions, there is no maximum – this metrics represents the total number of clicks on enhanced content observed.
• Clicks Per Interaction: Calculated as: Clicks / Interactions.
• Conversions: Also referred to as “Carts”, this is a hybrid metric that represents the count of add-to-cart events or completed transactions – depending on the retailer. The formula to calculate conversions is: Add-to-cart events or Transactions / Sessions. 
• Conversion Rate: The percentage of sessions that result in a conversion. Formula: Conversions / Sessions.
• Events: Events capture the specific actions taken by shoppers when interacting with the controls available on enhanced content, such as opening and closing hotspots, scrolling through a carousel, open and closing full-screen views of widgets, and playthroughs of videos.
• Experience or Experience Type: From the context of Syndigo’s enhanced content solution, experience refers to either Hotspots, Toolbar, or In-Line – These speak to the location and form of presentation for enhanced content on product pages. Hotspots and Toolbar experiences are available in association with Hero Images which are above-the-fold and immediately visible when visitors load a URL in their browsers. In-Line is content that appears below-the-fold, generally located in a section designated by the retailer titled “From the manufacturer” or “From the brand”. In most cases, shoppers must scroll down the page to view the In-Line experience.
• Interactions: Visits (page views) that resulted in the shopper clicking on any enhanced content at least one time (i.e. Selecting a hotspot, scrolling through a carousel). Within the context of Devices, there is a maximum count of 1 interaction per page view, per device.
• Interaction Rate: The frequency by which visits resulted in at least one interaction. Calculated as: Interactions / Uniques.
• Interaction Time: The total amount of time, in seconds, that all shoppers spent clicking on content during all visits.
• Page ID: This is the identifier assigned by retailer sites to differentiate between each unique product details page URL. Reference this value to distinguish between distinct URLs on the same site.
• Sessions: A single session consists of one or more page loads by a unique shopper during a one-hour period. A unique visitor may conduct multiple sessions on any given day, depending on their activity.
• Time On Page: The total amount of time, in seconds, that all shoppers remained active on the product page URL overall before each session concluded.
• Average Time On Page: Average time, in seconds, that all shoppers remained active on the product page URL overall before each session concluded. Calculated as: Time On Page / Sessions.
• Uniques: Also referred to as Unique Visits – this metric is a count of each distinct visitor that loaded a URL where enhanced content was published. There is a maximum count of 1 Unique for each distinct shopper observed within any 24-hour period, and a single Unique shopper may be associated with multiple Visits and Sessions on any given day.
• Viewable Impressions: Visits (page views) that resulted in the unique visitor bringing at least 200 pixels of enhanced content into view in the browser, whether that was above-the-fold content that appears instantly on page load or if they scrolled down to below-the-fold content on the page.
• Viewable Impression Rate or Viewability Rate: The frequency by which Sessions resulted in at least 200 pixels of enhanced content appearing in the browser viewport. Calculated as: Viewable Impressions / Sessions.
• Views: Visits that resulted in at least 200 pixels of enhanced content appearing in the browser viewport, per experience or widget type.
• Widget Type: Also known as content types, widgets are the building blocks of enhanced content. A full collection of enhanced content is constructed using one or more widgets associated with any of the following types: Image Galleries, Document Galleries, Videos, Feature Sets, 360 Views, Carousels, Interactive Tours, Comparison Tables, Specification Tables, Text, and iFrames. 

Device Insights

This export provides the daily data for each URL that also fuels the Devices view in the Widget Insights curated report. The standard enhanced content engagement metrics are broken down by Device type – desktop, mobile, and tablet.

Key columns recommended for the identification of records:

• Date
• Product Name
• Device
• Site Name
• Page ID

Key metrics:

• Uniques
• Sessions
• Viewable Impressions
• Interactions
• Clicks
• Interaction Time
• Time On Page
• Interaction Rate
• Avg Time on Page
• Clicks Per Interaction
• Viewable Impression Rate

Optional fields available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code

Enhanced Content Projects

Summary: The Enhanced Content Projects report replaces what was formerly known as the Enhanced Content Collections Index report. This export is derived from a snapshot that was taken the previous evening (during Syndigo’s overnight data aggregation processes). The snapshot captures every Project, Product, and Collection that existed in the account. Changes to the count of projects, products, and collections will not be reflected in this export until the next calendar day. There are no analytics associated with this report, it should be leveraged for auditing or informational purposes only.

Key columns recommended for the identification of records:

• Product Name
• Product ID
• Project Name
• Project ID
• Language
• Countries
• Collection ID
• Collection Type
• Label
• Draft Preview Link
• Live Preview Link
• CXH Deep Link
• Has Inline
• Has Toolbar
• Has Hotspots
• Availability Date
• Product Status
• Archived

Optional fields available for additional context around product attributes and Syndigo records:

• Company Name
• GTIN
• UPC
• MPN
• MFG Part #
• Brand
• Is Live
• Moderation Date
• First Visit Date
• Last Visit Date
• Created Date

Enhanced Content Sections

The Sections report is not related to any curated report in the Enhanced Content Reporting Suite. This report compiles events, uniques and views observed for every URL where enhanced content was viewed by shopper – from the context of collection language, country, and type, and broken down further by distinct experiences and widget types.

Key columns recommended for the identification of records:

• Date
• Product Name
• Collection Type
• Language
• Countries
• Site
• Page ID
• Device
• Event
• Experience
• WidgetType

Key metrics:

• Uniques
• Views

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code

Enhanced Conversion

This export provides the daily data for each URL that also fuels the Enhanced Conversion - Products curated report.

Key columns recommended for the identification of records:

• Date
• Product Name
• Site Name
• Page ID

Key metrics:

• Uniques
• Sessions
• Carts
• Conversion Rate
• Time On Page
• Average Time on Page
• Units
• Cart Value
• Visits
• Interactions

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, Currency, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code, Created Date

Enhanced Coverage

This is an export of the data underlying the Enhanced Coverage report, with additional columns to provide detailed contextual information not available in the curated report. Note that there are no dates associated with Coverage, as this information is captured as a snapshot reflecting only the state of the account as of yesterday.

Key columns recommended for the identification of records:

• Retailer
• Page ID
• Product Name
• Language
• Countries
• Status*
• URL
• Has Inline
• Has Toolbar
• Has Hotspots
• Availability Date*
• Last Visit Date*

*From the context of Coverage, Status is “Available” when all required steps have been completed within the Syndigo platform to ensure enhanced content will load successfully upon visits to URLs. Availability Date refers to the first day the content entered the status “Available”, and Last Visit Date reflects the most recent day that enhanced content loaded successfully on the URL – the most recent Last Visit Date possible being yesterday.

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Site ID, Pipeline, Site Code, Product ID, UPC, MPN, Brand, Collection ID, Moderation Date, Page Validation Date, Packaging Level, Map Price, Archived, Competitive Flag, Created Date

Enhanced Lift

This export provides the daily data for each URL that also fuels the Enhanced Conversion – Lift curated report. All metrics that are utilized in the calculation of the Lift and Incremental Revenue KPIs, but not displayed in the curated report, are made available through this export. Reference the Enhanced Conversion Lift Report article if more information is required about how these metrics are derived.

Key columns recommended for the identification of records:

• Date
• Product Name
• Currency
• Site Name
• Page ID

Key metrics:

• Treatment Uniques
• Treatment Sessions
• Treatment Carts
• Treatment Cart Value
• Treatment Conversion Rate
• Treatment Time on Page
• Treatment Average Time on Page
• Holdout Uniques
• Holdout Sessions
• Holdout Cart Value
• Holdout Conversion Rate
• Holdout Time on Page
• Holdout Average Time on Page

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code, Created Date

Enhanced Lift Product Insights: Raw

This export provides the daily data for each URL that also fuels the Enhanced Conversion – Lift Product Insights curated report. All metrics that are utilized in the calculation of the product page-level Conversion Rate Lift KPIs are made available through this export. Reference the article Lift Product Insights Report: Overview to learn more about how these metrics are derived.

Note: Some terminology differs slightly between the raw export and the curated report, as the raw export utilizes more abbreviated terms for the sake of concision. The Treatment Group, or Content Viewers, are labeled “Viewers” in this raw export. The Holdout Group, or Non-Viewers, are labeled “No-View” in this raw export.

Recommended usage of this raw export: Ingest the daily data from Syndigo into an internal database. Build dashboards on top of the internal database that enable your organization to roll up by any aggregation level desired – such as by product, product set, site, and by any timeframe – and then calculate the Conversion Rate Lift KPI for each desired aggregation level using the formula (Viewer Conversion Rate – No-View Conversion Rate) / No-View Conversion Rate.

Key columns recommended for the identification of records:

• Date
• Product Name
• Currency
• Site Name
• Page ID

Key metrics:

• Viewer Sessions
• Viewer Carts
• Viewer Revenue
• Viewers Total Time On Page
• No-View Sessions
• No-View Carts
• No-view Units
• No-View Revenue
• No-View Total Time On Page

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code, Created Date

Experience Insights

This export provides the daily data for each URL that also fuels the Experiences view in the Widget Insights curated report. The standard enhanced content engagement metrics are broken down by each distinct Experience type (hotspots, toolbar, and inline).

Key columns recommended for the identification of records:

• Date
• Site Name
• Product Name
• Page ID
• Device
• Experience

Key metrics:

• Views
• Viewable Impressions
• Interactions
• Clicks
• Clicks Per Interaction
• Interaction Time
• Interaction Rate
• Time On Page

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code

Pages Insights

This export provides the daily data for each URL that also fuels the Overall view in the Widget Insights curated report. The standard enhanced content engagement metrics are aggregated at the level of overall page loads.

Key columns recommended for the identification of records:

• Date
• Site Name
• Product Name
• Page ID

Key metrics:

• Visits
• Uniques
• Sessions
• Viewable Impressions
• Viewable Impression Rate
• Interactions
• Clicks
• Clicks Per Interaction
• Interaction Time
• Interaction Rate
• Time On Page
• Avg Time on Page

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code, Created Date

Video Insights

This export provides the daily data for each URL that also fuels the Video Engagement curated report. The video-specific enhanced content engagement metrics are aggregated at the level of each distinct combination of URL, Experience type, and Widget type for videos only.

Key columns recommended for the identification of records:

• Date
• Site Name
• Product Name
• Page ID
• Device
• Experience
• Widget Type

Key metrics:

• Uniques
• Views
• Video Plays
• Play Rate
• Playback Time
• Avg Playback Time
• Video Completes
• Completion Rate

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code

Widget Insights

This export provides the daily data for each URL that also fuels the Widget Overview in the Widget Insights curated report. The standard enhanced content engagement metrics are aggregated at the level of each distinct Widget Type.

Key columns recommended for the identification of records:

• Date
• Site Name
• Product Name
• Page ID
• Device
• Experience
• Widget Type

Key metrics:

• Views
• Clicks
• Clicks per view

Optional columns available for additional context around product attributes and Syndigo records:

Company ID, Company Name, Product ID, GTIN, UPC, MPN, Brand, Packaging Level, Map Price, Archived, Competitive Flag, Site ID, Site Owner ID, Site Base URL, Site Code