The Most Active and Friendliest
Affiliate Marketing Community Online!

“FunnelFlux  Zeydoo

Fashion Affiliate Marketing Journey 2021 (SEO Traffic)

Honeybadger

Affiliate
affiliate
AffKit Ninja
Business Overview
  • Affiliate marketing business will trade Monday Jan 4 2021 - Friday Dec 31 2021
  • Business promotes seasonal & special occasion impulse-buy products
  • Customer is English-speaking internet user US, Canada, Australia, UK, Ireland
Business Objective
  • Business will generate $100,000 affiliate commission by Friday 12.31.2021
Business Strategy
  • Business will operate 10 affiliate product websites
  • Each affiliate website earn $27.40 per day average
  • Total daily commission $274 average (x 365 days = $100,000)
Business Tactics
  1. Each website based on seasonal niche product range (on 4th sub-level)
  2. Products are chosen in advance from seasonal increase in customer searches
  3. Websites will test products 1st on customer using organic search traffic
  4. Successful organic product test will be tested on paid results*
  5. *Only revenue from successful organic test will be used for paid test
  6. Main products are seasonal or special occasion impulse buys
  7. Promoted/listed products are generally $10-$25 (maximum $50)
  8. Website are optimized for best user experience
  9. Organic search engines guidelines carefully followed for best ranking
  10. Repetitive work gets outsource & automated
Business Management
  1. Business is registered with government
  2. Business have all liability insurances
  3. Agile methodology is used on Trello platform
  4. Accountant make quarterly financial report
    • Q1 Report (end of March)
    • Q2 Report (end of June)
    • Q3 Report (end of September)
    • Q4 Report (end of December)
  5. Share project diary with Affiliate Fix community
 
Voluum

Graybeard

Well-Known Member
affiliate
  • Successful organic product test will be tested on paid results*
  • *Only revenue from successful organic test will be used for paid test
  • Some revenue from organic SEO referral sales of products (offers) will be reinvested in paid traffic to? scale?
Like taking odds on a craps table or doubling down when playing 21 (Blackjack) ;)
May work --need to try. Scaling SEO referrals is not realistic for long ...
 

Honeybadger

Affiliate
affiliate
AffKit Ninja
January 2021 Targets

The business will operate 10 affiliate websites with 3 revenue targets for January
  1. Generate $5/day per site
  2. Generate $150/site total
  3. Generate $1,500 total commission
Revenue Chart 2021

SiteJANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDECTOTAL
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
$5$10$15$20$25$30$35$35$30$40$40$40
TOT$1.5K$3K$4.5K$6K$7.5K$9K$10K$10K$9K$12K$12K$12K$100K
[td]1[/td] [td]$10,050[/td] [td]2[/td] [td]$10,050[/td] [td]3[/td] [td]$10,050[/td] [td]4[/td] [td]$10,050[/td] [td]5[/td] [td]$10,050[/td] [td]6[/td] [td]$10,050[/td] [td]7[/td] [td]$10,050[/td] [td]8[/td] [td]$10,050[/td] [td]9[/td] [td]$10,050[/td] [td]10[/td] [td]$10,050[/td]
 

Honeybadger

Affiliate
affiliate
AffKit Ninja
January 2021 Overview

The business will update 10 affiliate websites between Monday - Friday (no work on weekend or outside office time) with target to generate $5+/day commission per site, this will maintain $5+ daily average for each site & each site generate $150 in January, total commission in January its $1,500

$1,500 will cover all business cost for January and enough wage for all personal cost, then in February all targets are double

This $1,500 will not arrive until April 1, 2021 (60 days after January end) so January bills are paid from 1-31 October 2020 earning --> $1,100 arrived January 4, 2021 & its just enough to pay all bills this month

Revenue Chart - January 2021

This spreadsheet is bespoke, it havent copied from somewhere so if you want to use just copy and paste, or model however you like

DAYSite 1Site 2Site 3Site 4Site 5Site 6Site 7Site 8Site 9Site 10TOTAL
1$5$5$5$5$5$5$5$5$5$5$50
2$5$5$5$5$5$5$5$5$5$5$50
3$5$5$5$5$5$5$5$5$5$5$50
4$5$5$5$5$5$5$5$5$5$5$50
5$5$5$5$5$5$5$5$5$5$5$50
6$5$5$5$5$5$5$5$5$5$5$50
7$5$5$5$5$5$5$5$5$5$5$50
8$5$5$5$5$5$5$5$5$5$5$50
9$5$5$5$5$5$5$5$5$5$5$50
10$5$5$5$5$5$5$5$5$5$5$50
11$5$5$5$5$5$5$5$5$5$5$50
12$5$5$5$5$5$5$5$5$5$5$50
13$5$5$5$5$5$5$5$5$5$5$50
14$5$5$5$5$5$5$5$5$5$5$50
15$5$5$5$5$5$5$5$5$5$5$50
16$5$5$5$5$5$5$5$5$5$5$50
17$5$5$5$5$5$5$5$5$5$5$50
18$5$5$5$5$5$5$5$5$5$5$50
19$5$5$5$5$5$5$5$5$5$5$50
20$5$5$5$5$5$5$5$5$5$5$50
21$5$5$5$5$5$5$5$5$5$5$50
22$5$5$5$5$5$5$5$5$5$5$50
23$5$5$5$5$5$5$5$5$5$5$50
24$5$5$5$5$5$5$5$5$5$5$50
25$5$5$5$5$5$5$5$5$5$5$50
26$5$5$5$5$5$5$5$5$5$5$50
27$5$5$5$5$5$5$5$5$5$5$50
28$5$5$5$5$5$5$5$5$5$5$50
29$5$5$5$5$5$5$5$5$5$5$50
30$5$5$5$5$5$5$5$5$5$5$50
31$5$5$5$5$5$5$5$5$5$5$50
TOTAL$155$155$155$155$155$155$155$155$155$155$1,550
 

Honeybadger

Affiliate
affiliate
AffKit Ninja
Business Report - Week 1 of 52
1.1.2021 - 1.7.2021

Week 1 Commission

SourceCommission
Affiliate Network 1$60
Affiliate Network 2$53
Affiliate Network 3$22
Affiliate Network 4$47
Affiliate Network 5$0
Affiliate Network 6$14
Total$196

Project Notes
  • Week 1 commission target $150 reached (plan was originally 10 website x $5 commission, instead its 1 website x $150 commission this week)
  • Out of 10 planned websites for 2021, 5 websites are live, the other 5 are behind schedule
  • Out of 5 live websites, only 1 website has affiliate ID links, next week affiliate ID links are added to websites 2, 3, 4, 5
  • Fixed technical product issue (alerted by Google Search Console Dec. 23, validation start Dec. 25, reported fixed Dec. 30), problem was deleted wrong duplicate product images on server storage, Google Search Console gave list of URLs, added missing images before start validation
  • Accidentally deleted all Google Search Console data from 2020 (wasn't back up), possible to connect Google Search Console API to database with MySQL & Python but need outsource for programmer (not extra funds to pay this January 2021, re-consider February 2021)
  • Set-up Google Search Console to display GSC data direct in Google Analytics & waiting to see 48 hours later what additional data this will display to Google Analytics (ideally this will display user queries from Google Search in Google Analytics, after this feature was 99% - but not completely - retired by Google some years ago)
  • Added new Amazon Associates products to replace seasonal out-of-stock products, but no way have found to select new products with automation because Amazon product labels are so poorly optimized (takes alot of work to find specific high quality low cost season impulse buy products that are in stock), so now finally I start to research artificial intelligence with 2 objectives --> 1. Perform new product identification for my affiliate websites in 2022, 2. Give me understanding of general AI in retail before I make a online study course for AI in E-commerce, here is 1st research paper I read today (free PDF) --> info.microsoft.com/rs/157-GQE-382/images/Final%20AI%20Retail%20Playbook.pdf
 
Last edited:

Graybeard

Well-Known Member
affiliate
Accidentally deleted all Google Search Console data from 2020 (wasn't back up), possible to connect Google Search Console API to database with MySQL & Python but need outsource for programmer (not extra funds to pay this January 2021, re-consider February 2021)

can you just download the zip daily --this is from a commercial acct
Performance-on-Search-2021-01-07$ tree
.
├── Countries.csv
├── Dates.csv
├── Devices.csv
├── Filters.csv
├── Pages.csv
├── Queries.csv
└── Search appearance.csv

Code:
Query,Clicks,Impressions,CTR,Position
KW1,817,4678,17.46%,6.47
KW2,496,3014,16.46%,6.83
KW3,474,604,78.48%,1.69
KW4,463,2804,16.51%,7.63
KW5,447,517,86.46%,1.45
KW6,427,3328,12.83%,9.25
KW7,415,5540,7.49%,8.22
KW8,405,2193,18.47%,6.43

so some LINUX CLI Terminal magic

Code:
$sed "s/^/$(date +'%F $T'),domain_name,/"  Queries.csv>Queries_domain_$(date +%F).csv
**edit the time code to a mySQL format
Code:
Date,domain_name,Query,Clicks,Impressions,CTR,Position
2021-Jan-07 23:18:10,domain_name,keyword,38765,387555,10.00%,1.22
2021-Jan-07 23:18:10,domain_name,keyword,3560,32897,10.82%,1.36
2021-Jan-07 23:18:10,domain_name,keyword,2834,26359,10.75%,1.4
2021-Jan-07 23:18:10,domain_name,keyword,1932,19259,10.03%,1.34
2021-Jan-07 23:18:10,domain_name,keyword,1387,13447,10.31%,1
2021-Jan-07 23:18:10,domain_name,keyword,1328,2547,52.14%,2
2021-Jan-07 23:18:10,domain_name,keyword,817,4678,17.46%,6.47
2021-Jan-07 23:18:10,domain_name,keyword,533,562,94.84%,1
2021-Jan-07 23:18:10,domain_name,keyword,496,3014,16.46%,6.83
2021-Jan-07 23:18:10,domain_name,keyword,474,604,78.48%,1.69
2021-Jan-07 23:18:10,domain_name,keyword,468,6112,7.66%,1.57
2021-Jan-07 23:18:10,domain_name,keyword,463,2804,16.51%,7.63
2021-Jan-07 23:18:10,domain_name,keyword,457,481,95.01%,1
2021-Jan-07 23:18:10,domain_name,keyword,447,517,86.46%,1.45
2021-Jan-07 23:18:10,domain_name,keyword,440,2588,17.00%,1.14
2021-Jan-07 23:18:10,domain_name,keyword,427,3328,12.83%,9.25
2021-Jan-07 23:18:10,domain_name,keyword,415,5540,7.49%,8.22
2021-Jan-07 23:18:10,domain_name,keyword,405,2193,18.47%,6.43
2021-Jan-07 23:18:10,domain_name,keyword,403,437,92.22%,1.12
2021-Jan-07 23:18:10,domain_name,keyword,392,2538,15.45%,1.35
2021-Jan-07 23:18:10,domain_name,keyword,392,1130,34.69%,2.9
2021-Jan-07 23:18:10,domain_name,keyword,389,730,53.29%,2.55
2021-Jan-07 23:18:10,domain_name,keyword,371,1718,21.59%,6.24
2021-Jan-07 23:18:10,domain_name,keyword,368,2161,17.03%,5.54
2021-Jan-07 23:18:10,domain_name,keyword,364,567,64.20%,1.04
2021-Jan-07 23:18:10,domain_name,keyword,359,3061,11.73%,9.04
2021-Jan-07 23:18:10,domain_name,keyword,359,571,62.87%,3.62
2021-Jan-07 23:18:10,domain_name,keyword,351,2249,15.61%,5.67
2021-Jan-07 23:18:10,domain_name,keyword,349,397,87.91%,1.95
2021-Jan-07 23:18:10,domain_name,keyword,346,1333,25.96%,1.43
2021-Jan-07 23:18:10,domain_name,keyword,334,556,60.07%,1.71
2021-Jan-07 23:18:10,domain_name,keyword,324,2634,12.30%,1.2
2021-Jan-07 23:18:10,domain_name,keyword,321,4889,6.57%,2.87
2021-Jan-07 23:18:10,domain_name,keyword,321,890,36.07%,3.19
2021-Jan-07 23:18:10,domain_name,keyword,315,317,99.37%,1
2021-Jan-07 23:18:10,domain_name,keyword,313,3549,8.82%,1.42
2021-Jan-07 23:18:10,domain_name,keyword,311,2685,11.58%,2.18
2021-Jan-07 23:18:10,domain_name,keyword,311,765,40.65%,1.45
2021-Jan-07 23:18:10,domain_name,keyword,305,796,38.32%,1.53
2021-Jan-07 23:18:10,domain_name,keyword,291,725,40.14%,2.58
2021-Jan-07 23:18:10,domain_name,keyword,282,2342,12.04%,8.64
2021-Jan-07 23:18:10,domain_name,keyword,279,803,34.74%,2.53
2021-Jan-07 23:18:10,domain_name,keyword,278,1847,15.05%,1
2021-Jan-07 23:18:10,domain_name,keyword,274,1654,16.57%,11.68
2021-Jan-07 23:18:10,domain_name,keyword,269,395,68.10%,2.63
the % part should be converted to a decimal value use sed then awk ;)
the api will not show 365 days or 4 years you just need to automate the file download daily and set up your own database add a field ,domain, and populate it in the csv LOAD FILE LOCAL to a mySQL (or DB of your choice)

Then cart.js for each keyword and the dates/quantities in a bar chart or line graph if you want visualization.
Example of something I am working on ---same data idea (basically)
NoSQL and Elastic Search is another option. All it takes is money :p
You could have a custom dashboard --

upload_2021-1-7_22-33-46.png
 
Last edited:

Honeybadger

Affiliate
affiliate
AffKit Ninja
Business Report - Week 2 of 52
1.8.2021 - 1.14.2021

Week 2 Commission

SourceCommission
Affiliate Network 1$67
Affiliate Network 2$78
Affiliate Network 3$6
Affiliate Network 4$43
Affiliate Network 5$0
Affiliate Network 6$7
Affiliate Network 7$0
Total$201

Project Notes
  • Development work --> New site launched (#6), now 6 websites live (2 website has affiliate ID links), 4 website behind schedule, next week plan to launch websites 7,8,9,10
  • Traffic & analytics stats --> Traffic recovered from New Year low around 200 visits/day to 800 visits/day, why the change? Seasonal for one, but I spend many many hours improving content for customers
  • Commissions earned --> banked $201 this week, pays bills in 60 days, same as last week "plan was originally 10 website x $5 commission = $150 commission, instead I reached the target from 1 website x $150 commission", joined 7th network and made contact with affiliate program managers (be professional and friendly with program managers, they just trying to make success like you)
  • New software tested --> Testing new software every day, Adobe's new online tools are sick, check this out adobe.com/creativecloud/tools.html (video editing, green screen, screen recorder, photo editing, flyer design)
  • Answer your questions -->About SEO, I said "SEO is very, very, very.....very easy" and it is, just you need to understand user question (and intent) and give best answer, nobody loses by consistently giving best answer, that's not how marketing works, in 2021 SEO shifts away from links (links just get you traffic) and more focus on user experience (good post on UX from Hubspot --> blog.hubspot.com/service/what-is-customer-experience)
 
banners
Top