Integration Specifications

This article will help you learn about how Daasity replicates data from H-E-B Circana, limitations to the data we can extract and where the data is stored in the H-E-B Circana schema.

Integration Overview

H-E-B Circana provides retailer-specific market data for H-E-B stores using Circana as the data source. The integration delivers weekly and aggregated sales data, promotional metrics, distribution information, and product attributes at the market level.

This document provides context on what kind of data is being gathered through this extractor, which data sources that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

Enterprise

Data Source

The Daasity H-E-B Circana extractor is built based on file-based data delivery (CSV files via S3 upload or manual upload). The following data sources are used by Daasity to replicate data from H-E-B Circana:

CSV file upload (heb_circana_data*.csv)
CSV file upload (heb_circana_products*.csv)

Data provider: Circana (retailer-specific implementation for H-E-B)

H-E-B Circana Schema

The Daasity H-E-B Circana extractor creates these tables using the data sources and replication methods listed. The data is mapped from source CSV file columns to the table based on the mapping logic outlined in each table.

The H-E-B Circana integration consists of two separate integrations, each creating one raw data table:

Note: The raw data from both tables is combined during transformation to create the final URMS sales report for reporting and analysis in Looker and other reporting tools.

Important: Both integrations (HEB Circana Data and HEB Circana Products) must have files uploaded and tables created. The transformation pipeline will fail if both tables (retail.heb_circana_data and retail.heb_circana_products) do not exist.

HEB Circana Data

Source: CSV file upload (heb_circana_data*.csv)

Update Method: UPSERT

Table Name: retail.heb_circana_data

Contains: Sales/fact data including revenue, units sold, promotional metrics, and distribution data

CSV Column

Database Column

Geography

geography

Time

time

Product

product

Dollar Sales

dollar_sales

Dollar Sales Year Ago

dollar_sales_year_ago

Dollar Sales Any Merch

dollar_sales_any_merch

Dollar Sales Any Merch Year Ago

dollar_sales_any_merch_year_ago

Dollar Sales Price Reductions Only

dollar_sales_price_reductions_only

Dollar Sales Price Reductions Only Year Ago

dollar_sales_price_reductions_only_year_ago

Dollar Sales Feature Only

dollar_sales_feature_only

Dollar Sales Feature Only Year Ago

dollar_sales_feature_only_year_ago

Dollar Sales Display Only

dollar_sales_display_only

Dollar Sales Display Only Year Ago

dollar_sales_display_only_year_ago

Dollar Sales Feature and Display

dollar_sales_feature_and_display

Dollar Sales Feature and Display Year Ago

dollar_sales_feature_and_display_year_ago

Unit Sales

unit_sales

Unit Sales Year Ago

unit_sales_year_ago

Unit Sales Any Merch

unit_sales_any_merch

Unit Sales Any Merch Year Ago

unit_sales_any_merch_year_ago

ACV Weighted Distribution

acv_weighted_distribution

ACV Weighted Distribution Year Ago

acv_weighted_distribution_year_ago

Base Dollar Sales

base_dollar_sales

Base Dollar Sales Year Ago

base_dollar_sales_year_ago

Base Unit Sales

base_unit_sales

Base Unit Sales Year Ago

base_unit_sales_year_ago

Total Points of Distribution

total_points_of_distribution

Total Points of Distribution Year Ago

total_points_of_distribution_year_ago

Base Unit Sales Any Merch

base_unit_sales_any_merch

Base Unit Sales Any Merch Year Ago

base_unit_sales_any_merch_year_ago

Base Dollar Sales Any Merch

base_dollar_sales_any_merch

Base Dollar Sales Any Merch Year Ago

base_dollar_sales_any_merch_year_ago

Weeks in Distribution

weeks_in_distribution

Weeks in Distribution Year Ago

weeks_in_distribution_year_ago

Number of Stores Selling

number_of_stores_selling

Number of Stores Selling Year Ago

number_of_stores_selling_year_ago

Daasity: timestamp when loaded into DB

loaded_at

HEB Circana Products

Source: CSV file upload (heb_circana_products*.csv)

Update Method: UPSERT

Table Name: retail.heb_circana_products

Contains: Product dimension data including UPC, brand, category, and product attributes

CSV Column

Database Column

Geography

geography

Time

time

Product

product

UPC 10 digit

upc_10_digit

Brand

brand

Brand Franchise

brand_franchise