• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Reporting Template for Adwords, Facebook, Twitter & Bing Data

Karen Ann

Refresher
Apr 21, 2009
127
24
18
British Columbia
First Name
Karen
Thank Minh, popped our data in and the report worked splendidly. Was nice to see everything visually and not just an excel spreadsheet! Thanks for sharing.
Karen Ann

Now to work on making a Data Studio doc for my monthly spreadsheet :)
 
  • 1
Reactions: Jeff Kershner

Jeff Kershner

Founder
May 1, 2005
3,634
1,233
113
Maryland
First Name
Jeff
Karen, so glad to see you jump on this. Curious if you're tracking and reporting on lead and sales attribution to any degree? If so, what does your visual look like?
 
Apr 18, 2017
9
1
1
First Name
Minh
Thanks for the feedback Karen. It'd be great to know what are other templates you are looking for as well, since we are developing a template gallery.
 

Karen Ann

Refresher
Apr 21, 2009
127
24
18
British Columbia
First Name
Karen
If so, what does your visual look like?
I have a monthly compilation that I pull tracking each online source separately. Most include SRP to VDP CTR, Cost per VDP view - lead - sale, Solds per source, inventory counts - photos missing - descriptions missing and more....but it's very dry and separated monthly in Excel.

I'd love to have it visually beautiful and especially with the option to easily see the previous period (month or quarter) comparison.

I also love popping exported data into a Google Sheet and the information I want is compiled in the Data Studio report, instead of manually entering anything. I am hoping that investing time into Data Studio will help me get better!
 

Karen Ann

Refresher
Apr 21, 2009
127
24
18
British Columbia
First Name
Karen
Thanks for the feedback Karen.
I'm having trouble getting source in the splits in various pie charts to be the same colour (dimension a= blue, dimension b= green). Colours change depending on metric, even when I filter to sort by dimension. Did yours just magically line up perfectly with metrics?
 
Apr 18, 2017
9
1
1
First Name
Minh
@Karen: Sorry for the late reply. Do you still have the problem? If so, can you please submit your question here so we can get back to you asap!
 
Visit Generations Digital