A blend of programming and seo

Category — zencart

Zencart local seo reports mod

by Roy (rawseo)

zenlogo Zencart local seo reports mod

Introduction

This module allows you track all of the keywords used to search you website. This can be helpful because it can give you an insight into what your customers actually need.

keyword box Zencart local seo reports mod


Installation

Step 1: Open admin/includes/boxes/report_dhtml.php

at line 20 where it says:

$za_contents[] = array('text' => BOX_REPORTS_CUSTOMERS_REFERRALS, 'link' => zen_href_link(FILENAME_STATS_CUSTOMERS_REFERRALS, '', 'NONSSL'));

add right after:

$za_contents[] = array('text' => 'Rawseo Local Keyword Reports', 'link' => zen_href_link('rawseo_keyword_reports.php', '', 'NONSSL'));

step 2: open includes/modules/pages/advanced_search/header_php.php

at the end, add the following:

//log keywords
$keywordQuery = sprintf("INSERT INTO rawseo_keyword_reports (keyword,timestamp) VALUES('%s',now())",mysql_escape_string($_GET['keyword']));
@mysql_query($keywordQuery);
//end logging keywords

step 3: open includes/modules/pages/advanced_search_result/header_php.php

find the following line (around line 54):

if (isset($_GET['keyword']) && $_GET['keyword'] != HEADER_SEARCH_DEFAULT_TEXT  && $_GET['keyword'] != KEYWORD_FORMAT_STRING) {
    $keywords = $_GET['keyword'];

add right after:

//log keywords
$keywordQuery = sprintf("INSERT INTO rawseo_keyword_reports (keyword,timestamp) VALUES('%s',now())",mysql_escape_string($keywords));
@mysql_query($keywordQuery);
//end logging keywords

step 4: Upload all files included in this zip file to your catalog

step 5: import db/rawseo_keyword_reports.sql into your database

You should now have another menu item under reports called “Rawseo Local Keyword Reports”.

Download

All files for this module can be download here.

October 20, 2009   No Comments