I often hear the words “AdWords is hard.

mdimranhasan139

AdWords report formatting Currently the columns are named “Sum Of XXXX” so let’s rename them and give them the proper units. In the values area click on the drop down for the first option, impressions, and go to value field settings: AdWords report impressions Rename it to just “Impressions “ (make sure to put a space at the end of the word{excel intricacies}). Then go to Number Format: AdWords report numbers For Impressions we want “Number” with 0 decimal places. Details for the rest are below: Clicks: Number, 0 Cost: Currency, 2 Converted Clicks.

Number, 0 CTR: Percentage, 1 CPC: Currency, 2 CPA: Currency, 2 ROI: Currency, 2 CVR: Percentage, 2 Weighted Avg IT Numbers Pos: Number, 1 AdWords report data Much better! Now let’s sort the data so the new data is on top! AdWords report pivot table field list On the right panel click on Month and sort “Newest to Oldest” and repeat for week and then day. AdWords report trend data Now we’re at a point where we can start to see some actual trends in the data. AdWords report Excel colors Add some color by going to the design tab and picking whatever is aesthetically pleasing to you.



Add a few columns to the left of the pivot, and a few to the top. Then highlight a column at the top, click “Ctrl Shift Right arrow” and right click the header letters and click “Hide.” AdWords report Excel merge Highlight the top few rows above the pivot and under “Home” click on “Merge & Center.” I like to match this header to the color scheme of the pivot and then type in your client’s name. AdWords report presentation And now in a mere 15 minutes we have a great-looking Google Ads report that can be sent to any client! Click here to download a free PPC report template. Mike Griffith MEET THE AUTHOR Mike Griffith See other posts by Mike GriffithWalking around our office.