AdWords
2.6K members online now
2.6K 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...