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.
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.
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
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
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?
3. Enter the Username of the account you’d like to analyze
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
6. Open the Data Source I’ve created – SocialBee Export Twitter Data Source
7. Click Make a copy of the 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.
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 sheet you just made and just make sure that the First Row Headers option is enabled and hit Reconnect
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”.
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.
11. Select the Data Source
Using the dropdown, select the Data Source you created earlier from the SocialBee Export.
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!