Google Data Studio is a powerful tool that allows marketers to create beautiful dashboards using data from different sources such as Google Analytics or Salesforce. The problem is that it requires some technical knowledge to get started. If you don’t have time to master these tools, you might want to consider another option.
Mailchimp itself a marketing automation service that helps businesses send emails to their customers. It has over 20 million subscribers worldwide and offers features such as email templates, autoresponders, analytics, etc.
You can now integrate Google Data Studio directly into your Mailchimp account. This way, you will be able to access all the features offered by both services simultaneously.
Sign up to Supermetrics for Data Studio
Supermetrics is an easy tool to use to analyze data about your customers. This will allow you to view data about your customer base. You can see how many visits each page gets, the bounce rate, the average length of time spent on the site, and much more.
You can also look at the keywords used to reach the site. For example, you might want to know which keywords bring people to your homepage and which ones lead them to your blog.
Once you have signed up, you can access the dashboard. From there, you can select “Data Studio.”
Here, you can add new columns and charts. You can also download CSV files of your data.
Now it’s time to start analyzing your data. Click on the “Keywords” tab. Here, you can sort the keywords based on popularity, volume, etc.
You can filter by that column if you’re looking for specific information, like how long visitors spend on your site.
Create a new Data Studio report and choose MailChimp as your Data Source
1. Select “Create New Report.”
2. Click “New Report” and enter a name and description.
3. Under “Choose Your Data Source,” select “Mail Chimp.”
4. You’ll see a list of different types of reports. If you want to send emails based on events, like mailing lists, etc., you’ll need to use a “Segment” report.
5. After selecting “Segment” under “Report Type,” you’ll be able to add segments to your report. For example, you could segment people based on their gender, age group, location, etc.
6. Once you’ve added your segments, you can create your email template.
7. To do this, click on the “+” icon next to “Email Template.”
Allow Data Studio and Supemetrics to connect
In Step 2: Create a New Connection, you selected Excel Online as the connection type. In Step 3: Allow Data Studio to Connect to Excel Online, you will see the following error message. This occurs because you do not allow Data Studio access to your Excel Online account. You must add Data Studio to your list of allowed apps in Microsoft 365. To do this, follow these steps:
1. Log into your Microsoft 365 admin portal.
2. 3. Enter “Data Studio” in the Name field.
4. Check the box next to “Allow this app.”
5. Click OK.
6. On the left side menu bar, select Users.
Allow Data Studio to connect to MailChimp
To allow Data Studio to connect to your MailChimp account, follow these steps:
1. Log into the MailChimp website.
2. 3. Add Data Studio as one of your applications.
4. Click Save Changes.
5. When you go back to Data Studio, you should see a green check mark next to MailChimp.
Step 5: Start Analyzing!
After connecting both tools, you are ready to begin analyzing your data. Let’s look at some things you can learn from your data.
Connect Supermetrics to your MailChimp account
Go through these steps to connect your Supermetrics account to your mail chimp accounts. This allows us to sync data across our different platforms.
You will need to enter your email address, username, and password into the login box. If you are logged into your mail chimp already, please use the same credentials.
Click OK to continue.
You should now see your Supermetrics dashboard.
Choose the Parameters of your MailChimp data
MailChimp is one of the most popular email marketing platforms out there. But it doesn’t come without a few quirks. You’ll need to choose from many parameters when setting up your account. Let’s look at what each parameter does and how you can use it to improve your campaign.
Connect your MailChimp data to your report.
If you want to use MailChimp data to filter your Google Analytics reports, it helps to know how to do so.
This process allows you to filter out the specific information you need from your MailChimp data set. You can export this filtered data into another spreadsheet or database, such as Excel or SQL Server.
First, open up Google Data Studio. Make sure that you are selecting “Mailchimp” under the “Data Source Type” and then “Connecting to MailChimp” under the “Connect Method.”
Next, enter your MailChimp API key and secret. Enter your credentials here.
You will now see a list of columns you can filter out of your MailChimp data. Choose what you want to keep, and click “Add Column.” Repeat this process for each column you wish to include in your analysis.
Once you’ve finished adding columns, go ahead and save your dataset. Now, you are ready to start filtering your data.
In Google Data Studio, select your newly created dataset. Click on the cog icon next to “Column Filters.” You can add filters to your data based on the above-collected columns. For example, you might want to exclude specific dates or countries from your analysis.
Add your MailChimp data to your Data Studio report.
You’ve just finished building your first Data Studio report. You’re excited about how it looks and what you learned while creating it. But now what? How do you make sure you don’t lose all that hard work? Here are some tips to ensure you never forget where you put your data.
1. Keep Your Reports Organized
If you want to keep track of all the reports you build, organize them into folders. This makes it easy to find specific reports later on. Using Gmail, you can even label your folder “Data Studio.”
2. Use Tags
Tags are keywords that help you quickly identify your reports. For example, if you tag your report “Sales,” you’ll know exactly what type of report you’re looking for when you go to view it again.
3. Label Your Dimensions
Dimensions are the boxes that hold your metrics. They show up in every chart you build in Data Studio. To make things easier to remember, label each dimension box like “Product Name” or “Monthly Sales.”
Create your Google Data Studio report!
Google Data Studio makes it simple to build interactive dashboards and data visualizations. In this step-by-step tutorial, you’ll learn how to use the Google Data Studio Report builder to create your custom dashboard.
You’ll start by creating a simple chart that displays monthly sales figures. Then, you’ll move on to building a table that lists out each store’s names and the total number of products sold there. Finally, you’ll combine both of those elements into one beautiful dashboard.
I love Google Data Studio and this site is all about sharing tips and trick and help users get the most of out Google’s free data visualization tool