Brent Neale’s Post

View profile for Brent Neale, graphic

Google Ads 7-Figure Specialist

I've been using Custom Columns since the start of my Google Ads career. These are the columns I CANNOT live without. Firstly, a big special mention to these PPC Megaminds. Miles McNair Denie Geertzen 🟢 Arjan Schoorl As the creators of Columnlibrary.com, you'll forever be in the Hall of PPC Fame. Getting onto it. 𝟭. 𝗔𝘃𝗴 𝗗𝗮𝗶𝗹𝘆 𝗖𝗼𝘀𝘁 (adjust formula for 14 & 30 days) Formula: Cost.date_range(last_7_days) / 7 Format: Money 𝟮. 𝗥𝗢𝗔𝗦 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 (adjust formula for 14 & 30 days) Formula: Conversion_value_per_cost.date_range(last_7_days) Format: Number 𝟯. 𝗖𝗣𝗔 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 Formula: Cost_per_conv.date_range(last_7_days) Format: Money 𝟰. 𝗘𝘀𝘁. 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝗽𝗲𝗻𝗱 Formula: (Cost.between_dates(month_start, yesterday) / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1)) Format: Money 𝟱. 𝗘𝘀𝘁. 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 Formula: Conversion_value_by_conv_time.between_dates(month_start, yesterday) + (Conversion_value_by_conv_time.date_range(last_7_days) / 7) * (day(offset_days(offset_months(month_start(), 1), -1)) - day(today())) Format: Money 𝟲. 𝗔𝗱𝗱 𝘁𝗼 𝗖𝗮𝗿𝘁 > 𝗣𝘂𝗿𝗰𝗵𝗮𝘀𝗲 𝗥𝗮𝘁𝗲 (Replace conv actions appropriately) Formula: Conversions.conversion_action("*Purchase Conv Action*") / All_conversions.conversion_action("*Add to Cart Conv Action*") Format: Percent % 𝟳. 𝗖𝗵𝗲𝗰𝗸𝗼𝘂𝘁 > 𝗣𝘂𝗿𝗰𝗵𝗮𝘀𝗲 𝗥𝗮𝘁𝗲 (Replace conv actions appropriately) Formula: Conversions.conversion_action("*Purchase Conv Action*") / All_conversions.conversion_action("*Checkout Conv Action*") Format: Percent % 𝟴. 𝗖𝗼𝗻𝘃𝗲𝗿𝘀𝗶𝗼𝗻 𝗟𝗼𝘀𝘁 (𝗕𝘂𝗱𝗴𝗲𝘁) Formula: ((Impr / Search_impr_share * Search_Lost_IS_budget) * CTR) * (Conversions / Clicks) Format: Number 𝟵. 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗟𝗼𝘀𝘁 (𝗕𝘂𝗱𝗴𝗲𝘁) Formula: (((Impr / Search_impr_share * Search_Lost_IS_budget) * CTR) * (Conversions / Clicks)) * (Conversion_value / Conversions) Format: Money 𝟭𝟬. 𝗜𝗻𝘃𝗲𝘀𝘁𝗺𝗲𝗻𝘁 𝗢𝗽𝗽𝗼𝗿𝘁𝘂𝗻𝗶𝘁𝘆 (𝗕𝘂𝗱𝗴𝗲𝘁) Formula: ((Impr / Search_impr_share * Search_Lost_IS_budget) * CTR) * Avg_CPC Format: Money 𝟭𝟭. 𝗥𝗢𝗔𝗦 Formula: All_conversion_value.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster") / Cost Format: Number 𝗜 𝗛𝗜𝗚𝗛𝗟𝗬 𝗿𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱 saving this post for later. Have I missed any columns you use regularly? If so, let me know in the comments! I will also be donating 𝗔𝗨𝗗$𝟭 𝗳𝗼𝗿 𝗲𝘃𝗲𝗿𝘆 𝗿𝗲𝘀𝗵𝗮𝗿𝗲 ♻️ , 𝗮𝗻𝗱 𝗔𝗨𝗗$𝟬.𝟭𝟬 𝗳𝗼𝗿 𝗲𝘃𝗲𝗿𝘆 𝗿𝗲𝗮𝗰𝘁𝗶𝗼𝗻 (𝘁𝗵𝗮𝘁 𝗶𝘀𝗻'𝘁 𝗮 𝗹𝗶𝗸𝗲)! 💰 The donation will be made 48 hours after publishing this post. This donation will go to the 𝗪𝗼𝗿𝗹𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗲𝗿 𝗘𝘅𝗰𝗵𝗮𝗻𝗴𝗲, in hopes to give those in less fortunate countries access to computers. Who knows, maybe they could become the next leaders in the PPC Community 🤷♂️ #googleads #marketing

Alex C.

SEO Expert | Founder | SEO Partners | Working with businesses globally to improve their online presence through SEO

1mo

comment?

Like
Reply
Jonas Krøis Damsted

Co-Founder at REAKTION.COM | 🚀 I help your ecommerce agency improve server-side tracking, increase your profits, automate reporting and get real-time dashboards ✅ Official Meta, Google Ads & Shopify Tech Partner

2mo

Awesome list! ✅👏🏼 How about including 'Return Rate' or 'POAS after returns/refunds,' Brent Neale? This would be especially useful for agencies with fashion clients when reporting on the true profits during peak periods, such as the upcoming Black Friday. ✔️

Barış Sapmaz

Performance Marketing Executive - Endless Abroad Yurtdışı Eğitim

2mo

How should we use investment opportunity column?

Elvir Likić

Google Ads Strategist | $50M+ Ad Spend Experience | Scaling Businesses with High-Impact Google Ads Strategies | Managed $250K Monthly Budgets | Achieved 10x Increase in ROAS

2mo

Love it. Saved 🙌

Yananai C.

Is Your Ecom Brand Q1 Ready? | Scaling 7-9 Figure eCommerce Brands with Google Ads | FunnelVision CEO

2mo

I've seen about 4 that I could add to my team's roster. Shout out to you, man!

Hasnain Khan

Google Ads Specialist | Helping small businesses make their first $ million through Strategic Google ads Services. Want to grow? Book an Appointment Today

2mo

Saved 🙃

Franthoni WEINUM

Google & YouTube Ads For eCommerce Brands | Merchant Center Expert

2mo

This is really good. Brent Neale

Denie Geertzen 🟢

→ Profitably scaling 7 figure Businesses with Google Ads (+8yrs) 📈 - Working on a performance basis: I only grow if you do

2mo

Hoard them all 🔥 Brent Neale 👌

Tomasz Abbott-Wieczorek

✅ Available Google Ads Freelancer | $1,000,000,000+ Google Ads Spend Audited | Top 100 PPC Expert, Consultant & Coach | Building PPC Profit Club for PPC Specialists 🚀

2mo

Learnt some new ones here! Saved! Thanks Brent Neale

Vijay S.

Founder @SwiftPropel | Performance Marketing Agency

2mo

Thanks for sharing these tips, Brent! They’re incredibly useful. Do you have a favorite among these that you find yourself using the most?

See more comments

To view or add a comment, sign in

Explore topics