E-commerce Leads

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

Connect into your Google AdWords account and start searching for keywords combinations as shown in the video. Organize and download the keywords combinations and select only the most popular ones for the research.

Following the video 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.

 Tools used:

URL extractor: http://www.onlinesales.co.uk/tools/tools/bookmarklet-serps.php

URL trimmer: http://www.seoweather.com/trim-urls-to-root-domain-standardise-urls-prefixes/

Google spreadsheet: =UNIQUE(A1:A10000) where A is the column  with trimmed URL's

Transfer the URL's in Email Extractor and start the process. Export the results in an excel sheet as shown in the video.

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.

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

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.

Tutorial videos:

https://drive.google.com/file/d/0B7b0Oz17T0b3R0hqdnZhdFIybEk/view?usp=sharing

https://drive.google.com/file/d/0B7b0Oz17T0b3bF9vcTBQX2k2bTA/view?usp=sharing

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.

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.

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

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.

Tutorial videos:

https://drive.google.com/file/d/0B7b0Oz17T0b3R0hqdnZhdFIybEk/view?usp=sharing

https://drive.google.com/file/d/0B7b0Oz17T0b3bF9vcTBQX2k2bTA/view?usp=sharing

Transfer the URL's resulted from the previous stage into Email Extractor and start another extraction process.

Tutorial videos:

https://drive.google.com/file/d/0B7b0Oz17T0b3R0hqdnZhdFIybEk/view?usp=sharing

https://drive.google.com/file/d/0B7b0Oz17T0b3bF9vcTBQX2k2bTA/view?usp=sharing

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.

Tutorial videos:

https://drive.google.com/file/d/0B7b0Oz17T0b3R0hqdnZhdFIybEk/view?usp=sharing

https://drive.google.com/file/d/0B7b0Oz17T0b3bF9vcTBQX2k2bTA/view?usp=sharing

Connect into Campaign Monitor (username:[email protected], password: t.holdings) and create the right email template for the future campaign or use an existing one.

Collaborate with other teams leaders to create the perfect email template.

The email for the first Campaign should be a general so the NON-e-commerce websites won't be upset for receiving such email.

Setup email campaigns for each list and using the specific templates, schedule the campaign for the established date and time.

Continuously monitor the evolution of the campaigns and collect data regarding the opened emails and clicked links from the emails.

After collecting the data transfer it in a general spreadsheet so the data miners could complete the information about the potential clients.

Organize the data mining team and allocate work volume for each of them and be sure they provide good quality information.

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.

Remove the junk leads (websites that are not e-commerce)

The team leader should double-check the data and be sure there are no errors and no junk data.

Connect into Campaign Monitor (username:[email protected], password: t.holdings) and create the right email template for the future campaign or use an existing one.

Collaborate with other teams leaders to create the perfect email template for e-commerce Leads.

Setup email campaigns for each list and using the specific templates, schedule the campaign for the established date and time.

Continuously monitor the evolution of the campaigns and collect data regarding the opened emails and clicked links from the emails.

After collecting the data transfer it in a general spreadsheet.

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. 

Tutorial videos:

https://drive.google.com/file/d/0B7b0Oz17T0b3R0hqdnZhdFIybEk/view?usp=sharing

https://drive.google.com/file/d/0B7b0Oz17T0b3bF9vcTBQX2k2bTA/view?usp=sharing