BigQuery tables behind Looker studio dashboard for the Product mix modelling report | Learning Center

If you want to work with the data output directly in BigQuery, getting started is straightforward. Below is an example query to analyse performance metrics from your Product mix modelling report using a MACD model.

This query retrieves and summarises Product mix modelling report data, focusing on total item views, revenue, and purchases for each brand. It calculates the MACD scores and identifies the trending brands based on their performance over different time periods.

SELECT 
  item_brand, 
  SUM(item_views) AS total_item_views, 
  SUM(item_revenue) AS total_item_revenue, 
  SUM(item_purchases) AS total_item_purchases,     AVG(item_purchases_macd_07_30) AS avg_purchases_macd_07_30,     AVG(item_purchases_macd_30_90) AS avg_purchases_macd_30_90,     AVG(item_views_macd_07_30) AS avg_views_macd_07_30,     AVG(item_views_macd_30_90) AS avg_views_macd_30_90,     AVG(revenue_share_07_30_signal_line_10) AS avg_revenue_share_macd_07_30_signal,     AVG(revenue_share_30_90_signal_line_10) AS avg_revenue_share_macd_30_90_signal, 
AVG(item_purchases_score_macd_07_30) AS avg_purchases_score_macd_07_30,   AVG(item_purchases_score_macd_30_90) AS avg_purchases_score_macd_30_90,   AVG(item_views_score_macd_07_30) AS avg_views_score_macd_07_30,   AVG(item_views_score_macd_30_90) AS avg_views_score_macd_30_90,   AVG(revenue_share_score_07_30) AS avg_revenue_share_score_07_30,     AVG(revenue_share_score_30_90) AS avg_revenue_share_score_30_90 
FROM project.dataset.pmm_item_brand_level_report_{table_suffix} 
WHERE date >= '2023-01-01' 
GROUP BY 
  item_brand 
ORDER BY 
  avg_purchases_score_macd_07_30 DESC, 
  avg_views_score_macd_07_30 DESC, 
  avg_revenue_share_score_07_30 DESC 
LIMIT 10

Below is the detailed schema of the output tables in BigQuery:

Table 1: pmm_item_sku_level_report_{table_suffix}

Full name	Type	Description
run_date	DATETIME	The date and time when the report was run.
date	DATE	The date of the record.
item_sku	STRING	The SKU (Stock Keeping Unit) of the item.
currency_code	STRING	The currency code used for the transactions.
item_views	FLOAT	The number of item views.
item_revenue	FLOAT	The revenue generated from the item.
item_purchases	FLOAT	The number of item purchases.
item_purchases_filtered	FLOAT	The number of filtered item purchases.
item_views_filtered	FLOAT	The number of filtered item views.
item_revenue_rolling_07	FLOAT	The 7-day rolling revenue for the item.
item_revenue_rolling_30	FLOAT	The 30-day rolling revenue for the item.
item_revenue_rolling_90	FLOAT	The 90-day rolling revenue for the item.
item_purchases_ema_07	FLOAT	The 7-day exponential moving average of item purchases.
item_purchases_ema_30	FLOAT	The 30-day exponential moving average of item purchases.
item_purchases_ema_90	FLOAT	The 90-day exponential moving average of item purchases.
item_views_ema_07	FLOAT	The 7-day exponential moving average of item views.
item_views_ema_30	FLOAT	The 30-day exponential moving average of item views.
item_views_ema_90	FLOAT	The 90-day exponential moving average of item views.
revenue_share	FLOAT	The share of total revenue attributed to the item.
revenue_share_rolling_07	FLOAT	The 7-day rolling revenue share.
revenue_share_rolling_30	FLOAT	The 30-day rolling revenue share.
revenue_share_rolling_90	FLOAT	The 90-day rolling revenue share.
item_purchases_macd_07_30	FLOAT	The MACD value for item purchases between 7 and 30 days.
item_purchases_macd_30_90	FLOAT	The MACD value for item purchases between 30 and 90 days.
item_views_macd_07_30	FLOAT	The MACD value for item views between 7 and 30 days.
item_views_macd_30_90	FLOAT	The MACD value for item views between 30 and 90 days.
change_in_revenue_share_07_30	FLOAT	The change in revenue share between 7 and 30 days.
change_in_revenue_share_30_90	FLOAT	The change in revenue share between 30 and 90 days.
item_purchases_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item purchases between 7 and 30 days with a signal line of 10 days.
item_purchases_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item purchases between 30 and 90 days with a signal line of 10 days.
item_views_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item views between 7 and 30 days with a signal line of 10 days.
item_views_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item views between 30 and 90 days with a signal line of 10 days.
revenue_share_07_30_signal_line_10	FLOAT	The MACD signal line for revenue share between 7 and 30 days with a signal line of 10 days.
revenue_share_30_90_signal_line_10	FLOAT	The MACD signal line for revenue share between 30 and 90 days with a signal line of 10 days.
item_purchases_score_macd_07_30	FLOAT	The score for item purchases MACD between 7 and 30 days.
item_purchases_score_macd_30_90	FLOAT	The score for item purchases MACD between 30 and 90 days.
item_views_score_macd_07_30	FLOAT	The score for item views MACD between 7 and 30 days.
item_views_score_macd_30_90	FLOAT	The score for item views MACD between 30 and 90 days.
revenue_share_score_07_30	FLOAT	The score for revenue share MACD between 7 and 30 days.
revenue_share_score_30_90	FLOAT	The score for revenue share MACD between 30 and 90 days.
item_purchases_label_07_30	STRING	The label for item purchases between 7 and 30 days.
item_purchases_label_30_90	STRING	The label for item purchases between 30 and 90 days.
item_views_label_07_30	STRING	The label for item views between 7 and 30 days.
item_views_label_30_90	STRING	The label for item views between 30 and 90 days.
revenue_share_label_07_30	STRING	The label for revenue share between 7 and 30 days.
revenue_share_label_30_90	STRING	The label for revenue share between 30 and 90 days.
is_low_volume_item	BOOLEAN	Indicates if the item is low volume.
is_current_result	BOOLEAN	Indicates if the result is current.
item_name	STRING	The name of the item.
item_brand	STRING	The brand of the item.
item_category	STRING	The category of the item.

Table 2: pmm_item_brand_level_report_{table_suffix}

Full name	Type	Description
run_date	DATETIME	The date and time when the report was run.
date	DATE	The date of the record.
item_brand	STRING	The brand of the item.
currency_code	STRING	The currency code used for the transactions.
item_views	FLOAT	The number of item views.
item_revenue	FLOAT	The revenue generated from the item.
item_purchases	FLOAT	The number of item purchases.
item_purchases_filtered	FLOAT	The number of filtered item purchases.
item_views_filtered	FLOAT	The number of filtered item views.
item_revenue_rolling_07	FLOAT	The 7-day rolling revenue for the item.
item_revenue_rolling_30	FLOAT	The 30-day rolling revenue for the item.
item_revenue_rolling_90	FLOAT	The 90-day rolling revenue for the item.
item_purchases_ema_07	FLOAT	The 7-day exponential moving average of item purchases.
item_purchases_ema_30	FLOAT	The 30-day exponential moving average of item purchases.
item_purchases_ema_90	FLOAT	The 90-day exponential moving average of item purchases.
item_views_ema_07	FLOAT	The 7-day exponential moving average of item views.
item_views_ema_30	FLOAT	The 30-day exponential moving average of item views.
item_views_ema_90	FLOAT	The 90-day exponential moving average of item views.
revenue_share	FLOAT	The share of total revenue attributed to the item.
revenue_share_rolling_07	FLOAT	The 7-day rolling revenue share.
revenue_share_rolling_30	FLOAT	The 30-day rolling revenue share.
revenue_share_rolling_90	FLOAT	The 90-day rolling revenue share.
item_purchases_macd_07_30	FLOAT	The MACD value for item purchases between 7 and 30 days.
item_purchases_macd_30_90	FLOAT	The MACD value for item purchases between 30 and 90 days.
item_views_macd_07_30	FLOAT	The MACD value for item views between 7 and 30 days.
item_views_macd_30_90	FLOAT	The MACD value for item views between 30 and 90 days.
change_in_revenue_share_07_30	FLOAT	The change in revenue share between 7 and 30 days.
change_in_revenue_share_30_90	FLOAT	The change in revenue share between 30 and 90 days.
item_purchases_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item purchases between 7 and 30 days with a signal line of 10 days.
item_purchases_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item purchases between 30 and 90 days with a signal line of 10 days.
item_views_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item views between 7 and 30 days with a signal line of 10 days.
item_views_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item views between 30 and 90 days with a signal line of 10 days.
revenue_share_07_30_signal_line_10	FLOAT	The MACD signal line for revenue share between 7 and 30 days with a signal line of 10 days.
revenue_share_30_90_signal_line_10	FLOAT	The MACD signal line for revenue share between 30 and 90 days with a signal line of 10 days.
item_purchases_score_macd_07_30	FLOAT	The score for item purchases MACD between 7 and 30 days.
item_purchases_score_macd_30_90	FLOAT	The score for item purchases MACD between 30 and 90 days.
item_views_score_macd_07_30	FLOAT	The score for item views MACD between 7 and 30 days.
item_views_score_macd_30_90	FLOAT	The score for item views MACD between 30 and 90 days.
revenue_share_score_07_30	FLOAT	The score for revenue share MACD between 7 and 30 days.
revenue_share_score_30_90	FLOAT	The score for revenue share MACD between 30 and 90 days.
item_purchases_label_07_30	STRING	The label for item purchases between 7 and 30 days.
item_purchases_label_30_90	STRING	The label for item purchases between 30 and 90 days.
item_views_label_07_30	STRING	The label for item views between 7 and 30 days.
item_views_label_30_90	STRING	The label for item views between 30 and 90 days.
revenue_share_label_07_30	STRING	The label for revenue share between 7 and 30 days.
revenue_share_label_30_90	STRING	The label for revenue share between 30 and 90 days.
is_low_volume_item	BOOLEAN	Indicates if the item is low volume.
is_current_result	BOOLEAN	Indicates if the result is current.

Table 3: pmm_brand_market_level_report_{table_suffix}

Full name	Type	Description
run_date	DATETIME	The date and time when the report was run.
date	DATE	The date of the record.
item_brand	STRING	The brand of the item.
property_id	STRING	The unique identifier for the property where the data was collected (e.g., website or app).
market	STRING	The market in which the item is being sold, typically representing a geographic region or specific country.
currency_code	STRING	The currency code used for the transactions (e.g., USD, EUR).
item_views	FLOAT	The number of item views.
item_revenue	FLOAT	The revenue generated from the item.
item_purchases	FLOAT	The number of item purchases.
item_purchases_filtered	FLOAT	The number of filtered item purchases, potentially excluding certain outliers or specific conditions.
item_views_filtered	FLOAT	The number of filtered item views, potentially excluding certain outliers or specific conditions.
item_revenue_rolling_07	FLOAT	The 7-day rolling revenue for the item.
item_revenue_rolling_30	FLOAT	The 30-day rolling revenue for the item.
item_revenue_rolling_90	FLOAT	The 90-day rolling revenue for the item.
item_purchases_ema_07	FLOAT	The 7-day exponential moving average of item purchases.
item_purchases_ema_30	FLOAT	The 30-day exponential moving average of item purchases.
item_purchases_ema_90	FLOAT	The 90-day exponential moving average of item purchases.
item_views_ema_07	FLOAT	The 7-day exponential moving average of item views.
item_views_ema_30	FLOAT	The 30-day exponential moving average of item views.
item_views_ema_90	FLOAT	The 90-day exponential moving average of item views.
revenue_share	FLOAT	The share of total revenue attributed to the item.
revenue_share_rolling_07	FLOAT	The 7-day rolling revenue share.
revenue_share_rolling_30	FLOAT	The 30-day rolling revenue share.
revenue_share_rolling_90	FLOAT	The 90-day rolling revenue share.
item_purchases_macd_07_30	FLOAT	The MACD (Moving Average Convergence Divergence) value for item purchases between 7 and 30 days.
item_purchases_macd_30_90	FLOAT	The MACD value for item purchases between 30 and 90 days.
item_views_macd_07_30	FLOAT	The MACD value for item views between 7 and 30 days.
item_views_macd_30_90	FLOAT	The MACD value for item views between 30 and 90 days.
change_in_revenue_share_07_30	FLOAT	The change in revenue share between 7 and 30 days.
change_in_revenue_share_30_90	FLOAT	The change in revenue share between 30 and 90 days.
item_purchases_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item purchases between 7 and 30 days with a signal line of 10 days.
item_purchases_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item purchases between 30 and 90 days with a signal line of 10 days.
item_views_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item views between 7 and 30 days with a signal line of 10 days.
item_views_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item views between 30 and 90 days with a signal line of 10 days.
revenue_share_07_30_signal_line_10	FLOAT	The MACD signal line for revenue share between 7 and 30 days with a signal line of 10 days.
revenue_share_30_90_signal_line_10	FLOAT	The MACD signal line for revenue share between 30 and 90 days with a signal line of 10 days.
item_purchases_score_macd_07_30	FLOAT	The score for item purchases MACD between 7 and 30 days, typically used for assessing momentum or trend strength.
item_purchases_score_macd_30_90	FLOAT	The score for item purchases MACD between 30 and 90 days.
item_views_score_macd_07_30	FLOAT	The score for item views MACD between 7 and 30 days.
item_views_score_macd_30_90	FLOAT	The score for item views MACD between 30 and 90 days.
revenue_share_score_07_30	FLOAT	The score for revenue share MACD between 7 and 30 days.
revenue_share_score_30_90	FLOAT	The score for revenue share MACD between 30 and 90 days.
item_purchases_label_07_30	STRING	The label for item purchases between 7 and 30 days, potentially categorizing performance (e.g., increasing, decreasing).
item_purchases_label_30_90	STRING	The label for item purchases between 30 and 90 days.
item_views_label_07_30	STRING	The label for item views between 7 and 30 days.
item_views_label_30_90	STRING	The label for item views between 30 and 90 days.
revenue_share_label_07_30	STRING	The label for revenue share between 7 and 30 days.
revenue_share_label_30_90	STRING	The label for revenue share between 30 and 90 days.
is_low_volume_item	BOOLEAN	Indicates if the item is considered low volume, which might influence reporting and analysis (e.g., less frequent transactions).
is_current_result	BOOLEAN	Indicates if the result is current, distinguishing between live data and historical data.

Table 4: pmm_category_market_level_report_{table_suffix}

Full name	Type	Description
Product mix modelling report	DATETIME	The date and time when the report was run.
Product mix modelling report	DATE	The date of the record.
Product mix modelling report	STRING	The category of the item, providing a classification that groups similar products together.
Product mix modelling report	STRING	The unique identifier for the property where the data was collected (e.g., website or app).
Product mix modelling report	STRING	The market in which the item is being sold, typically representing a geographic region or specific country.
Product mix modelling report	STRING	The currency code used for the transactions (e.g., USD, EUR).
Product mix modelling report	FLOAT	The number of item views.
Product mix modelling report	FLOAT	The revenue generated from the item.
Product mix modelling report	FLOAT	The number of item purchases.
Product mix modelling report	FLOAT	The number of filtered item purchases, potentially excluding certain outliers or specific conditions.
Product mix modelling report	FLOAT	The number of filtered item views, potentially excluding certain outliers or specific conditions.
Product mix modelling report	FLOAT	The 7-day rolling revenue for the item.
Product mix modelling report	FLOAT	The 30-day rolling revenue for the item.
Product mix modelling report	FLOAT	The 90-day rolling revenue for the item.
Product mix modelling report	FLOAT	The 7-day exponential moving average of item purchases.
Product mix modelling report	FLOAT	The 30-day exponential moving average of item purchases.
Product mix modelling report	FLOAT	The 90-day exponential moving average of item purchases.
Product mix modelling report	FLOAT	The 7-day exponential moving average of item views.
Product mix modelling report	FLOAT	The 30-day exponential moving average of item views.
Product mix modelling report	FLOAT	The 90-day exponential moving average of item views.
Product mix modelling report	FLOAT	The share of total revenue attributed to the item.
Product mix modelling report	FLOAT	The 7-day rolling revenue share.
Product mix modelling report	FLOAT	The 30-day rolling revenue share.
Product mix modelling report	FLOAT	The 90-day rolling revenue share.
Product mix modelling report	FLOAT	The MACD (Moving Average Convergence Divergence) value for item purchases between 7 and 30 days.
Product mix modelling report	FLOAT	The MACD value for item purchases between 30 and 90 days.
Product mix modelling report	FLOAT	The MACD value for item views between 7 and 30 days.
Product mix modelling report	FLOAT	The MACD value for item views between 30 and 90 days.
Product mix modelling report	FLOAT	The change in revenue share between 7 and 30 days.
Product mix modelling report	FLOAT	The change in revenue share between 30 and 90 days.
Product mix modelling report	FLOAT	The MACD signal line for item purchases between 7 and 30 days with a signal line of 10 days.
Product mix modelling report	FLOAT	The MACD signal line for item purchases between 30 and 90 days with a signal line of 10 days.
Product mix modelling report	FLOAT	The MACD signal line for item views between 7 and 30 days with a signal line of 10 days.
Product mix modelling report	FLOAT	The MACD signal line for item views between 30 and 90 days with a signal line of 10 days.
Product mix modelling report	FLOAT	The MACD signal line for revenue share between 7 and 30 days with a signal line of 10 days.
Product mix modelling report	FLOAT	The MACD signal line for revenue share between 30 and 90 days with a signal line of 10 days.
Product mix modelling report	FLOAT	The score for item purchases MACD between 7 and 30 days, typically used for assessing momentum or trend strength.
Product mix modelling report	FLOAT	The score for item purchases MACD between 30 and 90 days.
Product mix modelling report	FLOAT	The score for item views MACD between 7 and 30 days.
Product mix modelling report	FLOAT	The score for item views MACD between 30 and 90 days.
Product mix modelling report	FLOAT	The score for revenue share MACD between 7 and 30 days.
Product mix modelling report	FLOAT	The score for revenue share MACD between 30 and 90 days.
Product mix modelling report	STRING	The label for item purchases between 7 and 30 days, potentially categorizing performance (e.g., increasing, decreasing).
Product mix modelling report	STRING	The label for item purchases between 30 and 90 days.
Product mix modelling report	STRING	The label for item views between 7 and 30 days.
Product mix modelling report	STRING	The label for item views between 30 and 90 days.
Product mix modelling report	STRING	The label for revenue share between 7 and 30 days.
Product mix modelling report	STRING	The label for revenue share between 30 and 90 days.
Product mix modelling report	BOOLEAN	Indicates if the item is considered low volume, which might influence reporting and analysis (e.g., less frequent transactions).
Product mix modelling report	BOOLEAN	Indicates if the result is current, distinguishing between live data and historical data.

Table 5: pmm_ga4_base_metrics_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
currency_code	STRING	The currency code used for the transactions (e.g., USD, EUR).
property_id	STRING	The unique identifier for the property where the data was collected (e.g., website or app).
hostname	STRING	The hostname where the data was collected, typically representing the domain of the website or app.
source	STRING	The source of the traffic, such as a search engine (e.g., Google), a social media platform, or a direct link.
medium	STRING	The medium through which the traffic was acquired, such as organic search, paid search, email, or referral.
campaign	STRING	The name of the marketing campaign that drove the traffic.
campaign_id	STRING	The unique identifier for the marketing campaign, used for tracking and reporting purposes.
sessions	FLOAT	The number of sessions recorded, representing user interactions with the property within a given time frame.
engagedSessions	FLOAT	The number of engaged sessions, where users interacted meaningfully with the property (e.g., spending a certain amount of time or visiting multiple pages).
market	STRING	The market in which the campaign is being run, typically representing a geographic region or specific country.
transactions	FLOAT	The number of transactions completed as a result of the campaign.
Revenue	FLOAT	The total revenue generated from the transactions attributed to the campaign.
newUsers	FLOAT	The number of new users acquired through the campaign, representing first-time visitors to the property.
firstTimePurchasers	FLOAT	The number of first-time purchasers who completed their first transaction as a result of the campaign.

Table 6: pmm_item_category_level_report_{table_suffix}

Full name	Type	Description
run_date	DATETIME	The date and time when the report was run.
date	DATE	The date of the record.
item_category	STRING	The category of the item, providing a classification that groups similar products together.
currency_code	STRING	The currency code used for the transactions (e.g., USD, EUR).
item_views	FLOAT	The number of item views.
item_revenue	FLOAT	The revenue generated from the item.
item_purchases	FLOAT	The number of item purchases.
item_purchases_filtered	FLOAT	The number of filtered item purchases, potentially excluding certain outliers or specific conditions.
item_views_filtered	FLOAT	The number of filtered item views, potentially excluding certain outliers or specific conditions.
item_revenue_rolling_07	FLOAT	The 7-day rolling revenue for the item.
item_revenue_rolling_30	FLOAT	The 30-day rolling revenue for the item.
item_revenue_rolling_90	FLOAT	The 90-day rolling revenue for the item.
item_purchases_ema_07	FLOAT	The 7-day exponential moving average of item purchases.
item_purchases_ema_30	FLOAT	The 30-day exponential moving average of item purchases.
item_purchases_ema_90	FLOAT	The 90-day exponential moving average of item purchases.
item_views_ema_07	FLOAT	The 7-day exponential moving average of item views.
item_views_ema_30	FLOAT	The 30-day exponential moving average of item views.
item_views_ema_90	FLOAT	The 90-day exponential moving average of item views.
revenue_share	FLOAT	The share of total revenue attributed to the item.
revenue_share_rolling_07	FLOAT	The 7-day rolling revenue share.
revenue_share_rolling_30	FLOAT	The 30-day rolling revenue share.
revenue_share_rolling_90	FLOAT	The 90-day rolling revenue share.
item_purchases_macd_07_30	FLOAT	The MACD (Moving Average Convergence Divergence) value for item purchases between 7 and 30 days.
item_purchases_macd_30_90	FLOAT	The MACD value for item purchases between 30 and 90 days.
item_views_macd_07_30	FLOAT	The MACD value for item views between 7 and 30 days.
item_views_macd_30_90	FLOAT	The MACD value for item views between 30 and 90 days.
change_in_revenue_share_07_30	FLOAT	The change in revenue share between 7 and 30 days.
change_in_revenue_share_30_90	FLOAT	The change in revenue share between 30 and 90 days.
item_purchases_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item purchases between 7 and 30 days with a signal line of 10 days.
item_purchases_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item purchases between 30 and 90 days with a signal line of 10 days.
item_views_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item views between 7 and 30 days with a signal line of 10 days.
item_views_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item views between 30 and 90 days with a signal line of 10 days.
revenue_share_07_30_signal_line_10	FLOAT	The MACD signal line for revenue share between 7 and 30 days with a signal line of 10 days.
revenue_share_30_90_signal_line_10	FLOAT	The MACD signal line for revenue share between 30 and 90 days with a signal line of 10 days.
item_purchases_score_macd_07_30	FLOAT	The score for item purchases MACD between 7 and 30 days, typically used for assessing momentum or trend strength.
item_purchases_score_macd_30_90	FLOAT	The score for item purchases MACD between 30 and 90 days.
item_views_score_macd_07_30	FLOAT	The score for item views MACD between 7 and 30 days.
item_views_score_macd_30_90	FLOAT	The score for item views MACD between 30 and 90 days.
revenue_share_score_07_30	FLOAT	The score for revenue share MACD between 7 and 30 days.
revenue_share_score_30_90	FLOAT	The score for revenue share MACD between 30 and 90 days.
item_purchases_label_07_30	STRING	The label for item purchases between 7 and 30 days, potentially categorizing performance (e.g., increasing, decreasing).
item_purchases_label_30_90	STRING	The label for item purchases between 30 and 90 days.
item_views_label_07_30	STRING	The label for item views between 7 and 30 days.
item_views_label_30_90	STRING	The label for item views between 30 and 90 days.
revenue_share_label_07_30	STRING	The label for revenue share between 7 and 30 days.
revenue_share_label_30_90	STRING	The label for revenue share between 30 and 90 days.
is_low_volume_item	BOOLEAN	Indicates if the item is considered low volume, which might influence reporting and analysis (e.g., less frequent transactions).
is_current_result	BOOLEAN	Indicates if the result is current, distinguishing between live data and historical data.

Table 7: pmm_product_base_metrics_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
property_id	STRING	The unique identifier for the property where the data was collected (e.g., website or app).
hostname	STRING	The hostname where the data was collected, typically representing the domain of the website or app.
market	STRING	The market in which the item is being sold, typically representing a geographic region or specific country.
currency_code	STRING	The currency code used for the transactions (e.g., USD, EUR).
item_category	STRING	The category of the item, providing a high-level classification for grouping similar products together.
item_sku	STRING	The SKU (Stock Keeping Unit) of the item, serving as a unique identifier for the product.
item_name	STRING	The name of the item, typically the product's title or description.
item_brand	STRING	The brand of the item, indicating the manufacturer or the label under which the product is sold.
item_category_1	STRING	The first level of item categorization, often used for a primary product category.
itemCategory2	STRING	The second level of item categorization, providing further granularity within the primary category.
itemCategory3	STRING	The third level of item categorization, offering additional specificity within the secondary category.
item_revenue	FLOAT	The revenue generated from the item.
item_purchases	FLOAT	The number of item purchases.
item_views	FLOAT	The number of item views, indicating how many times the item was viewed by users.

Table 8: pmm_sku_market_level_report_{table_suffix}

Full name	Type	Description
run_date	DATETIME	The date and time when the report was run.
date	DATE	The date of the record.
property_id	STRING	The unique identifier for the property where the data was collected (e.g., website or app).
item_sku	STRING	The SKU (Stock Keeping Unit) of the item, serving as a unique identifier for the product.
market	STRING	The market in which the item is being sold, typically representing a geographic region or specific country.
currency_code	STRING	The currency code used for the transactions (e.g., USD, EUR).
item_views	FLOAT	The number of item views.
item_revenue	FLOAT	The revenue generated from the item.
item_purchases	FLOAT	The number of item purchases.
item_purchases_filtered	FLOAT	The number of filtered item purchases, potentially excluding certain outliers or specific conditions.
item_views_filtered	FLOAT	The number of filtered item views, potentially excluding certain outliers or specific conditions.
item_revenue_rolling_07	FLOAT	The 7-day rolling revenue for the item.
item_revenue_rolling_30	FLOAT	The 30-day rolling revenue for the item.
item_revenue_rolling_90	FLOAT	The 90-day rolling revenue for the item.
item_purchases_ema_07	FLOAT	The 7-day exponential moving average of item purchases.
item_purchases_ema_30	FLOAT	The 30-day exponential moving average of item purchases.
item_purchases_ema_90	FLOAT	The 90-day exponential moving average of item purchases.
item_views_ema_07	FLOAT	The 7-day exponential moving average of item views.
item_views_ema_30	FLOAT	The 30-day exponential moving average of item views.
item_views_ema_90	FLOAT	The 90-day exponential moving average of item views.
revenue_share	FLOAT	The share of total revenue attributed to the item.
revenue_share_rolling_07	FLOAT	The 7-day rolling revenue share.
revenue_share_rolling_30	FLOAT	The 30-day rolling revenue share.
revenue_share_rolling_90	FLOAT	The 90-day rolling revenue share.
item_purchases_macd_07_30	FLOAT	The MACD (Moving Average Convergence Divergence) value for item purchases between 7 and 30 days.
item_purchases_macd_30_90	FLOAT	The MACD value for item purchases between 30 and 90 days.
item_views_macd_07_30	FLOAT	The MACD value for item views between 7 and 30 days.
item_views_macd_30_90	FLOAT	The MACD value for item views between 30 and 90 days.
change_in_revenue_share_07_30	FLOAT	The change in revenue share between 7 and 30 days.
change_in_revenue_share_30_90	FLOAT	The change in revenue share between 30 and 90 days.
item_purchases_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item purchases between 7 and 30 days with a signal line of 10 days.
item_purchases_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item purchases between 30 and 90 days with a signal line of 10 days.
item_views_macd_07_30_signal_line_10	FLOAT	The MACD signal line for item views between 7 and 30 days with a signal line of 10 days.
item_views_macd_30_90_signal_line_10	FLOAT	The MACD signal line for item views between 30 and 90 days with a signal line of 10 days.
revenue_share_07_30_signal_line_10	FLOAT	The MACD signal line for revenue share between 7 and 30 days with a signal line of 10 days.
revenue_share_30_90_signal_line_10	FLOAT	The MACD signal line for revenue share between 30 and 90 days with a signal line of 10 days.
item_purchases_score_macd_07_30	FLOAT	The score for item purchases MACD between 7 and 30 days, typically used for assessing momentum or trend strength.
item_purchases_score_macd_30_90	FLOAT	The score for item purchases MACD between 30 and 90 days.
item_views_score_macd_07_30	FLOAT	The score for item views MACD between 7 and 30 days.
item_views_score_macd_30_90	FLOAT	The score for item views MACD between 30 and 90 days.
revenue_share_score_07_30	FLOAT	The score for revenue share MACD between 7 and 30 days.
revenue_share_score_30_90	FLOAT	The score for revenue share MACD between 30 and 90 days.
item_purchases_label_07_30	STRING	The label for item purchases between 7 and 30 days, potentially categorizing performance (e.g., increasing, decreasing).
item_purchases_label_30_90	STRING	The label for item purchases between 30 and 90 days.
item_views_label_07_30	STRING	The label for item views between 7 and 30 days.
item_views_label_30_90	STRING	The label for item views between 30 and 90 days.
revenue_share_label_07_30	STRING	The label for revenue share between 7 and 30 days.
revenue_share_label_30_90	STRING	The label for revenue share between 30 and 90 days.
is_low_volume_item	BOOLEAN	Indicates if the item is considered low volume, which might influence reporting and analysis (e.g., less frequent transactions).
is_current_result	BOOLEAN	Indicates if the result is current, distinguishing between live data and historical data.
item_name	STRING	The name of the item, typically the product's title or description.
item_brand	STRING	The brand of the item, indicating the manufacturer or the label under which the product is sold.
item_category	STRING	The category of the item, providing a classification that groups similar products together.

BigQuery tables behind Looker studio dashboard for the Channel grouping performance report v2

BigQuery tables behind Looker studio for the Creative insights report

BigQuery tables behind Looker studio for the DV360 performance report

BigQuery tables behind Looker studio dashboard for the Shopping insights report v2

BigQuery tables behind Looker studio dashboard for the Black Friday report