If foreign trade SEO marketers want customers to predict the effect of English SEO, they must predict the return on investment of English website SEO and keywords. This article will start with the required information and data, and how to estimate the return on investment of websites and keywords.
foreign tradeOne of SEO's biggest challenges is proving its worth. it is knownGoogle SEOIt is very valuable, but it is important that we let decision-makers realize its value in a timely manner. In order to do this, I did ROI budgeting on changing keyword targeting as follows:
?
1. What do you need?
?
Statistics is the simplest, but it is not so easy to obtain valuable data from numerous data. Each part of the counting process is listed below, and then we can start counting and searching.
?
1. Keyword related data:
?
keyword list
?
Search volume for each keyword
?
Keyword related URLs
?
keyword ranking
?
Ranking for relevant URLs
?
2. Advantages of the preferred URL page:
?
List of deleted and preferred URL duplicates
?
Page Authority per URL
?
Bonus: External and internal links for each URL.Here you can try all your favorite methods,As long as it has a comparative value, like a number.
?
3. Keyword competitiveness:
?
For each keyword, the top 10 rankings on search engines are the most competitive.
?
2. How to get the information you need?
?
There are already many articles about keyword research, and here Jiexin Internet Marketing Agency will not elaborate. For the keyword data list, the most important thing is to get the keywords and related information you need from it. You need to choose the most competitive URL with the highest degree of keyword fit (that is, your preferred URL).
?
For a list of preferred URLs, you'll want to use keyword-related data on the preferred URLs. the
?
1. Copy the keyword data into the corresponding URL data, and create a new label for it.
?
2. Use "Remove Duplicates (in Excel)" to remove duplicate URLs.


?
Once you have a list of URLs with duplicates removed, then you need to extract relevant data from it. Jiexin Network Marketing Agency recommends that Moz API with SEO tools must be installed before use, and then it can be used in Excel. Or you can use Google Docs, which has similar resources.
?
After the SEO tool is installed, enter "MOZ URL Metrics to Fit", and a list of URL titles, canonical URLs, external links and internal links, as well as some other indicators and DA/PA will appear.
?
For the listed relatively competitive keywords, first you need to search for each keyword. You can search manually, or use the keyword ranking tool to enter the keywords you want to search and view the exported data. If you don't have such a tool, there are other ways, such as using the Import XML command in a Google spreadsheet to grab the top URLs.


?
The above are related examples. Note that you can run numerous searches column by column, I ran 850 per column, if you run too many, Google will block your IP address. In addition, once the corresponding data is obtained, it must be extracted in time, because these data are updated very quickly. These data can be temporarily placed in the Excel sheet you are building for the calculation of return on investment.
?
From the above list, you can extract each URL into a separate list, remove duplicate URLs, thereby enhancing the competitiveness of the entire URL list, and then analyze these URLs using the SEO tool in the Excel sheet as before , to get the relevant data.
?
3. Make data work for you
?
Once you have the list, you can use the VLOOKUP function to get the information you need. Jiexin Internet Marketing Agency uses competitive keyword lists as the basis for its work.
?
Extract the corresponding preferred URL, page weight, and PA and DA of the top 10 URLs, and then I can calculate the average PA and DA of each query, so that I can compare and estimate the URL pages to be ranked Chances of this page ranking high (provided I've determined that these are keyword-related pages).
?
Now, we want to analyze the following sets of data:
?
1. Conversion rate
?
2. Average value
?
3. Income of the previous year
?
All assumptions can be adjusted according to the actual data or estimated data of the website. I'm using the most common way by far, estimating by total hits, but you can choose any precision you want. There are two sets of data that deserve special attention:
?
4. Annual profit.
?
5. Increased profit compared with last year.
?
The reason why we should pay attention to these two sets of data is because money can turn ghosts around. Obviously, you can't guarantee that it will be profitable at the moment, but these can tell investors that if they continue to invest in the project, it will eventually be profitable.