Campaign builder tool - Web based or pc app (.net)

What would you like better ?

  • A web based version

    Votes: 25 51.0%
  • A normal pc version (.net)

    Votes: 24 49.0%

  • Total voters
    49
Forget all that bullshit I was talkin' about standard deviation and whatnot. All that's unnecessary. I think something useful can be done with just similar_text and the percent parameter. I already got something sort of working without needing seeds.
 


here's a php-based keyword grouper that utilizes metaphones, soundex, levenshtein distance and a few other methods...

At a quick glance, yes it does use all of the word matching functions but similar-text seems to handle the score while the others are used to just pass a loose reference to give a quick evaluation of the word to see if it's even suitable go group ... they seem to exist for efficiency.

It's already fast enough to handle 1500 phrases I threw it's way in a second or two & it does a pretty good job sorting out phrases on it's own ... time to roll up my sleeves and play under the hood a bit.

+100000000 to you. This is definitely a step in the right direction. Any chance on getting us in touch with the hack? (S)He might enjoy this thread.

Forget all that bullshit I was talkin' about standard deviation and whatnot. All that's unnecessary. I think something useful can be done with just similar_text and the percent parameter. I already got something sort of working without needing seeds.

You are correct ... but still, standard deviation might have it's place in the big picture, I'm certainly not ruling it out since it holds so much value in predicting number patterns.

I don't think we're going to get a perfect solution by eyeballing the function. It's going to have to be done through testing and evaluating ... I've already started.

My goal is to use this concept to wrap up keywords into groups and then use the keyword grouping to find popular ad copy for those words so the whole damn process of campaign building is automated (minus time to revise the ad copy). It'll never be perfect but if done well, I can see it saving hours of time.
 
Props to erect, good to see some progression towards a much-needed tool. The built in keyword grouper in AE sucks balls, excel macros are inaccurate for long tail KW's, and doing it manually is a pain in the ass. I'll see if I can get in contact with the coder.
 
Hey , nice thread guys . It gave me some good ideas and I'm making some testing now.
I'll give you shortly a beta keyword grouper to test. Please write here any other ideas you might have.
 
are you talking about something like Acquisio?

no


All right fuckers, here you go

keyword grouping

I've got a dataset loaded up in the textbox but you are welcome to use your own keywords if you prefer.

I've noticed a couple of random phrases floating around in the output so it's still not perfect yet, anything you guys could point out would be appreciated. I am happy that there are very few leftover words after all the grouping is done.

For all the nerds following this thread: We were really over-thinking things and really missed something obvious. These algorithms provide scattered results regardless how high you turn the filter up ... for example, program and problem will almost always be considered similar words.

The solution: filter out the most popular 2 & 3 word phrases 1st so that way you can effectively pull them out of the results before dropping a levenshtein on them. It also speeds things up quite a bit.

For the record, each grouping follows the pattern

1. filter all matches for the most common 2&3 word phrases
2. match possible adgroups by accepting any word > 80% using
PHP:
$lev_match = levenshtein($haystack,$needle) ;
      $percent = ($lev_match / strlen($needle) ) * 100 ;
3. cycle through all words with each adgroup (#2) and pull out all matches > 80% common using similar_text
4. dump all that shit into $big_array and then run #2 & #3 again
5. take whatever leftover words you have and parse out the most common 1 word phrases. Match the phrase for each word and assign it to an adgroup.

The other functions would come in handy for matching up the misspellings ... I chose to just ignore this part for now.

I've run about a dozen niches and they all turn out relatively well. Like I said, there are still some imperfections but if I were setting up a campaign, I'd be happy to start from these groups rather than from scratch.

I'll probably not develop this particular version any further, unless you guys give some awesome suggestions. The final product that I'll be using for Campaign Sniper's AI will factor in high volume phrases for the ad grouping instead of just common words in the set. It'll also use AI to pull ad copy for each ad group.

Edit: I almost forgot, I put the smallest word in each ad group as the ad group name ... don't read anything special into the naming conventions.
 
  • Like
Reactions: rileypool
How are you pulling out the 2 and 3 word phrases?

::emp::

PHP:
    $keyphrase_array = explode(' ',$keyphrase) ;
    if(count($keyphrase_array) > 1) {
    
      // get the 2 letter words
      $i = 0 ;
      for ($j=1; $j<count($keyphrase_array); $j++) {
          array_push($two_word_array,trim($keyphrase_array[$i].' '.$keyphrase_array[$j])) ;
      }
    }
      
    if(count($keyphrase_array) > 2) {

      // get the 3 letter words
      $i = 0 ;
      $j = 1 ;
      for ($k=2; $k<count($keyphrase_array); $k++) {
          array_push($three_word_array,trim($keyphrase_array[$i].' '.$keyphrase_array[$j].' '.$keyphrase_array[$k])) ;
      }
    }
 
erect, you sir, are a god.
grassy ass

Any feedback from anyone? I'm looking to make the results better if at all posible.



After looking at my last post, that code is worthless without this function. The above just rounded up all the matches in all the keywords and dumped it into an array.

a simple

$sorted_three_words = array_sort_by_count($three_word_array,'desc') ;

will sort them into a multi-dimensional array by frequency so you can actually do something useful.
 
I got something working too. Here's the results from erects sample keywords but I had to delete like half of them because of the forum's 10,000 character post limit. I might put something on the web later. I've written almost no code to refine these results. After I do that the results should get a lot better. This is a very crude version.

business form

business forms
business form
free business forms
business cards
business forms online
business forms invoice
business forms software
bussiness cards
business flyers
business postcards
business card formats
business card format
buisiness cards
business logos
business for sale
blank business forms
custom business forms
printed business forms
business order forms
business information
business owner
small business forms
business brokers
business names
business plan forms
tops business forms
sample business forms
business letter form
american business forms
business legal forms
moore business forms
business contract forms
business forms com
business forms on line
perfect business forms
online business forms
business form templates
business form software
small business form
business plan form
business proposal forms
business invoice forms


law forms

legal forms
free legal forms
law forms
online legal forms
release forms
sample legal forms
llc forms
lease forms
lease form


small business

small business
small businesses
small business advice
small business ideas
start business
small business idea
selling a business
start a small business
small business help
small business law
small business legal
wholesale business
small business owner
small business funding
small business stories
small business tips
small business owners
sell your business
small business software


business printing

business cards printing
business cards online
business card printing
business card printing software
business card printing services
business card printing machine
business cards size
business cards design
business cards designs
business cards on line
business card printers
business card printer
business card program
online business card printing
business card printing service
cheap business card printing
business printing
business card programs
business cards program
color business card printing
business cards printed
full color business card printing
business card printing company
business card printing program
business card printing equipment
professional business card printing
business card printing companies
fast business card printing
discount business card printing
business card paper
business cards paper
business form printing
business cards stationery
business cards stationary
post cards printing


graphic design

graphic design
graphic designers


digital printing

digital printing
catalog printing
digital printing press
book digital printing
digital color printing
digital book printing


commercial printer

commercial printing
commercial printers
commercial printer
commercial invoice


printing press

printing services
printing service
mailing services
scanning services
billing services
printing press
book printing services
print services
brochure printing services


paperless home

paperless office
paperless office software
paperless office system
paperless office solutions
paperless filing
paperless offices
paperless software
paperless medical office
the paperless office
paperless law office
paperless society
paperless office solution
paperless home


document management

document management system
document management software
document management
document management solution
document management systems
document imaging system
document imaging systems
document management solutions
document management scanning
document management service
web document management
electronic document management systems
document management services
document management company
document management consulting
pdf document management
document management companies
web based document management system
document management system software
legal document management software
record management system
document management product
document managment system
electronic document management system
document management web
document management imaging
document management software review
free document management software


document workflow

document workflow
document management workflow
document imaging workflow


document scan

document imaging
document scanning
document imaging software
document imaging solution
document imaging solutions
document imaging services
document imaging company
digital document imaging
document scan
document imaging service
document imaging scanner
document imaging companies
document archiving
document manager


busines card

free business cards
business card
color business cards
cheap business cards
full color business cards
business card size
free business card design
designer business cards
free business card designs
software business cards
online business cards
create business cards
print business cards
create business card
order business cards
unique business cards
free business card
print business card
photo business cards
make business cards
buy business cards
free business card maker
glossy business cards
making business cards
creating business cards
cheap business card
make business card
personal business cards
order business card
massage business cards
fast business cards
best business cards
embossed business cards
cool business cards
unique business card
military business cards
salon business cards
metal business cards
folded business cards
attorney business cards
busines cards
free business card creator
bussiness card
bussines cards
dog business cards
premium business cards
legal business cards
medical business cards
beauty business cards
buisness cards
dj business cards
spa business cards
dental business cards
best business card
modern business cards
lawyer business cards
music business cards
lawyer business card
die cut business cards
visual business cards
make a business card
folding business cards
avon business cards
army business cards
bakery business cards
transparent business cards
dvd business cards
jewelry business cards
folded business card
video business cards
cool business card
printers business cards
printer business cards
free business cards design
business cards com
free businesscards
250 business cards
freeware business cards
computer business cards
busines card
busness cards
free business software
free online business cards
create business cards online
cd business cards
inexpensive business cards
1000 business cards
police business cards
bussines card
free bussiness cards
corporate business cards
purchase business cards
e business cards
free business card designer
buisness card
insurance business cards
fashion business cards
fitness business cards
free business card template
free business cards templates
free business cards template
word business cards
student business cards
upload business cards
free buisness cards


business card logo

business card designs
business card design
business card maker
business card holder
business card design tips
business card design templates
business card design software
business card design ideas
business card designer
business cards design online
best of business card design
best business card design
business card design sample
cool business card design
business card design program
good business card design
business card design template
business logo design
business card logo
business card idea
business card ideas
business card express
business cards ideas
business card images
free business card design software
best business card designs
cool business card designs
business card builder
 
Keyword Grouper

Tested only in FF 3 and IE7. I'll probably only leave mine up a day or two since you can use erect's for free if you want. But if anyone wants it enhanced(better results/more features) or customized for personal use you can PM me.
 
... I've written almost no code to refine these results.

I'm extremely interested in how you intend to filter things and which functions you will end up using.

That stuff could possibly create a flawless grouping system once you get all of the low hanging fruits sorted into ad groups. but phrases like ...

business card print
free business card
business card design

... you've really got to extract before sending to the filter. I'm personally excited about getting to use metaphone to round up all the misspellings, but I've not really found a use yet for soundex. Anyone care to shed some light on this function?




Before this conversation started, I never even considered that this kind of stuff was "within the margin of error" that a human would produce ... now, I almost think I could do it better than a human after I get the hang of it.
 
Keyword Grouper

Tested only in FF 3 and IE7. I'll probably only leave mine up a day or two since you can use erect's for free if you want. But if anyone wants it enhanced(better results/more features) or customized for personal use you can PM me.

better results my ass!?!!?%

Just shittin, that's solid, I didn't take a look at that one before my previous post. I won't be upgrading the public one I posted much since I'll be focusing on the internal version. It looks like logic can return some great results if someone needs a more enhanced version.

Would you care to explain how you worked your grouping out (PM is fine) ... I'm just curious about looking at this problem from all angles.

here's my most recent version, it doesn't allow for people to input. The search terms are taken directly from the db and volume is considered when making adgroups. These are much more tightly themed than the 1st.
 
  • Like
Reactions: sgtryan and jeff_p
better results my ass!?!!?%

Just shittin, that's solid, I didn't take a look at that one before my previous post. I won't be upgrading the public one I posted much since I'll be focusing on the internal version. It looks like logic can return some great results if someone needs a more enhanced version.

Would you care to explain how you worked your grouping out (PM is fine) ... I'm just curious about looking at this problem from all angles.

here's my most recent version, it doesn't allow for people to input. The search terms are taken directly from the db and volume is considered when making adgroups. These are much more tightly themed than the 1st.

Dude I'm only using similar_text(i'll switch to levenshtein probably because it's faster) and matching on a percentage(the interface threshold values of loose, less loose, tighter and tightest correlate to 73, 76, 79 and 82%).
It's really dumb and still yielding decent results which kind of has me excited.
I'm fucking with code to weed out the least good from each group using a technique similar to what I pm'd you, but I don't know if that will yield good results, it will probably be slow, and it is probably overthinking it.

Oh and I think I told you how I did my grouping in pm?
It's basically just an outer looop and inner. The outer loop just starts looping through the words and the inner loop starts looping as well.

Outer loop:

for($i=0; $i<count($words)-1; $i++) {

//Check if word has already been matched and continue if so

for($j=$i+1; $j<count($words); $j++) {

// check if word has been matched or if it equals the word in the outer loop, condinute if so


This way I only loop n-1 + n-2 +... + (down to where n-x=1) times where n is the number of phrases in the array.

If there's a match the word from the outer loop becomes a key if it doesn't exist and the word from the inner loop is placed in it. THat's the gist of the grouping. The comparisons, matching and grouping are all more or less done on a first come first serve basis which is determined by the initial order of the list. See what I mean? Not real intelligent yet still not horrible results.

The comparisons really aren't intelligently ordered which makes the matches less than optimal and can lead to "scattering" of groups(different groups that probably should be together).

BTW, sorry OP for completing hijacking your thread. LOL
 
I'm interested in a PPC management system

I'd be willing to spend 2-3k+ on a program that would help me manage multiple accounts on the 3 networks.

If anyone has anything already coded, email me and I would be interested in buying a copy - david@clickonitmedia.com