How to Analyze a Competitor’s Twitter account with SocialBee & Google Data Studio (Free Template)

Let’s look at how to set up a Twitter Content Analysis Dashboard to monitor how a Twitter profile is performing online using the awesome beta feature in SocialBee – Export Tweets.

socialbee twitter dashboard screenshot

And yeah, I include the Google Data Studio templates for free, don’t worry.

If you’re lucky enough to be a SocialBee user, then you’ll be able to populate this dashboard right away and analyze your competitor’s Twitter performance, figure out what tools they are using and which of their strategies are working.

I came up with the idea for this dashboard when reverse engineering the Twitter strategy that And.Co uses to promote each one of their blog posts, but I’ll get more into that strategy next week.

Let’s get started.

The Resources you’ll need (they are also linked from their respective steps below because you should open them in order)
Copy this Data Source
Copy This Dashboard (Report)

Getting your competitors Twitter data from Social Bee

1. Log into your SocialBee Account

If you aren’t already using SocialBee, I highly recommend it. We’re going to use the Twitter account setup for SumoChamp for this demo.

2. Go to the Edge Tab > Export Tweets

socialbee export tweets feature

This is a beta feature in SocialBee, so If you don’t have the Edge tab, you’ll need to pop open the chat window and send a very friendly message asking for them to enable it for you.

For the truly lazy, here’s a template

Hey!

SocialBee is one of the best apps of all time! I heard there is an amazing beta feature called Export Tweets that I would absolutely love to be able to try out. Is there any chance someone on your beautiful team would be able to activate it for me?

Thanks!

3. Enter the Username of the account you’d like to analyzesocialbee export tweet username

If you don’t know the username, just search for it here

4. Select if you’d like to include Retweets and Replies in the file

Note: Since Twitter changed their rules recently Evergreen content is now posted as retweets, whereas it wasn’t in the past. Keep that in mind when looking at the data and deciding whether to include it in your export.

5. Hit the Generate CSV button

Now just wait for the email to arrive and download the attached CSV file

social bee twitter export email example

 

6. Open the Data Source I’ve created – SocialBee Export Twitter Data Source

 

7. Click Make a copy of the Data Source

How to Copy a Google Data Studio Data Source 

Click the copy button to make a version of the SocialBee Export Data Source in your own Google Data Studio Account.

If you haven’t used Google Data Studio before, you’ll be asked to jump through a few Onboarding steps first. I’ve noticed that sometimes after you’re finished the Data Studio onboarding, it takes you away from the page and also doesn’t copy the data source, even though you triggered the onboarding using the copy button. If that happens just follow the link again and click copy.

8. Edt the Data Source to include your CSV File from SocialBee

Once you’ve got a copy of the Data Source it should take you to the page that lists all of the Connector options. If it doesn’t take you there and you are still looking at the screen with all the fields, simply click the button to go to edit the fields.

Edit Connections in Google Data Studio

You can’t upload the CSV directly, so a workaround I’ve been using is to just import the CSV file into a fresh Google Sheets file and then use the Google Sheets connector inside of Data Studio.

Open a new Google Sheet File and rename it to something recognizable inside of Data Studio. I’m using Tweets – Appsumo – July 6 for mine.

Go to File > Import and select your CSV file.

Go back to your Data Studio account and Select the Google Sheets Connector.

Select the Google Sheets Connector in Data Studio

Select the sheet you just made and just make sure that the First Row Headers option is enabled and hit Reconnect

reconnect in google data studio socialbee

Note: The first time you connect the two you’ll have to grant access to GDS to access your Drive account.

Make sure it says “No fields changed due to configuration change”.

No fields changed due to configuration change Google Data Studio popup window

9. Open the Twitter Competitor Analysis Google Data Studio Template

 

10. Copy the dashboard

We’ll make a copy of the Twitter Dashboard the same way that we did with the Data Source. Simply click the copy icon at the top.

duplicate in Google Data Studio

11. Select the Data Source

Using the dropdown, select the Data Source you created earlier from the SocialBee Export.

Change Data Source of Dashboard in Data Studio

After you’ve selected the proper source, simply hit “Create Report and your new data will be displayed on the Dashboard.

And that’s it!  You’re all done! Now it’s time for you to analyze one of your competitors!

 

Was this dashboard helpful? Have some questions or ideas for a new template? Let me know in the comments.

Quickly see all past AppSumo deal data with our Free Extension!

FREE

Leave a Comment

Your email address will not be published. Required fields are marked *