Stay organized with collections
Save and categorize content based on your preferences.
This page describes the insights you can get from the Cortex Looker Block
for Cross Media & Product Connected Insights. With this Looker Block
you can get a comprehensive view of your campaign spend and performance by
combining your campaign data from multiple paid media platforms
including Google Ads, Meta, TikTok and YouTube (with DV360) into
BigQuery with pre-packaged ingestion pipelines and reporting views
provided by Google Cloud Cortex Framework for Marketing.
This pipeline also includes an option to use a Gemini text generation
model on Vertex AI to match textual representations of media campaigns
with a single product hierarchy node. For example, a campaign named
"BMX - Reels - Reach" matches the product hierarchy node
['Fitness & Sports', 'Bicycles', 'Special Bikes','BMX Bikes'].
See a
high level breakdown of volume of impressions and clicks from each platform for
campaigns relating to specific product category and product.
Available insights
The Looker Block for Cross Media & Product Connected Insights in
Cortex Framework offers the following insights.
Overview of high-level performance and engagement metrics including:
- Total impressions
- Total clicks
- Click through rate (CTR)
- Total Spend
- Cost per Mille (CPM)
- Cost per click (CPC)
- Spend by month and media platform
- Cumulative monthly spend in total and by media platform
- Campaigns in chronological view
- Impressions, clicks, click through rate and cost per mille by media platform,
campaign, and country
- Detailed performance by campaign and country
Required Data
Get the required BigQuery datasets for this block by
following the installation instructions for
Cortex Framework.
Repository
To access the Cortex Looker Block for Cross Media & Product Connected
Insights, visit its official GitHub repository: block-cortex-cross-media.
This repository contains essential views, Explores and dashboards that enable
you to seamlessly integrate data into your Looker environment.
These resources provide a solid foundation for creating custom reports,
visualizations, and dashboards tailored to your specific needs.
Deployment
For instructions about how to deploy the Cortex Looker Block for
Cross Media & Product Connected Insights, see
Deploy Looker Blocks for Cortex Framework.
Other Considerations
For optimizing the performance and functionality of your
Looker Block for Cross Media & Product Connected Insights
consider the following:
- Liquid Templating Language: Some constants, views, Explores and
dashboards use liquid templating language. For more information, see
Looker's Liquid Variable Reference
documentation.
- Unhide additional dimensions and measures: Many dimensions
and measures are hidden for simplicity. If you find anything valuable missing,
set field's
hidden parameter value to No in the relevant views.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThis Looker Block provides a unified view of campaign performance and spend across multiple paid media platforms like Google Ads, Meta, TikTok, and YouTube (with DV360), using data consolidated in BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eIt offers insights into overall campaign performance, including total impressions, clicks, CTR, spend, CPM, and CPC.\u003c/p\u003e\n"],["\u003cp\u003eYou can analyze media platform performance and monthly spend trends, with a detailed breakdown by platform and country.\u003c/p\u003e\n"],["\u003cp\u003eThe Looker Block allows campaigns to be matched to specific product hierarchies using a Gemini text generation model on Vertex AI.\u003c/p\u003e\n"],["\u003cp\u003eThe block's resources, including views, Explores, and dashboards, are available on the block-cortex-cross-media GitHub repository, enabling users to customize reports and visualizations.\u003c/p\u003e\n"]]],[],null,["# Looker Block for Cross Media & Product Connected Insights\n\nLooker Block for Cross Media \\& Product Connected Insights\n==========================================================\n\nThis page describes the insights you can get from the Cortex Looker Block\nfor Cross Media \\& Product Connected Insights. With this Looker Block\nyou can get a comprehensive view of your campaign spend and performance by\ncombining your campaign data from multiple paid media platforms\nincluding Google Ads, Meta, TikTok and YouTube (with DV360) into\nBigQuery with pre-packaged ingestion pipelines and reporting views\nprovided by [Google Cloud Cortex Framework for Marketing](/cortex/docs/overview).\n\nThis pipeline also includes an option to use a Gemini text generation\nmodel on Vertex AI to match textual representations of media campaigns\nwith a single product hierarchy node. For example, a campaign named\n*\"BMX - Reels - Reach\"* matches the product hierarchy node\n`['Fitness & Sports', 'Bicycles', 'Special Bikes','BMX Bikes']`.\n\nSee a\nhigh level breakdown of volume of impressions and clicks from each platform for\ncampaigns relating to specific product category and product.\n\nAvailable insights\n------------------\n\nThe Looker Block for Cross Media \\& Product Connected Insights in\nCortex Framework offers the following insights.\n\nOverall campaign performance\n----------------------------\n\nOverview of high-level performance and engagement metrics including:\n\n- Total impressions\n- Total clicks\n- Click through rate (CTR)\n- Total Spend\n- Cost per Mille (CPM)\n- Cost per click (CPC)\n\n### Media platform performance and spend by month\n\n- Spend by month and media platform\n- Cumulative monthly spend in total and by media platform\n\n### Campaign performance\n\n- Campaigns in chronological view\n- Impressions, clicks, click through rate and cost per mille by media platform, campaign, and country\n- Detailed performance by campaign and country\n\nRequired Data\n-------------\n\nGet the required BigQuery datasets for this block by\nfollowing the installation instructions for\n[Cortex Framework](https://github.com/GoogleCloudPlatform/cortex-data-foundation).\n\nRepository\n----------\n\nTo access the Cortex Looker Block for Cross Media \\& Product Connected\nInsights, visit its official GitHub repository: [**block-cortex-cross-media**](https://github.com/looker-open-source/block-cortex-cross-media).\nThis repository contains essential views, Explores and dashboards that enable\nyou to seamlessly integrate data into your Looker environment.\nThese resources provide a solid foundation for creating custom reports,\nvisualizations, and dashboards tailored to your specific needs.\n\nDeployment\n----------\n\nFor instructions about how to deploy the Cortex Looker Block for\nCross Media \\& Product Connected Insights, see\n[Deploy Looker Blocks for Cortex Framework](/cortex/docs/looker-block-deployment).\n\n### Other Considerations\n\nFor optimizing the performance and functionality of your\nLooker Block for Cross Media \\& Product Connected Insights\nconsider the following:\n\n- **Liquid Templating Language** : Some constants, views, Explores and dashboards use liquid templating language. For more information, see Looker's [Liquid Variable Reference](/looker/docs/liquid-variable-reference) documentation.\n- **Unhide additional dimensions and measures** : Many dimensions and measures are hidden for simplicity. If you find anything valuable missing, set field's `hidden` parameter value to `No` in the relevant views."]]
