It All Started With An Idea

Broadcasting Ambition: A Director’s Tale

Before diving into the story, let’s look at my achievements within the first 70 days in the new role:

  • MRR Growth: Reached the highest level since January, with a 135% increase since May.
  • Net Growth: Started at -0.02% in January ’24 and climbed to +600% by July, hitting 7.1%.
  • Churn Reduction: Churn decreased by 76% since January ’24, with a month-over-month reduction of 25.9%.

If it were just about the Data, the Data highlights a strong understanding of the industry and the capacity to deliver substantial results quickly. To offer balance the below must also be considered when it comes to perception.

So here are potential counters that could include:

In the dynamic world of media, where the airwaves carry the pulse of our society, I navigate the currents not as a director, but simply as John. This deliberate choice to set aside my title is a nod to the evolving landscape of communication, where informality reigns and approachability is king. The Wall Street Journal, a bastion of tradition, recently embraced this shift, eliminating the routine use of honorifics to foster a more equal footing among individuals.

The absence of my title is a philosophical stance that values the collective symphony of ideas over the solo performances of hierarchical accolades. It’s a commitment to an environment where every voice has the potential to echo through the halls of innovation and every team member is an integral part of the narrative we broadcast to the world.

Yet, this choice is not without contention. The comfort of traditional structures and the clarity that titles provide cannot be dismissed. They offer a sense of stability and recognition, deeply ingrained in the fabric of corporate culture. Harvard University’s research into misinformation highlights the challenges of change within established systems, where resistance can stem from the very roots of our social constructs.

As we embark on this narrative journey together, I will over time explore the nuances of leading without a formal title, the challenges it presents, and the unexpected doors it opens. Welcome to a story of broadcasting ambition, where the only title that truly matters is the one we earn in the hearts and minds of our audience.

“As the Director of Paid Media, my role transcends the confines of a title, embodying a dedication to excellence and innovation. It’s a responsibility owning that title, that I carry with unwavering commitment, understanding the influence I wield and the expectations of those who rely on me not just to lead, but to inspire and coach beyond even my own realization of potential. With this in mind, we move forward.”

The impact I make is measured not just in data, but in the advancements I champion within the industry. In pursuit of solutions for global challenges in Google Ads and social media, I’ve tackled issues like PII collection on platforms such as TikTok, enhancing data privacy without fanfare. My curiosity drives me to operate behind the scenes, contributing to the digital landscape’s evolution. My experience as an alpha tester for Google and currently for Meta fuels my passion for this ever-changing field. The script provided can be transformed into a tool akin to Optymzer, streamlining campaign creation directly from a spreadsheet—a testament to the efficiency and ingenuity that define my approach. Should you wish to tailor it further, GPT’s capabilities are at your disposal to refine and personalize the solution.

Here is a script to automate campaign builds: #script #googleads

function main() {
  var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/1-eQUVkvkSESNN6ErhsQH8dfslN6EXIJ2K1MdCthXwcc/edit?gid=1740813153#gid=1740813153';
  var SHEET_NAME = 'Sheet2';

  // Open the spreadsheet
  var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = spreadsheet.getSheetByName(SHEET_NAME);

  // Read the data
  var data = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn()).getValues();

  // Process and upload campaigns
  uploadCampaigns(data, sheet);
}

function uploadCampaigns(data, sheet) {
    var columns = [
        'Campaign', 'Campaign type', 'Networks', 'Budget', 'Budget type', 'Bid strategy type', 'Location'
    ];

    var upload = AdsApp.bulkUploads().newCsvUpload(
        columns, {moneyInMicros: false});
    data.forEach(item =>
        upload.append({
            'Campaign': item[0],
            'Campaign type': item[1],
            'Networks': item[2],
            'Budget': item[3],
            'Budget type': item[4],
            'Bid strategy type': item[5],
            'Location': item[6],
        }));
    upload.apply();

    Logger.log("Campaigns have been uploaded.");

    // Clear the sheet content after upload
    sheet.getRange(2, 1, data.length, data[0].length).clearContent();
} 

This Google Ads Script automates the process of uploading campaigns from a Google Sheet to Google Ads.

Key Functions

Main Function:

  • Defines Sheet Location: The Google Sheet URL and the specific sheet name (Sheet2) are specified.
  • Opens and Reads Data: Opens the Google Sheet and retrieves data starting from the second row to the last populated row and column.
  • Initiates Campaign Upload: Passes the retrieved data to the uploadCampaigns function for processing.

uploadCampaigns Function:

  • Defines Campaign Fields:Sets up column headers for the campaign attributes (e.g., Campaign, Budget, Location).
  • Prepares and Uploads Campaigns:Uses AdsApp.bulkUploads().newCsvUpload to prepare a bulk upload.Iterates through the data to map each row to the appropriate campaign fields.Executes the upload to Google Ads using upload.apply().
  • Post-Upload Actions:Logs a success message once the campaigns are uploaded.Clears the uploaded data from the Google Sheet to reset it for future use.

Summary

This script automates campaign uploads from a Google Sheet to Google Ads, enhancing efficiency by directly mapping spreadsheet data to campaign fields, executing the upload, and then clearing the processed data for a seamless workflow.

References: 1: “5 Proven Churn Prevention Strategies for Sustainable Business Growth,” Fintemps. 2: “6 proven methods for reducing churn, and how to prevent it altogether,” Rev. 3: “10 Ways of Managing a Team Through Change – Explained,” Change Management Insight. 4: “4 Factors That Shape Market Trends,” Investopedia. 5: “What Leadership Looks Like in Different Cultures,” Harvard Business Review.

About the author

John M. Williams — Founder, It All Started With An Idea. Senior paid media specialist with 15+ years and $350M+ in managed ad spend across Google, Meta, LinkedIn, and Amazon. Creator of Buddy, the open-source AI Google Ads agent. Hero Conf 2025 + 2026 speaker.

More about John · LinkedIn ↗ · GitHub ↗

Working notes

More from the blog.

Read the blog  Get a free audit