AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
2.3K members online now
2.3K members online now
Dive into advanced features like Remarketing, Flexible Bid Strategies, AdWords Editor, and AdWords Scripts
Guide Me
star_border
Reply

Paid and Organic Report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi There,

 

I have a quick question on the Paid & Organic Report. Basically a member of our team has devised a Vlookup in excel to work out increases or decreases in CTR for both SEO results & PPC Ads when shown separately or together (the data is brough in from the Paid & Organic report in dimensions). The idea in principle is good however there can be slight discrepancies in the figures when compared back to Adwords. So I'm wondering is there a more reliable tool out there for this that anyone knows of? See below pic which might explain it a bit better. 

Thanks in advance for any help that can be offered! 

Capture 1.PNG

Paid and Organic Report

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

The best source I know for getting the organic is linking WebMasterTools to AdWords. 

 

If you see the organic in dimensions, you probably already did that...