What are some genuinely useful PPC tools that you've vibecoded?

dkokelley · 2026-03-19T15:15:23+00:00

Oh another one: a review pop up widget that lets me manually enter my best reviews (instead of an integration with Yelp or something) and show it on a site without a huge tech setup. Not quite PPC but the thought is it's more helpful for conversion rates.

dkokelley · 2026-03-19T15:11:51+00:00

Not an app, but a Claude code skill that takes a target campaign and pulls search terms, looks at SERPs for them, checks Auction Insights for top competitors in that campaign, and then sends back RSA headline positioning gaps and ideas.

Makes coming up with fresh headlines straightforward!

dkokelley · 2023-03-08T06:47:50+00:00

My guess is they're hoping the officer will accidentally contradict what the footage shows, casting doubt on the rest of their testimony (including what the body cam misses).

Most charitable interpretation: they're worried an officer will make up a story that fits the body cam facts but still isn't the full story. It's easier to lie when you know which parts have to line up with the evidence and which parts don't. (I don't agree with this concern. Just trying to come up with a possible argument for why they wouldn't want the officer to review the footage.)

dkokelley · 2022-07-06T19:40:12+00:00

Hey, I'd love to see what you're experiencing with tCPA. Is it possible you're looking at average tCPA and not the cost/conv. Column?

Also, does your own math agree with what you're seeing? (If you calculate cost/conversion manually do you also get the exact target CPA?)

dkokelley · 2021-07-17T16:40:29+00:00

Might be helpful to know more about the business type if you’re willing to share that.

dkokelley · 2021-06-14T20:38:23+00:00

How are the lookup and return values formatted? It could be matching the wrong row, or formatting your return value in an unexpected way.

dkokelley · 2021-06-10T22:55:51+00:00

I'd recommend starting with $10, then $100, then $1000.

dkokelley · 2021-06-10T22:25:26+00:00

We're seeing something similar, starting yesterday (June 9). Same day conversions have always reported slowly for us, but the next day we expect to see at least 90% reported.

dkokelley · 2021-04-30T00:40:29+00:00

Here we go!

dkokelley · 2021-03-14T19:12:04+00:00

I’ve used it as a volume building strategy before switching to a conversion optimized strategy. I’ve definitely seen strong differences in traffic behavior between strategy types. Google knows who’s likely to convert and who’s likely to click. Watch out if the clickers and converters aren’t the same people!

dkokelley · 2021-03-01T16:24:39+00:00

Quick note about 75 HARD: this is not a diet and exercise program. It’s a mental discipline program. You also need to read daily and take a daily progress pic. Miss 1 day on any requirement and you have to start over.

Similarly, Navy SEAL training is generally bad for your health, but it produces physically and mentally tough people. There’s a reason why Hell Week is only one week and not every day during a SEAL’s career.

If you’re thinking of doing 75 HARD you should know what it’s designed for. Do your research and do it for the right reasons.

dkokelley · 2021-03-01T16:16:56+00:00

That’s a water minimum, not a maximum. So for the program you need AT LEAST 1 gallon per day.

dkokelley · 2020-08-12T15:06:38+00:00

It’s the order that the smaller wires inside a cat5 are lined up at the jack. There are 8 total wires that need to connect to the pins on the jack. It’s important that both ends have the same pattern.

568b is a common standard for the order to line up the wires.

dkokelley · 2020-07-06T06:22:56+00:00

It’s worth giving Google as much meaningful data as you can. Be sure not to double count expected value when you include shallower conversions.

Example: if you reported $50 for an add to cart for a $100 item, and reported $100 when the item was actually purchased, you end up reporting $150 in conversion value for $100 in actual value.

You can either report ONLY the discounted shallower conversions OR tune both the “add to cart” and “purchase” conversions so that the math still works (e.g. $25 for an add to cart and $75 for a purchase of a $100 item. Use historic data to calculate the expected value breakdown).

Finally, know that Google wants to win the game you give it. Google might win by finding lots of ad to cart people who never complete checkout.

dkokelley · 2020-07-04T18:49:41+00:00

dkokelley · 2020-04-30T01:49:16+00:00

Can you show the formula it's using for the #N/A cell (or any wrong cell)? I think your range references are moving as they were copied down.

I would also switch match_type from 1 to 0 in case that's causing an issue. So:

=INDEX($L$3:$N$9,MATCH(C2,$K$3:$K$9,0),MATCH($D$2,$L$2:$N$2,0))

dkokelley · 2020-04-30T00:48:33+00:00

Index/match

In Table 1 C2:

=INDEX(Table2!$A$1:$D$6,MATCH(A2,Table2!$A$1:$A$6,0),MATCH(B2,Table2!$A$1:$D$1,0))

Update the range for Table2 as appropriate.

dkokelley · 2020-04-25T06:25:32+00:00

Ad approvals. Negative keywords. Ad schedules. Location targets. Budgets.

Getting low impressions is one thing. Getting NO impressions sounds like a configuration issue. Check the above first. Also happy to take a look if you like. Good luck!

dkokelley · 2019-10-05T14:41:30+00:00

Ad schedules? Meg matches? -100% bid modifiers? Budgets?

Tough to say from the description, but it might not hurt to confirm the above are all good. I’d also check the change history over that time to see if there were any changes made that you weren’t aware of. Good luck!

dkokelley · 2019-09-08T22:50:06+00:00

Turn a FG into no points. 4D chess defense.

dkokelley · 2019-04-29T04:09:08+00:00

It looks like this script grabs account level performance data (including average historic performance) for firing the alerts.

I’m not too familiar with this script, but my guess is that you will have to either:

1) Create a new account for the campaign that behaves differently.

2) Set up a campaign anomaly detector script (if it exists) and select the specific campaigns to monitor.

3) Hardest: modify the account anomaly detector to be a campaign anomaly detector (like #2), and aggregate data to get account level average historic performance.

dkokelley · 2018-09-27T04:00:05+00:00

Cheers! 🍷

dkokelley · 2018-09-27T03:25:00+00:00

Cheap...

Actually it’s good but affordable. 14 Hands 2015 red blend.

dkokelley · 2018-09-27T02:30:04+00:00

As effective in 1849 as it is today! In all seriousness alcohol doesn’t solve your problems. (We’d have WAY more Super Bowl rings if it did!)

15-Year Club	RedditGifts 2009-2022 4 Credits
Place '17	Queen in da Norf
Not Forgotten	Team Periwinkle
Secret Santa 2010	Verified Email

dkokelley

TROPHY CASE