As we mentioned in our previous post , it is often difficult to show the value of an SEO campaign to a client or potential client. By not being able to clearly see the value of the optimization work or not being able to clearly visualize the return on investment, a client may cancel a campaign or decide not to hire your web positioning services. In today’s note, we are going to see another way to communicate the impact that an SEO optimization campaign can have. We will present the results to the client in the form of money that the campaign can generate. Let us begin! Data we need: Google Search Console performance information Average monthly search volumes from Google Keyword Planner (optional) Google Analytics Conversion Rate Google.
Analytics Average Ticket Suppose we are trying to close
SEO campaign for a site that sells beer online. We are going to work a little with the data we have… First of all, we are going to raise the keywords that bring traffic to the site. For this we Country B2B & B2C Email List are going to use the Google Search Console Performance report. It is important that we see the number of total clicks, total impressions, average CTR and average position. We are going to dump this information into a Google Sheets We are going to pull up the average monthly search volumes for these keywords from the Google Keyword Planner. We are going to add this information to another tab within the same Google Sheet. Now we are going to unify both tables using the VLOOKUP function (also known as VLOOKUP ). Once this is done, we are going to enter Google.
Ecommerce Conversion Rate
Average order value We return to our sheet to add these variables to our data. Feature engineering Canad Data Now comes the fun part! As we saw in the. Data Science post , functionality engineering consists of generating data from our data. In this case, if we know how many visits a keyword brought, how many people have to enter. Our site for a purchase to be made and the average value of that purchase. We can easily know how much money a keyword brought us. With this simple formula we can obtain this information. Qty revenue generated by keyword = clicks x average conversion. Rate x average order value If the customer has the percentage of online purchases that. Fall after purchasing a product, we can add this data to our table.