This is how we avoid the request limit that breaks the Bit.ly API with larger spreadsheets. Column J will show FALSE until you delete the contents of column L which then triggers the API call to Bit.ly. Columns C-G allow you to add the details about the campaign, similar to the way Google’s UTM builder lets you create URLs, and of course the destination URL you want traffic to go to goes in column H.Make a note in the description and date column to help you remember some details about the URL for your records. Note that this requires that you have a Bit.ly account – but you probably already know that if you’re reading this… We have Whole Whale’s open token there as a placeholder to show it works. Here is where we got the Bit.ly code for this spreadsheet and here is where you can find you Bit.ly access code. Add your Bit.ly API in the AdminBitly sheet. Ok, so it isn’t the easiest thing in the world but it is SOOOO worth it once you see how much time it will save you from creating a URL, saving it, then going to Bit.ly and shortening it. First, how to use the UTM builder spreadsheet Since we think that secrets secret are no fun, we’ve shared the spreadsheet and tips for successful campaign URL creation. So we hacked a solution in our Google Spreadsheet for one of our clients, that allowed them to quickly create campaign URLs and then shorten them with your Bit.ly API without running into the limit. We contacted their team and they said you can’t have over X # of requests per session through the API – basically saying ‘stop that because we’re not fixing it’. After creating hundreds of campaign URLs with different UTM builders and spreadsheets we had a huge issue with Bit.ly’s API that broke when we tried to shorten too many URLs in the same spreadsheet. Learn more about AdRoll’s Cross-channel Performance Dashboard and how it’s different from Google Analytics.They said it couldn’t be done, a spreadsheet that quickly creates campaign URLs for Google Analytics UTM tracking AND shortens them with Bit.ly (Note-we aren’t really sure who ‘they’ are, or frankly if they really said this). Specifically designed for marketers to track cross-channel activities and optimize their marketing campaigns, the AdRoll Cross-channel Performance Dashboard automatically reconciles your conversion data across channels and provides optimization recommendations. The Cross-channel Performance Dashboard is offered as a complementary tool, included in our Marketing & Ads Plus plan. AdRoll’s Cross-channel Performance Dashboard fully utilizes the UTM tagging standard from the UTM Link Builder, giving you a clear and holistic view of your online marketing activities and their impacts to your conversion and revenue metrics. You also need a good analytics tool to monitor all your website traffic and conversions. With dynamic macro support, it greatly reduces the number of URLs you need to manage, saving you time and making UTM tracking less error prone. AdRoll’s UTM Link Builder helps you standardize your UTM parameters for each marketing channel. UTM tracking is effective and accurate only if you follow certain UTM best practices. How do you use UTM parameters to track and optimize campaign performance? Combining these UTM based metrics and advertising KPIs, such as CPC (cost-per-click) and CPM (cost-per-thousand-impressions), you have a more holistic view into your campaign performance. UTM based tracking allows you to develop campaign analytics metrics based on visitor behavior on your website. For example, if you’re running a “Fall Sale” promotion, all the links of this campaign would use a tag like, “FallSalePromo.”īy adding these UTM parameters to your landing page URLs, you can monitor traffic driven by various campaigns to your website, as well as measuring the engagement and conversion from those traffic sources. Campaign (utm_campaign): The campaign refers to a particular promotion.Content (utm_content): If you have multiple links in the same campaign, the “content” field helps you distinguish the versions of the ad you’re running.Term (utm_term): The term identifies the keywords you’ve paid for in a pay-per-click (PPC) ad.Medium (utm_medium): The medium informs you of the channel name your tracked link is featured in, such as email or social media.Source (utm_source): The source tells you which website is sending you traffic.They are query parameters appended to the end of your campaign landing page URLs in order to track campaign performance. UTM (Urchin Tracking Module) parameters, which are also known as UTM tags or UTM codes, were originally created by Urchin Software Corporation.
0 Comments
Leave a Reply. |