Universal Event Tracking is Bing’s tracking script to track conversions and setup Remarketing on the Bing Ad Platform. The UET Tag can be deployed easily with GTM to track pageviews and interactions.
In this video, we’re going to show you how to install Bing’s UET tag on your website with the help of Google Tag Manager.
? Helpful Links
UET Tag Helper: https://chrome.google.com/webstore/detail/uet-tag-helper-by-bing-ad/naijndjklgmffmpembnkfbcjbognokbf
Bing Ads: https://secure.azure.bingads.microsoft.com/
Google Tag Manager: https://www.google.com/analytics/tag-manager/
Our GTM Playlist: https://goo.gl/MfGcRR
? More from Measureschool
GTM Resource Guide: https://old.measureschool.com/guide
Free GTM Beginner course: https://old.measureschool.com/emailcourse
?Looking to kick-start your data journey? Hire us: https://old.measureschool.com/services/
? Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books
? Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear
? FOLLOW US
– How can you get your Mail Chimp campaign data into a Google Sheet? Well, in this video we’re going to show you how to build an app script that connects to the Mail Chimp API and pulls the campaign information into Google Sheets so you can analyze and visualize it. All the more, coming up right after this. Hi there and welcome to another video of Measure School.com where we teach you the data driven way of digital marketing. My name is Julian and on this channel we do marketing tech reviews, how to videos, and tutorials, just like this one. So if you haven’t yet, consider subscribing. Now pulling all your data together so you can analyze it and visualize it in one tool is sometimes really hard to do.
Now as you might now, I’m a big fan of Google Sheets because it lives in the cloud and we can connect to different tools to pull the data in regularly. But unfortunately there’s not always a direct connection between the tools that you want to get the data from and pull them into your spreadsheet so you can analyze them. And this is where Appscript comes in.
– [Ben] Hi everyone. This is Ben from benlcollins.com. And today I’m going to show you how to bring your Mail Chimp data into a Google Sheets using their API. So open up a blank sheets and then rename it to Mail Chimp for this project. What I’m going to do is set up the headings in the Sheets, then we’ll open up the script editor and start writing the code and then we’ll jump into Mail Chimp to get the API key that I need and then come back to the Sheets to finish it all off. So that’s the strategy. In the interest of time, I’m just going to copy in these headings from another sheet that I’ve been working on. And I’ll just show you what they look like. I’m going to wrap the text there and center them all. So these are the details, the data that I want to get from the API. For example, when the campaign was sent, what the title was, the subject line, how many recipients, the clicks, the open rate, that sort of stuff, and then finally, actually we can calculate these two.
These are going to be calculations that we’re going to use then to create a chart showing the performance of all the campaigns over time. That’s the idea with this analysis. So let’s go and open up the Script Editor. So I go to Tools, to Script editor, that, that opens up. You can immediately just clear out the code that’s there. We don’t need that stuff. And again, let’s just rename this project Mail Chimp. And then I’m going to start by just creating the necessary API key and list ID that I need to then run all my code so let’s just for the moment put these in and then we’re going to actually retrieve them from Mail Chimp. So I need an API key and then a list ID as well.
We’re going to go into Mail Chimp now and get those two. So open up a new tab, open up Mail Chimp, log in. And then Choose a profile, and under extras here is this tab called, “API Keys.” And then you come down here to create a key, click that, it’s going to create a new key for you and it will be this new one at the top here. So let’s just click that one and rename it to be “mailchimpsheets” or some other name and then its ready use.
What we’re going to do is copy that key there and insert that in between these two little hyphens here which gives me my API key as a text string ready to use in my application here. Now it’s really important that you don’t actually give this out to anyone which is why it’s blurred on my screen right now, you won’t be able to see that one.
Because anyone that has that API key can write a little bit of code then to actually infiltrate your email list and delete subscribers or add subscribers or send out spam campaigns. So it’s really important that only you have access and only you see this API key, so don’t share that around. It’s perfectly okay to have it here in your code but don’t save this code, for example, onto the web without removing your API key first. Now the other thing we need is this List ID so let’s go back to Mail Chimp. Let’s go to the menu here to Lists. Navigate to your list and then click on your list here, open the list up and under settings, you’ll see this one List name and defaults, just click that.
And then here under List ID, you’ll see the List ID here. This one here. So, we’re going to need that number as well but that’s just very easy to get under Lists, Settings. And I’m just going to add that in there and that’s me ready to go now with the two pieces of code I need to make this function run, or this application run. So what I’m going to do now is actually create a function.
We’re going to create one function initially that just retrieves some data from the API and I’m going to take a look at it and see what I get back and then from there we can start to actually build out the analysis that we want to do. What I’m going to do is just actually move to the compact controls here so we get a bit more space. And I’m just going to copy in some code there so you’ll see just under the List ID, I’ve copied in this code, just some comments to start with. Then a function called Mailchimp Campaign where I specify the root of the API and then the end points of the API that I want to access.
And then this is the really important one here, the parameters I need. The important one is this API key here. You can see this. What this does is when we request the data from Mail Chimp, we pass it the API key we specified up here at the top and that’s what allows Mail Chimp, that’s what lets Mail Chimp know that we’re a legitimate application and we’re okay to receive some data from them.
Let’s just put this in. So what this is going to do is call the API, and then just pass the data that’s returned and then we’ll be able to display the output here in this Logger function. So let’s just close that function off. Hit save, and then what we’re going to do now is run this function called mailchimpCampaign and it’s going to ask us for permission first because it hasn’t done this before so it needs to access our data. Let’s see review, and it wants to connect to an external service, that’s fine, we’ll click on Allow. We come up to View the Logs, we should see some stuff in there so let’s click that. And there we go, we can actually now see this is what the Mail Chimp API is returned to us. It’s obviously a lot of data, it’s kind of difficult to read in this format but you can see if we look in a little bit of detail there’s things like, there for example, send_time.
As a next step, let’s just go ahead and get a little bit of the campaign data that we actually want and just, again, we’ll just log it. I’m just going to say find out how many campaigns I have. And then, also, I’m going to extract all the subject lines from those campaigns and display them. So let’s run it. Let’s view logs again. And there we go. This time 27 campaigns. And you can see the subject lines of the different campaigns I’ve run so it looks like that’s great. It’s working now. It’s now pulling out specific pieces of data that we want and that’s exactly the sort of data we’re going to now put into the Google Sheet here. So what I want to do is just put the word tripe here and all of this stuff here, I’m just going to tab in which will just move, indents it.
And then we’re going to do a catch and this catch is the real way we should be making sure that we catch any errors, we try this and if we fail at some p