Does anyone have a good tool (spreadsheet you’ve developed or app) for capturing the success of social media advertising campaigns across Google AdWords, Facebook Advertising, etc. all in one place that you would be willing to share? I’m looking for something that will make it easy for the C-suite to see the ROI over time.
Also, what do you find useful to use for an editorial calendar besides Excel? We’re looking for something that our team can access and that will show recurring events that happen every year that we need to plan for and also one-off events.
Jessica L. Atcheson
Marketing and Communications Manager
Pronouns: she, her, hers*
Boston Area Rape Crisis Center
617-649-1288 | firstname.lastname@example.org
www.barcc.org | Facebook | Twitter | Instagram
BARCC: Dedicated to healing. Advocating for change.
*Unsure what this means? Feel free to ask me!
Statement of Confidentiality: Privacy is very important to the Boston Area Rape Crisis Center, and we will make every effort to ensure that confidential information is secure. Unfortunately, electronic communications can never be fully protected. Whenever possible, please refrain from including confidential information in your e-mail correspondence with us.
If you are not the intended recipient of this e-mail, be advised that this message is intended only for the person(s) named above and may contain confidential or privileged information. Any disclosure, copying, dissemination, or taking of any action in reliance upon the information in this e-mail is strictly prohibited. If you have received this e-mail in error, please contact the sender and destroy this message and any attachments.
I can offer three dashboard tools that you can take a quick look at --
Kissmetrics (enterprise level solution starting at $200 / mo), Cyfe (starts at $19 / mo), and Google Analytics (free). Google Analytics is super comprehensive, but it does takes some skill to be able to configure the reporting.
I took a look at your website, and it appears that you're using WordPress for your CMS. There are a few great editorial calendar plugins that WordPress users like:
Editorial Calendar -- A free plugin intended mostly to allow you to see your posts and their status in calendar view. This plugin hasn't been updated in several months, but it is compatible with the must current version of WordPress.
Nelio Content -- A freemium plugin that allows you to see your posts and their status in calendar view. Nelio Content also allows you to plan the promotion of your blog posts via social media; additionally, it has a content analysis function that's pretty useful, and it includes some post analytics. Plans start at $19 a month ($9 a month if paid annually).
Coschedule -- A premium plugin that allows you to see your posts and their status in calendar view. Coschedule also allows you to plan the promotion of your blog posts via social media; additionally, Coschedule has post analytics, custom workflows and more. Plans start at $30 a month.
Hope that helps!
Thanks so much to both of you. I can't wait to explore these options.
I didn't know about Nellio Content as a WP plug-in and am really interested in looking into it. Thanks!
I second the suggestion of looking into co-schedule. It's a great tool for all those reasons, plus a robust dashboard and easily allows multiple-team use.
As a person who loves her spreadsheets, especially metrics ones, I haven't developed any that really capture or overlay promoted content with organic, nor integrated paid advertising with visits/actions. I'd love to see something like that if others have an all-in-one dashboard. I usually keep these things in separate dashboards, which can become very unwieldy. I have a client that has an ad agency run all advertising for them and they find a lot of use of one overall report of all paid ads for the month and then compare paid ads with paid ads but not organic with paid. That seems to make a lot of sense to me.
Senior Communications Analyst
National Resident Matching Program®
2121 K Street NW, Suite 1000, Washington, DC 20037
Phone: 202-499-5987 Email: email@example.com