Paid and Organic Report
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!