mastering the art of ecommerce reporting with excel

#thinkppc

FLASH SERIES

Mastering the Art of Ecommerce Reporting With

Excel

HOSTED BY:

#thinkppc

Presenters

• Jacob Brown– Senior Account Manager at Hanapin Marketing

– Blogger on PPC Hero

– @jakebrownppc

• Alaina Thompson– Production Associate at Hanapin Marketing– Blogger on PPC Hero– @AlainaPThompson

#thinkppc

Join the conversation

• Include the hashtag #thinkppc in your Twitter tweets.

• Or use the webinar question box to send us questions.

#thinkppc

Live Poll Question #1

How do you manage your PPC account(s)?#thinkppc

a) I’m part of an in-house PPC teamb) I do all the marketing including PPCc) I work with an agencyd) I’m a consultant

#thinkppc

Easily Calculate Projected Lag RevenueTools > Conversions > Attribution > Time Lag

#thinkppc

Easily Calculate Projected Lag Revenue

=IF(ISNA(VLOOKUP(C:C,I:J,2,FALSE)),100%,VLOOKUP(C:C,I:J,2,FALSE)

#thinkppc

Revenue per Impression Ad Testing

#thinkppc

Revenue per Impression Ad Testing

#thinkppc

Bid Changes in Excel

#thinkppc

Bid Changes in Excel

#thinkppc

Live Q&A Time!

#thinkppc

Have more questions?

Contact Us Directly

• Webinar Feedback: marketing@hanapinmarketing.com

____________________________________________

Thank you for attending our webinar! #thinkppc