Weekly competitor scorecard for Facebook and Instagram

Every Monday at 9am, tell me how my social presence stacked up against my competitors last week, so I walk into the week planning meeting with an actual answer rather than a vague feeling.

Start by using Agorapulse Get Workspace Profiles to resolve my connected profiles. Work only with my Facebook Page and my Instagram business profile. Agorapulse competitor tracking supports those two profile types only, so skip any other network such as LinkedIn, X, TikTok or YouTube entirely rather than attempting a competitor lookup that cannot succeed.

Use a window covering the previous seven days ending yesterday: since is the Monday of last week and until is Sunday. Pass both as explicit plain dates on every report call, because the Agorapulse report operations require since and until and will not infer them. Do not ask for today's figures. Agorapulse synchronizes competitor data once daily, so yesterday is the freshest complete data available, and a same-day request returns an incomplete or empty picture.

For each of the two profiles, call Agorapulse Get Competitors to list the competitors tracked for that profile, then call Get Competitor Report for the same seven day window to pull their numbers. Then call Agorapulse Get Content Report for my own profile over the identical window, so my performance and theirs are measured across the same days and the comparison is like for like.

Post the result to Slack with Send a Message. Keep it short and opinionated, around 200 words at most. Lead with the single biggest change since last week in one sentence: the thing that actually moved, not a recap of every metric. Then rank us against each competitor on follower growth, posting volume and engagement. Explicitly flag where we are losing ground, and wherever a competitor is beating us, say what they posted that worked, naming the format, topic or cadence visible in their content. Close with one concrete recommendation for the coming week.

Then append the week's numbers to my Google Sheets tracking tab using Append Values, one row per competitor per week, plus one row for my own profile so the baseline sits alongside them. Use these columns: week start date, week end date, network, profile name, competitor name, follower count, follower growth, posts published, total engagement, and engagement per post. Always append, never overwrite existing rows, so the numbers build into a trend line over months rather than vanishing into chat history.

Handle the thin cases honestly. If a profile has no competitors tracked, say so in the Slack message instead of silently skipping it. If a report comes back empty for the window, call out the gap rather than reporting zeros as though they were real results.