1 / 15

Affiliate Marketing Dashboard Template

Use this multi-sheet Excel template to evaluate the success of each of your affiliate marketing promotions.<br><br>Includes dynamic calculations, cross-tab linking and expert tips from Affiliate Marketing experts to the right of each tab in Excel template.

Download Presentation

Affiliate Marketing Dashboard Template

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Affiliate Marketing Dashboard Spreadsheet - Summary Affiliate Marketing System Tracking Dashboard (Summary) Affiliate Marketing System Tracking Dashboard (Summary) Product/Program Product/Program My Main Link My Main Link Commission % Commission % Conversion % Conversion % Total This Year Total This Year Instructions: Instructions: This sheet is a quick look at your affiliate promotion totals. No need to edit any of this information; it's pulled in from the other sheets. A cell with #DIV/0! does not have data to calculate yet. LeadPages (example) 30% 30% 30% 30% 30% 30% 30% 10.6% $4,670.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 http://link.leadpages.net/aff_c?offer_id=6&aff_id=438 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1

  2. Affiliate Marketing Dashboard Spreadsheet - LeadPages (Example) LeadPages (example) LeadPages (example) LeadPages.net Joey Barker Brandon Lytle, Kevin Raheja partnerships@ave81.com affiliates.leadpages.net example@example.com P@ssW0rd http://link.leadpages.net/aff_c?offer_id=6&aff_id http://link.leadpages.net/aff_c?offer_id=6&aff_id http://mylpdemo.com/lp http://mylpdemo.com/lp Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $4,670.00 Free Referrals 15 22 4 23 15 67 43 21 7 12 137 85 451 # of Sales 1 2 0 3 3 11 5 2 0 1 13 7 48 Conversion % Affiliate Revenue 6.7% 9.1% 0.0% 13.0% 20.0% 16.4% 11.6% 9.5% 0.0% 8.3% 9.5% 8.2% 10.6% Total Sales January February March April May June July August September October November December Year Totals $15.00 $35.00 $80.00 $125.00 $185.00 $1,200.00 $270.00 $290.00 $340.00 $515.00 $1,215.00 $400.00 $4,670.00 $50.00 $116.67 $266.67 $416.67 $616.67 $4,000.00 $900.00 $966.67 $1,133.33 $1,716.67 $4,050.00 $1,333.33 $15,566.67 Note: The numbers entered in this example are purely hypothetical so you can see how to enter the data, but based on LeadPages various product levels and recurring revenue. As of April 2015, price points for LeadPages products are $37/month, $67/month, $97/month, $297/year, $477/year, $799/year, $400/2year, $800/2year, $1000/2year (for Standard, Pro, Enterprise, respectively). This also assumes some upgrades occur on the backend by the LeadPages marketing and customer success teams. And it assumes you've established trust with your audience for a high Additional Links Additional Links LP Weekly Webinar LP Podcast LP Facebook Advertising LP Webinar Funnel LP 4-Step Tutorial LP Blog Raw Link Raw Link My Redirect My Redirect 2

  3. Affiliate Marketing Dashboard Spreadsheet - LeadPages (Example) 3

  4. Affiliate Marketing Dashboard Spreadsheet - Product 1 Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $0.00 Free Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 # of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Conversion % Affiliate Revenue #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Sales January February March April May June July August September October November December Year Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Additional Links Additional Links Raw Link Raw Link My Redirect My Redirect 4

  5. Affiliate Marketing Dashboard Spreadsheet - Product 1 5

  6. Affiliate Marketing Dashboard Spreadsheet - Product 2 Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $0.00 Free Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 # of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Conversion % Affiliate Revenue #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Sales January February March April May June July August September October November December Year Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Additional Links Additional Links Raw Link Raw Link My Redirect My Redirect 6

  7. Affiliate Marketing Dashboard Spreadsheet - Product 2 7

  8. Affiliate Marketing Dashboard Spreadsheet - Product 3 Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $0.00 Free Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 # of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Conversion % Affiliate Revenue #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Sales January February March April May June July August September October November December Year Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Additional Links Additional Links Raw Link Raw Link My Redirect My Redirect 8

  9. Affiliate Marketing Dashboard Spreadsheet - Product 3 9

  10. Affiliate Marketing Dashboard Spreadsheet - Product 4 Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $0.00 Free Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 # of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Conversion % Affiliate Revenue #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Sales January February March April May June July August September October November December Year Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Additional Links Additional Links Raw Link Raw Link My Redirect My Redirect 10

  11. Affiliate Marketing Dashboard Spreadsheet - Product 4 11

  12. Affiliate Marketing Dashboard Spreadsheet - Product 5 Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $0.00 Free Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 # of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Conversion % Affiliate Revenue #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Sales January February March April May June July August September October November December Year Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Additional Links Additional Links Raw Link Raw Link My Redirect My Redirect 12

  13. Affiliate Marketing Dashboard Spreadsheet - Product 5 13

  14. Affiliate Marketing Dashboard Spreadsheet - Template to Duplicate Product Name: Product Name: Website: Owner Name: Contact Name: Contact Email: Affiliate Login Username: Password: Affiliate Link Affiliate Link My Redirect: My Redirect: Commission %: Annual Total: Instructions: Instructions: Depending on how each program reports your revenue, enter the appropriate details. It's most likely reporting will be total affiliate revenue. Track free referrals and number of sales to notice trends in your affiliate marketing efforts, especially your conversion rate. 30% $0.00 Free Referrals 0 0 0 0 0 0 0 0 0 0 0 0 0 # of Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Conversion % Affiliate Revenue #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Sales January February March April May June July August September October November December Year Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Additional Links Additional Links Raw Link Raw Link My Redirect My Redirect 14

  15. Affiliate Marketing Dashboard Spreadsheet - Template to Duplicate 15

More Related