Send report format .html

[My Name]

Dear all,

I'm looking API send AdWords reports in .html format. Is there any available resource to help me with this? 

Thank you

[Ray Tsang (AdWords API Team)]

Hi,

You will need to download the report in a pre-defined format, and then reformat it as HTML, for example.

Thanks,

Ray

[Sage Lewis]

I'm successfully creating a csv file for my report and displaying it in html format with this code:

<?php

echo "<table>\n\n";

$f = fopen("report.csv", "r");

while (($line = fgetcsv($f)) !== false) {

        echo "<tr>";

        foreach ($line as $cell) {

                echo "<td>" . htmlspecialchars($cell) . "</td>";

        }

        echo "</tr>\n";

}

fclose($f);

echo "\n</table></body></html>";

?>

The issue I'm running into is: 'returnMoneyInMicros'. 

All my monetary data is displaying in microformats.

Do you think there is any way I can solve this by simply converting my csv file to html. Or do you think I'm going to need to pull the data into something like mysql and parse it there?

Thanks!

[Anash P. Oommen (AdWords API Team)]

Hi Sage,

You can divide the value by 1000000 before printing the html. Also, php has pretty good support for parsing csv.

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[Sage Lewis]

That's easy for you to say :)

I'm still pretty new to parsing csv files. But I am getting closer.

I'll keep working on that.

Thanks for your help!

[Anash P. Oommen (AdWords API Team)]

Hi Sage,

Feel free to ask on this thread if you have more questions.

Cheers,
Anash P. Oommen,

AdWords API Advisor