How to Track your Referrals

by

Tracking and analyzing your referrals can help you improve sales by allowing you to focus on the promotional campaigns that are working best for your store. Let’s start by taking a look at where you can find all the necessary information.

Linkover & Referral Report Summary 

Tracking

CSV & Tracking Codes 

Downloading your CSV file is really useful for analyzing your numbers. First, you’ll need Excel on your computer. If you have Microsoft Office on your computer, then it should be  already installed. Once you download the CSV (it will be in the Downloads folder titled referralHistory.csv), double click on the file  and it will open in Excel. If you don’t have Excel on your computer, an alternative would be to use the Spreadsheet application on Google Drive. Here you would have to copy and paste all the data from you CSV into your Google Drive Spreadsheet. Below is what your CSV file should look like when you open it up.

Referralh3

We can see here that the Tracking Code column is empty. Tracking codes help you identify what websites your referrals are coming from. This is where you’ll be able to tell which social media sites, websites, and blogs are working best for you.  Below is how you create a tracking code for your store link.

Store Link & Tracking Code 

Go to:

http://www.zazzle.com/my/associate/storelink

Enter the store name and any tracking code like myfacebook, myblog, mywebsite, etc. (I would use your actual page names here, so if your Facebook page is Great Invitations, I would use “great_invitations”) and then click “build link”.

StoreLink

After you click “Build Link” the link with the tracking code with be created.

StoreLink2

As you can see the addition to the code is “&tc=myfacebook”.  As long as you always enter a tracking code, it will show up in your CSV file.

Sort & Filter Functions in Excel

Sort & filter functions can help you analyze your data and answer many questions. The sort function can help you arrange your data in various ways like lowest to highest amount, alphabetical order, by color, by font, or by icons.

Here is an example of how to sort your “Referral Amount” column from highest to lowest.

Highlight all the columns in your spreadsheet, and then go to:

Home -> Sort & Filter -> Custom Sort ->  Column sort by = Referral Amount-> Sort on =Values -> Order = Z-A ->OK

referral_amount

This will rearrange your referral amounts from highest to lowest (since you chose Z-A). This is useful if you’d like to see where the highest referrals are coming from. In this example, they’re coming from tracking code myfacebook, myblog, and myspace.

Sort2

The filter function is a quick and easy way to view and work with a subset of data. It can help you see all the referrals that came from a certain tracking code.

Here is an example how to see all your referrals that came from “myfacebook”.

Highlight  all the columns in your spreadsheet, and then go to:

Home ->Sort & Filter ->Filter

Now you will see arrows appear on top of each column. Click on the arrow in the tracking code column and then click “select all” then click “myfacebook” and click “Ok”. Then, you should only see “myfacebook” in the tracking code column. One way this  is useful is if you want to see how many referrals came from “myfacebook” for example.

Filter1   Filter2

More on sort & filter functions here.

Growth Functions

It’s always good to know how your business is performing. Below are two important equations that can help you figure out just that.

MoM Growth: growth rate of current month compared to the previous month.

MoM Equation: (Month2-Month1)/Month1

Example:

MoM

% Change June to July

Step 1: ($370.20 – $429.87)/$429.87 = -0.139
Step 2:-0.139 x 100 = -13.9%
Conclusion: Business declined by 13.9% since last month.

% Change July to August

Step 1: ($599.87 – $370.20)/ $370.20 = 0.62
Step 2: 0.62 x 100 = 62%
conclusion: Business grew by 62% since last month.

YoY growth: growth rate of current year compared to the previous year (you can calculate year over year growth for quarter, month, week, or even day. In this example we’ll use months.)

YoY equation: (Year2-Year1)/Year1

Example:

Filter2

Change from July 2012 to July 2013.
Step 1: ($370.20 – $150.87)/$150.87 =1.453
Step2: 1.453 x 100 = 145.3%
Conclusion: Business grew by 145.3% for July 2013 compared to July 2012.

Questions to Ask

Remember to ask yourself these questions when you are analyzing your earnings and campaigns so you can better understand your business and improve conversion and growth.

1. Did your sales grow or fall since the last month?
2. Did your sales grow at the same rate as they did last month?
3. Did your sales grow or fall since last year?
4. Did your sales grow at the same rate as the previous year?
5. What did you do differently this month or year to cause this change?
6. What are your main traffic sources?
7. Did you traffic sources change from last month or year? Why?

 

17 Responses to “How to Track your Referrals”

  1. Mike Simmons Says:

    By FAR the most informative and helpful newsletter that Zazzle has ever published. The meticulous attention to detail and ability to break a complex mystery like referrals and analytics down for the novice user tells me that Zazzle needs to promote whoever wrote this newsletter and immediately place him or her in charge of the “Get Things Done” team. Seriously…the author of this issue is your diamond in the rough. In fact, the CEO should come down and acknowledge it personally. Ignoring this talent would be the biggest loss in your company’s history. From now on, when I have a concern I want to know that THIS PERSON is on the case.

  2. dotpattern Says:

    CSV located at the bottom of the page https://www.zazzle.com/my/earnings/referralhistory

  3. Valerie Says:

    Could you use open office calc as well?

  4. cleroy61 Says:

    Very nice and great article but I’ve got a pb ; My associate is this : http://www.zazzle.com/cleroy61?rf=238638477869530360
    When I put my store name and my track name, the html code is this one for me :

    cleroy61 – Christophe Leroy Photographie
    like this : http://www.zazzle.com/cleroy61*?tc=mycleroy61onstareeblog
    First, there is not my associate ID ?rf=238638477869530360 after my cleroy61 store name ;
    Second, You can also see there is a star (*) after ?tc= while in your example, there is a & Isn’t it?

    Otherwise the track id would be for me that one :
    http://www.zazzle.com/cleroy61?rf=238638477869530360*?tc=mycleroy61onstareeblog
    or this one :
    http://www.zazzle.com/cleroy61?rf=238638477869530360&?tc=mycleroy61onstareeblog

    The difference is * and &

    PS : I’ve got some difficulties to post what I want on wordpress comments , email me to cleroy61 (a) gmail . com if you don’t understand what I mean, please !

    Thank you
    cleroy61

    • Elizabeth, Associates Mentor Says:

      Hi Christophe,

      Thanks for pointing this out, the system in this case is using what is called “The Zazzle Star”. When you add an asterisk (*) after your store URL, as in “zazzle.com/username*”, it becomes a referral link. Both links should work correctly, but let me know if you have any issues.

      Hope this helps!

      Thanks,

      Elizabeth P.

      • sesentirmieux Says:

        Thank you for answering me ! But sorry, I don’t add * before ?tc= (I have made a mistake on my first post), but when I’m only clicking on build link button ; What I have understood is both links are the same : one is a shrinker url.

        Can you tell/show me how to do this with twitter because url becomes very lengthy ?

        Another issue, when I have created a build store link for tracking users/traffic , I only need to use excel or calc to see them ? So, Why Do you create a list of build store link tracking code on each zazzle store owners dashboard ? (even I can look for my tracking code what I put somewhere) imagine, I’m creating today, one tracking code build link for facebook, one for my blog, one for my website, one for a specific forum a ten others for another forums, one for google plus, one for stumbleupon, one for twitter, etc …. I can get huge tracking code, so I would to find these codes on my dashboard, do you understand ?

        Have a nice day
        Best regars
        cleroy61

      • Elizabeth, Associates Mentor Says:

        Hi there,

        Hope all is well, and yes, both links are the same. The way you can use this for Twitter is enter your full URL with the referral code into tinyurl.com and it will shorten the whole link for you. The reason why you create a tracking code for each link is to track where your referrals are coming from. So if you place a product on all your social media networks, but use a different tracking code for each, then you can tell how many referrals come from each network when you download your CSV. So, if then you see that you received 10 referrals from Facebook, but only one from Twitter, the conclusion would be to focus your time on Facebook.

        Hope this helps.

        Thanks!

        Elizabeth P.

      • sesentirmieux Says:

        Also, in my first comment and the last url, when I put on post comment button of this post, wordpress has add amp; so my last url is without amp; so can I use the one and use a bitly url to shrink it.

    • Terry Maltos Says:

      Use this instead of your * – that breaks up your link way too easily across platforms.
      http://www.zazzle.com/cleroy61?rf=238638477869530360&tc=mycleroy61onstareeblog
      Also – in your links above – two question marks in the string are improper format (right?) and may *not* actually work.
      Hope that helps.

    • dotpattern Says:

      Hi Christophe,

      No need to use the zazzle star,

      Go to any page on your zazzle store, copy the URL then add your referral code at the end.
      If there is already a ?…. in the URL, then your ref code needs to begin with the ampersand &.
      — Only use one ? to callout the first “parameter”, then the next parameter(s) use the &

      For example:

      http://www.zazzle.com/alchemical/cards+stamps?rf=238663014376241939 => cards and stamps DEPARTMENT in my store.

      http://www.zazzle.com/curiosities_shop/gifts?rf=238663014376241939 => HOME PAGE
      http://www.zazzle.com/gifts?ch=curiosities_shop&rf=238663014376241939 => SORT BY Color, Price, Events & Occasions & Recipients

      Note: special characters turn to ascii code on blogs. Example: & turns to &

      Check this page for more RSS (and URL) parameters:
      http://www.zazzle.com/sell/affiliates/promotionaltools/rss

      P.S. on any product page, click SHARE > LINK and use the “html” link.
      For example: Sun light on Prunus Park Pitcher (NO ZAZZLE STAR)

      Sun light on Prunus Park Pitcher …… by cleroy61 More Sun light on prunus park Pitchers

  5. Michelle Says:

    Is there a way to have multiple tracking ID’s for affiliate links not linking directly to a store? I have a couple of websites, and use my associate ID for one and it works, but I’d like to link to different Zazzle products for my other blog. The associate profile only has space for one website. So I guess my question is, is it acceptable to link from a blog other than my primary one, and if so is it possible to track from which blog a referral came from? Thanks for any help!

    • Elizabeth, Associates Mentor Says:

      Hi Michelle,

      The way you track which links the clicks are coming from is by going to http://www.zazzle.com/my/associate/storelink and then adding a tracking code when you build your link. If you are trying out different websites, you can add tracking code “website1″ and “website2″, for example. You would have to build two separate links for those, but you can use them both. You should also be able to add the tracking code to any product on the site.

      Hope this helps, and let me know if you have any other questions.

      Thanks,

      Elizabeth P.

  6. RESTEN High End Outdoor Furniture Says:

    Great article! Very helpful!!

  7. bobbeej Says:

    I just happened to run across this blog on Zazzle. Great information, very helpful!! My online store on Zazzle.com is BobbeeJs.
    http://www.zazzle.com/BobbeeJs

  8. cleroy61 Says:

    Hi everyone,
    Why in my Linkover History, I haven’t got my *.cvs file to download ?
    Thank you very much
    Have a nice day
    cleroy61

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

Join 674 other followers

%d bloggers like this: