Using whitespark To Generate Local Citations ... - SEO Cheat Guides

Go to Google.com and enter the provided search term. Click on the search icon. From the results, scroll down to the map pack and write down all business ...
4MB Sizes 0 Downloads 60 Views
Using whitespark To Generate Local Citations Step by Step Guide

Using whitespark To Generate Local Citations Step by Step Guide Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

Using whitespark To Generate Local Citations Step by Step Guide

Hi Virtual Assistant, I would like you to use whitespark to generate where our client's competition has their local citations. Please follow the step-by-step procedure below. Here is the information you will need. Pictures will be shared with you on dropbox.com Gmail Login Email: Password: Other Information Search Term: No. of Businesses To Search: Shared DropBox.com Folder: Note: The information noted above must be copied into the relevant filed EXACTLY as shown above. Please let me know if you have any questions. Thanks,

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 1, 2 Please Follow the Steps Below 1) Go to https://accounts.whitespark.ca/sign-up and from the provided information, enter the Name, Email and Password. Click on ‘Create My Account’.

2)

Next on the account creation confirmation page, click Tools.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 3, 4 3)

Click on ‘Local Citation Finder’.

4)

Scroll down the page and click on ‘Try it Free!’.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 5, 6 5)

Click on ‘Create My Free Subscription’.

6)

Hoover over ‘Your Account’ and click on ‘Subscriptions & Services’.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 7, 8 7)

From the Local Citation Finder box, click on ‘Launch Local Citation Finder’.

8)

Click on ‘Business Search’.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 9 9) Go to Google.com and enter the provided search term. Click on the search icon. From the results, scroll down to the map pack and write down all business names along with phone numbers and record this information for the number of businesses you were asked to search above. Please start with #1 and work your way down in ranked order.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 10, 11 10) Go back to the business search and from the noted information, enter the Country, Location, Phone Number and Business Name for the first map pack result You wrote down. Click Search.

11) If the above doesn’t populate alternatively you should receive an email from whitespark for the search confirmation and from this email, click on ‘View your results’.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 12, 13 12) Click on ‘Your Search Results’ and then click on ‘View Sources’ against the respective KEYPHRASE.

13)

Click on ‘Export CSV’.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 14, 15 14) Open the CSV file in MS Excel and rename this sheet to the business name used to search the citations.

15) Click on the ‘Insert Worksheet’ icon and rename the new sheet to the second business name for the citation search and so on.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 16, 17 16) Repeat the steps 12 and 13 for the second or more business name(s) and add the CSV data to new tabs.

17) As all CSV exports are done, create a new sheet and rename it as ‘Unique Citations’. Copy data from all sheets to Unique Citations. Select all rows and columns from this sheet, click on Data menu and Remove Duplicates from Data Tools tab. Click on Unselect All and then select checkbox next to Citation Source. Click on OK.

Copyright 2016 - SEOCheatGuides.com - All Rights Reserved

STEP 18 18) Click OK. Once this is completed, please e-mail me the document named us