Packaged Solutions link

These recipes are entire workflows that deploy end to end solutions for clients.

All 90 days older

more_vert donut_small

Airflow Composer Example

Demonstration that uses Airflow/Composer native, Airflow/Composer local, and StarThinker tasks in the same generated DAG.

close
Build Airflow / Composer workflows using StarThinker.
Deploy any existing recipe as a DAG.
Refrence Service and User Credential integration.
Minimize manual DAG coding work.
more_vert waves

BigQuery Anonymize Dataset

Copies tables and view from one dataset to another and anynonamizes all rows. Used to create sample datasets for dashboards.

close
Create anonymous data sets for demos.
Anonymize dashboard data.
more_vert waves

BigQuery Anonymize Query

Runs a query and anynonamizes all rows. Used to create sample table for dashboards.

close
Create anonymous tables for demos.
Anonymize dashboard data.
folder

BigQuery Dataset

Create and permission a dataset in BigQuery.

close
addchart

BigQuery Function

Add a custom function or table to a dataset.

close
arrow_forward

BigQuery Query Run

Run query on a project.

close
arrow_forward

BigQuery Query To Table

Save query results into a BigQuery table.

close
close
arrow_forward

BigQuery Query to Sheet

Copy the contents of a query into a Google Sheet.

close
more_vert security

CM360 Bulk User Editor

A tool for rapidly bulk editing Campaign Manager profiles, roles, and sub accounts.

close
Create and edit profiles in bulk.
Create and edit roles in bulk.
Redefine bulk role permissions.
Update sub account permissions.
Add entire teams to an Advertiser, Campaign, or Role.
Save time on user audits and updates.
more_vert donut_small

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.

close
Reduce time to market of campaigns and provide the agility to respond quickly to changes.
Quality of campaigns increases as fewer manual steps lead to fewer errors, and the visualization that Bulkdozer provides is invaluable to validate and audit campaigns.
More efficiency means more time and resources available to focus on higher value tasks.
Leads to better media decisions and better ROAS.
more_vert done_outline

CM360 Campaign Auditor

A tool for rapidly bulk checking Campaign Manager campaigns

close
View multiple campaigns at once.
Write custom filters to find outliers.
Rapidly audit entire campaign set for an account.
more_vert compare

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.

close
Compare campaign performance for A/B testing.
Evaluate national vs. local campaigns.
Evaluate tier 1 vs tier 2 campaigns.
Compare performance along time and geography.
Identify KPI drop of relative to local population.
assignment_returned

CM360 Data Transfer To Bigquery

Move data from a DT bucket into a BigQuery table.

close
more_vert donut_large

CM360 Data Warehouse

Deploy a BigQuery dataset mirroring CM360 account structure. Foundation for solutions on top.

close
Mirror all CM360 account configuration in BigQuery.
Attach any number of dashboards, views, or automations on top.
Whatever access the user or service has, thats whats in the warehouse.
Updates on whatever schedule you set.
more_vert fingerprint

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.

close
Measure mix of domain and app traffic.
Discover which sites are underepporting.
Measure advertiser and campaign level transparency.
Determine which dimensions have lowest transparency.
more_vert add_alert

CM360 Floodlight Monitor

Monitor floodlight impressions specified in sheet and send email alerts.

close
Reduce floodlight outages.
Verify configuration issues faster.
Lose less conversion data.
Spend less time auditing floodlights.
Route alerts to appropriate analyst.
more_vert terrain

CM360 Geo Trends

Analyze performance against radius around specific locations. Includes correlation to local landmarks and features derived from public data sets.

close
View performance at 5/10/15/50 mile distances.
Evaluate trends across regions.
Identify local landmark correlations.
more_vert security

CM360 Log Audit

Downloads Campaign manager logs and allows audits.

close
Meet contractual access reporting information.
Reduce unauthorized use of CM accounts and assets.
Audit user access within CM.
Prevent malicious user access / behavior.
more_vert donut_large

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.

close
Break down creative properities for analysis.
Determine which factors are most valuable to performance.
Discover missed marketing opportunities.
donut_small

CM360 Report

Create a CM report from a JSON definition.

close
more_vert email

CM360 Report Emailed To BigQuery

Pulls a CM Report from a gMail powered email account into BigQuery.

close
Acquire client CM data without having an account.
Build new data ingestion service for clients.
Consolidate client data in a central data warehouse.
Automate emailed report downloading.
Build dashboards from emailed reports.
donut_small

CM360 Report Replicate

Replicate a report across multiple networks and advertisers.

close
donut_small

CM360 Report Run

Trigger a CM report run

close
donut_small

CM360 Report To BigQuery

Move existing CM report into a BigQuery table.

close
donut_small

CM360 Report To Sheets

Move existing CM report into a Sheet tab.

close
donut_small

CM360 Report To Storage

Move existing CM report into a Storage bucket.

close
more_vert donut_large

CM360 Segmentology

CM360 funnel analysis using Census data.

close
Optimize creatives and landing pages for engaged demographics.
Examine CM360 funnel in terms of demographics.
Discover missed marketing opportunities.
Run continously to measure impact of funnel changes.
more_vert cleaning_services

CM360 To DV360 Bulk Creator

Allows bulk creating DV360 Insertion Orders and Line Items from CM360.

close
Speed up bulk creating.
Add custom validation rules using BQ.
more_vert security

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.

close
Meet contractual access reporting information.
Reduce unauthorized use of CM accounts and assets.
Audit user access within CM.
Prevent malicious user access / behavior.
analytics

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.

close
analytics

Census Data Normalized

Convert given census table to percent of population, normalizing it.

close
more_vert donut_small

DV-3PO Custom Signals

DV-3PO Custom Signals allows automated changes to be made to DV360 campaigns based on external signals from weather and social media trends. In the future it will also support news, disaster alerts, stocks, sports, custom APIs, etc.

close
Automatically react to custom signals and analytics
Budget is better allocated based on business rules and priorities.
Shortest possible reaction time to external events.
Minimize manual work.
more_vert donut_small

DV360 / CM360 Privacy Audit

Dashboard that shows performance metrics across browser to see the impact of privacy changes.

close
See drilled down metrics of your accounts performance as ITP changes
more_vert people

DV360 Audience Analysis

The Audience Wizard Dashboard helps you to track the audience performance across all audiences on Display.

close
Historical audience performance insights.
Performance by audience type + audience category.
Headroom impressions and CPA by audience list.
more_vert cleaning_services

DV360 Bulk Editor

Allows bulk editing DV360 through Sheets and BigQuery.

close
Speed up bulk editing.
Add custom validation rules using BQ.
more_vert gps_fixed

DV360 Bulk Targeting Editor

Allows bulk targeting DV360 through Sheets and BigQuery.

close
Speed up bulk targeting.
more_vert donut_large

DV360 Data Warehouse

Deploy a BigQuery dataset mirroring DV360 account structure. Foundation for solutions on top.

close
Mirror all DV360 account configuration in BigQuery.
Attach any number of dashboards, views, or automations on top.
Whatever access the user or service has, thats whats in the warehouse.
Updates on whatever schedule you set.
more_vert whatshot

DV360 Deal Finder

Compares open vs. deal CPM, CPC, and CPA so that clients can decide which sites, inventory, and deals work best.

close
Move client towards more deals.
Help client decide which inventory to invest in.
Optimize client spend to improve CPM, CPC, or CPA performance.
Justify deal spend.
Identify poorly performing deals.
more_vert perm_phone_msg

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.

close
Saves on the time to manually move Insertion Order budgets from month to month.
Allows you to categorize line items into categories, then the tool will aggregate up all the spend and budget for those line items and determine any remaining or negative budget. Then it will spread that amount equally across all of the Line Items in that category.
donut_large

DV360 Report

Create a DV360 report.

close
more_vert email

DV360 Report Emailed To BigQuery

Pulls a DV360 Report from a gMail email into BigQuery.

close
Acquire client DV360 data without having an account.
Build new data ingestion service for clients.
Consolidate client data in a central data warehouse.
Automate emailed report downloading.
Build dashboards from emailed reports.
donut_large

DV360 Report To BigQuery

Move existing DV360 reports into a BigQuery table.

close
donut_large

DV360 Report To Sheets

Move existing DV360 report into a Sheets tab.

close
donut_large

DV360 Report To Storage

Move existing DV360 report into a Storage bucket.

close
donut_large

DV360 SDF To BigQuery

Download SDF reports into a BigQuery table.

close
more_vert donut_large

DV360 Segmentology

DV360 funnel analysis using Census data.

close
Optimize creatives and landing pages for engaged demographics.
Examine DV360 funnel in terms of demographics.
Discover missed marketing opportunities.
Run continously to measure impact of funnel changes.
more_vert gps_fixed

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.

close
See all settings across Partner, Advertiser, and Line Item in one view.
Spot errant targeting in seconds.
Correct targeting before and during campaigns.
Deploys at access level of user, managed via DV360.
more_vert security

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.

close
Meet contractual access reporting information.
Reduce unauthorized use of DV accounts and assets.
Audit user access within DV.
Prevent malicious user access / behavior.
file_copy

Drive Copy

Copy a drive document.

close
monetization_on

Dynamic Costs Reporting

Calculate DV360 cost at the dynamic creative combination level.

close
file_download

Email Fetch

Import emailed CM report, Dv360 report, csv, or excel into a BigQuery table.

close
analytics

Federal Reserve Regional Data

Download federal reserve region.

close
analytics

Federal Reserve Series Data

Download federal reserve series.

close
more_vert donut_large

GA360 Segmentology

GA360 funnel analysis using Census data.

close
Optimize creatives and landing pages for engaged demographics.
Examine GA360 funnel in terms of demographics.
Discover missed marketing opportunities.
Run continously to measure impact of funnel changes.
more_vert settings_input_component

Google API To BigQuery

Execute any Google API function and store results to BigQuery.

close
Call any Google API ednpoint.
Move results into BigQuery.
more_vert donut_large

GoogleAds Segmentology

GoogleAds funnel analysis using Census data.

close
Optimize keywords and landing pages for engaged demographics.
Examine Google Ads funnel in terms of demographics.
Discover missed marketing opportunities.
Run continuously to measure impact of funnel changes.
more_vert policy

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.

close
Time savings of 5+ hours per manual review.
Violations are caught in less than 24 hours.
Agency teams communicating and addressing the issues increases.
Reporting will follow the same conventions.
Enables better cross-region analysis and strategy.
file_download

Project IAM

Sets project permissions for an email.

close
more_vert donut_large

SA360 Report

Move SA360 report to BigQuery.

close
Move report data to BigQuery quickly.
Assemble with other tasks to create a workflow.
more_vert security

SA360 Web Query Report

Download SA360 reports into a Google Sheet.

close
Download reports.
Build custom analysis.
Save time on account audits.
donut_large

Salesforce To BigQuery

Move query results into a BigQuery table.

close
view_column

Sheet Clear

Clear data from a sheet.

close
view_column

Sheet Copy

Copy tab from a sheet to a sheet.

close
view_column

Sheet To BigQuery

Import data from a sheet and move it to a BigQuery table.

close
donut_large

SmartSheet Report To BigQuery

Move report data into a BigQuery table.

close
donut_large

SmartSheet Sheet To BigQuery

Move sheet data into a BigQuery table.

close
archive

Storage Archive

Wipe old information from a Storage bucket based on last update time.

close
storage

Storage Bucket

Create and permission a bucket in Storage.

close
arrow_forward

Storage To Table

Move using bucket and path prefix.

close
more_vert policy

Tag Key Value Uploader

A tool for bulk editing key value pairs for CM placements.

close
Update CM Placement key value pairs in bulk.
Speed up tag editing.
Ensure more consistent tagging.
perm_phone_msg

Trends Places To BigQuery Via Values

Move using hard coded WOEID values.

close
perm_phone_msg

Trends Places To Sheets Via Values

Move using hard coded WOEID values.

close
more_vert perm_phone_msg

Twitter Targeting

Adjusts line item settings based on Twitter hashtags and locations specified in a sheet.

close
Create campaigns that respond to twitter trends.
Activate spend when a specific tag trends.
Protect brand by disabling advertising based on trends.
Fully automated, just provide locations, hashtags and line item settings to change.
link

URL

Pull URL list from a table, fetch them, and write the results to another table.

close
switch_video

Video Overlay

Add images, text, and audio to videos.

close
more_vert donut_large

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.

close
Identify cTV apps to potentially reach desired audiences


Run These Workflows In Minutes On Google Cloud

Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop