|
Step 6: Remove the domain from the search analytics landing page.
Hopefully you can now see where things are going. We have one tab that contains all the Google Analytics data by landing page and another tab that contains the search analytics data by landing page, so all that’s left to do is consolidate the data.
First, we just need to extract the domain name from the Search Console data.Analytics data pulls popular landing pages (excluding https://domain-name.com ), while Search Console pulls the entire domain. So, in order to merge the data, we need to format them into cayman islands whatsapp data the same format. To do this, you need to perform a Find and Replace on the Page column in the Search Console tab in Google Sheets and replace with no replacement (remove the domain name from the URL).
Step 7: Merge data.
Download the keyword-level data template here. The template has the formulas in place to drive year-over-year landing page sessions, bounce rate, and overall goal conversion rate. I also set the سی column to "Target Keywords" so that you can enter the terms you are actively targeting on each page. This way, you can see if your goals are similar to your rankings in Google. After the template is ready, copy the keyword data labels to the worksheet.
After copying the worksheet, you should see a new worksheet with a tab called "Keyword Data." From here, select the Keyword Data tab and click Copy...
|
|