Category Archives: Facebook

Page Posts – Dates

posts-datesThis Analytics Edge wizard lets you select the date range to be used for the query.

You can pick from several preset values, or pick a combination of start date, duration and/or end date.

Note that some metrics are not available for several days.

For the dates, you can select a specific calendar date, pick from one of several dynamic dates like ‘start of last month’, or enter a date value.

When entering a date manually, you can type in the date, use an Analytics Edge range name (like [Date]), or enter a cell reference to a worksheet containing a date.

Finally, you can select to use the date range chosen, or use the same duration period previous to the chosen date range, or use the same period from the previous year.

Page Posts – Pages

posts-pagesThis Analytics Edge wizard allows you to select a Facebook account and page, and get back details about the posts on that page.

You can choose the account and page, or link to a worksheet cell for the account name and/or Facebook Page ID (the number portion displayed in the selector).

URL Shares

urlsharesThis Analytics Edge wizard is used to get the Facebook share metrics for any URL or list of URLs.

Single URL

Select a valid account to use (any account is ok), and enter the full URL that you want metrics for.

List of URLs

Enter * (an asterisk) for the URL to read a list of URLs from a worksheet. With the Analytics Edge Basic Add-in, the list will be obtained from the first column of the worksheet that the query is on. With the Analytics Edge Core Add-in, the list will be obtained from the first column of a worksheet with the same name as the macro that the query is in.

urlshares-output

The Metrics

The numbers that appear in the Facebook Like and Share buttons are shown as the Facebook Share Count.  The number is usually the same as the Facebook Engagement Count, which is a total of shares and likes. If you want just the Likes, use the Facebook Engagement Like Count number. Total comments are shown in the Facebook Engagement Comment Count metric, but that includes private and deleted comments; the public comment count is shown as Facebook Share Comments.

The old Facebook share and like metrics delivered by the old API (which was shut down Aug 7, 2016) may have been different, and Facebook has implied that they were less accurate. if you simply want a number for Likes, Comments and Shares, then use:

Likes = Facebook Engagement Like Count
Comments = Facebook Share Comments
Shares = Facebook Engagement Count – Facebook Engagement Like Count

Facebook Insights Weekly Report

Basic Add-in, Facebook Connector
facebook-weekly-reportSee the latest week’s performance of your Facebook page with this free Excel report from Analytics Edge.

Using the Basic Add-in and Facebook connector, one simple refresh shows this week’s Likes, Reach and Engagement compared to the previous week, plus 12-week trend charts showing the types of posts you made and the user response.

Analytics Edge can deliver the custom Facebook Insights reporting the way you need it.

Download the workbook: Facebook-weekly-report-1-0.xlsx

 

Misunderstood Metrics: Facebook Insights

fb-misunderstood-metricsIt can be confusing to download your data from Facebook Insights and try to recreate some of the online reports, only to discover the metric names don’t match. The online Facebook reports use terminology that changes over time (remember People Talking About This?), and do not always have an equivalent downloadable metric. This makes it difficult to recreate those reports in Excel. This article, and the companion Excel workbook, shows which downloaded metrics are behind those online numbers.

Continue reading

Post Insights – Pages

fb-post-insights-pagesUse this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query.

You have the option of selecting from the drop-down lists or identifying  a worksheet cell that contains the information. Note that Pages are identified only by their ID number.

Post Insights – Fields

fb-page-insights-fieldsThis Analytics Edge wizard lets you select the Facebook Post Insights metrics you want.

Multiple unsegmented metrics can be selected at once, and they will be shown side-by-side in the report, listed by date.

Segmented metrics must be individually selected since they create a table of values by date.

All post metrics are only available as lifetime totals to date.

Post Insights – Dates

fb-post-instghts-datesThis Analytics Edge wizard lets you pick the date range for your Facebook Post Insights query. All posts created in this date range will be included in the results.

You can pick from several preset values, or pick a combination of start date, duration and/or end date.

For the dates, you can select a specific calendar date, pick from one of several dynamic dates like ‘start of last month’, or enter a date value.

When entering a date manually, you can type in the date, use an Analytics Edge range name (like [Date]), or enter a cell reference to a worksheet containing a date.

Finally, you can select to use the date range chosen, or use the same duration period previous to the chosen date range, or use the same period from the previous year.

Accounts

accountsUse this wizard to log in to your Facebook account and authorize Analytics Edge to access your data.

Enter a name for the account you want to login with, then click the Add Account button. Multiple accounts can be stored, and you can change which account gets used by default by selecting it and clicking the Make Default button.

 

Insights – Dates

datesThis Analytics Edge wizard lets you pick the date range for your Facebook Insights query.

You can pick from several preset values, or pick a combination of start date, duration and/or end date.

Note that some metrics are not available for several days, so there is a preset for 4_DAYS_AGO and an end date option for 4 Days Ago, which should get you the most recent values.

For the dates, you can select a specific calendar date, pick from one of several dynamic dates like ‘start of last month’, or enter a date value.

When entering a date manually, you can type in the date, use an Analytics Edge range name (like [Date]), or enter a cell reference to a worksheet containing a date.

Finally, you can select to use the date range chosen, or use the same duration period previous to the chosen date range, or use the same period from the previous year.

Insights – Fields

fieldsThis Analytics Edge wizard lets you select the Facebook Insights metrics you want.

Multiple Totals metrics can be selected at one, and they will be shown side-by-side in the report, listed by date.

Segmented metrics must be individually selected since they create a table of values by date.

There are daily totals (day period) available, as well as running 7-day totals (week period) and running 28-day totals (days_28 period). Some metrics are only available as lifetime totals. Selecting a period of all will get you all available periods for the metrics selected.

Insights – Pages

pagesUse this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query.

You have the option of selecting from the drop-down lists or identifying  a worksheet cell that contains the information. Note that Pages are identified only by their ID number.

* Facebook Help

The Facebook Connector for Analytics Edge makes it possible to automate your Facebook Insights downloads into Microsoft Excel. Get just the metrics you want, formatted for use in Excel.

facebook-connnector

Before you can use the connector, you MUST log in to a valid Facebook account (with the Accounts wizard) and have read_insights access for at least one Facebook Page.