Menu
Home
Forums
New posts
Search forums
What's new
New posts
New media
New media comments
Latest activity
Media
New media
New comments
Search media
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Home
Forums
Starting Out
New Blog Posts
How To Gift Card Churn Like A Pro – Finding The Best Rate
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
<p>[QUOTE="Chasing The Points, post: 144539, member: 2"]</p><p><a href="http://saverocity.com/chasingthepoints/gift-card-churn-like-pro-finding-best-rate/"><img src="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny-300x82.png" data-url="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny-300x82.png" class="bbImage " style="" alt="" title="" /></a></p><p>Yesterday’s post covered what I think is the <a href="http://saverocity.com/chasingthepoints/gift-card-churn-like-pro-shipping-lesson/">best practice for mailing out your gift cards using USPS</a>. For any gift card churner out there, <a href="http://www.giftcardgranny.com/sell-a-gift-card/">Gift Card Granny</a> is an excellent resource for newbies and experts alike. It lists out all of the <strong>public</strong> rates that you can sell your gift cards.</p><p></p><p>The companies they list are: Giftcards.com, Gift Card Zen, ABC Gift Cards, Cardpool, Junkcard, and Monster Gift Card.</p><p></p><p><a href="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_sites.png"><img src="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_sites-600x77.png" data-url="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_sites-600x77.png" class="bbImage " style="" alt="" title="" /></a></p><p></p><p></p><p></p><p></p><p></p><p>Of the listed ones, I have only sold on Gift Card Zen and Cardpool. Remember, for your first $1000 in transactions TopCashBack will pay out 4% when you partner with Cardpool.</p><p></p><p>The biggest downside to Gift Card Granny is their inability to provide a sortable table.</p><p></p><p><span style="font-size: 18px"><strong>How To Build The Table:</strong></span></p><p></p><p></p><p>First, you need Google Chrome, then I highly encourage you read this <a href="https://dataist.wordpress.com/2012/10/12/get-started-with-screenscraping-using-google-chromes-scraper-extension/">article</a> and download the Scraper extension for Google Chrome.</p><p></p><p>Once installed, you right click the website and the menu will display “Scrape Similar”</p><p></p><p><a href="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape.png"><img src="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape-600x250.png" data-url="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape-600x250.png" class="bbImage " style="" alt="" title="" /></a></p><p></p><p>Depending on your initial click your results that you see won’t be the same, but that is OK.</p><p></p><p>Once you have that box you want to now change the field that is highlighted with //tr[9]/td to this:</p><p></p><p style="margin-left: 20px"><strong>//div[2]/div/div[3]/table/tbody/tr</strong></p><p></p><p>And hit the “Scrape” button</p><p></p><p>Now you will see this:</p><p></p><p><a href="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape2.png"><img src="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape2-600x247.png" data-url="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape2-600x247.png" class="bbImage " style="" alt="" title="" /></a></p><p></p><p></p><p></p><p>We are almost there, right now the scrape is still leaving it in one column. To fix that you need to change the XPath.</p><p></p><p><a href="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_xpath.png"><img src="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_xpath.png" data-url="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_xpath.png" class="bbImage " style="" alt="" title="" /></a></p><p></p><p>You need to add all of the rows with this code:</p><p></p><p style="margin-left: 20px"><strong>./td</strong></p> <p style="margin-left: 20px"><strong>./td[2]</strong></p> <p style="margin-left: 20px"><strong>./td[3]</strong></p> <p style="margin-left: 20px"><strong>./td[4]</strong></p> <p style="margin-left: 20px"><strong>./td[5]</strong></p> <p style="margin-left: 20px"><strong>./td[6]</strong></p> <p style="margin-left: 20px"><strong>./td[7]</strong></p><p></p><p>And change the name column that corresponds to the columns found on Gift Card Granny:</p><p></p><p style="margin-left: 20px"><strong>Vendor</strong></p> <p style="margin-left: 20px"><strong>GiftCards.com</strong></p> <p style="margin-left: 20px"><strong>Gift Card Zen</strong></p> <p style="margin-left: 20px"><strong>ABC Gift Cards</strong></p> <p style="margin-left: 20px"><strong>Cardpool</strong></p> <p style="margin-left: 20px"><strong>Junkcard</strong></p> <p style="margin-left: 20px"><strong>Monster Gift Card</strong></p><p></p><p>When completed, it will look like this:</p><p></p><p><a href="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_final_scrape.png"><img src="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_final_scrape-600x282.png" data-url="http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_final_scrape-600x282.png" class="bbImage " style="" alt="" title="" /></a></p><p></p><p></p><p></p><p>After you have successful scrape, click on the “Export to Google Docs…” button. Now you have the download of all the public rates and you can find the best deal. With this, you are now empowered to search through the sell by rate instead of by vendor. Because of this, you can play around with the math to find out how to take action on gift card churning and to see if a vendor really is a deal.</p><p></p><p><a href="http://saverocity.com/chasingthepoints/gift-card-churn-like-pro-finding-best-rate/">Continue reading...</a></p><p>[/QUOTE]</p>
[QUOTE="Chasing The Points, post: 144539, member: 2"] [URL='http://saverocity.com/chasingthepoints/gift-card-churn-like-pro-finding-best-rate/'][IMG]http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny-300x82.png[/IMG][/URL] Yesterday’s post covered what I think is the [URL='http://saverocity.com/chasingthepoints/gift-card-churn-like-pro-shipping-lesson/']best practice for mailing out your gift cards using USPS[/URL]. For any gift card churner out there, [URL='http://www.giftcardgranny.com/sell-a-gift-card/']Gift Card Granny[/URL] is an excellent resource for newbies and experts alike. It lists out all of the [B]public[/B] rates that you can sell your gift cards. The companies they list are: Giftcards.com, Gift Card Zen, ABC Gift Cards, Cardpool, Junkcard, and Monster Gift Card. [URL='http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_sites.png'][IMG]http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_sites-600x77.png[/IMG][/URL] Of the listed ones, I have only sold on Gift Card Zen and Cardpool. Remember, for your first $1000 in transactions TopCashBack will pay out 4% when you partner with Cardpool. The biggest downside to Gift Card Granny is their inability to provide a sortable table. [SIZE=5][B]How To Build The Table:[/B][/SIZE] First, you need Google Chrome, then I highly encourage you read this [URL='https://dataist.wordpress.com/2012/10/12/get-started-with-screenscraping-using-google-chromes-scraper-extension/']article[/URL] and download the Scraper extension for Google Chrome. Once installed, you right click the website and the menu will display “Scrape Similar” [URL='http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape.png'][IMG]http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape-600x250.png[/IMG][/URL] Depending on your initial click your results that you see won’t be the same, but that is OK. Once you have that box you want to now change the field that is highlighted with //tr[9]/td to this: [INDENT=1][B]//div[2]/div/div[3]/table/tbody/tr[/B][/INDENT] And hit the “Scrape” button Now you will see this: [URL='http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape2.png'][IMG]http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_initial_scrape2-600x247.png[/IMG][/URL] We are almost there, right now the scrape is still leaving it in one column. To fix that you need to change the XPath. [URL='http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_xpath.png'][IMG]http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_xpath.png[/IMG][/URL] You need to add all of the rows with this code: [INDENT=1][B]./td ./td[2] ./td[3] ./td[4] ./td[5] ./td[6] ./td[7][/B][/INDENT] And change the name column that corresponds to the columns found on Gift Card Granny: [INDENT=1][B]Vendor GiftCards.com Gift Card Zen ABC Gift Cards Cardpool Junkcard Monster Gift Card[/B][/INDENT] When completed, it will look like this: [URL='http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_final_scrape.png'][IMG]http://saverocity.com/chasingthepoints/wp-content/uploads/sites/12/2015/01/gc_granny_final_scrape-600x282.png[/IMG][/URL] After you have successful scrape, click on the “Export to Google Docs…” button. Now you have the download of all the public rates and you can find the best deal. With this, you are now empowered to search through the sell by rate instead of by vendor. Because of this, you can play around with the math to find out how to take action on gift card churning and to see if a vendor really is a deal. [url="http://saverocity.com/chasingthepoints/gift-card-churn-like-pro-finding-best-rate/"]Continue reading...[/url] [/QUOTE]
Insert quotes…
Preview
Name
Verification
What is the name of Joe's Podcast?
Post reply
Home
Forums
Starting Out
New Blog Posts
How To Gift Card Churn Like A Pro – Finding The Best Rate
Top