Semrush Api Lookups Calculations And Ui
Objective Automate the aggregation of URL meta data, including basic scoring and exporting of output Deliverables UI for management of URL lists, including creation of list groups and exporting of lists and list data Back end lookups and API parsing of URLs from SEMRush API o Basic calculations using SEMRush data Requirements 1) Create New UI a) User creates campaign and provides name (campaign_name) b) Campaign comprises up to two source input lists: keywords, URLs 2) Perform Data Lookups a) Keyword Lookups i) Looked up against SEMRush Organic Search results ii) Output fields to parse (1) Rank (2) Domain (3) URL b) URL Lookups i) Inputs (1) Use lookup Domain result from keyword lookup (a) above (2) Use manually entered domains in step 1 ii) Looked up against SEMRush (1) (by+organic_organic) - Competitors in organic search report (2) http://us.api.semrush.com/?action=report&type=domain_organic_organic&key=XXXXXXXXXXX&display_limit=10&export=api&export_columns=Dn,Np,Or,Ot,Oc,Ad&domain=pretarget.com/resources.html iii) Output fields to parse (numeric) (1) Dn - Sites competing with this site in search results, sorted by the number of common keywords (2) Np - The number of keywords for which the site is displayed in search results next to the analyzed site (3) Or - Keywords this site has in the TOP20 organic results (4) Ot - Estimated number of visitors coming from the first 20 search results (per month) (5) Oc - Estimated cost of purchasing the same number of visitors through Ads (6) Ad - Keywords this site has in the TOP20 Ads results 3. Merge, Calculate Data i) Frequency = Calculate frequency of occurrence for each URL and TLD ii) Sum Each (1) Common Keywords (2) Organic Keywords (3) Organic Traffic (4) Organic Cost (5) Adwords Keywords iii) Keyword Overlap = Common Keywords/Organic Keywords iv) Value Per Visitor = Organic Cost/Organic Traffic 4. Search & Export/Report UI i) Searches by keyword wild card (1) campaign_name (2) Source keyword (3) Source URL/Domain (4) Result URL (5) Result Domain ii) Sort by Frequency, largest to smallest iii) Show first 50 results iv) View Report Parameters Above results (1) Search Field (2) Search Value (3) Google US (4) Date/Time of Lookup v) View fields on screen (1) Source keyword or source url (2) URL (3) Domain (4) Frequency (5) Sum of Common Keywords (6) Sum of Organic Keywords (7) Sum of Organic Traffic (8) Sum of Organic Cost (9) Sum of Adwords Keywords (10) Keyword Overlap (11) Value Per Visitor (12) Average Rank (13) Average Page vi) Click to export all results to Excel Constraints Designed for maximum future flexibility SEMRush Databases: US Google only 20 results per keyword for organic search results
Latest related projects
| Project name/Short description | Project type | Posted time | Budget |
|---|---|---|---|
Code Html/css Page With Php Email Form And Edit Css For Site Please login or register to view the project detail. Full details ยป | 2 hours ago | n/a | |
Youtube Marketing We are looking for people who can make youtube SEO packages. We'd like to add this service to our website and we are looking for people how can work continuously and Please bid this offer with your packages and price list. We need ONLY 100% REAL users! Also we will need to include a feature to target audience by LOCATION (especially US and some US STATES like California, Nevada, Arizona) and ... Full details ยป | 5 hours ago | n/a | |
Seo For High Competition Word Site I have a website that needs more natural and organic backlink and I need more traffic per day - real traffic so no software. Please submit your quote to hit this goal. include your method and specific time flame. We target only Canada Ontario Toronto customer. We do not count access outside from Canada. Only white hat SEO. No SPAM comment for SNS and blog or we cancel your contract. Provide ... Full details ยป | 5 hours ago | n/a | |
Enhancement Of Ecommerce Website I am looking for Magento Expert person who can work on my ecommerce website(mall8door.com) and I want to include some additional feature in my website like : Auto Complete Search Box like ezee-shop.com Ajax Shopping Cart like ezee-shop.com in Grocery & Fliptcart.com in Electronics Quick Shopping like http://www.ezee-shop.com/quick_shopping.html Look n Feel like goodlife.com ... Full details ยป | 5 hours ago | n/a | |
Internet Explorer Browser Fix My home page is messed up in Internet Explorer. Looks fine in Chrome. I must have deleted a css/xhtml tag somewhere. Need someone to fix asap. Full details ยป | 6 hours ago | n/a | |
Google Map Api Expert For World Regions Overview The first task will be for you to give me a 20 minutes demo using Google Development API platform on how you would carry out the specification (see attached) Please note that if there are any particular functionalities, mark, or layout that is difficult to achieve we would consider modifying our requirement to make the job easier/less costly. For instance, I believe the roll over mouse ... Full details ยป | 7 hours ago | n/a | |
Slider For My Website And Optimization 2 I am looking for someone to help me with a slider for my website. I also need some SEO help. Full details ยป | 7 hours ago | n/a | |
Extract And Export Html Table Data To Excel Hi guys, I need to scrape this site (http://www.optometrists.asn.au/) for its database of Optometrists, and their contact details. Manually, this requires doing a wildcard surname search by the first letter (e.g. search 'A' for all Optometrists with surnames beginning with letter A). I'd like it if you'd be able to automate this process by running some script to scrape the search result ... Full details ยป | 10 hours ago | n/a | |
Custom Table Html Code Needed For Product Display & Ordering I need an HTML expert that is capable of designing a custom table for (6) products that I'd like to display and sell on my website. The website address is http://amy.myarbonne.com which is a template site that is capable of accepting custom HTML code. I need to have HTML code that will enable a table display and selling capabilities of the following products so that when a customer wants to purchase ... Full details ยป | 13 hours ago | n/a | |
Link Building Campaign Seeking a seasoned programmer for link building campaign. Links include articles, social bookmarking, and other successful means you have to promote my site and bring inbound leads/referrals. My main objective is to brand my presence within my local market only. Here are some steps I want you to follow: 1. I want one page (or two if necessary) of high quality fresh original content that include ... Full details ยป | 22 hours ago | n/a | |
Google Custom Search I have a Google Custom Search API account, and need a script that I can use, with my account credentials, and submit a string that I provide, and return the number of results found within a 24 hour period. Example I submit: Mitt+Romney+CNN Mitt+Romney+MSNBC Mitt+Romney+CNBC and this function should return total number of results for that "set". Please note, the set could be ... Full details ยป | 23 hours ago | n/a | |
Google+ Image Created From Logo We are setting up a Google+ page for our business and need an image created for our profile based on our logo. The size needs to be 250X250 and I would like to have the logo in there as well as some nice transient colour or design behind the logo to fill it in and look nice. Should be pretty easy project for graphic designers. Full details ยป | 1 day ago | n/a | |
Google Snippets I want to start creating Snippets for my canlaw.com web site. Please go to http://www.canlaw.com/legalforms/separationkit.htm and the check the download now page for costs etc I want a snippet for the separation kit covering a short description: eg " CanLaw Separation Agreement. All you need to cover your own separation" Download now for just $55.00 or something like the above. Payment ... Full details ยป | 1 day ago | n/a | |
Modifications Hotel&flight Compare Site We have a clone of Hotelscombined.com script which is programmed to use Hotelscombined.com affiliate. But we would like to use our own affiliates from different booking sites instead of the one from Hotelscombined.com. In this script now, everything is based on clicks wherefor eventually hotelscombined.com will pay us for. We want that we earn an affiliate money for the bookings our site has generated ... Full details ยป | 1 day ago | n/a | |
Easy Project Only For Us And Uk Guys Only Hi Guys, I've a data entry type of project only for US/UK guys. Please apply only if you have dynamic IP provided by your ISP. More info will be shared in PMB. THIS PROJECT IS ONLY FOR US/UK GUYS. Thanks. Full details ยป | 1 day ago | n/a | |
Sitemap Needed Hello, We need a sitemap for our site Its a classifieds site, all site is AJAX and JQUERY So Google bot or sitemap software cant read pages or countries So you should fetch each page in each category and each country Regards Full details ยป | 1 day ago | n/a | |
Link Building Experts i have alot of seo clients plus alot of my own sites that i need a reliable person to work on. Im searching for a very long term link building provider. You must be an expert on this. Right now the backlinks that work really well are backlinks from blog sites, usually backlinks with content post in blogs. These are the kinds of links i want. If you have a good source for a large large supply of ... Full details ยป | 1 day ago | n/a | |
Seo Www.iqcontrol.ie Hi you gave me pricing at $150 per month, is this best price ?how many months? And when would I see results? Full details ยป | 1 day ago | n/a | |
Windows 8 Wordpress Theme Looking for Wordpress Theme that navigates like Windows 8. Requirements: -WordPress 3.x Compat -Menus: Header and Footer -Adsense Ready -When you click on the pages at the top (Header Menu), the whole side shifts to that page (Similar to how Xbox 360 Dashboard Does). This requires javascript, not flash. -Tiles will display either featured image or title of post -Different Title Sizes can be ... Full details ยป | 1 day ago | n/a | |
Fixing Prestashop Theme Positioning Hi All, The design & layout of the theme have no problem...Everything ok with Firefox but somehow when view with other browser like chrome, safari & IE got problem. The theme design with a blockcart run off when the browser resize... suppose it will stay on the right but when i make the browser smaller the Blockcart run to the bottom. Your task is make sure theme look nice in other ... Full details ยป | 1 day ago | n/a | |
Google Calendar In Classic Asp Hi We need functions related to manage events of Google Calendar. ONLY CLASSIC ASP CODE. 1. One function to authenticate to Google Calendar by OAuth 2.0 2. One function to populate events from one calendar and between 2 dates 3. One function to delete an event from one calendar and his id 4. One function to insert an event in one calendar 5. One function to modify an event in one calendar Thanks ... Full details ยป | 1 day ago | n/a | |
Write Articles About Learning Guitar 2 I need 3 500 word articles written in the Guitar niche. I expect this person to have a very well rounded knowledge about how to play the guitar. MUST have expert English writing skills. Absolutely NO plagiarism. Must be 100% unique content. No grammer errors. Articles must be SEO friendly, and follow all of the Ezine Articles guidelines and policies. Will discuss more details with winning ... Full details ยป | 1 day ago | n/a | |
Google Adwords Keyword Volume Scraper I need to scrape data from the Google AdWords External Keyword Tool (much like how Market Samurai does it). I have a tool that runs on my dedicated server & I need to be able to pull in the following data from the adwords external keyword tool in real-time: - search volume each month - see attached of excel pull down from Google - Option to supply matchtype, country, language and devices - ... Full details ยป | 1 day ago | n/a | |
Mobile Phone Sms Auto Responder Android developers, we are seeking an Android app capable of sending an auto response to the sender of a SMS (text) if the smart phone is moving above a certain speed. The app should recognize if a smart phone is in motion above 5 mph (2.24 meters per second) and sending an automated response to the sender of a SMS (text message) upon receipt that the phone is in motion. Auto text should be sent using ... Full details ยป | 1 day ago | n/a | |
Simple Wordpress Plugin I am looking for a PHP developer with experience in building plugins for the Wordpress platform. I need a simple plugin that takes existing HTML code and modifies it to PHP to produce an output which can go to a Wordpress Post or page or output a completed standalone HTML file ready to upload to a server. The user of the plugin must be able to select from a dropdown list a pre determined design ... Full details ยป | 1 day ago | n/a | |
Php Mysql Code Generator To Create Custom Web Applications I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see www.propertymarket.biz or http://atomicinfosystem.in/transportmanagement/admin_home.php (user type : Data entry user | user name : | password ... Full details ยป | 1 day ago | n/a | |
Need 40 Article Rewritten & Seo Optimized 2 2 I need a series of articles rewritten for our website content. i'm looking for a writer who can rewrite me 40 articles. I will provide you with the links.The rewritten article should pass Copyscape with at least 80% uniqueness, and search engine optimized. this should be done before submitting them its .5$ per article. I can not increase my budget so if you think you can not work in the given ... Full details ยป | 1 day ago | n/a | |
Register Google Adsense With My Details I need you to register a Google adsense account with my details (I will give you the name and address after you bid). After it successfully goes through, you hand it all details useful for the adsense account as under: 1. The gmail adress used. Please register a new one and ask me for the alternate email adress. 2. Passwords too. Thanks and I expect bids now and ask for clarifications. Full details ยป | 2 days ago | n/a | |
Wordpress Work And Maintenance On My Website I use the Standard Theme and Yoast SEO and need someone to complete some work on my website. I know there are some problems from a report. I also have sharing problems to Facebook. I also want some ideas on my pages to make them look better. I do not want to switch the theme, but to work with the theme. I especially don't want anyone to cause problems because I have little time to deal with anything. ... Full details ยป | 2 days ago | n/a | |
Website With A Small Db 2 Hello, I need a small website with contact form, multilanguage, and a database. Clients would login and check their transaction status. Automated tracking numbers should be generated. Also need a feature to notify Clients with instant emails. Example site careposit.com Full details ยป | 2 days ago | n/a | |
Big File Uploader And File Sharing Site Need large file UPLOADER, HOSTING, SHARING, site better than these see inside in two weeks. Review the sites (all pages not just home page) and bid on the best components of these so mine will be preferred over these. Should have free and upgrade paid options. Need complete end to end fully automated site on my server before work is regarded as done. I expect bids from experienced coders ONLY with ... Full details ยป | 2 days ago | n/a | |
Seo Worker Is Required I am in need of a SEO freelancer to expand and increase the ranking of my e-commerce portals. I am not looking for any organization here, I am in urgent need of a qualified, talented SEO guy who can follow my definite instructions and take things forward with professional expertise. I have already 4 team members in my SEO team, I only need one more to increase the productivity and performance of ... Full details ยป | 2 days ago | n/a | |
Insert A Searc Box And Searchresult On A Wordpress Blog We are building a website based on a wordpress solution. We need a functionallity similar to the one you see on www.aogb.dk, where the user type in a word/phrase and then we perform a broard search on google, facebook, twitter and others.The searchresult is to be shown on the site as well. Please look at www.aogb.dk. We are not experts in html/javascript, so I need the complete code, and info ... Full details ยป | 2 days ago | n/a | |
Quick Contact Form Needed 2 2 Hi guys. I need a PHP contact form using Google Captcha created. I will have some 20 fields or so. I'll provide the template that must be used, you'll insert/create the needed code. Some limitations must be set on the fields as well. This should be a 2-3 hours maximum job for a good programmer. Please keep your bids low, thank you! Full details ยป | 2 days ago | n/a | |
Install Free Translation On Site On my site findtout.com/fr The english cities has to be translated to french. Like you see on the english side its possible to choose the country , province or state and city, but on the french section it does not working and I was told its because google api has been changed .... Please help. Full details ยป | 2 days ago | n/a | |
Setup 2 Online Store Linked With Given Wordpress Templa 2 I need you to setup 2 online store eg. Store A and B in two different domains. When customer click buy on store A, they will be brought to Store B an affiliate store to do actual purchase. Store A need to link to google base. I will give you a wordpress template that uses opencart. Store B is just an Amazon AStore very simple. However I be giving 5 categories and I need you insert the best selling ... Full details ยป | 2 days ago | n/a | |
Simple Php Business Directory Simple PHP Business Directory: Home Page State Page Listing Page Contact Page Home page is the home page that will display a clickable Map of the US. Each US State can be clicked and directed to it's State page. It will also display newly added Listings and Featured Listings. Also need a menu bar with links; Home, States (Drop down), Featured, New, Contact State Page will simply list ... Full details ยป | 2 days ago | n/a | |
Yelp Review Listing With Google Maps I need to add a yelp web app to my website using the yelp api to display reviews in both a listing format and in a google map. (see example: http://www.vailpm.com/dining-restaurants) The user/visitor must be able to search for restaurants, bars, cafes, diners etc and get nearby results of businesses with yelp reviews. Currently my website does have the search functionality that returns reviews in ... Full details ยป | 2 days ago | n/a | |
Google Adwords Data Scrapper 2 I would like someone to build a tool that can go to : https://adwords.google.com/o/Targeting/Explorer?__c=8337484959&__u=9278523159&__o=cues&ideaRequestType=KEYWORD_IDEAS and collect the data, It must be build on C#, C++ or VB. I want to be able to call a function, like this : Adwords.Scrape("keyword here") that keyword would be inputted and the results returned back ... Full details ยป | 2 days ago | n/a | |
Realchat Scripting Api Custom Code I use RealChat Enterprise Edition 5.0 chat software (www.realchat.com) and need to use the RealChat Scripting API to display the number of people currently chatting in a specific chat room on one of my webpages. The display of the number of people currently chatting should be in parenthesis, like this (1). If the current number of people chatting is less than one, display nothing. It's been suggested ... Full details ยป | 2 days ago | n/a | |
Seo Results Based Project My site: www.nuvaskincare.com got seriously hit from the Panda/Penguin updates and I need these keywords to rank on the top 10 again: obagi tretinoin obagi blender obagi clear I'll pay 1/2 of the project cost once you rank these keywords on the top 20 and the rest when they are ranked in the top 10 for a week. These are long term project, I will have more keywords to work on once the results ... Full details ยป | 2 days ago | n/a | |
Looking For Seo Expert To Help Me Hire Seo Expert Hi Folks, We are Looking for Highly Experienced SEO guy who can help us to hire a very Good SEO guy for Hyderabad Location. You need to handle a technical Interview for 6 people. Thanks Masood Full details ยป | 2 days ago | n/a | |
Htaccess And 404 Error Issues Need to solve a .htaccess issue. We have a new joomla site that is using ACESEF (but a "fresh" install of joomla does the same thing). This new site has many new pages that the old site does not have. Problem is that many of the old URL's that do not exist on the new site do not generate 404 errors. So google continues to show those unless they see a 404 error. And in our new joomla ... Full details ยป | 2 days ago | n/a | |
Wordpress Theme For Funny Pictures Similar To Lolsnap 2 I need one custom theme for WordPress created. I will be using this website to post funny pictures. The website will have similar features as http://lolsnaps.com The following are the requirements for the new theme: 1) Need small header similar to http://lolsnaps.com/ 2) The next and previous buttons on pictures similar to DamnLOL.com 3) The content area needs to be atleast 728px similar to ... Full details ยป | 2 days ago | n/a | |
Website Build - Seo I am looking for somebody that can build and design a website for a surveillance camera business. The website should be very minimalistic and optimized for google queries. For more details please contact me. For an example of what i'm looking for please see the following: http://www.mr-locks.com/ http://www.interiors.davroc.co.uk/ Full details ยป | 2 days ago | n/a | |
Book Topic Researcher ** This ongoing project requires research strictly for appropriate topic/titles, NO actual writing of articles is required.** I am a ebook publisher that is looking for virtual assistants to follow my guidelines and provide topic/titles for new books. The person can find topic ideas throughout the internet, offline, Google, Youtube, blogs, etc. However, specific requirements for acceptance are ... Full details ยป | 2 days ago | n/a | |
Music Database Creation & Web Automation Reposting this project as project was closed before I could select a bidder. --- I run a Chicago-based live music blog, with a sub-focus on charts, graphs and visuals that provide insight into the live music experience. Some of my signature content involves presenting select bands' song lists, using a unique visual presentation styles to more easily communicate statistics and uniqueness of each ... Full details ยป | 2 days ago | n/a | |
Keyword Research US based company is looking for a strong SEO professional to complete a comprehensive keyword research and report. This keyword research is being done for a new website - everything about the site will be based upon what you find and provide in your report. Here is what I need: -Professional, Comprehensive Keyword Research -Analysis of most search terms around their product based upon the information ... Full details ยป | 2 days ago | n/a | |
Seo For Www.allmywalls.com Hello, We are interested in hiring someone to handle our SEO for our website. Could you send a detailed list of the services that you would perform, credentials (other websites you have worked with), and pricing for the monthly service. Thank you, Dave Full details ยป | 2 days ago | n/a | |
Seo Stanza Our site is www.stanzatextbooks.com We have had about 3-4 months of Seo work done. Please take a look and let me know what you recommend to get our site in first pages of google, yahoo, bing and msn. Please make specific recommendations after taking a look at the site internally and externally. I can provide temporary admin access. Some keywords: Rent textbooks cheap; used cheap textbooks; ... Full details ยป | 2 days ago | n/a |
