Welcome SMX Advanced Attendees!
SMX 2023:
ChatGPT Ads/Translation API Template:
https://docs.google.com/spreadsheets/d/1q9nzwmJA-KODB4TDuz70D-tLeRb0tt6tClyiqLvltOU/copy
Make a copy of the template, install the ChatGPT in Google Sheets™ and Docs™
Warning #1: ChatGPT is a changing platform and your mileage may vary when processing prompts. We recommend you play with the prompts within chatGPT before using them with the API.
Warning #2: ChatGPT+ users do NOT get free API credits. When signing up, users get a small number of free API credits to use within 3 months. After that you will have to have a paid API account with OpenAI to use API credits. Also, the more advanced the language model, the more API credits they cost. Keep a close eye on how many API credits you are using and make sure you have a cap on the number of credits that can be used on your account.
If you have any questions, please email me or join me on our Facebook group, Google Ads for Savvy Digital Marketers. You can also reach me on twitter at @jphebdon.
SMX 2019:
Grab the Auction Insights Template here:
About the Auction Insights template:
This page will have updated versions of this report, including an upcoming data studio version. For now, please make a copy of the following template. It can accommodate up to 30 segments of time, so I recommend you start by using “past 30 days” and segmenting the data by day to start with. Clear the sample data and paste in your own.
If you have any questions, please email me or join me on our Facebook group, Google Ads for Savvy Digital Marketers. You can also listen to an old podcast we did on Auction Insights on the Paid Search Magic podcast here.
Want to learn more about Data Studio? Check out Amy Hebdon’s new YouTube channel where she makes Data Studio accessible and useful:
Data Studio for Paid Search playlist:
https://www.youtube.com/playlist?list=PLFKQFU6BH6wL-V8a0Xipu3PsMHm_vf76g
A few notes about Bing Microsoft Ads:
- Microsoft limits the # of time periods you can segment downloadable data by. (16 days, 17 weeks, 17 months, 13 quarters, 3 years)
- We tend to see much more overlap by weakly competitive domains, often consisting of review and search ad arbitrage sites.
You cannot “back” your way into competitor budgets:
You may be able to get some idea of their aggressiveness, but Google does not provide enough data to determine budgets
You cannot determine the keyword set of a competitor:
Auction Insights only provides data on the intersection of auctions that you both participate in.
About Impression Share:
https://support.google.com/adwords/answer/2497703
The Ad Auction:
https://support.google.com/adwords/answer/1704431
Auction Insights:
https://support.google.com/adwords/answer/2579754?hl=en#find
Please reach out if you have any questions. Thank you!
James Hebdon
Paid Search Magic | CTO & Co-Founder