The StarThinker project will no longer receive new solution contributions from the Google team.
Please read the full StarThinker Open Source Support Ends At Google article for more details.
These recipes are entire workflows that deploy end to end solutions for clients.
All olderDemonstration that uses Airflow/Composer native, Airflow/Composer local, and StarThinker tasks in the same generated DAG.
| Build Airflow / Composer workflows using StarThinker. |
| Deploy any existing recipe as a DAG. |
| Refrence Service and User Credential integration. |
| Minimize manual DAG coding work. |
Copies tables and view from one dataset to another and anynonamizes all rows. Used to create sample datasets for dashboards.
| Create anonymous data sets for demos. |
| Anonymize dashboard data. |
Runs a query and anynonamizes all rows. Used to create sample table for dashboards.
| Create anonymous tables for demos. |
| Anonymize dashboard data. |
Create and permission a dataset in BigQuery.
Add a custom function or table to a dataset.
Run query on a project.
Save query results into a BigQuery table.
Create a BigQuery view.
Copy the contents of a query into a Google Sheet.
A tool for rapidly bulk editing Campaign Manager profiles, roles, and sub accounts.
| 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. |
Bulkdozer is a tool that can reduce trafficking time in Campaign Manager by up to 80%% by providing automated bulk editing capabilities.
| 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. |
A tool for rapidly bulk checking Campaign Manager campaigns
| View multiple campaigns at once. |
| Write custom filters to find outliers. |
| Rapidly audit entire campaign set for an account. |
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.
| 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. |
Move from BigQuery to CM.
Move form Sheets to CM.
Move data from a DT bucket into a BigQuery table.
Deploy a BigQuery dataset mirroring CM360 account structure. Foundation for solutions on top.
| 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. |
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.
| Measure mix of domain and app traffic. |
| Discover which sites are underepporting. |
| Measure advertiser and campaign level transparency. |
| Determine which dimensions have lowest transparency. |
Monitor floodlight impressions specified in sheet and send email alerts.
| Reduce floodlight outages. |
| Verify configuration issues faster. |
| Lose less conversion data. |
| Spend less time auditing floodlights. |
| Route alerts to appropriate analyst. |
Analyze performance against radius around specific locations. Includes correlation to local landmarks and features derived from public data sets.
| View performance at 5/10/15/50 mile distances. |
| Evaluate trends across regions. |
| Identify local landmark correlations. |
Downloads Campaign manager logs and allows audits.
| Meet contractual access reporting information. |
| Reduce unauthorized use of CM accounts and assets. |
| Audit user access within CM. |
| Prevent malicious user access / behavior. |
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.
| Break down creative properities for analysis. |
| Determine which factors are most valuable to performance. |
| Discover missed marketing opportunities. |
Create a CM report from a JSON definition.
Pulls a CM Report from a gMail powered email account into BigQuery.
| 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. |
Replicate a report across multiple networks and advertisers.
Trigger a CM report run
Move existing CM report into a BigQuery table.
Move existing CM report into a Sheet tab.
Move existing CM report into a Storage bucket.
CM360 funnel analysis using Census data.
| 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. |
Allows bulk creating DV360 Insertion Orders and Line Items from CM360.
| Speed up bulk creating. |
| Add custom validation rules using BQ. |
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.
| Meet contractual access reporting information. |
| Reduce unauthorized use of CM accounts and assets. |
| Audit user access within CM. |
| Prevent malicious user access / behavior. |
Correlate another table with US Census data. Expands a data set dimensions by finding population segments that correlate with the master table.
Convert given census table to percent of population, normalizing it.
Dashboard that shows performance metrics across browser to see the impact of privacy changes.
| See drilled down metrics of your accounts performance as ITP changes |
The Audience Wizard Dashboard helps you to track the audience performance across all audiences on Display.
| Historical audience performance insights. |
| Performance by audience type + audience category. |
| Headroom impressions and CPA by audience list. |
Allows bulk editing DV360 through Sheets and BigQuery.
| Speed up bulk editing. |
| Add custom validation rules using BQ. |
Allows bulk targeting DV360 through Sheets and BigQuery.
| Speed up bulk targeting. |
Deploy a BigQuery dataset mirroring DV360 account structure. Foundation for solutions on top.
| 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. |
Compares open vs. deal CPM, CPC, and CPA so that clients can decide which sites, inventory, and deals work best.
| 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. |
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.
| 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. |
Create a DV360 report.
Pulls a DV360 Report from a gMail email into BigQuery.
| 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. |
Move existing DV360 reports into a BigQuery table.
Move existing DV360 report into a Sheets tab.
Move existing DV360 report into a Storage bucket.
Download SDF reports into a BigQuery table.
DV360 funnel analysis using Census data.
| 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. |
Continously audit all targeting settings for a DV360 Partner in one dashboard. Use filters to locate errant targeting and quickly correct issues.
| 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. |
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.
| Meet contractual access reporting information. |
| Reduce unauthorized use of DV accounts and assets. |
| Audit user access within DV. |
| Prevent malicious user access / behavior. |
Copy a drive document.
Calculate DV360 cost at the dynamic creative combination level.
Import emailed CM report, Dv360 report, csv, or excel into a BigQuery table.
Download federal reserve region.
Download federal reserve series.
Execute any Google API function and store results to BigQuery.
| Call any Google API ednpoint. |
| Move results into BigQuery. |
GoogleAds funnel analysis using Census data.
| 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. |
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.
| 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. |
Sets project permissions for an email.
Move SA360 report to BigQuery.
| Move report data to BigQuery quickly. |
| Assemble with other tasks to create a workflow. |
Download SA360 reports into a Google Sheet.
| Download reports. |
| Build custom analysis. |
| Save time on account audits. |
Move query results into a BigQuery table.
Clear data from a sheet.
Copy tab from a sheet to a sheet.
Import data from a sheet and move it to a BigQuery table.
Move report data into a BigQuery table.
Move sheet data into a BigQuery table.
Wipe old information from a Storage bucket based on last update time.
Create and permission a bucket in Storage.
Move using bucket and path prefix.
A tool for bulk editing key value pairs for CM placements.
| Update CM Placement key value pairs in bulk. |
| Speed up tag editing. |
| Ensure more consistent tagging. |
Move using a WOEID query.
Move using hard coded WOEID values.
Move using a WOEID query.
Move using hard coded WOEID values.
Adjusts line item settings based on Twitter hashtags and locations specified in a sheet.
| 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. |
Pull URL list from a table, fetch them, and write the results to another table.
Add images, text, and audio to videos.
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.
| Identify cTV apps to potentially reach desired audiences |
Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.