{"id":9569,"date":"2017-01-19T12:25:50","date_gmt":"2017-01-19T12:25:50","guid":{"rendered":"https:\/\/www.process.st\/templates\/e-commerce-leads\/"},"modified":"2024-02-28T20:50:08","modified_gmt":"2024-02-28T20:50:08","slug":"e-commerce-leads","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/e-commerce-leads\/","title":{"rendered":"E-commerce Leads"},"content":{"rendered":"
\n

Preparation: <\/h2>\n<\/section>\n
\n

Product research <\/h2>\n
\n

Perform an online research and look for product related to e-commerce activities such as goods and services. Create a Google spreadsheet which will include the results of the research and distribute it to all of the team's members.<\/p>\n

 Top 20  selling Internet items. <\/p>\n

https:\/\/docs.google.com\/spreadsheets\/d\/1KUlrheh-y5d7oLjQFL9pp9-HfO3BI9ltHk2i2azhqm4\/edit?usp=sharing<\/a><\/p>\n<\/p><\/div>\n<\/section>\n

\n

URL's research: <\/h2>\n<\/section>\n
\n

Keyword planner <\/h2>\n
\n

Connect into your Google AdWords account and start searching for keywords combinations as shown in the video<\/a>. Organize and download the keywords combinations and select only the most popular ones for the research.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Collect end process the URL's <\/h2>\n
\n

Following the video<\/a> set up your google search tools and perform the research for each relevant keyword combination. Using the tools provided below extract and trim the URL's to the root and transfer them in a google spreadsheet. Apply the UNIQUE formula after the research is completed for all the keywords combinations.<\/p>\n

 Tools used:<\/h5>\n

URL extractor: http:\/\/www.onlinesales.co.uk\/tools\/tools\/bookmarklet-serps.php<\/a><\/p>\n

URL trimmer: http:\/\/www.seoweather.com\/trim-urls-to-root-domain-standardise-urls-prefixes\/<\/a><\/p>\n

Google spreadsheet: =UNIQUE(A1:A10000) where A is the column  with trimmed URL's<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Email extraction: <\/h2>\n<\/section>\n
\n

Email extraction first stage <\/h2>\n
\n

Transfer the URL's in Email Extractor and start the process. Export the results in an excel sheet as shown in the video.<\/p>\n

Transfer the results in the URL's google spreadsheet in column G and then in column H apply  the SPLIT formula =SPLIT(G1, ",")and drag it to the end of column G.<\/p>\n

In the first cell of column E apply the formula  =IFERROR(IF(MATCH(B1,$I$1:$I$1000,0)>0,1,0),0) where B is the unique URL's column and I is the column with URL's resulted from the first extraction in Email Extractor, drag the cell to the end of column B<\/p>\n

Apply a filter in column E and select only the "0" results and transfer them in a new sheet. In the next column apply a CONCATENATE formula =CONCATENATE(A1, "\/contact"), drag to the end of column A and select the new URL's.<\/p>\n

Tutorial videos:<\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3R0hqdnZhdFIybEk\/view?usp=sharing<\/a><\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3bF9vcTBQX2k2bTA\/view?usp=sharing<\/a><\/p>\n<\/p><\/div>\n<\/section>\n

\n

Email extraction second stage <\/h2>\n
\n

Transfer the URL's resulted from the previous stage into Email Extractor and start another extraction process. Export the results in an excel sheet and then select the result and transfer them in column G in the last URL's sheet.<\/p>\n

Transfer the results in the URL's google spreadsheet in column G and then in column H apply  the SPLIT formula =SPLIT(G1, ",")and drag it to the end of column G.<\/p>\n

In the first cell of column E apply the formula  =IFERROR(IF(MATCH(B1,$I$1:$I$1000,0)>0,1,0),0) where B is the unique URL's column and I is the column with URL's resulted from the second extraction in Email Extractor, drag the cell to the end of column B<\/p>\n

Apply a filter in column E and select only the "0" results and transfer them in a new sheet. In the next column apply a CONCATENATE formula =CONCATENATE(A1, "-us")and select the new URL's.<\/p>\n

Tutorial videos:<\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3R0hqdnZhdFIybEk\/view?usp=sharing<\/a><\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3bF9vcTBQX2k2bTA\/view?usp=sharing<\/a><\/p>\n<\/p><\/div>\n<\/section>\n

\n

Email extraction third stage <\/h2>\n
\n

Transfer the URL's resulted from the previous stage into Email Extractor and start another extraction process.<\/p>\n

Tutorial videos:<\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3R0hqdnZhdFIybEk\/view?usp=sharing<\/a><\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3bF9vcTBQX2k2bTA\/view?usp=sharing<\/a><\/p>\n<\/p><\/div>\n<\/section>\n

\n

Email Extraction completed <\/h2>\n
\n

Transfer into a new spreadsheet the email extraction results from first, second and thirst stage, name and tag the document properly and attach it to this checklist.<\/p>\n

Tutorial videos:<\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3R0hqdnZhdFIybEk\/view?usp=sharing<\/a><\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3bF9vcTBQX2k2bTA\/view?usp=sharing<\/a><\/p>\n<\/p><\/div>\n<\/section>\n

\n

Email campaign: <\/h2>\n<\/section>\n
\n

Create templates in Campaign Monitor <\/h2>\n
\n

Connect into Campaign Monitor (username:management@t-holdings.co.uk, password: t.holdings) and create the right email template for the future campaign or use an existing one.<\/p>\n

Collaborate with other teams leaders to create the perfect email template.<\/p>\n

The email for the first Campaign should be a general so the NON-e-commerce websites won't be upset for receiving such email.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Create lists and setup the campaigns <\/h2>\n
\n

Setup email campaigns for each list and using the specific templates, schedule the campaign for the established date and time.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Collect data from Campaign Monitor <\/h2>\n
\n

Continuously monitor the evolution of the campaigns and collect data regarding the opened emails and clicked links from the emails.<\/p>\n

After collecting the data transfer it in a general spreadsheet so the data miners could complete the information about the potential clients.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Leads Categorization and data completion: <\/h2>\n<\/section>\n
\n

Team organization <\/h2>\n
\n

Organize the data mining team and allocate work volume for each of them and be sure they provide good quality information.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Categorize the Leads and Collect more information <\/h2>\n
\n

Search the web for information about the potential clients, starting from their website provided in the spreadsheet. Look for company name, phone number and business owner's name.<\/p>\n

Remove the junk leads (websites that are not e-commerce)<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Get the leads ready for the second email campaign. <\/h2>\n
\n

The team leader should double-check the data and be sure there are no errors and no junk data.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Follow Up Email Campaign: <\/h2>\n<\/section>\n
\n

Create templates in Campaign Monitor <\/h2>\n
\n

Connect into Campaign Monitor (username:management@t-holdings.co.uk, password: t.holdings) and create the right email template for the future campaign or use an existing one.<\/p>\n

Collaborate with other teams leaders to create the perfect email template for e-commerce Leads.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Create lists and setup the campaigns <\/h2>\n
\n

Setup email campaigns for each list and using the specific templates, schedule the campaign for the established date and time.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Collect data from Campaign Monitor <\/h2>\n
\n

Continuously monitor the evolution of the campaigns and collect data regarding the opened emails and clicked links from the emails.<\/p>\n

After collecting the data transfer it in a general spreadsheet.<\/p>\n

The team leader should double-check the data and be sure there are no errors and no junk data, and also get the spreadsheet ready for the sales team. <\/p>\n<\/p><\/div>\n<\/section>\n

\n

Knowledge base: <\/h2>\n<\/section>\n
\n

Training videos <\/h2>\n
\n

Tutorial videos:<\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3R0hqdnZhdFIybEk\/view?usp=sharing<\/a><\/p>\n

https:\/\/drive.google.com\/file\/d\/0B7b0Oz17T0b3bF9vcTBQX2k2bTA\/view?usp=sharing<\/a><\/p>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"

Preparation: Product research Perform an online research and look for product related to e-commerce activities such as goods and services. Create a Google spreadsheet which will include the results of the research and distribute it to all of the team's members.  Top 20  selling Internet items.  https:\/\/docs.google.com\/spreadsheets\/d\/1KUlrheh-y5d7oLjQFL9pp9-HfO3BI9ltHk2i2azhqm4\/edit?usp=sharing URL's research: Keyword planner Connect into your Google […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"24","template_description":"","template_id":"j_U4ARsFgQ_i0qJFtqdDaQ","task_0":"Preparation:","task_slug_0":"preparation","task_1":"Product research","task_slug_1":"product-research","task_2":"URL's research:","task_slug_2":"urls-research","task_3":"Keyword planner","task_slug_3":"keyword-planner","task_4":"Collect end process the URL's","task_slug_4":"collect-end-process-the-urls","task_5":"Email extraction:","task_slug_5":"email-extraction","task_6":"Email extraction first stage","task_slug_6":"email-extraction-first-stage","task_7":"Email extraction second stage","task_slug_7":"email-extraction-second-stage","task_8":"Email extraction third stage","task_slug_8":"email-extraction-third-stage","task_9":"Email Extraction completed","task_slug_9":"email-extraction-completed","task_10":"Email campaign:","task_slug_10":"email-campaign","task_11":"Create templates in Campaign Monitor","task_slug_11":"create-templates-in-campaign-monitor","task_12":"Create lists and setup the campaigns","task_slug_12":"create-lists-and-setup-the-campaigns","task_13":"Collect data from Campaign Monitor","task_slug_13":"collect-data-from-campaign-monitor","task_14":"Leads Categorization and data completion:","task_slug_14":"leads-categorization-and-data-completion","task_15":"Team organization","task_slug_15":"team-organization","task_16":"Categorize the Leads and Collect more information","task_slug_16":"categorize-the-leads-and-collect-more-information","task_17":"Get the leads ready for the second email campaign.","task_slug_17":"get-the-leads-ready-for-the-second-email-campaign","task_18":"Follow Up Email Campaign:","task_slug_18":"follow-up-email-campaign","task_19":"Create templates in Campaign Monitor","task_slug_19":"create-templates-in-campaign-monitor-2","task_20":"Create lists and setup the campaigns","task_slug_20":"create-lists-and-setup-the-campaigns-2","task_21":"Collect data from Campaign Monitor","task_slug_21":"collect-data-from-campaign-monitor-2","task_22":"Knowledge base:","task_slug_22":"knowledge-base","task_23":"Training videos","task_slug_23":"training-videos","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[7,1],"tags":[],"class_list":["post-9569","post","type-post","status-publish","format-standard","hentry","category-miscellaneous","category-uncategorized"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=9569"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9569\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=9569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=9569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=9569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}