Google’s a mess. Here’s what you need to know and do.

Laptop on fire with Google logo

Google is struggling with some of the biggest technical issues in its history, affecting users’ experiences across tools, including spending controls and campaigns on the all-important Google Ads platform.  The company says it hopes to provide an update soon explaining the problems and answering questions about when they will be resolved. Other mainline Google products […]

Google Analytics 4: Channeling Reality & Crucial Next Steps Checklist

Image of a sunset turning the sky bright orange, in reference to the sunsetting of Universal Analytics.

Absent a pardon, Google Analytics 4 will become channel law as of July 1, 2023, replacing Universal Analytics.  UA was first announced at Google’s 2012 Summit and has since been a marketing industry staple for web analytics. It has been a trade. We give Google all our web data. Google gives us free analytics, transparent […]

Python in a Marketing World Episode 5: Reporting with the Google Trends API

Python in a Marketing World: Episode 5 - Google Trends API

In 2020, AIMCLEAR Data Operations Specialist, Tanner Riebel produced a 4-part series on using Python to automate aspects of marketing common to all ad ops: performance alerts, reporting, and analysis. He’s kicking off 2021 with a new episode of “Python in a Marketing World” focused on how marketers can access and leverage the Google Trends […]

Python in a Marketing World Episode 4: Creating a Weekly Executive Summary

Python in a Marketing World - Episode 4 - Create a Weekly Executive Summary

We are excited to announce part 4 of our new video series, “Python in a Marketing World,” hosted by Data Operations Specialist Tanner Riebel. The series provides a jumpstart for marketers interested in learning Python. In case you missed the first three episodes, check out: Episode 1 “Reporting With The Google Analytics API“  was a […]

Python in a Marketing World Episode 3: Creating a Performance-Based Alert System

Python in a Marketing World - Create a Performance-Based Alert System

We are excited to announce part 3 of our new video series, “Python in a Marketing World,” hosted by Ads Operations Analyst Tanner Riebel. The series provides a jumpstart for marketers interested in learning Python. Episode 1 “Reporting With The Google Analytics API“  was a primer on connecting directly to the Google Analytics API and […]

Python in a Marketing World Episode 2: Reporting With The Google Ads API

Python in a Marketing World: Reporting with the Google Ads API

We are excited to announce part 2 of our new video series, “Python in a Marketing World,” hosted by Ads Operations Analyst Tanner Riebel. The series provides a jumpstart for marketers interested in learning Python. Episode 1 was a primer on connecting directly to the Google Analytics API and pulling site data into Google BigQuery […]

Python in a Marketing World Episode 1: Reporting With The Google Analytics API

Python in a Marketing World: Episode 1 - Reporting with the Google Analytics API

We are excited to announce the launch our new video series, “Python in a Marketing World,” hosted by Ads Operations Analyst Tanner Riebel. The series provides a jumpstart for marketers interested in learning Python. As companies continue to emphasize data-driven decision making, martech skills have become increasingly helpful for marketers to add to their skillset. […]

Digital Marketing Reports for Time-Starved Data Analysts: PivotTable POWER!

Want to blow people’s minds by quickly and efficiently pulling actionable insights from large spreadsheets? Look no further than PivotTables! The enigma of the Excel world, they are daunting for the uninitiated and invaluable for those in the know. Don’t get us wrong, we still <3 our formulas and complex dashboards, but for single-channel data […]

10 Excel Marketing Ninja Moves! Ditch Tedious Formatting & Annoying Adjustments

Two ninja silhouettes fight at daybreak as we introduce our post, 10 Excel Marketing Ninja Moves! Ditch Tedious Formatting & Annoying Adjustments.

We’re back with more tips and tricks for a faster, easier, more ninja-like approach to Excel! This time around the focus is on tips and tricks, rather than specific Excel formulas. We love Excel, this much is true. That said, sometimes it can be so frustrating and tedious that the thought of going Office Space […]

Automate Digital Reports: 10 Excel Formulas For Smarter, Faster Work

As it goes in this world, time is money — and when it comes to compiling and creating digital marketing reports, the saying is as true as ever. Sure, certain time sucks are unavoidable, but there are strategies and tools that can create efficiencies, ease the pain and yield powerful results. In the midst of […]