Digital Analytics + SEO + Attribution model 10-07-2020 07:01 AM - last edited 10-09-2020 09:10 AM

[marcusRB]

Dashboard PoC with real/fake data, made by Google Sheet ( ETL connector), DB connector and API:

Done:

- Google Analytics (audience, adquisition, behaviour, conversions)

- Google Ads (main campaigns and specific metrics)

- SEO (Search Console)

- Attribution model for omnichannel business

- Brand score by Sistrix API and SEO visibility

Pending:

I'll improve social and other analytical flow in the dashboard.
Same for other advertiser and offline conversions.

PBIX will be available very soon! Thanks for your feedback.

eyJrIjoiMTlhZmQwMmEtMGNhZC00N2JjLThlMmQtNTk0NzU1MTlhOGQ1IiwidCI6IjhiMjA5Mzc4LTk4YTEtNDRkMS1hYTNhLTdhYTIyZjY4ODA0YiIsImMiOjl9&embedImagePlaceholder=true

[Pa1Kumar]

Hi Marcus! Excellent Work! Which can help me a lot Please share the PBIX to   pavankumar961921@gmail.com

[caseytoliver]

Hey there! I just came across your post, and it looks like you've done an amazing job with your dashboard PoC. The integration of Google Analytics, Google Ads, and Search Console is definitely going to help you get some deep insights into your website performance.
I'm really interested to see how you'll improve the social and other analytical flow in the dashboard. It's always great to have a comprehensive view of all the metrics that matter. I'm also curious to see how you'll include advertiser and offline conversions.
By the way, I recently read a post about Site Audit and how it can help with SEO and website optimization. Have you tried it out?

[Anonymous]

@marcusRB please share the pbix with me too.
Thank you very much in advance!

[diegopoggi]

Hi Marcus! This report is great!!! It would help me a lot, could please share the pbix? Thank you