Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Keyword/Keyword Phrases - Priority Links - Help!!

(Page 1 of 2)
> >
Quote Reply
Keyword/Keyword Phrases - Priority Links - Help!!
I presently have LinksSQL 2.1.0 Beta2 installed. Also, I have the Priority Links Mod installed. It works great for categories. I also have the AdCycle Plugin.

Besides having priority (premium) links by category, what I'd also like to do is allow people to have priority links based upon purchased keywords/keyword phrases. Obviously, people would pay for these.

What do I need to do to make this happen? Has anyone else tried this type of application/modification?

Is there a way to integrate the AdCycle software and have a separate "Priority" or "Premium" links area just above the regular search results area? Would this make any sense?

Any suggestions or insight would be GREATLY appreciated!

Thanks in advance.

Mark

OhioBiz

www.ohiobiz.com
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hi,

This would involve:

1. Adding a keywords field to the Links table saying what keywords this is related to.

2. Adding a global that looks up what the user searched on and returns a list of matching links. Something like:

Code:
premium_results => sub {
my $tags = shift;
my $query = $tags->{query};
my $sth = $DB->table('Links')->select ( { Keywords => $query } );
my $output;
while (my $link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('link', $link);
}
return $output;
}

That assumes your field is called Keywords, and only does an exact match. May need to tweak it to get a better match. You would then do:

<%-- Premium Results --%>
<%premium_results%>

in your search_results template.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Alex,

Thanks a lot for your response.

I will give it a try.



Mark Geyman - OhioBiz
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
is there a way to do this for each category?
Quote Reply
Re: [Alex] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Alex,

Do I create a new global in the Template Globals area, under Build in the Admin section?

If so, I typed "premium_results" in the New: box and put your code in the adjacent box, and saved it. It said it "saved successfully" but "premium_results" didn't show up as a new global (along with title_linked_row, time, site_title, etc.).

I already added a "Keywords" field to the Links table.

I went to the search_results template and added <%-- Premium Results --%>
<%premium_results%> just like you stated.


My result was "Unknown Tag: 'premium_results'" showing up on the search results page after doing a search on the same keywords I associated with the designated link.

What might I be doing wrong?

Thanks a lot.

Mark G.

OhioBiz
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
anyone? I asked this before and anxiously await a way to make preminum listings work...

thanks
Quote Reply
Re: [Alex] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Alex,

I followed your directions above but I get this result, after performing a query. This is after inserting the <%-- Premium Results --%><%premium_results%> on the search_results template:

Your search returned 1 categories and 672 Links. premium_results => sub { my $tags = shift; my $query = $tags->{query}; my $sth = $DB->table('Links')->select ( { Keywords => $query } ); my $output; while (my $link = $sth->fetchrow_hashref) { $output .= Links::SiteHTML::display('link', $link); } return $output; }

What am I doing wrong or what is missing?

Thanks a lot.

Mark G.
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hi Mark,

When I put:

something => sub {
...

}

it's my own shorthand for adding a global. It means you should add a global with the name 'something' and the value 'sub { ... }'. Make sure the value starts with sub { and has no leading space or it won't work.

Hope that helps,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Alex,

Thanks a lot. That did the trick!

mgeyman
Quote Reply
Re: [Alex] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
The modification works great for sponsored links, but only for an exact keyword match. ¿What is needed to make it work when having different keywords, let´s say 10?

Thanks
Quote Reply
Re: [vic] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
hi,

this is NOT a solution but something to think about:

I also have a keyword text-field for every link (high search weight e.g.:5)

Then I have a field Premium for every link (default=0; premium_links=1; VIP_links=2)

If you want to display premium-links in another way than others, put something like:

<%if Premium eq '1'%>

<%else%>

<%endif%>

into links.html.

For building categories with premium-links first and then the rest of the links set

build_search_order_category (admin=>setup=>Build Options) to: Premium DESC,.......

For building search results with premium-links first and then the rest of the links set

build_search_order_search (admin=>setup=>Search Options) to: Premium DESC,keywords,.......

This would allow you to use the normal functionallity of the search-function (not only exact matches).



Another way is to use HTML-Adcycle-Banners (SearchTarget-Banners). But in this case you have to setup each banner manually, can always only display the amount of banners you have integrated into the search_results.html and it has nothing to do with your links at all. But you can define as many keywords as you want.

Have a look at:

http://www.shop-netz.de/...1&query=hardware

There you can see an adcycle "SponsoredLink"-HTML-SearchTarget-Banner and the first two links which are displayed are PREMIUM-Links.



Just work a little bit around.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Last edited by:

ManuGermany: Jan 22, 2003, 11:35 PM
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hello,

I'm still trying to get the Adcycle targeted keywords to work properly in order to display the appropriate text ad banner. I have no problem with the banners working in a given category but just can't get the keyword results to show up on the search_results.html page. I'm using <%Plugins::Adcycle::display_search_banner%> tag as suggested in the Adcycle Help section (within Links SQL Admin page) but I'm not getting the text box to display at all. I just get a little linkable dot. What is the appropriate tag to place on the search_results.html page? Do I need to create a global to pass the keywords in order to serve up the appropriate banner?I'm trying to use the Sponsored Link boxes sinmilar to Google. See an example in one of my category areas at http://www.ohiobiz.com/.../Internet/index.html.Any advice would be greatly appreciated.Thanks.mgeyman
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hi,

See this post:

http://www.gossamer-threads.com/...orum.cgi?post=225233

Thats the way I do it and it works quite good.

I'm using the lastest versin of the Adcycle-Plugin from the GT-Plugins-Download-Area.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
I looked at it but where do you get the javascript and the IFRAME RICH MEDIA CACHE-BUST CODE? I have the latest version of Adcycle and I don't see any option that would give me that result.

mgeyman
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hi,goto: adcycle->Groups -> Your SearchTargetGroup

Just click on "Ad Code" behind your group "SearchTargeted" (This should be the name of your group)

There you should also find the IFRAME-AdCode

See pics below.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Manu,

Thank you very much for the visuals. Maybe where I'm going wrong is selecting "Text Link" as the ad type. I see you specified a size 156 X 60. I have three ad types to select from "468 x 60", "Text Link," and "Pop-Window." Maybe this is where I am going wrong??

Thanks so much for your help!

mgeyman
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Crazy Yeah, that should it be.

In my postings at:

http://www.gossamer-threads.com/...orum.cgi?post=225233

I always was talking about BANNERS not text-links!!!!!!

--------------

O.K., now we got this.

I've setup both, an HTML-Banner and a Standard-Banner for each SearchTarget-Campaign (Adcycle3.gif).

Check HTML-Default (adcycle4.gif) at the Standard-Banner to make sure this is only displayed if the HTML-AD won't work (IFRAME-browser-problems).

Hope you will get it now!

P.S.: you can create new ad-types at adcycle->manager

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Last edited by:

ManuGermany: Jan 24, 2003, 8:20 AM
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Thanks Manu, sounds like good turn around. Unfortunatelly I bought AdCycle before the plugin was released and do not have it. My other concern is that I have experimented server overload problems when using AdCycle, due to high traffic in my website and decided to disable it untill I install it in a separate server.
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Manu,

Thank you so much for your assistance! I'll give it a try now.

mgeyman
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Manu,

I was able to generate the following code:

<!-- START ADCYCLE IFRAME RICH MEDIA CACHE-BUST CODE for SearchTargeted -->

<script language="javascript"><!--

var id=180; var jar=new Date();var s=jar.getSeconds();var m=jar.getMinutes();

var flash=s*m+id;var cgi='http://www.ohiobiz.com/linkssql2/adcycle';

var p='<iframe src="'+cgi+'/adcycle.cgi?gid=5&t=_top&id='+flash+'&type=iframe&keywords=ENTER+KEYWORD+LIST" ';

p+='height=60 width=150 border=0 marginwidth=0 marginheight=0 hspace=0 ';

p+='vspace=0 frameborder=0 scrolling=no>';

p+='<a href="'+cgi+'/adclick.cgi?gid=5&id='+flash+'" target="_top">';

p+='<img src="'+cgi+'/adcycle.cgi?gid=5&id='+flash+'&keywords=ENTER+KEYWORD+LIST" width=150 height=60 ';

p+='border=1 alt="Click to Visit"></a></iframe>'; document.write(p); // -->

</script><noscript><a href="http://www.ohiobiz.com/linkssql2/adcycle/adclick.cgi?gid=5&id=180" target="_top">

<img src="http://www.ohiobiz.com/linkssql2/adcycle/adcycle.cgi?gid=5&id=180&keywords=ENTER+KEYWORD+LIST" width=150 height=60 border=1></a></noscript>

<!-- END ADCYCLE IFRAME RICH MEDIA CODE -->

I know I have to add the actual keywords and make the modifications you previous mentioned but where does the above code go? Where do I place it? Do I have to create an additional field in the Database->Links->Properties area for the appropriate link? Is there a global used?

Did you follow the help instructions provided for displaying search result banners below?

Displaying Search Result Banners
To be able to have ceartain banners show up when users search for specific keywords you need to:


1. In Adcycle, create a group in Adcycle called SearchTargeted
2. In Adcycle, edit the campaign you want to be targeted and under Other Targeting, click on Add/Modify Criteria. From here you can add the keywords you want associated.
3. In Adcycle, click on Groups and select the SearchTargeted group you just made and make sure the campaign is selected.
4. In Links SQL go to the admin panel, under Plugins. Then click on Plugin Manager and edit the Adcycle plugin. Set the keyword_group setting to correspond to the Adcycle Group ID of the SearchTargeted group.
5. In Links SQL enter:
<%Plugins::Adcycle::display_search_banner%>This is where I am getting stuck. Is the the correct way? What am I missing? It doesn't seem to call up the banner when I type in the appropriate keyword(s).Thanks.mgeyman

Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hi,

put the group-code you've generated (groups->SearchTarget->Get Ad-Codes)into your search_results.html-template!

Replace ENTER+KEYWORD+LIST with <%query%>:




...

var p='<iframe src="'+cgi+'/adcycle.cgi?gid=5&t=_top&id='+flash+'&type=iframe&keywords=<%query%>" ';

....

AND

...

p+='<img src="'+cgi+'/adcycle.cgi?gid=5&id='+flash+'&keywords=<%query%>" width=150 height=60 ';
...






Afterwards you have to create campaigns within your SearchTarget-group for every different Banner/Text, you want to display. The HTML_Ad-Code has to be the same for every campaign!!! The only difference between the campaigns' HTML-AD-Codes should be the Image SRC and Texts to display (and of course the click-url).

Example:




<TABLE BORDER="0" WIDTH="190">
<TR><TD ALIGN ="center">
<FONT SIZE="2" FACE="Verdana" COLOR="#aabbcc"><B>Sponsored Link :</B></FONT>
</TD></TR>
<TR><TD>
<TABLE BORDER="0" WIDTH="190" HEIGHT="102" CELLPADDING="0" CELLSPACING="0" BGCOLOR="#A8DDA0">
<TR VALIGN="middle"><TD>
<TABLE BORDER="0" WIDTH="188" HEIGHT="100" ALIGN="center">
<TR BGCOLOR="#EBFFED" VALIGN="top" ALIGN="center"><TD>
<a href="http://www.shop-netz.de/cgi-bin/shop/adcycle/adclick.cgi?cid=31&gid=GID&mid=43&id=1" target="_blank"><FONT SIZE="2" FACE="Verdana"><B>
Communik</B></FONT></A><br>
<a href="http://www.shop-netz.de/cgi-bin/shop/adcycle/adclick.cgi?cid=31&gid=GID&mid=43&id=1" target="_blank">
<img src="http://www.shop-netz.de/shopping/images/adimages/keyword/communik.gif" width=156 height=60 border=0 alt="Sponsored Link"></a><br>
<FONT SIZE="1">Shop mit über 35.000 Artikeln<br>
rund um Netzwerk u. PC
</FONT>
</TD></TR></TABLE>
</TD></TR></TABLE>
</TD></TR></TABLE>




Black- this is in every campaign the same!!!

green- this is what I've changed in every Campaign depending on the Advertiser

blue- this is the adcycle-url-provided by adcycle setting up the html-ad

There is no need to use <%Plugins::Adcycle::display_search_banner%>.



I hope this helps!

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Manu,

I got the part with the search code that does on the search_results.html page but where does the HTML-Ad-Code (below) for each banner/text reside after it is generated? Does this code get copied into a field for the link that the pertains to (within the Links SQL database)?

Thank you very much!

mgeyman

Afterwards you have to create campaigns within your SearchTarget-group for every different Banner/Text, you want to display. The HTML_Ad-Code has to be the same for every campaign!!! The only difference between the campaigns' HTML-AD-Codes should be the Image SRC and Texts to display (and of course the click-url).

Example:






<TABLE BORDER="0" WIDTH="190">
<TR><TD ALIGN ="center">
<FONT SIZE="2" FACE="Verdana" COLOR="#aabbcc"><B>Sponsored Link :</B></FONT>
</TD></TR>
<TR><TD>
<TABLE BORDER="0" WIDTH="190" HEIGHT="102" CELLPADDING="0" CELLSPACING="0" BGCOLOR="#A8DDA0">
<TR VALIGN="middle"><TD>
<TABLE BORDER="0" WIDTH="188" HEIGHT="100" ALIGN="center">
<TR BGCOLOR="#EBFFED" VALIGN="top" ALIGN="center"><TD>
<a href="http://www.shop-netz.de/cgi-bin/shop/adcycle/adclick.cgi?cid=31&gid=GID&mid=43&id=1" target="_blank"><FONT SIZE="2" FACE="Verdana"><B>
Communik</B></FONT></A><br>
<a href="http://www.shop-netz.de/cgi-bin/shop/adcycle/adclick.cgi?cid=31&gid=GID&mid=43&id=1" target="_blank">
<img src="http://www.shop-netz.de/shopping/images/adimages/keyword/communik.gif" width=156 height=60 border=0 alt="Sponsored Link"></a><br>
<FONT SIZE="1">Shop mit über 35.000 Artikeln<br>
rund um Netzwerk u. PC
</FONT>
</TD></TR></TABLE>
</TD></TR></TABLE>
</TD></TR></TABLE>
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
this is the code for the (my) HTML-Ads for the campaigns.

As you can see, the banner img i've integrated is the same as for my alternative(if Iframe won't work) JPG/gif-Banner ad (->img src: http://www.shop-netz.de/shopping/images/adimages/keyword/communik.gif)

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Manu,

Maybe I'm not asking the question properly - where do I put this code (HTML-AD...<TABLE>...</TABLE>) ?

When someone, let's say, does a keyword search in LinksSQL for the term "flowers." On the search results page that contains the IFRAME RICH MEDIA CACHE-BUST CODE code (with keyword="<%query%> in the appropriate places you mentioned), how does that look for the proper HTML-AD code to pull the proper banner that is associated with the keyword term "flowers?" Where is the compaign banner <TABLE>....</TABLE> code stored?

Thanks in advance for the clarification.

mgeyman
Quote Reply
Re: [mgeyman] Keyword/Keyword Phrases - Priority Links - Help!! In reply to
Hi,

my <Table>...</Table> - Code is stored in the HTML-Ad-Field of my HTML-Banner of a campaign (See Adcycle3.jpg)

Just the IMG-tag (as mentioned before) I use for the JPG/GIF-Banner of the same campaign (see also adcycle3.jpg)

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
> >