What is a good tool to use to create SEA reports in?
-
Hiya Mozzers,
I'm looking for a tool to create fancy SEA reports in. I'm doing it manually in Word right now and that just takes far too much time and just isn't pretty. We're a small marketing-as-a-service agency and SEA is one of the services we offer, but we're not an Adwords certified partner yet (because we don't have the 10.000 a month yet). So that's to give you an idea of our company size. We're not looking for something big and expensive.
Would love to hear some idea's on tools to use!
Sophie
-
Hi Sophie,
We have built a reporting tool called ReportGarden (http://reportgarden.com). Using ReportGarden it is much easier and quicker to create your SEA/SEM reports. You can create templates that you can be reused to generate reports with a single click. We also provide automation so that you can schedule reports to be emailed to your clients daily/weekly/monthly.
If you have any questions reach out to me at support@reportgarden.com
Ashok
-
This is more towards SEO than PPC, but you might find some useful things in the blog post at http://moz.com/blog/storytelling-through-data-a-new-inbound-marketing-seo-report-structure.
If you do a search for ppc reporting template, you might find some things that will help, especially if you add excel as a search term. Here's one that's several years old, but may still be helpful. http://www.shimonsandler.com/monthly-ppc-performance-report-template/
-
Spyfu have quite good reporting tools which can be branded to your firm.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Impressions data: Google Webmaster Tools VS Google AdWords
Dear community, I was doing some research within Google Webmaster Tools (WMT) keyword data when I noticed that the impressions within this tool are quite different compared to the keyword impression data provided by Google AdWords (ADW). Some specs about the situation: Date: December 2014 (31 days). Keyword: brand + main keyword* (e.g. amazon shoes, if Amazon would have been the client) Visitors come from: the Netherlands (>97%). Search volume: 3,8 K for this branded keyword last year (December 2013), of which >99% came from the Netherlands (source: Google Keyword Planner). Search query data: "impressions" for Google WMT (organic keyword impressions) and “impressions” for Google ADW (paid keyword impressions). Of course the ADW keyword is [exact]. So, what's wrong? The data doesn’t match, while I expected approximately the same amount of impressions assuming the keywords are: both [exact] keywords; (check! ✓) within the same period of time; (check! ✓) the Ad is being displayed "all the time" (check! ✓) the domain/page is being indexed "all the time" (check! ✓) How much of a difference is there? Organic impressions: 7,4 K (source: Google WMT) Paid impressions: 2,1 K (source: Google ADW) Note that the search volume according to Google Keyword Planner of last year is somewhere in between: 3,8K. The search volume from this tool of last December is not available just yet (but I don’t expect much difference here since Google Trends shows a steady search volume). If the difference would have been 10-20%, I wouldn't be surprised at all, but this is huge. **What could explain the differences? ** If a lot of people were using AdBlockers (they do, but not nearly as massively (around 10%)). If we would have made mistakes in AdWords: budget, bidding, targeting etc. - This is not the case, got this confirmed by the manager who double-checked the data and settings. Also: since it’s a branded keyword it’s really cheap for us and easy to get high quality scores. If we would have made mistakes regarding indexing/crawling that would have caused an extreme loss in domain visibility in the SERP's: possibly caused by robots.txt, a noindex-tag, server problems etc. This was not the case and Google WebmasterTools says the average position was 1,0 during the complete month. "Something else" went wrong during that specific period of time with this specific domain. I don’t think so because I checked multiple months and multiple other domains of other clients. These gave me the same relative results (okay, some were a bit closer: 30 K paid impressions vs 62 K organic impressions for instance, still a big difference). What other possibilities are left? The impressions from Google WMT and Google ADW are not the same, even though they are called the same and therefore suggest they should be (about) the same. AdWords just randomly fails to display and/or measure some branded ads (even though there is plenty of budget, bidding is fine and QS is 10/10). Definitions of "impressions" for both tools according Google: AdWords definition of "impressions" WebmasterTools definition of "impressions" Hope someone has some more suggestions or useful links! Thanks in advance! Ektor Tsolodimos
Paid Search Marketing | | BlueMango0 -
Looking to syndicate content - can't use PR Web or Outbrain URGENT!
I have a client in urgent need. They have a blog that they are trying to syndicate and drive traffic towards. Their blogs rest on individual URL's and their topics are loosely connected to the gaming industry. We are using PR Web and planned on using Outbrain to drive traffic, but the topics got pulled due to content restrictions. Any suggestions of tools I can use to help syndicate their blogs? Any and all recommendations would be GREATLY appreciated!
Paid Search Marketing | | jfeitlinger0 -
Google URL Builder / Campaign Tracking on two Different Domain using the Same Analytics Code
Hey Everyone, I think I know the answer to this but I'd like to get some confirmation. I currently have a landing page at "www.xyz.com", it's a separate domain in which only the landing page exists and not a vanity URL which redirects. However, the navigation and all the links on "www.xyz.com" actually link out to "www.abc.com". The domain / landing page "xyz" has the same analytics tracking code as domain "www.abc.com". My question is this, if I use Google URL builder to create custom URL's to track for each ad that I'm running in Adwords, will this data show up in the analytics of "abc" even though it's a separate domain because it has the same analytics code? In other words, does campaign data show only if the domain and the google analytics code line up, or does the domain not matter and as long as you have the same analytics code (despite two separate domains) that campaign data (built through Google URL builder) will show? My hunch and best guess it that as long as the analytics code is the same (regardless of a separate domain) that the data in campaign will show with the custom URL's I build. I'm aware that I can test this and I will but I'd like to get an idea from the community first to make things easier. Anybody have experience with this? Answers greatly appreciated! Thanks!
Paid Search Marketing | | EvansHunt0 -
Has anyone used Adroll (Facebook retargeting)with any success?
Hello! I am wondering if anyone out there has had a good experience with Adroll. I set up a campaign a couple months ago, but have yet to see any return on my investment. I'm now considering stopping this service because it seems to not be living up to its hype. What has your experience in using this service?
Paid Search Marketing | | Gordian0 -
Wordwatch Software: PPC Adwords campaign managers heard of, tried, or actively using this?
I've been trialing WordWatch for about a month. I'll admit I've been skeptical from the start. I don't quite understand the results they're delivering or how it works. So I did a search for "Wordwatch review" hoping someone out there could shed some light or help me decide whether this software was worth keeping. But all I can find are two suspicious and badly written posts, immediately raising red flags. (Penuguin should have eliminated crap sites using the Flesch-Kincaid reading level, but I digress.) **Wordwatch premise: **They take over keyword bidding to maximize budgets and clicks. They monitor the Adwords campaign to find an "optimal" bid price. Two questions about this premise: How is it different than using the Google settings for optimize for clicks or conversions? Since Google Adwords is based on a Vickery auction, wouldn't lowering my bid only lower my position? Bearing everyone has the same QS, then lowering my bids to the range between 2 positions does not increase my actual cost. I have Wordwatch enabled for a few of my campaigns. Their interface leaves a lot to be desired. They don't report the activity or the changes they make to the campaigns from the dashboard. I had to go into my Adwords Change History to track what they were doing. And lo and behold they're also adding long tail keywords to my ad groups. Bottom line I didn't notice any huge impact, and I don't see how it's better than Google's own version of campaign settings. I don't know that they're really legit. But their marketing was so convincing, and they raised $1.4M that I need other opinions. Any one with some pro/cons, or yay/nays?
Paid Search Marketing | | flowsimple0 -
Adwords search term report processing help
So I've downloaded my 6000 row adwords search term report, and want to analyses brand keywords and variants only....I could do this by brute force, but I'll want to do it again in a month or two. I have a nice regex string which will do the job but can't find a way to implement a solution. Is there a good way to do this? Or is there a better way? Adwords won't let me filter using regex, Excel needs vb setup to use regex and I've tried the regex in Libre Calc (doesn't return the correct results).
Paid Search Marketing | | k3nn3dy30 -
Recommended tools for PPC competitive intelligence?
Do you guys have any tools you recommend for spying on your PPC competition? Trying to figure out which competitive intelligence tool offers the most value. http://searchengineland.com/tips-for-spying-on-your-ppc-competitors-89988
Paid Search Marketing | | qlkasdjfw0