Affiliate Marketing Tracking and Link Management Spreadsheet

Description

This 8-Sheet Google Sheets file contains a huge wealth of affiliate marketing tracking goodness and is the perfect complement to our Beyond Amazon Affiliate Challenge! With examples, information, links, and formulas already in the spreadsheet, you will know exactly how to use each sheet and have a headstart inputting your data and information into it!

Sheet #1: Log-In Information

On this sheet, you have the following columns:

• Affiliate Network/Partner
• Log-in URL
• Username
• Password
• Publisher ID
• Payout Threshold
• Payout Window
• W-9 Submitted
• Payment Info Submitted
• Last Updated Profile
• Referral Link to Program

Sheet #2: Individual Affiliate Program Information

This sheet is all about knowing what programs you belong to and what they have to offer you and where to get your links for them! It includes the following columns:

• Program/Product Name
• Network
• Commission Rates
• Bounties/Bonuses
• Excluded Categories
• Cookie Length
• Referral Link
• Pretty Link URL
• Deep Link Generator URL
• Permissions Required or Things Not Allowed
• Affiliate Manager Name
• Affiliate Manager Email
• If You’ve Reviewed the Product on Your Site/Video/Social
• Date of Last Social Share
• Date of Last Email Share
• Date of Last Blog Post Mention

Sheet #3 – Favorite Links

This sheet is so you can quickly and easily grab links to your favorite individual products from your favorite retailers, you know, for the products you just LOVE to talk about? This will allow you to skip going back to their websites and using deep-link generators every time you want to share about these favorites. This sheet contains the following columns:

• Product
• Network
• URL
• Short-Link

Sheet #4 – Monthly Earnings

Keep track of how much you are making from all your various affiliate networks and programs with this handy sheet! It will automatically calculate how much you’ve made so far this year, your average earnings, and your total affiliate earnings from all partners. It also contains a bonus section where you can input your earnings from ads, sponsored work, products you sell, and other business earnings so that you can calculate your total earnings each month as well as then see what percentage of your income comes from what revenue stream!! It’s really important to help you see the big picture of what source is bringing you the most income, what’s improving, what’s not, and to double-check that you are getting paid those earnings from your partners too.

Sheet #5 – Blog Editorial Calendar Planning

This sheet, and the following two sheets, will help you plan out your affiliate marketing strategy for the year, based on upcoming holidays, seasons, and occasions. This spreadsheet has the following columns:

• Upcoming Holidays/Season/Occasion/Event
• Date of Holiday/Season/Occasion
• Promotional Period for Occasion
• Affiliates to Promote for that Occasion
• Blog Post Ideas related to that occasion that would contain affiliate content
• Gift Guides for that Occasion
• Gift Guide Placement Information
• Promo Codes for Affiliates You Are Promoting
• Giveaway Information

Sheet #6 – Social Editorial Calendar Planning

Plan out specific social media affiliate shares using the following columns:

• Upcoming Holidays/Season/Occasion/Event
• Date of Holiday/Season/Occasion
• Promotional Period for Occasion
• Affiliates to Promote for that Occasion
• Facebook Ideas related to that occasion that would contain affiliate content
• Pinterest Ideas
• Instagram Feed Ideas
• Instagram Story Ideas
• Youtube/Video Ideas
• Promo Codes for Affiliates You Are Promoting
• Giveaway

Sheet #7 – Email Editorial Calendar Planning

Plan out specific email and newsletter affiliate mentions and promotions using the following columns:

• Upcoming Holidays/Season/Occasion/Event
• Date of Holiday/Season/Occasion
• Promotional Period for Occasion
• Affiliates to Promote for that Occasion
• Email Ideas related to that occasion that would contain affiliate content
• Dedicated Email Blast Ideas
• Promo Codes for Affiliates You Are Promoting

Sheet #8 – Checklist for Updating Posts for Affiliate Marketing

This last sheet is to help you keep track of blog posts you want or need to update affiliate links in or optimize for affiliate marketing. You can input old seasonal content and set dates to update them and make sure they are ready for the new season with working links and new affiliate strategies and tips. This sheet includes the following columns:

• Post Title
• Post URL
• Working Link Check
• Links Open in New Windows Check
• Links Are Coded Nofollow Check
• Shortcodes Added Check (to make affiliate link management and promo codes easier to manage)
• Additional Affiliate Ideas for that Content
• Date You Update the Post