All StarThinker recipes and solutions can be run from Google Collaboratory. Also visit the Solution Gallery or click a link below to deploy a notebook.
- BigQuery Anonymize Dataset - Copies tables and view from one dataset to another and anynonamizes all rows. Used to create sample datasets for dashboards.
- BigQuery Anonymize Query - Runs a query and anynonamizes all rows. Used to create sample table for dashboards.
- Storage Archive - Wipe old information from a Storage bucket based on last update time.
- DV360 Audience Analysis - The Audience Wizard Dashboard helps you to track the audience performance across all audiences on Display.
- CM360 User Audit - Gives CM clients ability to see which profiles have access to which parts of an account. Loads CM user profile mappings using the API into BigQuery and connects to a DataStudio dashboard.
- DV360 User Audit - Gives DV clients ability to see which users have access to which parts of an account. Loads DV user profile mappings using the API into BigQuery and connects to a DataStudio dashboard.
- Census Data Correlation - Correlate another table with US Census data. Expands a data set dimensions by finding population segments that correlate with the master table.
- Census Data Normalized - Convert given census table to percent of population, normalizing it.
- BigQuery Function - Add a custom function or table to a dataset.
- BigQuery Query To Table - Save query results into a BigQuery table.
- BigQuery Query Run - Run query on a project.
- Storage To Table - Move using bucket and path prefix.
- BigQuery Query to Sheet - Copy the contents of a query into a Google Sheet.
- BigQuery Query To View - Create a BigQuery view.
- Storage Bucket - Create and permission a bucket in Storage.
- CM360 Bulkdozer Editor - Bulkdozer is a tool that can reduce trafficking time in Campaign Manager by up to 80%% by providing automated bulk editing capabilities.
- CM360 Campaign Comparison - Group KPIs into cohorts and compare performance across time and geography. Quickly discover where national and local campaigns need to be targeted, funded, or optimized.
- CM360 Conversion Upload From BigQuery - Move from BigQuery to CM.
- CM360 Conversion Upload From Sheets - Move form Sheets to CM.
- CM360 Data Warehouse - Deploy a BigQuery dataset mirroring CM360 account structure. Foundation for solutions on top.
- CM360 Geo Trends - Analyze performance against radius around specific locations. Includes correlation to local landmarks and features derived from public data sets.
- CM360 Oculi - Export CM360 Creatives into BigQuery, process them with the Vision API, and generate a breakdown of each creative asset mapped back to its parent. Also generate a series of views to flatten the data.
- CM360 Report Replicate - Replicate a report across multiple networks and advertisers.
- CM360 Segmentology - CM360 funnel analysis using Census data.
- CM360 To DV360 Bulk Creator - Allows bulk creating DV360 Insertion Orders and Line Items from CM360.
- CM360 Campaign Auditor - A tool for rapidly bulk checking Campaign Manager campaigns
- CM360 Bulk User Editor - A tool for rapidly bulk editing Campaign Manager profiles, roles, and sub accounts.
- cTV Inventory Availability Dashboard - The cTV Audience Affinity dashboard is designed to give clients insights into which cTV apps their audiences have a high affinity for using. The goal of this dashboard is to provide some assistance with the lack of audience targeting for cTV within DV360.
- BigQuery Dataset - Create and permission a dataset in BigQuery.
- DV360 Report - Create a DV360 report.
- DV360 Report To BigQuery - Move existing DV360 reports into a BigQuery table.
- DV360 Report To Sheets - Move existing DV360 report into a Sheets tab.
- DV360 Report To Storage - Move existing DV360 report into a Storage bucket.
- CM360 Report - Create a CM report from a JSON definition.
- CM360 Log Audit - Downloads Campaign manager logs and allows audits.
- CM360 Report Run - Trigger a CM report run
- CM360 Report To BigQuery - Move existing CM report into a BigQuery table.
- CM360 Report To Sheets - Move existing CM report into a Sheet tab.
- CM360 Report To Storage - Move existing CM report into a Storage bucket.
- DV360 Deal Finder - Compares open vs. deal CPM, CPC, and CPA so that clients can decide which sites, inventory, and deals work best.
- Drive Copy - Copy a drive document.
- CM360 Data Transfer To Bigquery - Move data from a DT bucket into a BigQuery table.
- DV360 Data Warehouse - Deploy a BigQuery dataset mirroring DV360 account structure. Foundation for solutions on top.
- DV360 Bulk Editor - Allows bulk editing DV360 through Sheets and BigQuery.
- DV360 Segmentology - DV360 funnel analysis using Census data.
- DV360 Bulk Targeting Editor - Allows bulk targeting DV360 through Sheets and BigQuery.
- DV360 Targeting Audit - Continously audit all targeting settings for a DV360 Partner in one dashboard. Use filters to locate errant targeting and quickly correct issues.
- Dynamic Costs Reporting - Calculate DV360 cost at the dynamic creative combination level.
- CM360 Report Emailed To BigQuery - Pulls a CM Report from a gMail powered email account into BigQuery.
- DV360 Report Emailed To BigQuery - Pulls a DV360 Report from a gMail email into BigQuery.
- Email Fetch - Import emailed CM report, Dv360 report, csv, or excel into a BigQuery table.
- CM360 Floodlight Monitor - Monitor floodlight impressions specified in sheet and send email alerts.
- Federal Reserve Regional Data - Download federal reserve region.
- Federal Reserve Series Data - Download federal reserve series.
- GA360 Segmentology - GA360 funnel analysis using Census data.
- GoogleAds Segmentology - GoogleAds funnel analysis using Census data.
- Google API To BigQuery - Execute any Google API function and store results to BigQuery.
- Say Hello - Recipe template for say hello.
- Project IAM - Sets project permissions for an email.
- DV360 / CM360 Privacy Audit - Dashboard that shows performance metrics across browser to see the impact of privacy changes.
- Tag Key Value Uploader - A tool for bulk editing key value pairs for CM placements.
- Test Script - Used by tests.
- DV360 Monthly Budget Mover - Apply the previous month's budget/spend delta to the current month. Aggregate up the budget and spend from the previous month of each category declared then apply the delta of the spend and budget equally to each Line Item under that Category.
- PoliceBot - A tool that helps enforce CM object name conventions by checking names against a set of client-defined patterns, and emailing violations to appropriate agency teams on a daily basis.
- SA360 Web Query Report - Download SA360 reports into a Google Sheet.
- SA360 Report - Move SA360 report to BigQuery.
- Salesforce To BigQuery - Move query results into a BigQuery table.
- DV360 SDF To BigQuery - Download SDF reports into a BigQuery table.
- Sheet Clear - Clear data from a sheet.
- Sheet Copy - Copy tab from a sheet to a sheet.
- Sheet To BigQuery - Import data from a sheet and move it to a BigQuery table.
- SmartSheet Report To BigQuery - Move report data into a BigQuery table.
- SmartSheet Sheet To BigQuery - Move sheet data into a BigQuery table.
- Test Script - Used by tests.
- CM360 Domain And App Transparency - Reports the percentage of CM impressions that can be attributed to a specific domain or application. Allows diagnostic of which domains and apps are misconfigured by publisher resulting in underreporting.
- Trends Places To BigQuery Via Query - Move using a WOEID query.
- Trends Places To BigQuery Via Values - Move using hard coded WOEID values.
- Trends Places To Sheets Via Query - Move using a WOEID query.
- Trends Places To Sheets Via Values - Move using hard coded WOEID values.
- Twitter Targeting - Adjusts line item settings based on Twitter hashtags and locations specified in a sheet.
- URL - Pull URL list from a table, fetch them, and write the results to another table.
- Video Overlay - Add images, text, and audio to videos.
© 2019 Google LLC - Apache License, Version 2.0