If previously I wrote an article about Script auto tweet with Imacros and Tweetdeck , This time I will share about Pinterest Automatic Pin with Imacros. With this tools, we can automatic pin our blog post to pinterest board. Using iMacros, we no longer need bother to market our amazon affiliate product on social media like pinterest.
Table of Contents
Boost your amazon earning with Pinterest Automatic Pin .
Besides observant in choosing a product, marketing is also necessary to increase our earnings. Source of Traffic and earnings for my amazon affiliate site, most are from pinterest. Why use Pinterest ? Pinterest helps people discover the things they want to plan, buy and do. Here’s how it works for you ( read here ).
Lets start the experiment
1 2 3 4 | http://www.pinterest.com/pin/create/button/ ?url=http%3A%2F%2Fwww.flickr.com%2Fphotos%2Fkentbrew%2F6851755809%2F &media=http%3A%2F%2Ffarm8.staticflickr.com%2F7027%2F6851755809_df5b2051c9_z.jpg &description=Next%20stop%3A%20Pinterest |
With the following information :
- Url , your blog post url.
- Media, your products picture url.
- Description, your product description.
Learn more about pinterest here ( Pin It button ).
2. How do we get the blogs data ?
Many ways to get posts data. In this case, i use mysql query to get my amazon product post and data. this is example how i get my blog post from Phpadmin ( My wordpress database was modified).
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | SELECT d.name,CONCAT( "http://www.pinterest.com/pin/create/button/ ?url=http://mysite.com/", a.post_name, "&media=", e.meta_value, "&description=", SUBSTR( a.post_title, 1, 250 ) , " on http://mysite.com/", a.post_name ) AS result FROM wp_posts a INNER JOIN wp_term_relationships b ON a.ID = b.object_id INNER JOIN wp_term_taxonomy c ON b.term_taxonomy_id = c.term_taxonomy_id INNER JOIN wp_terms d ON c.term_id = d.term_id INNER JOIN wp_postmeta e ON a.ID = e.post_id WHERE a.post_status = 'publish' AND c.taxonomy = 'category' AND e.meta_key = 't_image' AND LENGTH( CONCAT( SUBSTR( post_title, 1, 250 ) , " on http://mysite.com/", post_name ) ) <=498 ORDER BY d.name, post_date ASC |
In my case, i export query data into CVS format. The format will be like below
3. You need to create the pinterest board first.
Okay, after we get data (save your data to c:\data.csv ) , create imacros script pinterest automatic pin.
1 2 3 4 5 6 7 8 9 10 | VERSION BUILD=8810214 RECORDER=FX TAB T=1 SET !DATASOURCE C:\data.csv SET !LOOP 1 SET !DATASOURCE_LINE {{!LOOP}} URL GOTO={{!COL2}} TAG POS=1 TYPE=LI ATTR=TXT:{{!COL1}} WAIT SECONDS=5 TAG POS=1 TYPE=BUTTON FORM=NAME:NoFormName ATTR=TXT:Pin<SP>it WAIT SECONDS= 30 |
Excellent pieces. Keep writing such kind of ifo on your page.
Im really impressed by your blog.
Hi there, You have dne a great job. I will certainly digg iit annd in my ooinion recommmend to
my friends. I’m sure they will be benefited from this web site.
RuntimeError: Column number 2 greater than total number of columns 1, line 6 (Error code: -953)
okay, i will fix it later 🙂
Hi guys,
First – good job with the script and the site.
Quick suggestion – Pintereste changed lately their pin pop-up and introduced a “Recently Picked” selection of 3 pinboards on top of the pinvboard list – this broke the iMacro script.
Is there any way you can update the script please?
John
hello john,
I do not use this script in a long time, if it will spare me fix this script, because I still have a big project unfinished. thank you for your info 🙂
Thanks Sigit,
I appreciate it.
I believe it’s the same issue as the one reported by Müslüm.
Anyway, thanks for your help. I appreciate it.
John
Thanks for share , it work for me .