这个课程旨在帮助你自动化任务,即使你没有编程经验。
在四个引人入胜的1小时直播课中,你将学会如何自动收集来自Google广告的数据,并有效地利用这些数据。你将学会发现有价值的见解,掌握关键的Google Sheets公式,并立即应用示例脚本。此外,这个精通工作坊还包括练习电子表格,帮助你提升技能。
通过精通工作坊,你将获得在数字营销领域备受追捧的稀缺和有价值的技能。这个工作坊将改变你处理数据的方式,节省你的时间,让你能够专注于创造性和战略性的任务。
This program is designed to help you automate your tasks—even if you have no coding experience.
In four engaging 1-hour live sessions, you’ll discover how to automate data collection from Google Ads and use this data effectively.
You’ll learn to find valuable insights, master key Google Sheets formulas, and apply sample scripts immediately.
The Mastery Workshop also includes practice spreadsheets to build your skills.With the Mastery Workshop, you’ll gain rare and valuable skills that are highly sought after in digital marketing.
This workshop will transform how you handle data and save you time, allowing you to focus on creative and strategic tasks.
- 教程编号:2048213531
- 教程语言:英语 / 无字幕
- 安全扫描:无病毒无插件 / 云查杀 Virustotal Virscan
- 培训机构:未知 / IMJMJ
- 文件大小:18.5GB
- 文件格式:视频 / 文档 / 图文
- 压缩软件:7ZIP
- 视频播放:完美解码
│ ├─00-Resources
│ │ 01-A Tour of the Website.mp4
│ │ 01-Start Here.pdf
│ │ 02- x27 Settings x27 tab explained [imjmj.com].pdf
│ │ 02-A letter for your boss to buy the PMax Script [imjmj.com].docx
│ │ 02-Ad World - Italy - Oct 2023 [imjmj.com].pdf
│ │ 02-ADworld Experience Presentation [imjmj.com].pdf
│ │ 02-Blank Search Categories explained [imjmj.com].pdf
│ │ 02-Change Google Sheets Currency 40 more 41 [imjmj.com].pdf
│ │ 02-Copy of TEMPLATE - Top Search Terms - MikeRhodes.com.au [imjmj.com].xlsx
│ │ 02-Exporting data from the PMax sheet [imjmj.com].pdf
│ │ 02-Free nGram Analysis Script [imjmj.com].pdf
│ │ 02-Get useful data faster [imjmj.com].pdf
│ │ 02-Google ThinkBook [imjmj.com].docx
│ │ 02-How to find install my free 40 v28 41 PMax Script [imjmj.com].pdf
│ │ 02-How to install the script 40 for beginners 41 [imjmj.com].pdf
│ │ 02-How to use the PMax Script Sheet - part 1 [imjmj.com].mp4
│ │ 02-How to use the PMax Script Sheet - part 2 [imjmj.com].mp4
│ │ 02-Installing the Script Step-by-Step Guide [imjmj.com].mp4
│ │ 02-Issues with OpenAI API key - START HERE [imjmj.com].pdf
│ │ 02-MCC Script - Training Videos [imjmj.com].pdf
│ │ 02-MCC Script Account Spend 40 an intro to iterators 41 [imjmj.com].pdf
│ │ 02-MCC Script Update Automating PMAX Insights [imjmj.com].mp4
│ │ 02-My Google ThinkBook [imjmj.com].pdf
│ │ 02-Need to convince your boss to buy the script [imjmj.com].pdf
│ │ 02-New Free Script - keyword vs search term comparison [imjmj.com].pdf
│ │ 02-paid script timing out use the x27 lotsProducts x27 variable [imjmj.com].pdf
│ │ 02-Placements for Demand Gen [imjmj.com].pdf
│ │ 02-PMAX Script Version 36 [imjmj.com].mp4
│ │ 02-PMax Whisperer Script - updated to v7 [imjmj.com].pdf
│ │ 02-Reasons Why You Should Be Using Google Ads Scripts [imjmj.com].pdf
│ │ 02-Script Change History - by Nils Rooijmans [imjmj.com].pdf
│ │ 02-Script Geographic data from multiple time periods [imjmj.com].pdf
│ │ 02-Script Get SQR data for past 91 days [imjmj.com].pdf
│ │ 02-Script Search Categories in PMax [imjmj.com].pdf
│ │ 02-Script to Chart top Search Terms [imjmj.com].pdf
│ │ 02-Search Terms 40 as well as Categories 41 [imjmj.com].pdf
│ │ 02-Steal my x27 Script 101 x27 Template [imjmj.com].pdf
│ │ 02-TEMPLATE - geo script - websavvy [imjmj.com].xlsx
│ │ 02-The PMax Whisperer [imjmj.com].pdf
│ │ 02-The Power of MCC Scripts [imjmj.com].pdf
│ │ 02-The Product tab explained [imjmj.com].pdf
│ │ 02-Updating Sheets with the MCC PMax Script [imjmj.com].mp4
│ │ 02-Using the Console to debug scripts [imjmj.com].pdf
│ │ 02-Want to use Claude3 instead of OpenAI [imjmj.com].pdf
│ │ 02-What x27 s new in v36 [imjmj.com].pdf
│ │ 02-Where does the x27 Channel x27 data really mean [imjmj.com].pdf
│ │ 02-Wiki - how to use the PMax script sheet [imjmj.com].pdf
│ │ 03-Agency in a Bot.pdf
│ │ 03-How to go from Novice to Expert in an topic.pdf
│ │ 03-The 10-80-10 Method explained.pdf
│ │ 03-The First 20 Hours - how to learn anything 40 fast 41 .pdf
│ │ 03-The first 20 hours -- how to learn anything Josh Kaufman TEDxCSU.mp4
│ │ 03-Tim Ferris on Learning How to Use DiSSS method To Master any Skill 40 CASE STUDY 41 .mp4
│ │ 03-Too Busy to Make Changes Then you must do this.pdf
│ │ 03-Too Busy to Make Changes. Then you must do this.mp4
│ │ 03-Use Tim Ferriss x27 DiSSS Method of Learning.pdf
│ │ 04-Time to update your script - v68 out now.pdf
│ │ Resources.txt
│ │
│ ├─01-Advanced Google Sheet Formulae [imjmj.com]
│ │ │ Resources.txt
│ │ │
│ │ ├─01-Assumptions & Expectations [imjmj.com]
│ │ │ Resources.txt
│ │ │
│ │ ├─02-Intermediate Google Sheet Functions
│ │ │ 01-How to get the most from the Sheets UI.pdf
│ │ │ 01-Mike Rhodes - Intermediate Sheet Formula.xlsx
│ │ │ 02-Conditional Formatting [imjmj.com].pdf
│ │ │ 03-Understanding the If Statement.mp4
│ │ │ 03-Using IF statements.pdf
│ │ │ 05-Moving data around FILTER UNIQUE and SORT.pdf
│ │ │ 05-Three New Formulae Unique Sort and Filter.mp4
│ │ │ 06-Working with text LEFT RIGHT MID SEARCH REGEX.pdf
│ │ │ 06-Working with Text Strings and Functions.mp4
│ │ │ Resources.txt
│ │ │
│ │ └─03-Advanced Google Sheet Functions
│ │ 01-Mike Rhodes - Advanced Sheet Formula.xlsx
│ │ 01-Pivot Tables Explained.pdf
│ │ 01-Pivot Tables.mp4
│ │ 02-QUERY the power of SQL inside your Sheet [imjmj.com].mp4
│ │ 03-XLOOKUP 40 more powerful than your Nan x27 s VLOOKUP 41 .pdf
│ │ 04-ARRAYFORMULA Import Range.mp4
│ │ Resources.txt
│ │
│ ├─02-From Data to Information to Insight
│ │ │ Resources.txt
│ │ │
│ │ └─01-Main Course Content [imjmj.com]
│ │ 01-IntroDduction.mp4
│ │ 02-Big Picture [imjmj.com].mp4
│ │ 03-A Framework for Client Conversations.mp4
│ │ Resources.txt
│ │
│ ├─03-GA4 Your Business
│ │ │ Resources.txt
│ │ │
│ │ ├─01-Introduction [imjmj.com]
│ │ │ 01-1.1 Why Analytics Matters.mp4
│ │ │ 02-1.2 - Useful Not Accurate [imjmj.com].mp4
│ │ │ 03-1.3 - Plan Before You Start.mp4
│ │ │ 04-1.4 - Why Did Google Make This Big Change.mp4
│ │ │ 05-1.5 - Who is Mike Rhodes 40 WebSavvy 41 .mp4
│ │ │ Resources.txt
│ │ │
│ │ ├─02-Big Differences
│ │ │ 01-2.1 - UA vs GA4.mp4
│ │ │ 02-2.2 - What Are Google Signals [imjmj.com].mp4
│ │ │ 03-2.3 - Can You Import UA Data.mp4
│ │ │ 04-2.4 - Properties Views.mp4
│ │ │ 05-2.5 - No More Goals.mp4
│ │ │ 06-2.6 - No Useful Filters 40 e.g. Facebook 41 .mp4
│ │ │ 07-2.7 - Data Expiration.mp4
│ │ │ 08-2.8 - Retention LTV Reports.mp4
│ │ │ 09-2.9 - Engaged vs Bounced.mp4
│ │ │ 10-2.10 - GTM vs gtag [imjmj.com].mp4
│ │ │ Resources.txt
│ │ │
│ │ ├─03-A Tour of the Interface
│ │ │ 01-3.1 - 3 Main Sections Admin.mp4
│ │ │ Resources.txt
│ │ │
│ │ ├─04-GA4 Setup - the basics
│ │ │ 01-4.1 - Who Not How- Analyzify.mp4
│ │ │ 02-4.2 - Exclude Referral Traffic [imjmj.com].mp4
│ │ │ 03-4.3 - Expand Data Retention to 14 Months.mp4
│ │ │ 04-4.4 - Enable Google Signals.mp4
│ │ │ 05-4.5 - Cross Domain Tracking.mp4
│ │ │ 06-4.6 - Set Reporting Identity.mp4
│ │ │ 07-4.7 - Link Google Ads GMC.mp4
│ │ │ 08-4.8 - Giving Access to Others.mp4
│ │ │ 09-4.9 - Query Parameters.mp4
│ │ │ 10-4.10 - The Setup Assistant [imjmj.com].mp4
│ │ │ Resources.txt
│ │ │
│ │ ├─05-GA4 Reports
│ │ │ 01-5.1 - Report Sections Overview.mp4
│ │ │ 02-5.2 - Customising a Report [imjmj.com].mp4
│ │ │ 03-5.3 - Acquisition Reports.mp4
│ │ │ 04-5.4 - Engagement Reports.mp4
│ │ │ 05-5.5 - Monetization Reports.mp4
│ │ │ 06-5.6 - Retention Customer Lifetime Value Reports.mp4
│ │ │ 07-5.7 - User Reports.mp4
│ │ │ 08-5.8 - Editing Using Summary Cards.mp4
│ │ │ Resources.txt
│ │ │
│ │ ├─06-GA4 Explorations
│ │ │ 01-6.1 - What Are Explorations.mp4
│ │ │ 02-6.2 - GA4 Segments [imjmj.com].mp4
│ │ │ 03-6.3 - Line Charts in Explore.mp4
│ │ │ 04-6.4 - GA4 Segment Overlap.mp4
│ │ │ 05-6.5 - Funnel Explorations.mp4
│ │ │ 06-6.6 - User Explorer.mp4
│ │ │ 07-6.7 - Cohort Analysis.mp4
│ │ │ 08-6.8 - User Lifetime Analysis.mp4
│ │ │ Resources.txt
│ │ │
│ │ └─07-Advertising & Attribution
│ │ 01-7.1 - Model Comparison Report.mp4
│ │ 02-7.2 - DDA as Standard [imjmj.com].mp4
│ │ 03-7.3 - Conversion Paths Report.mp4
│ │ Resources.txt
│ │
│ ├─04-AI In Your Agency
│ │ 01-A Framework for Thinking About AI.mp4
│ │ 02-AI Use Cases- Writing [imjmj.com].mp4
│ │ 03-AI Use Cases-Images Video.mp4
│ │ 04-AI Use Cases-Data Code.mp4
│ │ 05-AI Use Cases-As a Muse Teacher.mp4
│ │ 06-Where to From Here.mp4
│ │ Resources.txt
│ │
│ ├─05-Copywriting Fundamentals
│ │ │ Resources.txt
│ │ │
│ │ ├─01-Copywriting Fundamentals with Russ Henneberry [imjmj.com]
│ │ │ 01-1. Introduction to Copywriting Fundamentals.mp4
│ │ │ 02-2. Copywriting basics [imjmj.com].mp4
│ │ │ 03-3. The elements of value framework.mp4
│ │ │ 04-4. Examples of functional value.mp4
│ │ │ 05-5. Examples of emotional value.mp4
│ │ │ 06-6. Examples of life changing value.mp4
│ │ │ 07-7. Wrap up contact details.mp4
│ │ │ Resources.txt
│ │ │
│ │ └─02-Copywriting Fundamentals with Nik Thakorlal
│ │ 01-1. Introduction.mp4
│ │ 02-2. Great copywriting is a lot like trading [imjmj.com].mp4
│ │ 03-3. Knowing your goals is a vital step.mp4
│ │ 04-4. Common mistakes the importance of flow.mp4
│ │ 05-5. Emotional needs desires.mp4
│ │ 06-6. Harvesting ideas an inventory of interesting ideas.mp4
│ │ 07-7. Unawareness to awareness.mp4
│ │ 08-8. Compiling your research.mp4
│ │ 09-9. Create a customer magnet.mp4
│ │ 10-10. Map out the customer journey [imjmj.com].mp4
│ │ 11-11. Your product.mp4
│ │ 12-12. Positioning framing value.mp4
│ │ 13-13. Proof elements.mp4
│ │ 14-14. The power of neologizing.mp4
│ │ 15-15. There are only 6 types of -Great Leads.mp4
│ │ 16-16. Product awareness AND market sophistication.mp4
│ │ 17-17. Reverse market segmentation using data.mp4
│ │ 18-18. Real world case study using a decision tree email nurture.mp4
│ │ Resources.txt
│ │
│ ├─06-Email Fundamentals
│ │ │ Resources.txt
│ │ │
│ │ └─01-Modules [imjmj.com]
│ │ 01-1. Introduction.mp4
│ │ 02-2. What is Email Marketing [imjmj.com].mp4
│ │ 03-3. Klaviyo and First Party Data.mp4
│ │ 04-4. Segments and Lists.mp4
│ │ 05-5. List Growth and Advertising.mp4
│ │ 06-6. Nurturing Customers.mp4
│ │ 07-7. Lookalike Seeds and Exclusion Audiences.mp4
│ │ 08-8. iOS 15.mp4
│ │ Resources.txt
│ │
│ ├─07-Youtube Fundamentals
│ │ │ Resources.txt
│ │ │
│ │ ├─01-Youtube Fundamentals [imjmj.com]
│ │ │ 01-1. Introduction 40 2 41 .mp4
│ │ │ 01-1. Introduction.pdf
│ │ │ 02-2. Customer Targeting Options [imjmj.com].mp4
│ │ │ 02-2. Customer Targeting Options [imjmj.com].pdf
│ │ │ 03-3. Types of Ads Available Ad Structure.mp4
│ │ │ 03-3. Types of Ads Available Ad Structure.pdf
│ │ │ 04-4. Tom s ADUCATE Formula for Video Scripting.mp4
│ │ │ 04-4. Tom s ADUCATE Formula for Video Scripting.pdf
│ │ │ 05-5. Autopsy of a Highly Profitable Ad.mp4
│ │ │ 05-5. Autopsy of a Highly Profitable Ad.pdf
│ │ │ 06-6. The Math of a Great YouTube Ad.mp4
│ │ │ Resources.txt
│ │ │
│ │ └─02-Tom's Repeatable system for crafting epic YouTube ads
│ │ 01-1. Introduction 40 1 41 .mp4
│ │ 02-2. Measuring youtube ads with data [imjmj.com].mp4
│ │ 03-3. First principles of creating video ads.mp4
│ │ 04-4. The offer benefits desires.mp4
│ │ 05-5. Examples of desire.mp4
│ │ 06-6. Ed Dale s writing exercise and questions.mp4
│ │ 07-7. Status values behaviour.mp4
│ │ 08-8. Blockers- Financial personal strategies.mp4
│ │ 09-9. The outer ring ADUCATE.mp4
│ │ 10-10. Act 1 Opportunity [imjmj.com].mp4
│ │ 11-11. Act 2 Demonstration.mp4
│ │ 12-12. Act 3 Tension.mp4
│ │ 13-13. A great example of a great video.mp4
│ │ 14-14. Wrap up Tom s details.mp4
│ │ Resources.txt
│ │
│ ├─08-Performance Max
│ │ 01-1. Introduction What Why.mp4
│ │ 01-1. Introduction What Why.pdf
│ │ 02-2. The Terminology Explained [imjmj.com].mp4
│ │ 02-2. The Terminology Explained [imjmj.com].pdf
│ │ 03-3. Potential Issues with pMax.mp4
│ │ 03-3. Potential Issues with pMax.pdf
│ │ 04-4. Options for Campaign Structures.mp4
│ │ 04-4. Options for Campaign Structures.pdf
│ │ 05-5. Rolling out a pMax test - Part 1.mp4
│ │ 05-5. Rolling out a pMax test - Part 1.pdf
│ │ 06-6. 5. Rolling out a pMax test - Part 2.mp4
│ │ Resources.txt
│ │
│ ├─09-Google Ads Mastery
│ │ 01-1. Bidding.mp4
│ │ 02-2. Targeting [imjmj.com].mp4
│ │ 03-3. Messaging.mp4
│ │ 04-4. Shopping.mp4
│ │ 05-5. Data.mp4
│ │ 06-6. Optimisation.mp4
│ │ Resources.txt
│ │
│ └─10-Agency Toolkit Productivity, Finances & The Future of Agencies
│ │ Resources.txt
│ │
│ ├─01-Massively Increase Your Productivity [imjmj.com]
│ │ Resources.txt
│ │
│ ├─02-Finances & Accounting
│ │ 01-1. Why create this course.mp4
│ │ 01-1. Why create this course.pdf
│ │ 04-4. The 3 main accounting documents explained.mp4
│ │ 04-4. The 3 main accounting documents explained.pdf
│ │ 06-6. The Balance Sheet in more detail.mp4
│ │ 06-6. The Balance Sheet in more detail.pdf
│ │ 07-7. Do you need a cashflow forecast.mp4
│ │ 07-7. Do you need a cashflow forecast.pdf
│ │ 08-8. The HUGE difference between cash profit.mp4
│ │ 08-8. The HUGE difference between cash profit.pdf
│ │ 09-9. Some financial ratios to consider.mp4
│ │ 09-9. Some financial ratios to consider.pdf
│ │ 10-10. A review of Profit First [imjmj.com].pdf
│ │ 11-11. A glossary of financial terms.pdf
│ │ 11-FTA-Glossary-of-Accounting-Terms-FINAL-Aug2019.pdf
│ │ 12-12. Link to the sheet used in examples.pdf
│ │ 12-AgencySavvy - Finances Accounting.xlsx
│ │ 13-13. Getting paid by clients some ideas.mp4
│ │ 13-13. Getting paid by clients some ideas.pdf
│ │ 14-14. Different Payment Models.mp4
│ │ 14-14. Different Payment Models.pdf
│ │ 15-15. Thinking about adding new services.mp4
│ │ 15-15. Thinking about adding new services.pdf
│ │ Resources.txt
│ │
│ └─03-The Future of Agencies
│ 01-1. The nature of work is changing.mp4
│ 01-1. The nature of work is changing.pdf
│ 03-3. What are your goals for the next 2-4 years.mp4
│ 03-3. What are your goals for the next 2-4 years.pdf
│ 04-4. What new services do you need to offer.mp4
│ 04-4. What new services do you need to offer.pdf
│ Resources.txt