Reporting Template for Adwords, Facebook, Twitter & Bing Data

[nminh.hoang1023]

Hi everyone,

Continuing my previous post about Google Data Studio template for Facebook Ads, we've just developed another template for mixed paid channels, including AdWords, Facebook, Twitter and Bing data.

The template and instructions can be found on our blog: https://supermetrics.com/blog/paid-channel-mix/

Hope to hear what you think about it

 

[Karen Ann]

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

 

[Jeff Kershner]

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?

 

[nminh.hoang1023]

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]

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]

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?

 

[nminh.hoang1023]

@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!

 

[Alexander Lau]

7 Reasons You Should Be Using Scripts in Google Ads
https://www.wordstream.com/blog/ws/2018/08/15/google-ads-scripts