适用于PHP的Google Keyword Planner CSV分隔符


Google Keyword Planner CSV delimiter for PHP

谷歌关键词工具被谷歌关键词规划器取代,不幸的是,他们更改了csv导出中的分隔符。

在此之前,他们的csv导出是逗号分隔的,现在很奇怪,它看起来像这样:

Campaign    Currency    Budget  Language    Networks    Ad group    Max      CPC    Keyword Avg. monthly searches   Competition Avg CPC Impr. share In account? In plan?    Headline    Description line 1  Description line 2  Display URL Destination URL
Ideas   USD     en  Google Search                                                       
Ideas   USD             Keywords like: Golf Equipment           505680  0.42    0.78                                
Ideas   USD             Keywords like: Golf Equipment       golf equipment  9900    1.00    0.59        N   Y                   
Ideas   USD             Keywords like: Golf Equipment       ford credit 110000  0.15    1.52        N   Y                   

我尝试了很多php导入的分隔符,但注意到有效。。。我的旧代码是:

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)

你能告诉我它是什么分隔符吗?感谢:)

如果你正在下载excel版本,我相信分隔符是tab。试试这个:

while (($data = fgetcsv($handle, 1000, "'t")) !== FALSE)