Spreadsheet: 687068d1594936295-month-by-month-nested-sumifs-and-averageifs-formulas-stopped-working-content-calendar-help
Sheet: Analytics

 | APRIL 2020 |  |  |  |  |  |  | MAY 2020 |  |  |  |  |  |  |  |  |  |  | JUNE 2020 |  |  |  |  |  |  |  |  |  |  | JULY 2020 |  |  |  |  |  |  |  |  |  |  | AUGUST 2020 |  |  |  |  |  |  |  | SEPTEMBER 2020 | OCTOBER 2020 | NOVEMBER 2020 | DECEMBER 2020
OVERALL SENTIMENT | Facebook | Facebook | Facebook sentiment drivers based on inbound messages | Twitter | Twitter | Instagram | Instagram | OVERALL SENTIMENT | Facebook | Facebook | Facebook April vs. May % Change in sentiment | Twitter | Twitter | Twitter April vs. May % Change in sentiment | Instagram | Instagram | April vs. May % Change in sentiment |  | OVERALL SENTIMENT | Facebook | Twitter | Instagram |  |  |  |  |  |  |  | OVERALL SENTIMENT | Facebook | Facebook | Twitter | Twitter | Instagram | Instagram |  |  |  |  | OVERALL SENTIMENT | Facebook | Facebook | Twitter | Twitter | Instagram | Instagram
NEUTRAL |  |  |  |  |  |  |  | NEUTRAL |  |  |  |  |  |  |  |  |  |  | NEUTRAL |  |  |  |  |  |  |  |  |  |  | NEUTRAL |  |  |  |  |  |  |  |  |  |  | NEUTRAL
POSITIVE |  |  |  |  |  |  |  | POSITIVE |  |  |  |  |  |  |  |  |  |  | POSITIVE |  |  |  |  |  |  |  |  |  |  | POSITIVE |  |  |  |  |  |  |  |  |  |  | POSITIVE
NEGATIVE |  |  |  |  |  |  |  | NEGATIVE |  |  |  |  |  |  |  |  |  |  | NEGATIVE |  |  |  |  |  |  |  |  |  |  | NEGATIVE |  |  |  |  |  |  |  |  |  |  | NEGATIVE
FACEBOOK | Organic Total | Organic Average | Boosted Total | Boosted Average | Outliers/Comments for April |  |  | FACEBOOK | Organic Total | Organic Average | Boosted Total | Boosted Average | Outliers/Comments for May | APRIL vs MAY % CHANGE |  |  |  |  | FACEBOOK | Organic Total | Organic Average | Boosted Total | Boosted Average | Outliers/Comments for April | MAY vs JUNE % CHANGE |  |  |  |  | FACEBOOK | Organic Total | Organic Average | Boosted Total | Boosted Average | Outliers/Comments for July | JULY vs JUNE % CHANGE |  |  |  |  | FACEBOOK | Organic Total | Organic Average | Boosted Total | Boosted Average | Outliers/Comments for April | AUGUST vs JULY % CHANGE
ENGAGEMENT |  |  |  |  | [NAME] video was an outlier |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT
REACH |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH
IMPRESSIONS |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS
LIKES |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES
COMMENTS |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS
SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST
LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS
VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS
$ SPENT ON BOOSTS |  |  |  |  |  |  |  | $ SPENT ON BOOSTS |  |  |  |  |  |  |  |  |  |  | $ SPENT ON BOOSTS |  |  |  |  |  |  |  |  |  |  | $ SPENT ON BOOSTS |  |  |  |  |  |  |  |  |  |  | $ SPENT ON BOOSTS
END OF MONTH FANS | 41082 |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS
NET GAINED FANS |  |  |  |  |  |  |  | NET GAINED FANS |  |  |  |  |  |  |  |  |  |  | NET GAINED FANS |  |  |  |  |  |  |  |  |  |  | NET GAINED FANS |  |  |  |  |  |  |  |  |  |  | NET GAINED FANS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL vs MAY % CHANGE |  |  |  |  |  |  |  |  |  |  | MAY vs JUNE % CHANGE |  |  |  |  |  |  |  |  |  |  | JULY vs JUNE % CHANGE |  |  |  |  |  |  |  |  |  |  | AUGUST vs JULY % CHANGE
TWITTER | Total | Average |  |  |  |  |  | TWITTER | Total | Average |  |  |  |  |  |  |  |  | TWITTER | Total | Average |  |  |  |  |  |  |  |  | TWITTER | Total | Average |  |  |  |  |  |  |  |  | TWITTER | Total | Average
ENGAGEMENT |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT
REACH |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH
IMPRESSIONS |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS
LIKES |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES
COMMENTS |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS
SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST
LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | LINK AND WEBSITE CLICKS
TWITTER # OF CLICKS ON MEDIA (VIDEOS, GIFS, IMAGES) |  |  |  |  |  |  |  | TWITTER # OF CLICKS ON MEDIA (VIDEOS, GIFS, IMAGES) |  |  |  |  |  |  |  |  |  |  | TWITTER # OF CLICKS ON MEDIA (VIDEOS, GIFS, IMAGES) |  |  |  |  |  |  |  |  |  |  | TWITTER # OF CLICKS ON MEDIA (VIDEOS, GIFS, IMAGES) |  |  |  |  |  |  |  |  |  |  | TWITTER # OF CLICKS ON MEDIA (VIDEOS, GIFS, IMAGES)
PROFILE CLICKS |  |  |  |  |  |  |  | PROFILE CLICKS |  |  |  |  |  |  |  |  |  |  | PROFILE CLICKS |  |  |  |  |  |  |  |  |  |  | PROFILE CLICKS |  |  |  |  |  |  |  |  |  |  | PROFILE CLICKS
VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS
END OF MONTH FANS | 14884 |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS
NET GAINED FANS | 67 |  |  |  |  |  |  | NET GAINED FANS |  |  |  |  |  |  |  |  |  |  | NET GAINED FANS |  |  |  |  |  |  |  |  |  |  | NET GAINED FANS |  |  |  |  |  |  |  |  |  |  | NET GAINED FANS
INSTAGRAM | Total | Average |  |  |  |  |  | INSTAGRAM | Total | Average |  |  |  |  |  |  |  |  | INSTAGRAM | Total | Average |  |  |  |  |  |  |  |  | INSTAGRAM | Total | Average |  |  |  |  |  |  |  |  | INSTAGRAM | Total | Average
ENGAGEMENT |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT
REACH |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH
IMPRESSIONS |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS
LIKES |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES
COMMENTS |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS
SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST
WEBSITE CLICKS |  |  |  |  |  |  |  | WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | WEBSITE CLICKS |  |  |  |  |  |  |  |  |  |  | WEBSITE CLICKS
PROFILE CLICKS |  |  |  |  |  |  |  | PROFILE CLICKS |  |  |  |  |  |  |  |  |  |  | PROFILE CLICKS |  |  |  |  |  |  |  |  |  |  | PROFILE CLICKS |  |  |  |  |  |  |  |  |  |  | PROFILE CLICKS
FOLLOWS |  |  |  |  |  |  |  | FOLLOWS |  |  |  |  |  |  |  |  |  |  | FOLLOWS |  |  |  |  |  |  |  |  |  |  | FOLLOWS |  |  |  |  |  |  |  |  |  |  | FOLLOWS
INSTAGRAM SAVES |  |  |  |  |  |  |  | INSTAGRAM SAVES |  |  |  |  |  |  |  |  |  |  | INSTAGRAM SAVES |  |  |  |  |  |  |  |  |  |  | INSTAGRAM SAVES |  |  |  |  |  |  |  |  |  |  | INSTAGRAM SAVES
END OF MONTH FANS | 2482 |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FANS
NET GAINED FOLLOWERS | 17 |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS
LINKEDIN | Total | Average |  |  |  |  |  | LINKEDIN | Total | Average |  |  |  |  |  |  |  |  | LINKEDIN | Total | Average |  |  |  |  |  |  |  |  | LINKEDIN | Total | Average |  |  |  |  |  |  |  |  | LINKEDIN | Total | Average
ENGAGEMENT |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT
REACH |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH
IMPRESSIONS |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS
LIKES |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES
COMMENTS |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS
SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST
CLICKS |  |  |  |  |  |  |  | CLICKS |  |  |  |  |  |  |  |  |  |  | CLICKS |  |  |  |  |  |  |  |  |  |  | CLICKS |  |  |  |  |  |  |  |  |  |  | CLICKS
VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS
END OF MONTH FOLLOWERS | 1776 |  |  |  |  |  |  | END OF MONTH FOLLOWERS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FOLLOWERS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FOLLOWERS |  |  |  |  |  |  |  |  |  |  | END OF MONTH FOLLOWERS
NET GAINED FOLLOWERS | 35 |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS
YOUTUBE | Total | Average |  |  |  |  |  | YOUTUBE | Total | Average |  |  |  |  |  |  |  |  | YOUTUBE | Total | Average |  |  |  |  |  |  |  |  | YOUTUBE | Total | Average |  |  |  |  |  |  |  |  | YOUTUBE | Total | Average
ENGAGEMENT |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT |  |  |  |  |  |  |  |  |  |  | ENGAGEMENT
REACH |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH |  |  |  |  |  |  |  |  |  |  | REACH
IMPRESSIONS |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS |  |  |  |  |  |  |  |  |  |  | IMPRESSIONS
LIKES |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES |  |  |  |  |  |  |  |  |  |  | LIKES
COMMENTS |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS |  |  |  |  |  |  |  |  |  |  | COMMENTS
SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST |  |  |  |  |  |  |  |  |  |  | SHARES/RETWEETS/Dmed POST
CLICKS |  |  |  |  |  |  |  | CLICKS |  |  |  |  |  |  |  |  |  |  | CLICKS |  |  |  |  |  |  |  |  |  |  | CLICKS |  |  |  |  |  |  |  |  |  |  | CLICKS
VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS |  |  |  |  |  |  |  |  |  |  | VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS
SUBSCRIBERS | 360 |  |  |  |  |  |  | SUBSCRIBERS |  |  |  |  |  |  |  |  |  |  | SUBSCRIBERS |  |  |  |  |  |  |  |  |  |  | SUBSCRIBERS |  |  |  |  |  |  |  |  |  |  | SUBSCRIBERS
NET GAINED FOLLOWERS | 17 |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS |  |  |  |  |  |  |  |  |  |  | NET GAINED FOLLOWERS