Facebook Analytics Template for Agencies

[et_pb_section bb_built="1" _builder_version="3.0.47"][et_pb_row _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat" _i="0" _address="0.0"][et_pb_column type="4_4"][et_pb_text module_class="blog-font" _builder_version="3.0.80" background_layout="light" border_style="solid"]When it comes to weekly social media reporting, you need to give your clients a quick yet thorough rundown of how their channels are performing, without killing multiple hours to do it. Streamlining the communication process with your clients is key to providing a better client experience.So we asked our agency friends what metrics their clients want to see week-by-week, and created a Facebook analytics template for agencies using Google Spreadsheets.

Get The Facebook Analytics Template For Agencies Below

[/et_pb_text][et_pb_button button_url="https://docs.google.com/spreadsheets/d/19Ot9s2wVt-YO_aKHR_Hg3YM4N_hmmuW6YfYDUXsN1fM/edit?usp=sharing" url_new_window="on" button_text="Click Here to Access" button_alignment="center" _builder_version="3.0.72" /][et_pb_text module_class="blog-font" _builder_version="3.0.80" background_layout="light" border_style="solid"]

To copy the social media report to your own Google Drive, click the File menu and select "Make a Copy."

A Sample Report:

Instructions:

Just fill in your weekly post information, engagement and follower metrics, and voila! A clean looking report will be generated that makes the impact of your social media work easy to see.Filling out your report is as easy as apple pie. Here's how you do it:

Step 1: Post Reach and Engagement

Filling out the Content Metrics section acts as a table summary for your original content from the past week, and automatically calculates and fills in the reach and engagement section of your Client Report.

• Navigate to the Content Metrics tab.
• For all posts from your reporting week you wish to highlight, fill out the following:
• Date published
• Post summary
• Type (Organic / Boosted / Ad)
• Organic Reach
• Boosted Reach
• Reactions
• Comments
• Shares
• Post Clicks
• Please note: Total Reach and Total Engagement will automatically sum

Step 2: Account Growth

Filling out the Account Growth section will automatically generate a chart in the Client Report, allowing clients to quickly see how big their follower gain was on each day of the week.

• Navigate to the Account Growth tab.
• Replace the "Day X" headers with the dates from the week you are reporting on.
• For each day, record the number of followers below the headers.
• Please note: Weekly Total will automatically sum

Step 3: Top 5 Posts of the Week

This section of the Client Report is used to showcase the top 5 performing posts of the previous week to your client. This section must be filled in manually, but the fields can be copy and pasted from the Content Metrics section.You can correlate the performance of these posts with your Reach & Engagement numbers in the following section for notes.

Step 4: Content Game Plan

This section is for notes on the previous week's performance and next steps to be taken. This is a great place to highlight both successes and challenges, and ensure your client knows that you aware of any issues and have a plan to address them.We hope you find this Facebook analytics template for agencies helpful, and helps you better manage your time while managing the needs to your many clients. Feel free to drop us a line on our corner website chat box or tweet to us at @HeyOrca to provide us with feedback.[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row make_fullwidth="off" use_custom_width="off" width_unit="on" use_custom_gutter="off" allow_player_pause="off" parallax="off" parallax_method="off" make_equal="off" parallax_1="off" parallax_method_1="off" background_position="top_left" background_repeat="repeat" background_size="initial" global_module="7010"][et_pb_column type="4_4"][et_pb_text global_parent="7010" background_layout="light" text_orientation="center" use_border_color="off" border_color="#ffffff" border_style="solid"]

Curious to learn more about HeyOrca? Watch our 1-min Demo!

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row background_repeat_1="no-repeat" background_repeat_2="no-repeat" background_repeat_3="no-repeat" _builder_version="3.0.72"][et_pb_column type="1_3"][/et_pb_column][et_pb_column type="1_3"][et_pb_text _builder_version="3.0.72"]

Sharing is caring!

[Sassy_Social_Share][/et_pb_text][/et_pb_column][et_pb_column type="1_3"][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section bb_built="1" admin_label="section" transparent_background="off" parallax_method="off" custom_padding_tablet="50px|0|50px|0" custom_padding_last_edited="off|tablet" _builder_version="3.0.80" disabled="off" disabled_on="off|off|off" background_color="#ffffff" custom_margin="0px|||" custom_padding="0px|||" global_module="6738"][et_pb_row global_parent="6738" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.80" background_color="#f9f9f9" custom_margin="0px||0px|" custom_padding="0px||0px|" padding_top_1="0px" padding_bottom_1="0px"][et_pb_column type="4_4"][et_pb_cta global_parent="6738" title="Imagine social media approvals without spreadsheets" button_url="http://try.heyorca.com/request-a-demo/" url_new_window="off" button_text="Schedule a Demo" use_background_color="on" background_color="rgba(255,255,255,0)" background_layout="light" border_style="solid" custom_button="on" button_icon_placement="right" button_letter_spacing_hover="0" disabled="off" disabled_on="off|off|off" _builder_version="3.0.80" button_alignment="center" button_text_color="#ffffff" button_bg_color="#31c778" button_border_color="#31c778" button_text_color_hover="#ffffff" button_bg_color_hover="#00c65c" button_border_color_hover="#00c65c" custom_margin="0px|||" custom_padding="0px|||" button_use_icon="off"]

HeyOrca is a social media planner built for social media agencies. Our product centralizes content approval and client management in one place.

[/et_pb_cta][/et_pb_column][/et_pb_row][et_pb_row global_parent="6738" background_position="top_left" background_repeat="repeat" background_size="initial" _builder_version="3.0.80" disabled="on" disabled_on="on|on|on"][et_pb_column type="4_4"][et_pb_text admin_label="Newsletter Subscribe Stripe" global_parent="6738" background_layout="dark" text_orientation="center" border_style="solid" module_class="blog-font" _builder_version="3.0.80"]

Receive future social media and agency-related posts directly to your inbox.

[/et_pb_text][et_pb_code global_parent="6738" _builder_version="3.0.80"]<div id="hsformContainer2"><!-- [et_pb_line_break_holder] --><!--[if lte IE 8]><!-- [et_pb_line_break_holder] --><script charset="utf-8" type="text/javascript" src="//js.hsforms.net/forms/v2-legacy.js"></script><!-- [et_pb_line_break_holder] --><![endif]--><!-- [et_pb_line_break_holder] --><script charset="utf-8" type="text/javascript" src="//js.hsforms.net/forms/v2.js"></script><!-- [et_pb_line_break_holder] --><script><!-- [et_pb_line_break_holder] --> hbspt.forms.create({ <!-- [et_pb_line_break_holder] --> portalId: '596637',<!-- [et_pb_line_break_holder] --> target: '#hsformContainer2',<!-- [et_pb_line_break_holder] --> formId: '47463799-6377-48e8-b179-635f156dee3c'<!-- [et_pb_line_break_holder] --> });<!-- [et_pb_line_break_holder] --></script><!-- [et_pb_line_break_holder] --></div>[/et_pb_code][et_pb_cta global_parent="6738" title="The Ultimate Social Media Guide for Digital Agencies" button_url="https://try.heyorca.com/ultimate-social-media-guide/" url_new_window="on" button_text="Download now" use_background_color="on" background_color="rgba(255,255,255,0)" background_layout="dark" text_orientation="left" use_border_color="off" border_color="#ffffff" border_style="solid" custom_button="off" button_use_icon="default" button_icon_placement="right" button_on_hover="on" button_letter_spacing_hover="0" module_class="blog-font" disabled="on" disabled_on="on|on|on" _builder_version="3.0.80"]

"In Crossing the Chasm, Geoffrey Moore defines a market as a group of individuals who can reference each other. Put another way, for every market there is a social media community waiting to be born."

[/et_pb_cta][/et_pb_column][/et_pb_row][/et_pb_section]